Re: [U2] Adding capabilities in the sort term
For point 2 we have been consuming many different webservices within unidata for many years - there are two main ways to do it, either entirely within u2 or partly within and partly outside. It depends on circumstances as to which is the most appropriate - it is in effect pretty easy either way. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: 06 July 2011 19:35 To: u2-users@listserver.u2ug.org Subject: [U2] Adding capabilities in the sort term Has anyone done either of the following with a U2 system (we have Universe) and can give me some recommendations? (1) Added a signature pad so that captured signatures can be stored for future use. (We have Print Wizard, so can easily print graphical images if they can just be captured.) (2) Worked with Web Services from within your U2 application? Thanks- Harold Oaks This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1388 / Virus Database: 1516/3747 - Release Date: 07/06/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
Yikes, not what I would have expected. Also happens on 10.2.7 -Dianne On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
Prime information also returned a hit anytime the following syntax was used I'm guessing UV tried to emulate prime whenever possible SELECT filename recordid perhaps a different flavor would yield different results Rich Dianne Ackerman wrote: Yikes, not what I would have expected. Also happens on 10.2.7 -Dianne On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
While I agree that the user typing the commands may find the results unexpected, if you think about how the TCL commands are implemented, it actually makes sense. If I type: ED FOO BAR The ED command has been given an item-id so it attempts to read it. If I type: ED FOO it checks if there's a select-list and uses it, otherwise it either gives you an error message about syntax or prompts you for an item-id, depending on your mv flavor. Now consider: SELECT FILENAME 'itemid' Or SELECT FILENAME @ID = itemid both effectively say hey! I have given you an item id. The TCL SELECT verb, once given an item-id, doesn't bother to check for a select list. Like any TCL verb it just reads the supplied item-ids. Item-ids supplied on the command-line override any active SELECT list. Once you get that, and realize that the two variations above are interpreted by the SELECT command as being equivalent to an item-id being provided on the command line, then the behavior is understood. I didn't say expected. I also didn't say desirable. I said understood! :) It's one of those syntactical things you need to be aware of. Depending on your MV flavor SELECT FILENAME @ID = itemid May not be interpreted as an item-id on the command line. In order to make my commands portable, I always use the form: SELECT FILENAME 'item-id' ... using single quotes for item-id, if I really want to specify an item-id and not scan the whole file or use the active select list. I always use SELECT FILENAME WITH dictid = item-id ... If I want to simply add selection criteria based on the item-id to my SELECT statement, scanning the whole file or using the active select list. The same behavior applies to SSELECT, LIST, SORT and any other related TCL processors. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson Sent: Thursday, July 07, 2011 8:46 AM To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? Prime information also returned a hit anytime the following syntax was used I'm guessing UV tried to emulate prime whenever possible SELECT filename recordid perhaps a different flavor would yield different results Rich Dianne Ackerman wrote: Yikes, not what I would have expected. Also happens on 10.2.7 -Dianne On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Adding capabilities in the sort term
Symeon: Maybe you could outline the reasons why it would be advantageous each way, and give a small example for each. It'd be an excellent PickWiki addition. The reason I say this is because most of us would like to try out this stuff starting out with very simple examples. Bill - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 7/7/2011 12:47 AM *Subject:* Re: [U2] Adding capabilities in the sort term For point 2 we have been consuming many different webservices within unidata for many years - there are two main ways to do it, either entirely within u2 or partly within and partly outside. It depends on circumstances as to which is the most appropriate - it is in effect pretty easy either way. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: 06 July 2011 19:35 To: u2-users@listserver.u2ug.org Subject: [U2] Adding capabilities in the sort term Has anyone done either of the following with a U2 system (we have Universe) and can give me some recommendations? (1) Added a signature pad so that captured signatures can be stored for future use. (We have Print Wizard, so can easily print graphical images if they can just be captured.) (2) Worked with Web Services from within your U2 application? Thanks- Harold Oaks This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1388 / Virus Database: 1516/3747 - Release Date: 07/06/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute all at once (unless I know for sure this condition won't occur). UD v7.2.7 responds as I've always expected: 5 Dev (0)- BPTEST CMD = \SELECT SOMEFILE WITH INVNO = 1234567\ ; CMD-1 = \SELECT SOMEFILE 3 71*1\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_334914081 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. 1 records selected to list 0. ...which treats the 2nd execute as its own if the 1st execute returns no data from its select. HTH, Bill - Original Message - *From:* mbr...@epicor.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/7/2011 9:02 AM *Subject:* Re: [U2] Found something interesting.Bug or No Bugthat ismy question? Sound like a bug to me. UniData is fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 07 July 2011 16:59 To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? We are running Information flavor.. Could be. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson Sent: Thursday, July 07, 2011 11:46 AM To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? Prime information also returned a hit anytime the following syntax was used I'm guessing UV tried to emulate prime whenever possible SELECT filename recordid perhaps a different flavor would yield different results Rich Dianne Ackerman wrote: Yikes, not what I would have expected. Also happens on 10.2.7 -Dianne On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
Absolutely. SELECT on a SELECT will prune the list if there is an active select and matching criteria. What should NOT happen is zero records on the second SELECT if you know the record is present - irrelevant of syntax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 07 July 2011 17:24 To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute all at once (unless I know for sure this condition won't occur). UD v7.2.7 responds as I've always expected: 5 Dev (0)- BPTEST CMD = \SELECT SOMEFILE WITH INVNO = 1234567\ ; CMD-1 = \SELECT SOMEFILE 3 71*1\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_334914081 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. 1 records selected to list 0. ...which treats the 2nd execute as its own if the 1st execute returns no data from its select. HTH, Bill - Original Message - *From:* mbr...@epicor.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/7/2011 9:02 AM *Subject:* Re: [U2] Found something interesting.Bug or No Bugthat ismy question? Sound like a bug to me. UniData is fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 07 July 2011 16:59 To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? We are running Information flavor.. Could be. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson Sent: Thursday, July 07, 2011 11:46 AM To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? Prime information also returned a hit anytime the following syntax was used I'm guessing UV tried to emulate prime whenever possible SELECT filename recordid perhaps a different flavor would yield different results Rich Dianne Ackerman wrote: Yikes, not what I would have expected. Also happens on 10.2.7 -Dianne On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== tqU8Szsdb6q+D60dYsLMkVk+N89MWS9AodmYIqzE2R4VA== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB 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. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2008 server and UNiverse Status command
I don't think I've ever seen U2 (or any Pick for that matter) crash and need a re-install when using it, unless there were serious hardware problems. Clearly, this is an issue for U2 support. Contact your support person at Rocket. HTH, Bill - Original Message - *From:* t.sto...@monolith.com *To:* u2-users@listserver.u2ug.org *Date:* 7/7/2011 9:20 AM *Subject:* [U2] 2008 server and UNiverse Status command On two servers when I have entered the STATUS command Universe has crashed requiring a reinstall. Has any one else encountered this. I have seen nothing in the Rocket knowledge base. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
George - it's not so much the with - I think it's more the =. It's a case of it doing precisely what you ask as opposed to what you are thinking you are doing. The = is creates selection criteria otherwise it considers whatever follows as a record ID and ignores the outstanding select list. Bill - don't forget the REQUIRE.SELECT keyword in UniData. It tests the select list for you. You can even combine them and get consistent (albeit even more confusing) results. Eg: SELECT FILENAME # EXISTING_ID 54 records selected to list 0. SELECT FILENAME EXISTING_ID 1 records selected to list 0. CLEARSELECT SELECT FILENAME # EXISTING_ID 54 records selected to list 0. SELECT FILENAME = EXISTING_ID No data retrieved from current (S)SELECT statement. SELECT FILENAME # EXISTING_ID 54 records selected to list 0. select FILENAME EXISTING_ID REQUIRE.SELECT 1 records selected to list 0. CLEARSELECT select FILENAME EXISTING_ID REQUIRE.SELECT No active select list. Processing terminated. Hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute all at once (unless I know for sure this condition won't occur). UD v7.2.7 responds as I've always expected: 5 Dev (0)- BPTEST CMD = \SELECT SOMEFILE WITH INVNO = 1234567\ ; CMD-1 = \SELECT SOMEFILE 3 71*1\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_334914081 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. 1 records selected to list 0. ...which treats the 2nd execute as its own if the 1st execute returns no data from its select. HTH, Bill On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2008 server and UNiverse Status command
I agree with Bill; call it in. I couldn't resist noting that at least it gave you a definitive answer... g. Date: Thu, 7 Jul 2011 09:32:08 -0700 From: wphask...@advantos.net To: u2-users@listserver.u2ug.org Subject: Re: [U2] 2008 server and UNiverse Status command I don't think I've ever seen U2 (or any Pick for that matter) crash and need a re-install when using it, unless there were serious hardware problems. Clearly, this is an issue for U2 support. Contact your support person at Rocket. HTH, Bill - Original Message - *From:* t.sto...@monolith.com *To:* u2-users@listserver.u2ug.org *Date:* 7/7/2011 9:20 AM *Subject:* [U2] 2008 server and UNiverse Status command On two servers when I have entered the STATUS command Universe has crashed requiring a reinstall. Has any one else encountered this. I have seen nothing in the Rocket knowledge base. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse Was Re: PICKSystems Administratorposition
Hey Guys, Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse Was Re: PICKSystems Administratorposition
You might want to check these guys out. Not sure if they deal with Eclipse (or if I understand what Eclipse really is- too many buzzwords to keep up with), but, they have done plenty of Ultimate Plus to Universe/Unidata conversions and moved people away from Activant, while keeping the old PICK/MV apps in place. http://www.s7.com/s7migrationservices.html A gentleman by the name of Bruce Decker helped us out a great deal. If that is not relevant, forgive my ignorance on the understanding of what Eclipse is. I was just assuming that it was some type of MV system, or you would not have posted here... On Thu, Jul 7, 2011 at 2:03 PM, David maildsi...@gmail.com wrote: Hey Guys, Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse Was Re: PICKSystems Administratorposition
They would probably do QM or some other flavor too, but, for an extra fee. It all depends on, if its been done before, etc. etc., and how much new engineering has to be done. On Thu, Jul 7, 2011 at 2:18 PM, John Thompson jthompson...@gmail.comwrote: You might want to check these guys out. Not sure if they deal with Eclipse (or if I understand what Eclipse really is- too many buzzwords to keep up with), but, they have done plenty of Ultimate Plus to Universe/Unidata conversions and moved people away from Activant, while keeping the old PICK/MV apps in place. http://www.s7.com/s7migrationservices.html A gentleman by the name of Bruce Decker helped us out a great deal. If that is not relevant, forgive my ignorance on the understanding of what Eclipse is. I was just assuming that it was some type of MV system, or you would not have posted here... On Thu, Jul 7, 2011 at 2:03 PM, David maildsi...@gmail.com wrote: Hey Guys, Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse Was Re: PICKSystems Administratorposition
Also ask whether your client owns the source code. If not, things get trickier when dealing with Activant/Epicor. Fortunately, we did own our own source code, so there wasn't much they could do, when we decided to move away from them. On Thu, Jul 7, 2011 at 2:20 PM, John Thompson jthompson...@gmail.comwrote: They would probably do QM or some other flavor too, but, for an extra fee. It all depends on, if its been done before, etc. etc., and how much new engineering has to be done. On Thu, Jul 7, 2011 at 2:18 PM, John Thompson jthompson...@gmail.comwrote: You might want to check these guys out. Not sure if they deal with Eclipse (or if I understand what Eclipse really is- too many buzzwords to keep up with), but, they have done plenty of Ultimate Plus to Universe/Unidata conversions and moved people away from Activant, while keeping the old PICK/MV apps in place. http://www.s7.com/s7migrationservices.html A gentleman by the name of Bruce Decker helped us out a great deal. If that is not relevant, forgive my ignorance on the understanding of what Eclipse is. I was just assuming that it was some type of MV system, or you would not have posted here... On Thu, Jul 7, 2011 at 2:03 PM, David maildsi...@gmail.com wrote: Hey Guys, Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson -- John Thompson -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse Was Re: PICKSystems Administratorposition - Bayesian Filter detected spam
Just drop support and hire an ex-Eclipse employee to do the programming. Quicken and Activant reduced development and support staff so there are people out there. And you say they are a client ... do you program for them? Email me off-line for more info Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Sent: Thursday, July 07, 2011 11:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]Epicor and Eclipse Was Re: PICKSystems Administratorposition - Bayesian Filter detected spam Hey Guys, Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
Colin: REQUIRE.SELECT only works with the UniData parser, which is okay. For example: 7 Dev (0)- BPTEST CMD = \SELECT APOPEN WITH INVNO = 1234567\ ; CMD-1 = \SELECT APOPEN 3 71*1 REQUIRE.SELECT\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_424967581 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. Illegal attribute name: REQUIRE.SELECT 7 Dev (0)- BPTEST CMD = \SELECT APOPEN WITH INVNO = 1234567\ ; CMD-1 = \select APOPEN 3 71*1 REQUIRE.SELECT\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_429101431 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. No active select list. Processing terminated. We run in Pick mode so this is just one of the many dances required from UniData. Sometimes I forget these so thanks for the reminder (although this didn't help at all during a D3 to UD conversion - didn't want to change code when SYSTEM(11) works just fine). Thanks again, Bill - Original Message - *From:* alfke...@hotmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 7/7/2011 9:57 AM *Subject:* Re: [U2] Found something interesting.Bug or No Bugthat ismy question? George - it's not so much the with - I think it's more the =. It's a case of it doing precisely what you ask as opposed to what you are thinking you are doing. The = is creates selection criteria otherwise it considers whatever follows as a record ID and ignores the outstanding select list. Bill - don't forget the REQUIRE.SELECT keyword in UniData. It tests the select list for you. You can even combine them and get consistent (albeit even more confusing) results. Eg: SELECT FILENAME # EXISTING_ID 54 records selected to list 0. SELECT FILENAME EXISTING_ID 1 records selected to list 0. CLEARSELECT SELECT FILENAME # EXISTING_ID 54 records selected to list 0. SELECT FILENAME = EXISTING_ID No data retrieved from current (S)SELECT statement. SELECT FILENAME # EXISTING_ID 54 records selected to list 0. select FILENAME EXISTING_ID REQUIRE.SELECT 1 records selected to list 0. CLEARSELECT select FILENAME EXISTING_ID REQUIRE.SELECT No active select list. Processing terminated. Hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute all at once (unless I know for sure this condition won't occur). UD v7.2.7 responds as I've always expected: 5 Dev (0)- BPTEST CMD = \SELECT SOMEFILE WITH INVNO = 1234567\ ; CMD-1 = \SELECT SOMEFILE 3 71*1\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_334914081 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. 1 records selected to list 0. ...which treats the 2nd execute as its own if the 1st execute returns no data from its select. HTH, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Adding capabilities in the sort term
Hi, We are using HostAccess as our terminal emulator and Verifone's MX870 for the PIN Pad device. We chose to use Verifone's IP Connect product to actually perform the communication with the device. HostAccess provides basic subroutines that will permit you to send the commands to either talk to the MX or their SIM dll. Either way, we receive the signature back and display it on the screen without a problem. The beauty of the way we are doing this is that credit cards never touch our server, and with Verifone's end-to-end encryption no usable credit card information touches the register, which takes both out of scope for PCI DSS, and PCI PA-DSS... depending on your auditor that is. Tom Whitmore, RATEX Business Solutions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, July 06, 2011 2:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Adding capabilities in the sort term Has anyone done either of the following with a U2 system (we have Universe) and can give me some recommendations? (1) Added a signature pad so that captured signatures can be stored for future use. (We have Print Wizard, so can easily print graphical images if they can just be captured.) (2) Worked with Web Services from within your U2 application? Thanks- Harold Oaks This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse
From: David Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. I'm hoping they consider migration to another MV-based platform rather than doing the multi-whammy : changing DBMS, application, vendors, and employees. There are many fine ERP packages based on MV. The company should check with Rocket Software, and since they're considering a full migration anyway I believe they should also talk with Northgate, InterSystems, and TigerLogic, who all have vendors with large-scale packages. If they don't find what they need, sure, consider going elsewhere. Yes, to answer the questions, FOSS ERP platforms have been getting more robust and are worthy of investigation. I don't have stats right now but not long ago something like 12 out of the top 20 SourceForge projects were ERP - not the typical stuff we see there like torrent client/server, Linux tools, or games. I've said for years that MV-based ERP vendors were going to lose their shirts to those other offerings if they didn't learn to adapt and compete. Well, here we are. Hint to MV application vendors: Open Source your software, sell support and development services, and market that model to the mainstream. That's what your modern competitors are doing. And really, isn't that sort of what you've been doing for decades anyway, just not advertising it? Then you just need to get the DBMS vendors to open their eyes and recognize that the per-seat licensing model has been dead for at least a decade... Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse
An interesting stat about openbravo is how many devs they have on staff. I looked at them a few years ago and it was huge. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Installing UniObjects on Windows 2008 64 bit
Hello, A few weeks ago I posted about the trouble we've been having getting UniObjects to work as a COM/OLE object inside 64-bit Lotus Domino. We've been looking at ways to use the .Net version of UniObjects inside Domino instead, and we found the following web page that talks about how to access a .Net class from LotusScript: https://www-304.ibm.com/support/docview.wss?rs=899uid=swg21230705 Following the directions on that page, we've run GACUTIL and REGASM to register the objects in the uodotnet.dll and make them accessible via the COM interface, with partial success. When we use the Object Viewer, under the Object Classes / Grouped by Component Category / .Net Category, we find the following two classes: IBMU2.UODOTNET.SupportClass and IBMU2.UODOTNET.UniRecord. There are also entries for a bunch of exceptions: IBMU2.UODOTNET.UniCommandException, UniDataSetException, UniDynArrayException, UniFileException, etc. There are 14 of those exception entries in total. The rest of the classes, like UniObjects, UniSession, etc. are not listed in the object viewer (though some like UniCommand, UniDynArray and UniFile do have their exceptions listed). In LotusScript, we can then use the following code to successfully access the two exposed UniObjects classes: set obj = CreateObject(IBMU2.UODOTNET.SupportClass) set obj2 = CreateObject(IBMU2.UODOTNET.UniRecord) Both of those statements work. However, by themselves, those classes aren't much use. We cannot create COM objects for the core UniObjects, UniSessions, UniFile, etc. classes. They just give the generic cannot create automation object error messages. Does anyone know why the remainder of the UniObjects classes would not be accessible via the COM interface after using GACUTIL and REGASM? Is there something about the remaining UniObject classes that make them somehow incompatible with this approach for exposing .Net dlls as COM objects, even though it worked for the UniRecord class? Or are we just missing a step somewhere? Any advice would be welcomed! Thanks, Jim Stoner ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse
Well, I don't know Eclipse, but the company I currently work for is running Avante from Epicor. When the company wanted to cancel the Avante maintenance agreement Epicor claimed that this would automatically cancel UniData and SB+ support as well. Avante maintenance was a total waste of money since the original software has been heavily modified (and even though the changes were made by Epicor staff fixing their bugs was still chargeable) and by the time I could prove to Epicor that a fault was a genuine bug I had already a fix for it anyway. Of course we have the source code for Avante. To cut a long story short - we now have UD and SB+ support through another VAR and don't deal with Epicor anymore. Mecki On 07/07/2011 22:27, Tony Gravagno wrote: From: David Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. I'm hoping they consider migration to another MV-based platform rather than doing the multi-whammy : changing DBMS, application, vendors, and employees. There are many fine ERP packages based on MV. The company should check with Rocket Software, and since they're considering a full migration anyway I believe they should also talk with Northgate, InterSystems, and TigerLogic, who all have vendors with large-scale packages. If they don't find what they need, sure, consider going elsewhere. Yes, to answer the questions, FOSS ERP platforms have been getting more robust and are worthy of investigation. I don't have stats right now but not long ago something like 12 out of the top 20 SourceForge projects were ERP - not the typical stuff we see there like torrent client/server, Linux tools, or games. I've said for years that MV-based ERP vendors were going to lose their shirts to those other offerings if they didn't learn to adapt and compete. Well, here we are. Hint to MV application vendors: Open Source your software, sell support and development services, and market that model to the mainstream. That's what your modern competitors are doing. And really, isn't that sort of what you've been doing for decades anyway, just not advertising it? Then you just need to get the DBMS vendors to open their eyes and recognize that the per-seat licensing model has been dead for at least a decade... Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse - Found word(s) remove list in the Text body
2 dozen cheers for Mecki. Yes, this is a standard VAR tactic, since they are paying your license fees to the software vendor. Just deal directly with the software vendor. They tried that with our 3rd party fax software and had logged on to our system after we had dropped support. I had to remind them of California Penal Code Section 502 -Unauthorized Access to Computers, Computer Systems and Computer Data. Check your software contract - it may say licensed in perpetuity We never buy software without the source code. Garry L. Smith -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, July 07, 2011 2:55 PM To: U2 Users List Subject: Re: [U2] Epicor and Eclipse - Found word(s) remove list in the Text body Well, I don't know Eclipse, but the company I currently work for is running Avante from Epicor. When the company wanted to cancel the Avante maintenance agreement Epicor claimed that this would automatically cancel UniData and SB+ support as well. Avante maintenance was a total waste of money since the original software has been heavily modified (and even though the changes were made by Epicor staff fixing their bugs was still chargeable) and by the time I could prove to Epicor that a fault was a genuine bug I had already a fix for it anyway. Of course we have the source code for Avante. To cut a long story short - we now have UD and SB+ support through another VAR and don't deal with Epicor anymore. Mecki On 07/07/2011 22:27, Tony Gravagno wrote: From: David Have a client who has been on Eclipse since 2000. They are sick to death with the nickle and dime (read eye gouge) tactics by Activant and want out. Do you think Open Bravo or any of the other Open source ERP products could replace it. Obviously with a lot of customization. I'm hoping they consider migration to another MV-based platform rather than doing the multi-whammy : changing DBMS, application, vendors, and employees. There are many fine ERP packages based on MV. The company should check with Rocket Software, and since they're considering a full migration anyway I believe they should also talk with Northgate, InterSystems, and TigerLogic, who all have vendors with large-scale packages. If they don't find what they need, sure, consider going elsewhere. Yes, to answer the questions, FOSS ERP platforms have been getting more robust and are worthy of investigation. I don't have stats right now but not long ago something like 12 out of the top 20 SourceForge projects were ERP - not the typical stuff we see there like torrent client/server, Linux tools, or games. I've said for years that MV-based ERP vendors were going to lose their shirts to those other offerings if they didn't learn to adapt and compete. Well, here we are. Hint to MV application vendors: Open Source your software, sell support and development services, and market that model to the mainstream. That's what your modern competitors are doing. And really, isn't that sort of what you've been doing for decades anyway, just not advertising it? Then you just need to get the DBMS vendors to open their eyes and recognize that the per-seat licensing model has been dead for at least a decade... Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Charles Shaffer/NTNBOWER is out of the office
I will be out of the office starting 07/07/2011 and will not return until 07/11/2011. I will be out of the office until June 6. I will respond to your message when I return. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users