[U2] RE:
Dear Howard VMark was the company that developed the UniVerse Data Base product for which I have had much to do with for many years. VMark acquired Unidata and renamed itself to Ardent Software. Ardent was purchased by Informix and Informix was purchased by IBM. IBM now sell and support UniVerse. Now on another point. You say your boss may not want to spend good money keeping old data alive. Well it seems to me that if this old data is still useful and necessary then it must surely be considered current and active data. The fact that it resided in an old application is besides the point. I suggest purchasing the minimum UniVerse licences possible as this data probably only needs one or two uses accessing it at any point in time and this would keep the cost to a minimum. Hope this suggestion is useful. Cheers Trevor Ockenden Open Systems Professionals Sydney Australia m: 0414 731 634 e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wong, Howard Sent: Wednesday, 16 March 2005 1:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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.3 - Release Date: 15/03/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE:
Trevor, Indeed your suggestion reflects the views of many who have replied to my post. It is the least painful and most-certain way for us to make the data available for a few more years when the app will eventually be retired. Since we don't have any knowledge on UV, invariably we'd have to pay for outside help if we choose to extract the data instead of installing a new version of UV. Therefore I suspect the costs for both cases may come out to be pretty close. In any case, it will be the manager's call. Thanks for your thoughts. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Trevor Ockenden [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 5:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Dear Howard VMark was the company that developed the UniVerse Data Base product for which I have had much to do with for many years. VMark acquired Unidata and renamed itself to Ardent Software. Ardent was purchased by Informix and Informix was purchased by IBM. IBM now sell and support UniVerse. Now on another point. You say your boss may not want to spend good money keeping old data alive. Well it seems to me that if this old data is still useful and necessary then it must surely be considered current and active data. The fact that it resided in an old application is besides the point. I suggest purchasing the minimum UniVerse licences possible as this data probably only needs one or two uses accessing it at any point in time and this would keep the cost to a minimum. Hope this suggestion is useful. Cheers Trevor Ockenden Open Systems Professionals Sydney Australia m: 0414 731 634 e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wong, Howard Sent: Wednesday, 16 March 2005 1:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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.3 - Release Date: 15/03/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 --- 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] RE:
Also don't forget that Universe is a programming language as well as a database. In these sorts of cases a lot of people cost the movement of the data itself and forget all about the cost of developing an application that can actually do something with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: 16 March 2005 13:52 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: Trevor, Indeed your suggestion reflects the views of many who have replied to my post. It is the least painful and most-certain way for us to make the data available for a few more years when the app will eventually be retired. Since we don't have any knowledge on UV, invariably we'd have to pay for outside help if we choose to extract the data instead of installing a new version of UV. Therefore I suspect the costs for both cases may come out to be pretty close. In any case, it will be the manager's call. Thanks for your thoughts. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Trevor Ockenden [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 5:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Dear Howard VMark was the company that developed the UniVerse Data Base product for which I have had much to do with for many years. VMark acquired Unidata and renamed itself to Ardent Software. Ardent was purchased by Informix and Informix was purchased by IBM. IBM now sell and support UniVerse. Now on another point. You say your boss may not want to spend good money keeping old data alive. Well it seems to me that if this old data is still useful and necessary then it must surely be considered current and active data. The fact that it resided in an old application is besides the point. I suggest purchasing the minimum UniVerse licences possible as this data probably only needs one or two uses accessing it at any point in time and this would keep the cost to a minimum. Hope this suggestion is useful. Cheers Trevor Ockenden Open Systems Professionals Sydney Australia m: 0414 731 634 e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wong, Howard Sent: Wednesday, 16 March 2005 1:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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.3 - Release Date: 15/03/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message.
RE: [U2] RE:
Louie, The answer I got was one user at a time. So there are many users, but never more than one will use the app at any given time. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Louie Gouws [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 1:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Howard, Yes VMARK was the owner of the UniVerse RDBMS. The owner now is IBM. How many users need to read the 'old' data? Louie orig post but need to keep the data and move them to a newer server, Unix or otherwise. solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. This old app is kept around for reference, and is not being actively updated. Howard ~~~ --- 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] Paciolan
I'm working with some data from a system called Paciolan. (http://www.paciolan.com) It tracks season ticket holders, etc., for our athletics department. They keep sending spreadsheets with the 'tab' named SBCLIENT, which made me curious. So I hunted around on the web... Paciolan is listed as a U2 Business Partner. Does anyone know which database is underneath Paciolan's system? The people who use it are having trouble getting data out of it for us. Life would be easier around here if we could get directly at the data (read only is fine) and if it's a U2 database, so much the better! -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Paciolan
UniVerse Robin Stanley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak Sent: Wednesday, March 16, 2005 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Paciolan I'm working with some data from a system called Paciolan. (http://www.paciolan.com) It tracks season ticket holders, etc., for our athletics department. They keep sending spreadsheets with the 'tab' named SBCLIENT, which made me curious. So I hunted around on the web... Paciolan is listed as a U2 Business Partner. Does anyone know which database is underneath Paciolan's system? The people who use it are having trouble getting data out of it for us. Life would be easier around here if we could get directly at the data (read only is fine) and if it's a U2 database, so much the better! -- Wendy Smoak --- 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
Just something to remember, when the accountants get *nailed* during an audit, they are going to say: but I.T. let us do it. THEY should have made sure the data was OK! And THEY should have made sure there was an audit trail Been there, done that. Bean counters *can* be a backstabbing bunch. Fortunately, I kept all the original requests for mods, and I DID keep an audit trail unknown to the accountants. THEY lost THEIR job when I produced the audit trail and request for mods - absence of any mention of an audit trail, and I KEPT mine :-) Note that the above is not designed to besmirch the reputation of, nor the general character of bean counters. It is simply an observation that in all groups you have your winners and your weasels. And they look exactly the same in a suit and tie. So honor their requests, but CYA!!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 09:15 To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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
Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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] Paciolan
Wendy - The Cal Athletic Department has a Paciolan ticketing system as well. It is, indeed, Universe-based as Robin reported. In fact, until about 9 months ago our web app was combining data retrieved from our UniData Benefactor system and the Paciolan Ticketing system and presenting a single picture of a donor/customer's activity with the campus. Real time! Sweet! Last summer the Athletic Department decided to get out of the business of maintaining their own system and chose Paciolan's 'hosted' solution. Paciolan does not allow odbc calls to their systems, so now we get ticket data from an extract file that comes to us (from the Paciolan system) nightly. Jim --- Wendy Smoak [EMAIL PROTECTED] wrote: I'm working with some data from a system called Paciolan. (http://www.paciolan.com) It tracks season ticket holders, etc., for our athletics department. They keep sending spreadsheets with the 'tab' named SBCLIENT, which made me curious. So I hunted around on the web... Paciolan is listed as a U2 Business Partner. Does anyone know which database is underneath Paciolan's system? The people who use it are having trouble getting data out of it for us. Life would be easier around here if we could get directly at the data (read only is fine) and if it's a U2 database, so much the better! -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Write in debug breaks on trigger
Hi Folks. I'm trying to debug a program using the UniDebugger in UV 10.1 but when the program goes to do a WRITE to a file that a trigger on it, it's breaking with the following message. Program LABEL.BUILD.PICK.REPRINT: Line 578, Error performing trigger for PMCF. Program LABEL.BUILD.PICK.REPRINT: Line 578, WRITE failure. T Verb T is not in your VOC. The line it's breaking on is: 578:WRITEV '0' ON PMCF,LABEL.COUNTER*:CO:*:SHIP.DATE,1 ; * RESET LABEL COUNTER TO ZERO It appears to be any type of WRITE statement as it was breaking on an earlier WRITE to the PMCF file that wasn't a WRITEV. In testing, I commented out that first WRITE to get past it but then hit the same error on this statement, WRITEV. If I run the program, I do not have this error and the writes are performed and the data updated. If I take off the triggers for this file, it runs and debugs properly. I'm needing to run this program in our LIVE system in debug so I need to also have the triggers running. Anyone have any idea what would cause triggers to behave differently while debugging? I'm stumped! TIA. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2]: Epicor
My code has comments that don't always relate to the code. And I should probably step up the documentation to include the specific request itself. Or devise a more formal methad as Mr. Ellwood has done. But, where I work we are all at will employees. Fired at will or walk at will either way. I'm not too worried about loosing a job over some code changes that were misused. And I don't think that jail time is going to happen for a coder who makes a change that a CPA abuses. I should also point out that I have the benefit(!?!?) of working for a partnership that is not (yet) required to meet the SOX regulations. On Wed, 16 Mar 2005 09:59:34 -0800, Bill H. [EMAIL PROTECTED] wrote: Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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] Write in debug breaks on trigger
I reported something similar a while ago. I think it is due to the fact that input is not allowed during a trigger subroutine. As as you are in the debugger, input is required to step through the program you are debugging, when the trigger fires the input is trapped. I think this is a bug, U2 should be able to determine the difference between this type of input, or, it should step over the trigger, executing it, but not allowing debugging of it, so at least you can debug the rest of your program. I wonder if you compile the trigger with the -I flag? so that it cannot be debugged if that would fix the problem? Cheers, Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Gnosys Consulting Limited is not responsible for any changes made to this message and / or any attachments after sending by Gnosys Consulting Limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, March 17, 2005 7:09 AM To: U2-Users List Subject: [U2] Write in debug breaks on trigger Hi Folks. I'm trying to debug a program using the UniDebugger in UV 10.1 but when the program goes to do a WRITE to a file that a trigger on it, it's breaking with the following message. Program LABEL.BUILD.PICK.REPRINT: Line 578, Error performing trigger for PMCF. Program LABEL.BUILD.PICK.REPRINT: Line 578, WRITE failure. T Verb T is not in your VOC. The line it's breaking on is: 578:WRITEV '0' ON PMCF,LABEL.COUNTER*:CO:*:SHIP.DATE,1 ; * RESET LABEL COUNTER TO ZERO It appears to be any type of WRITE statement as it was breaking on an earlier WRITE to the PMCF file that wasn't a WRITEV. In testing, I commented out that first WRITE to get past it but then hit the same error on this statement, WRITEV. If I run the program, I do not have this error and the writes are performed and the data updated. If I take off the triggers for this file, it runs and debugs properly. I'm needing to run this program in our LIVE system in debug so I need to also have the triggers running. Anyone have any idea what would cause triggers to behave differently while debugging? I'm stumped! TIA. BobW --- 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
Now who ever said you were allowed to export, massage, and then reimport with no validation? H...sounds like something I would like to have DONE to me.. -- Debster -- Original message -- Now here's something that I can give an opinion on without obvious bias. I fail to see the benefit of a feature that allows you to easily circumvent you ERP systems data input process. To easily allow users to export ERP data to a spreadsheet...massage the data...then re-import that data back into the database has at least two obvious problems to me. First, data integrity becomes marginal at best. Second, what is wrong with the ERP input process that requires the data to be changed by another outside process? Epicor does have apps that integrate back to the ERP database, but the data is run through the input processes as part of that integration. Users are advised that doing updates outside of these processes are done so at their own peril. I don't know about ISO compliance, but easy outside input to the database is frowned upon by the FDA, SEC, and SOX auditors. David Litzau Epicor Technical Support J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Tuesday, March 15, 2005 2:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Marc: It is possible that this sort of data movement is precisely the reason financial information, at numerous companies, is difficult to attest to, let alone use for analysis. :-) When I see this benefit (capability), red flags go up all over the place. It's like giving a gun to children...most will be ok but someone __WILL__ get hurt. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Tuesday, March 15, 2005 8:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Being a Manage-2000 client, and having been an Oracle client in the past (10.x) and having seen a JD demo I must say of the t1 suppliers, they did put on a nice show. (They could export directly to excel, change data, and re import the data back into the erp) :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Tuesday, March 15, 2005 10:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor So maybe Advante, Dataflo, infoflo, M2K and the like are not tier 1 multi-million dollar installs. But for ease of use and the ability to tweak the system to meet your needs. I'll take the tier 2 any day. Not intending to start an argument, but what can SAP or JD Edwards do that the smaller Epicor products can't do? What makes them worth the added cost? I don't' buy into that they can handle more users. That is mostly a matter of database management, hardware and infrastructure. You also have to consider who is buying what system and what their intensions are. What do you really get out of a standard SAP or JD Edwards install that you can't get from any system provided by Epicor or similar smaller priced package? I'm not being rhetorical.(again spell checker saves the day, I didn't know a word could start with rh.) P.s. you can get the Monitor Series at a Circuit city store or other high end audio stores near you! You can't seriously expect me to send you something for free! I can't get stuff for free. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Debster Sent: Tuesday, March 15, 2005 12:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to
RE: [U2]: Epicor
sigh Why is it us against them? as in IT vs the Bean counters? Duh...that is where I always had my greatest problems as a project manager..getting IT and financial to play nice in the same sandbox. I hate to say it, but IT was always the worse of the two warring factions in this regard. YOU ALL WORK FOR THE SAME COMPANY An export tool has been used (and sometimes abused) for over 20 some odd years now. Accounting wants pivot tables etc...they can create presentations, they reformat and consolidate, and sometimes it is the only way to get consolidated financials from disparate systems. If you had no idea why or if Accounting ever wanted spreadsheets, ask..if you think they don't...you've been living under a rock -- Debster -- Original message -- Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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 system that I had setup, allowed accountants to change any field on an invoice. Believe it or not, that was the request. What they didn't know was that I kept a simple before change/change request/after change snapshot of the data along with date/time/logon as I had been warned about by a wise professor back in my school days (daze?). What I didn't know, was that they were changing the dates and invoice numbers on the invoices to make them look as if they were only 30-60 days old. This was to make the receivables look current, and therefore the company could leverage that to borrow money from Wells Fargo for purchase of more product to sell. The auditors from AA were very savvy and spotted the same invoice amount with different dates and different invoice numbers on printed aging reports kept for historical purposes. When they asked me about how that could happen, I produced the audit report. The accountants were charged with FRAUD at Wells Fargo's request and were tried and sent to jail! This was in the 80's. Way way before SOX. The first thing the accountants did was point the finger at me. That's why the auditors came to me along with the CEO with the intention of nailing me. Had I not been a paranoid programmer, I might have ended up in jail. The accountants thought I was a patsy, and got lots of time to think about that for 5 years. At the time, I worked for the accounting department. So I literally was protecting my career from my boss who was a fool of the highest magnitude and whom had drastically underestimated my abilities as a business analyst and programmer. Just because you're paranoid, doesn't mean they're NOT out to get you! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 11:06 To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor My code has comments that don't always relate to the code. And I should probably step up the documentation to include the specific request itself. Or devise a more formal methad as Mr. Ellwood has done. But, where I work we are all at will employees. Fired at will or walk at will either way. I'm not too worried about loosing a job over some code changes that were misused. And I don't think that jail time is going to happen for a coder who makes a change that a CPA abuses. I should also point out that I have the benefit(!?!?) of working for a partnership that is not (yet) required to meet the SOX regulations. On Wed, 16 Mar 2005 09:59:34 -0800, Bill H. [EMAIL PROTECTED] wrote: Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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
Mostly true. But how many systems are being chosen by the beancounters because they're standard? Not because it helps to improve sales, manufacturing or operations, just accounting functions? And then sales/manufacturing/operations has to adopt to the new, improved system? If SAP and/or Oracle/Peoplesoft is that great, why are any other packages being bought? Rog [EMAIL PROTECTED] wrote: Why is it us against them? as in IT vs the Bean counters? Duh...that is where I always had my greatest problems as a project manager..getting IT and financial to play nice in the same sandbox. I hate to say it, but IT was always the worse of the two warring factions in this regard. YOU ALL WORK FOR THE SAME COMPANY An export tool has been used (and sometimes abused) for over 20 some odd years now. Accounting wants pivot tables etc...they can create presentations, they reformat and consolidate, and sometimes it is the only way to get consolidated financials from disparate systems. If you had no idea why or if Accounting ever wanted spreadsheets, ask..if you think they don't...you've been living under a rock -- Debster --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
I seem to remember there is a link into ADO for CR ... maybe you could link into RBOs? XML might be another possible methodology - but I don't have a copy of CR to play with... Anyone got any inside information on these features in CR? Regards JayJay We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects and LDAP user authentication.
Gordon, Our system admin department just changed our Sun servers from using NIS (Network Information Name Service) to LDAP Directory Service. It was said that this user authentication is more secure than NIS. Unfortunately, our UniObjects quit working. When I try to open a session within a VBA program or with the UniDebugger it fails due to Invalid User Name or Password. doesn't the UniDebugger login using telnet? (I haven't used it for a while). Maybe the username/password you are using is not in LDAP? I would think that LDAP vs NIS should be transparent to the application (unless its SASL, maybe you need to associate a service tag with an authentication method in your SASL config?). Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2]: Epicor
It all boils down to Education and teams working together. If the powers that be see that IT does not cooperate then you get left out of the picture only to complain that decisions were made for you. Smart CFO's don't want to shell out for more than they have to, and that includes having to replace all the labor in IT because no one has the skill set to support their purchase. That happens when you have not proven any value to the overall progress of the company. They want results and they want them fast as possible with as little interruption to the business flow. Savvy companies now recognize IT's value and no longer consider it simply as a service department for the company. That accurate data is priceless -- Debster -- Original message -- Mostly true. But how many systems are being chosen by the beancounters because they're standard? Not because it helps to improve sales, manufacturing or operations, just accounting functions? And then sales/manufacturing/operations has to adopt to the new, improved system? If SAP and/or Oracle/Peoplesoft is that great, why are any other packages being bought? Rog [EMAIL PROTECTED] wrote: Why is it us against them? as in IT vs the Bean counters? Duh...that is where I always had my greatest problems as a project manager..getting IT and financial to play nice in the same sandbox. I hate to say it, but IT was always the worse of the two warring factions in this regard. YOU ALL WORK FOR THE SAME COMPANY An export tool has been used (and sometimes abused) for over 20 some odd years now. Accounting wants pivot tables etc...they can create presentations, they reformat and consolidate, and sometimes it is the only way to get consolidated financials from disparate systems. If you had no idea why or if Accounting ever wanted spreadsheets, ask..if you think they don't...you've been living under a rock -- Debster --- 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
We have seen a couple of cases where the CFO has gone to jail for carrying out an illegal action. The CFO gained no financial advantage, whilst the CEO who gained the financial advantage actually never went to jail. In the UK a programmer got into serious trouble when programming who got university places. After exhausting a variety of priority issues such as marks to decide who would get a position, he then made a decision based on skin colour. Programmers are regarded as professional/educated people by the courts and the courts view is that a programmer should no better when programming improper code. (Ignorance is no excuse) If a programmer modifies the code so the CFO does not pay the correct tax, then the court regards the programmer as an accomplice to the crime. The court's view is that a threat of sacking is not an excuse to commit a crime. Bill is right some IT people will be in for a horrific shock as they could be caught up in fraud, privacy issues, spam and other areas and most have not considered their legal implications. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Thursday, 17 March 2005 5:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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
Shouldn't this be on community by now? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: 17 March 2005 05:15 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor We have seen a couple of cases where the CFO has gone to jail for carrying out an illegal action. The CFO gained no financial advantage, whilst the CEO who gained the financial advantage actually never went to jail. In the UK a programmer got into serious trouble when programming who got university places. After exhausting a variety of priority issues such as marks to decide who would get a position, he then made a decision based on skin colour. Programmers are regarded as professional/educated people by the courts and the courts view is that a programmer should no better when programming improper code. (Ignorance is no excuse) If a programmer modifies the code so the CFO does not pay the correct tax, then the court regards the programmer as an accomplice to the crime. The court's view is that a threat of sacking is not an excuse to commit a crime. Bill is right some IT people will be in for a horrific shock as they could be caught up in fraud, privacy issues, spam and other areas and most have not considered their legal implications. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Thursday, 17 March 2005 5:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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/ 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/