[U2] Two Questions
Hello I'm have two questions 1.- There are some tools or some utility to trasspas de data from Universe to SQL Server. 2.- Can I connect to Universe from Internet? Regarts. Cisar (Spain) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
FYI FYI I want it to be understood that Kevin King was not the spaghetti man I mentioned earlier..I will not name that person. I only mentioned Kevin in the respect that given the fact that he is a published Grand Poobah of SB+ that you would expect more fancy schmanchy zing bang boom SB+ tricks. But apparently his wisdom of knowing when to hold 'em and when to fold 'em was far greater than spaghetti man who thought, hey its like Prego...its in there and I'm gonna use it even if it is the wrong sauce... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Sunday, March 13, 2005 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[no subject]
Hi Debster, We have 4 U2 based products: - Avanti - DataFlo - Manage 2000 - ManFact Across all 4 products we maintain Support, Development & Consulting groups in support of each of these products. We have a strong commitment to each of these 4 products; there is continuing development of the core applications and ancillary offerings... Indeed we have just released Avanti 9.4.6 which has as 3 major themes encompassing a myriad of enhancements (many of which are user driven): - Purchasing - Ease of Use - International Along with the continuing development of the products we have a very strong commitment to proactive customer communications (even to the point of airing our dirty laundry in public with our weekly patch bulletins)... These communications are, broadly speaking, covered in 3 areas: - Monthly eBulletins: These are filled with news and information geared toward a specific product (e.g. Avanti), we have an emphasis in these newsletters not on marketing but technical information (both product and technology). - Weekly Patch bulletins: Here we publish the latest hot issues relating to the products, including (if applicable) the patch; these patches may be downloaded & applied immediately rather than waiting for the next product release (if so desired)! - LISTSERV e-mail forums - some 25+ focused e-mail forums have been created, users are free to discuss any facet of their product; this results in some very informative and sometimes heated discussions. We also work closely with our suppliers, whether IBM or other third parties, to ensure that there is a 2-way dialog & that we may work effectively & efficiently. One of the key features of the way that we deliver product is in the way we empower our users to take the product & make it their own! Therein lies a danger, it is very easy to customize but with the customizations comes the maintenance problem, keeping the product up to date (particularly if a site has had a long history of different programmers working on it) can be a bear. Having said that I know of sites who look forward in anticipation of the next release, they race to see who can be first to go live on the latest & greatest... Competition can be fun (in a strange way) sometimes. We spend a lot of time & effort listening to our customers, constantly trying to improve services & support; if there are problems we rely on feedback to identify & rectify problems. If you are having issues then please feel free to contact the appropriate Support Manager or myself and I will direct you to the appropriate resource (if not myself). Martin Martin Canty Technical Support Manager - iSolutions www.epicor.com Tel.: (858) 352-1439 Fax: (858) 352-1494 E-Mail: [EMAIL PROTECTED] 5010 Wateridge Vista Dr, San Diego CA 92121 USA This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Maybe/and also on the wiki Ross Ferris Stamina Software Visage an Evolution in Software Development >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald >Sent: Monday, 14 March 2005 7:36 AM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Triggers docs? > >Ah. I'd forgotten about the filtering. So, Martin, if you get a chance, a >direct email? Thanks. > >...although in this particular instance, I think I've seen enough. >Fortunately, all sanctioned updates occur via a standard update subroutine, >so we'll just go with that. A manager had come across the word "triggers", >so I had to do some due diligence. > >Didn't there used to be a place to contribute and read docs? I poked around >a bit, and didn't find one. > > > > > >"Our greatest duty in this life is to help others. And please, if you can't >help them, could you at least not hurt them?" - H.H. the Dalai Lama >"When buying & selling are controlled by legislation, the first thing to be >bought & sold are the legislators" - P.J. O'Rourke >Dan Fitzgerald > > > > >>From: Moderator <[EMAIL PROTECTED]> >>Reply-To: u2-users@listserver.u2ug.org >>To: u2-users@listserver.u2ug.org >>Subject: Re: [U2] Triggers docs? >>Date: Sun, 13 Mar 2005 14:58:53 -0500 >> >>Dan, >>You won't see an attachment. Our list filters out attachments to >>minimize the risk of virii and trojans. >> >>- Charles Barouch, Moderator >> >>Dan Fitzgerald wrote: >> >>>Martin - I appreciate it, but I didn't see an attachment... >>--- >>u2-users mailing list >>u2-users@listserver.u2ug.org >>To unsubscribe please visit http://listserver.u2ug.org/ >--- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ > > >-- >No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers docs?
Ah. I'd forgotten about the filtering. So, Martin, if you get a chance, a direct email? Thanks. ...although in this particular instance, I think I've seen enough. Fortunately, all sanctioned updates occur via a standard update subroutine, so we'll just go with that. A manager had come across the word "triggers", so I had to do some due diligence. Didn't there used to be a place to contribute and read docs? I poked around a bit, and didn't find one. "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald From: Moderator <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers docs? Date: Sun, 13 Mar 2005 14:58:53 -0500 Dan, You won't see an attachment. Our list filters out attachments to minimize the risk of virii and trojans. - Charles Barouch, Moderator Dan Fitzgerald wrote: Martin - I appreciate it, but I didn't see an attachment... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers docs?
Dan, You won't see an attachment. Our list filters out attachments to minimize the risk of virii and trojans. - Charles Barouch, Moderator Dan Fitzgerald wrote: Martin - I appreciate it, but I didn't see an attachment... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2]: Epicor
Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
Don't feel bad...every person on this list has some dirty laundry. It's amazing how many of us have rode the economic roller coaster from such heights to such lows. Makes me wonder, is there any other profession that has such extremes? A garbage man isn't subjected to corporate takeover woes or such extremes in monetary compensation -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Sunday, March 13, 2005 12:05 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I meant to only send this to debster. But I forgot to change the address. I didn't mean to air dirty laundry in public. Doh.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Saturday, March 12, 2005 15:12 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I know they have several products, but have very little interest in them since I have so much experience in M2K. So, um Avante uses U2 or UV? I wonder if that's the "glorified jobshop" that my friend alluded to? All I know is that they bought ROI Systems in 07/03 and all the old timer ROI employees *HATE* working for them and have or are getting ready to jump ship...they say I'm the lucky one since I got laid off and got a compensation package, whereas they have had to put up with the huge corporate treatment of 'programmers as worker bees' mentality and are now quitting and receiving no package. I was a work-from-home 1,200 miles away from the office and was temporarily disabled with an elbow injury so severe that the doctors almost amputated. So when Epicor acquired ROI, I got the golden boot to the rear. Almost sued under the ADA, but I had an empty bank account and had to take the compensation package or risk loosing my house. :-0 !!! But that's ok, as Ann Landers used to say 'time wounds all heals'. ;-) *=aee=* -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Saturday, March 12, 2005 13:38 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor You forgot Avante -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Saturday, March 12, 2005 4:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Hi Will, You mean, like the epicor product that uses u2? (which I believe Manage-2000 is the only one). Or the epicor product that uses SQL? I have little knowledge of that one but an associate says it's a very poor substitute for M2K. His exact words:"I know their glorified jobshop package won't do diddly for m2k folk used to an mrp engine." (Manage-2000 abbreviated is M2k) If you're interested in M2k, I used it in a production distribution environment from 1988 to 1999, and still specialize in programming/consulting for that product. It's a very big system. Over 800 menus! Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, March 11, 2005 17:52 To: u2-users@listserver.u2ug.org Subject: [U2]: Epicor Is anyone on this list an Epicor user ? I have a client who is examining Epicor as a possible solution to part of what they need and would like some input. Thanks Will Johnson Fast Forward --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
I meant to only send this to debster. But I forgot to change the address. I didn't mean to air dirty laundry in public. Doh.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Saturday, March 12, 2005 15:12 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I know they have several products, but have very little interest in them since I have so much experience in M2K. So, um Avante uses U2 or UV? I wonder if that's the "glorified jobshop" that my friend alluded to? All I know is that they bought ROI Systems in 07/03 and all the old timer ROI employees *HATE* working for them and have or are getting ready to jump ship...they say I'm the lucky one since I got laid off and got a compensation package, whereas they have had to put up with the huge corporate treatment of 'programmers as worker bees' mentality and are now quitting and receiving no package. I was a work-from-home 1,200 miles away from the office and was temporarily disabled with an elbow injury so severe that the doctors almost amputated. So when Epicor acquired ROI, I got the golden boot to the rear. Almost sued under the ADA, but I had an empty bank account and had to take the compensation package or risk loosing my house. :-0 !!! But that's ok, as Ann Landers used to say 'time wounds all heals'. ;-) *=aee=* -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Saturday, March 12, 2005 13:38 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor You forgot Avante -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Saturday, March 12, 2005 4:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Hi Will, You mean, like the epicor product that uses u2? (which I believe Manage-2000 is the only one). Or the epicor product that uses SQL? I have little knowledge of that one but an associate says it's a very poor substitute for M2K. His exact words:"I know their glorified jobshop package won't do diddly for m2k folk used to an mrp engine." (Manage-2000 abbreviated is M2k) If you're interested in M2k, I used it in a production distribution environment from 1988 to 1999, and still specialize in programming/consulting for that product. It's a very big system. Over 800 menus! Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, March 11, 2005 17:52 To: u2-users@listserver.u2ug.org Subject: [U2]: Epicor Is anyone on this list an Epicor user ? I have a client who is examining Epicor as a possible solution to part of what they need and would like some input. Thanks Will Johnson Fast Forward --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
The Avante package I am working on uses UV. They seem to have "Technical Bulletins" on almost a bi-weekly basis of bugs within the system. The patches are a bear to install if there is even the normal end-user amount of customization on the existing system and a nightmare if it's extensive. Most of these bugs you find fixing well before the patch arrives if it's in an area that you utilize. There appears to be little to no respect for how Epicor handles support. Trying to gestimate learning curve for an individual is hard. What shortens the timeframe is the same for any package/tool. Just how familiar are you with the outside factors such as a extensive understanding of manufacturing business process flow and if you have ever utilized SB+ before. If you are unfamiliar with either than it of course extends the learning curve. I have seen both sides of the coin with other consultants at my current contract, one had extensive expertise in SB+ and very little Basic or manufacturing. The end result in his contribution was use of SB+ tools that were not utilized anywhere else within the Avante system, spaghetti in regards to the manufacturing functions, and misuse of SB+ tools where Basic was more appropriate. [Not even the illustrious SB+ guru Kevin King did that as he passed through their doors] On the other side, yet another consultant was unable to conform to the use of SB+ when appropriate. In other words, when enhancing, by conforming to the rest of the system it creates a better flow and less problems, it also strengthens your understanding of the system. I found Avante's extensive use of SB+ tools the biggest hurdle since other systems I had used it on primarily utilized it for forms and report design leaving the majority of processes to be written more in Basic. That is not the case with Avante, there is extensive use of paragraphs. I find this more cumbersome, more system use intensive with poor use causing gross inefficiencies. If you use debugger a lot to troubleshoot as I had in the past, it becomes a nightmare. You wind up using trace and display functions instead at various points to view what is actually occurring. Making sure you don't step on yourself as you pass through multiple paragraphs, screens to basic and back to the original screen depends on file use and preserving the work files utilized. Best bet when customizing Avante is to not screw too much with the core files, but instead utilize fields so far out, or adding additional user files that the potential for Avante stepping on them is eliminated. Would I choose it as a package? No, I think there are far better choices out there that are far more manageable in terms of both support and ease of customization. But that is just my .02 Debster -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Saturday, March 12, 2005 4:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Hi Will, You mean, like the epicor product that uses u2? (which I believe Manage-2000 is the only one). Or the epicor product that uses SQL? I have little knowledge of that one but an associate says it's a very poor substitute for M2K. His exact words:"I know their glorified jobshop package won't do diddly for m2k folk used to an mrp engine." (Manage-2000 abbreviated is M2k) If you're interested in M2k, I used it in a production distribution environment from 1988 to 1999, and still specialize in programming/consulting for that product. It's a very big system. Over 800 menus! Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, March 11, 2005 17:52 To: u2-users@listserver.u2ug.org Subject: [U2]: Epicor Is anyone on this list an Epicor user ? I have a client who is examining Epicor as a possible solution to part of what they need and would like some input. Thanks Will Johnson Fast Forward --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
...also forgot Dataflo (DataWorks) and Manfact, both use U2. From: [EMAIL PROTECTED] on behalf of Debster Sent: Sat 3/12/2005 3:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor You forgot Avante -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Saturday, March 12, 2005 4:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Hi Will, You mean, like the epicor product that uses u2? (which I believe Manage-2000 is the only one). Or the epicor product that uses SQL? I have little knowledge of that one but an associate says it's a very poor substitute for M2K. His exact words:"I know their glorified jobshop package won't do diddly for m2k folk used to an mrp engine." (Manage-2000 abbreviated is M2k) If you're interested in M2k, I used it in a production distribution environment from 1988 to 1999, and still specialize in programming/consulting for that product. It's a very big system. Over 800 menus! Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, March 11, 2005 17:52 To: u2-users@listserver.u2ug.org Subject: [U2]: Epicor Is anyone on this list an Epicor user ? I have a client who is examining Epicor as a possible solution to part of what they need and would like some input. Thanks Will Johnson Fast Forward --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Martin - I appreciate it, but I didn't see an attachment... "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald From: "Martin Canty" <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: Subject: RE: [U2] Triggers docs? Date: Fri, 11 Mar 2005 22:47:35 -0800 Hi Dan, Attached is a document I wrote (for our monthly newsletter) to use triggers. The example is to trap record corruption, there is coding for both UniData & UniVerse. We found the culprit within 10 minutes of implementing the trigger! There is a cost to using triggers though I measured it on UniData 5 & found that an update with a trigger took something like 10 times longer than an index based trigger (though the real trigger is so much more functionally rich!) Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/msword which had a name of U2 Triggers.doc] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
