[U2] Re: U2 Users Digest V1 #913
We do it all the time every day with BCI through EasySoft. There are some unfortunate limits (BCI doesn't handle many SQL types such as BigInt properly, for example), but there are usually ways around them based on how you write your queries. HTH, David Beahm Date: Mon, 7 Nov 2005 22:13:43 -0800 From: Dave Taylor [EMAIL PROTECTED] Subject: [U2] Reading/Writing MySQL Records into/out of Universe 10.x from Universe 10.x I've reviewed the archives and haven't found any definitive strategies for reliably reading/writing MySQL records into/out of Universe 10.x from Universe 10.x. Does anyone have any directly applicable and successful how-you've-done-it experience in this area? tia, Dave Dave Taylor President Sysmark Information Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sort help needed
Your logic is wrong here; you are inserting whether PART.NBR is found or not. The INS should be inside the ELSE clause. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Monday, November 07, 2005 4:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed LOCATE PART.NBR IN RECORD14,1 BY AL SETTING POSELSE NULL INS PART.NBR BEFORE RECORD14,POS INS related.data BEFORE related.field14,POS No need to do the second locate. Note: I've used the PI/Open syntax for the LOCATE statement (that's the only one I relate to), you may have to alter the syntax slightly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Plant hopping help
Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Fwd: [UV] Neiman Marcus posting for Sr. Technologist, UniVerse DBA
Posted on behalf of a non list member. Begin forwarded message: - This position will be a member of a small team of DBA's that assist with providing effective development and production level database technical support, and the strategic UniVerse database direction for NM Direct, BGMS and EDW. In addition, this individual is expected to facilitate and deliver enhancements to database maintenance and monitoring, proactively identify and eliminate causes of potential production disruptions, and successfully complete Disaster Recovery and Cold Fail-Over activities. Candidates interested in this position should possess the following: Minimum 5 years of UniVerse Database Administration Minimum 7 years of experience in IT/IS Environment Expertise in UniVerse 9x or 10x Database performance tuning, monitoring, troubleshooting and problem resolution Experienced in Development and Production of UVBasic applications Expertise in creating and upgrading UniVerse databases Familiarity with vi and shell scripting In Depth knowledge of UniVerse databases backup and recovery Experience in other Database (Oracle, MS-SQL Server, Informix, Teradata, or Netezza) is a plus Experience in IBM AIX Environment Self motivated and multi-tasking individual that works well in a small team environment Available to cover responsibilities of a rotating 24 x 7 on-call shift Available to work nights and weekends on short notice, as needs require Strong organizational and planning skills, attention to detail, and follow-through Strong analytical and problem solving skills Strong interpersonal, communication, and customer service skills with a positive attitude Excellent written and verbal skills and the ability to communicate with business users Ability to rapidly adapt to changing needs in a highly dynamic environments Bachelor of Science in Computer Science or related field or comparable business/technical experience If you have an interest in this position, please email [EMAIL PROTECTED] with your resume. Location is Las Colinas/Irving/Dallas, Texas. We do not cover any relocation costs. - FYI, this post is for a non-member, Melinda Fleming of Neiman Marcus, and she is responsible for the content. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sort help needed
The original question didn't specify that PART.NBR had to be unique. Maybe it's a list of orders and possibly contains two different orders for the same part number. From: [EMAIL PROTECTED] on behalf of Keith W. Roberts Sent: Tue 8/11/2005 11:24 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed Your logic is wrong here; you are inserting whether PART.NBR is found or not. The INS should be inside the ELSE clause. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Monday, November 07, 2005 4:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed LOCATE PART.NBR IN RECORD14,1 BY AL SETTING POSELSE NULL INS PART.NBR BEFORE RECORD14,POS INS related.data BEFORE related.field14,POS No need to do the second locate. Note: I've used the PI/Open syntax for the LOCATE statement (that's the only one I relate to), you may have to alter the syntax slightly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Plant hopping help
You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Plant hopping help
if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Plant hopping help
Jason, We use the following code in the :STARTSPOOLER program in our generic Pick spooler for Universe on NT: -- (Do other things) ! * Verify the current Account and log to the UVNT.SPOOLER account ! CMD = 'WHO' EXECUTE CMD CAPTURING WHO OLD.ACCT = OCONV(FIELD(WHO,' ',2),'MCU') IF OLD.ACCT NE 'UVNT.SPOOLER' THEN CMD = 'LOGTO UVNT.SPOOLER' EXECUTE CMD END ! * Verify the new account ! CMD = 'WHO' EXECUTE CMD CAPTURING WHO ACCT = OCONV(FIELD(WHO,' ',2),'MCU') IF ACCT NE 'UVNT.SPOOLER' THEN PRINT @(-1):@(5,5):You are in the :ACCT: Account. PRINT @(5,7):You may only run this :STARTSPOOLER process from the UVNT.SPOOLER Account. PRINT @(5,9):Touch Enter to exit.: INPUT ZZZ GOTO 999 END * (Do something in the new account) ! * Log back to the original account ! 999 IF OLD.ACCT NE 'UVNT.SPOOLER' THEN CMD = 'LOGTO ':OLD.ACCT EXECUTE CMD END END -- If the other plant is really in the same account but a different User login to that account, you could still use the logic above to logto the new User. hth, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Jason K. Szemborski [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 08, 2005 7:30 AM Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Fwd: [UV] Neiman Marcus posting for Sr. Technologist, UniVerse DBA
Thanks Clif, for posting this. Very interesting. Too bad they aren't 'in my town'... Oh, did you ask her if she has any good cookie recipes? Karl quote who=Clifton Oliver Posted on behalf of a non list member. Begin forwarded message: - This position will be a member of a small team of DBA's that assist with providing effective development and production level database technical support, and the strategic UniVerse database direction for NM Direct, BGMS and EDW. In addition, this individual is expected to facilitate and deliver enhancements to database maintenance and monitoring, proactively identify and eliminate causes of potential production disruptions, and successfully complete Disaster Recovery and Cold Fail-Over activities. Candidates interested in this position should possess the following: Minimum 5 years of UniVerse Database Administration Minimum 7 years of experience in IT/IS Environment Expertise in UniVerse 9x or 10x Database performance tuning, monitoring, troubleshooting and problem resolution Experienced in Development and Production of UVBasic applications Expertise in creating and upgrading UniVerse databases Familiarity with vi and shell scripting In Depth knowledge of UniVerse databases backup and recovery Experience in other Database (Oracle, MS-SQL Server, Informix, Teradata, or Netezza) is a plus Experience in IBM AIX Environment Self motivated and multi-tasking individual that works well in a small team environment Available to cover responsibilities of a rotating 24 x 7 on-call shift Available to work nights and weekends on short notice, as needs require Strong organizational and planning skills, attention to detail, and follow-through Strong analytical and problem solving skills Strong interpersonal, communication, and customer service skills with a positive attitude Excellent written and verbal skills and the ability to communicate with business users Ability to rapidly adapt to changing needs in a highly dynamic environments Bachelor of Science in Computer Science or related field or comparable business/technical experience If you have an interest in this position, please email [EMAIL PROTECTED] with your resume. Location is Las Colinas/Irving/Dallas, Texas. We do not cover any relocation costs. - FYI, this post is for a non-member, Melinda Fleming of Neiman Marcus, and she is responsible for the content. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fwd: [UV] Neiman Marcus posting for Sr. Technologist, UniVerse DBA
Geee Whatever happened to Neiman Marcus running this out of New York? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver Sent: Tuesday, November 08, 2005 10:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] Fwd: [UV] Neiman Marcus posting for Sr. Technologist, UniVerse DBA Posted on behalf of a non list member. Begin forwarded message: - This position will be a member of a small team of DBA's that assist with providing effective development and production level database technical support, and the strategic UniVerse database direction for NM Direct, BGMS and EDW. In addition, this individual is expected to facilitate and deliver enhancements to database maintenance and monitoring, proactively identify and eliminate causes of potential production disruptions, and successfully complete Disaster Recovery and Cold Fail-Over activities. Candidates interested in this position should possess the following: Minimum 5 years of UniVerse Database Administration Minimum 7 years of experience in IT/IS Environment Expertise in UniVerse 9x or 10x Database performance tuning, monitoring, troubleshooting and problem resolution Experienced in Development and Production of UVBasic applications Expertise in creating and upgrading UniVerse databases Familiarity with vi and shell scripting In Depth knowledge of UniVerse databases backup and recovery Experience in other Database (Oracle, MS-SQL Server, Informix, Teradata, or Netezza) is a plus Experience in IBM AIX Environment Self motivated and multi-tasking individual that works well in a small team environment Available to cover responsibilities of a rotating 24 x 7 on-call shift Available to work nights and weekends on short notice, as needs require Strong organizational and planning skills, attention to detail, and follow-through Strong analytical and problem solving skills Strong interpersonal, communication, and customer service skills with a positive attitude Excellent written and verbal skills and the ability to communicate with business users Ability to rapidly adapt to changing needs in a highly dynamic environments Bachelor of Science in Computer Science or related field or comparable business/technical experience If you have an interest in this position, please email [EMAIL PROTECTED] with your resume. Location is Las Colinas/Irving/Dallas, Texas. We do not cover any relocation costs. - FYI, this post is for a non-member, Melinda Fleming of Neiman Marcus, and she is responsible for the content. --- 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] Plant hopping help
There is no assumed trust between machines with rlogin, the trust relationship must be setup explicitly via the host.equiv or .rhosts files. If the machines are not listed in host.equiv or .rhosts, rlogin will prompt for a password. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Plant hopping help
The ERP system is DataFlo. The current systems are either running UniData or UniVerse on Unix or NT or Windows. DataFlo has a Multi-Plant module for which you would set up a UniData or UniVerse account (on the same system) for each Plant - for example: ACCOUNT-A could be Plant 0 in California ACCOUNT-B could be Plant 1 in New Mexico ACCOUNT-C could be Plant 2 in Florida With the Multi-plant module a couple of the features are that the plants can be setup to 'share' data (like General Ledger), to order from each other, and to drop-ship (Order from 1 plant but ship to customer from another). Jason, I'm not sure what you're trying to accomplish (need more info). * If user is trying to logon are you searching to see what Plant the user belongs in so you can log them onto to the correct account? You may wish to look at program SYS.35 and try Executing the LOGTO command (as mentioned below). * If user is at menu, they can use the LOGTO AccountPath or AccountName or simply enter PLANT and choose which plant they wish to go to. * If user is in an Inquiry screen, there are subroutines to allow you to pull data from another account... Note, I was with the DataFlo Tech Support from Budget Systems to DataWorks to Epicor (16 years) and have since joined Kore Technologies. Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Sort help needed
I always use: NFND=0 ; LOCATE WWW IN XXX BY YYY SETTING ZZZ ELSE NFND=1 [IF NFND=1 THEN] INS WWW BEFORE XXXZZZ [END] George This way I avoid the NULL, and you can choose at a later time whether you want to INS or not. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 12:45 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed Yep, I did make that [possibly invalid] assumption. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Tuesday, November 08, 2005 8:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed The original question didn't specify that PART.NBR had to be unique. Maybe it's a list of orders and possibly contains two different orders for the same part number. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Plant hopping help
Jason, I'm at a loss. I'm not familiar with PV.SENDKEYS, and I don't find it in the Universe BASIC Manual or the Universe Reference Manual for Rel 10.x, even under SENDKEY. I don't have an answer for you. Sorry, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Jason K. Szemborski [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 08, 2005 9:03 AM Subject: RE: [U2] Plant hopping help Thanks for your quick response. The way I have to look at this is as follows... I have a user at the customer master screen, they must enter search criteria and based on that, the system will log the user to the correct plant (account) and put them into the proper screen, prepopulating the screen with that customer's information. It looks like this EXECUTE would do what I am looking for, however that's the concern that I have is executing this and then changing screens and preloading that screen with the customer's account information... During this process, my subroutine might lose control after the execute and the user will resume control. I was thinking about PV.SENDKEYS, would this help in this matter? Thanks again, Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 10:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Plant hopping help
One thing to note with rlogin. If the user number is not the same on each server, even though the user-id and password are the same, it will prompt for password. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Tuesday, November 08, 2005 12:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Plant hopping help
Here's the whole situation... There are plants 10, 20, 30, 40 and 50. If a user is in plant 20, they enter the customer entry screen, a prompt will appear asking for search information (which can be phone, email, name, or account number) and based on this, I go check against the customer master and log the user to the plant that the customer belongs to. At this point, also based on the type of input, I may put them into the customer screen or contact screen or something else. UPDATE: I have achieved the plant change, so based on the search criteria, I get the user to the correct plant, however I am still trying to find a way to execute a command that places the user in the screen that I want them in. Currently I am executing this in this fashion... EXECUTE LOGTO :PLANT.NAME EXECUTE MSO-03 CALL PV.SENDKEYS(1,1) CALL PV.SENDKEYS(DW_IMP.PRM{ENTER},1) RETURN They get to NB-TRAINING but they do not get into the MSO-03 Screen, nor does it output the 1 value to the screen or any field on the screen. I also tried the EXECUTE MSO-03 command as a CALL PV.SENDKEYS(MSO-03,1). I even sprinkled SLEEP commands in between each execute and PV, and that did not seem to have an effect. That's where I am stuck at this point, still trying little things here and there. I think the problem I am running into is that once the LOGTO is executed, my program loses control and the rest does not execute. Thanks yet again... Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien Sent: Tuesday, November 08, 2005 12:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help The ERP system is DataFlo. The current systems are either running UniData or UniVerse on Unix or NT or Windows. DataFlo has a Multi-Plant module for which you would set up a UniData or UniVerse account (on the same system) for each Plant - for example: ACCOUNT-A could be Plant 0 in California ACCOUNT-B could be Plant 1 in New Mexico ACCOUNT-C could be Plant 2 in Florida With the Multi-plant module a couple of the features are that the plants can be setup to 'share' data (like General Ledger), to order from each other, and to drop-ship (Order from 1 plant but ship to customer from another). Jason, I'm not sure what you're trying to accomplish (need more info). * If user is trying to logon are you searching to see what Plant the user belongs in so you can log them onto to the correct account? You may wish to look at program SYS.35 and try Executing the LOGTO command (as mentioned below). * If user is at menu, they can use the LOGTO AccountPath or AccountName or simply enter PLANT and choose which plant they wish to go to. * If user is in an Inquiry screen, there are subroutines to allow you to pull data from another account... Note, I was with the DataFlo Tech Support from Budget Systems to DataWorks to Epicor (16 years) and have since joined Kore Technologies. Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- u2-users mailing
RE: [U2] Plant hopping help
Once it's setup, the trust is assumed (no further authentication required), and the problem with rhosts is that passwords are kept in plain text. But in order to make it a see-nothing do-nothing, full trust must be assumed (so no password will be asked). For internal network machines, the risk is minimal For machines across the internet, the risk could be tragic George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock Sent: Tuesday, November 08, 2005 1:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help There is no assumed trust between machines with rlogin, the trust relationship must be setup explicitly via the host.equiv or .rhosts files. If the machines are not listed in host.equiv or .rhosts, rlogin will prompt for a password. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reading/Writing MySQL Records into/out of Universe 10.x from Universe 10.x {Unclassified}
Look for BCI in the archives, Dave. I have posted a couple of times in the past and there was a thread a month or so ago connection from UniBasic to a SQL database HTH Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Tuesday, 8 November 2005 19:14 To: u2-users@listserver.u2ug.org Subject: [U2] Reading/Writing MySQL Records into/out of Universe 10.x from Universe 10.x I've reviewed the archives and haven't found any definitive strategies for reliably reading/writing MySQL records into/out of Universe 10.x from Universe 10.x. Does anyone have any directly applicable and successful how-you've-done-it experience in this area? tia, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Plant hopping help
This must be application specific. Maybe you should see if there is a list specific to your application and not for the underlying database. Unless you know how to work under the hood of your application what we till you may be beyond your ability. - Original Message - From: Jason K. Szemborski [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 08, 2005 9:30 AM Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- 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] Plant hopping help
I've never liked a system that has to LOGTO a bunch of different accts. I prefer running it out of one acct with remote file references. You're on UV, so you can use q-ptrs if you want instead of f-ptrs, which means you can easily create them on the fly. Once you know what acct (plant) they need: EXECUTE 'SET-FILE ':PLANT:' ':FILENAME:' ':PLANT:'.':FILENAME or the like for each filename you need to address, then OPEN PLANT:'.':FILENAME TO FILE.filename in your apps. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 9:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help Thanks for your quick response. The way I have to look at this is as follows... I have a user at the customer master screen, they must enter search criteria and based on that, the system will log the user to the correct plant (account) and put them into the proper screen, prepopulating the screen with that customer's information. It looks like this EXECUTE would do what I am looking for, however that's the concern that I have is executing this and then changing screens and preloading that screen with the customer's account information... During this process, my subroutine might lose control after the execute and the user will resume control. I was thinking about PV.SENDKEYS, would this help in this matter? Thanks again, Jason --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Plant hopping help
Put a DW in front of the MSO-03 - EXECUTE DW MSO-03 and it should work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 1:17 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help Here's the whole situation... There are plants 10, 20, 30, 40 and 50. If a user is in plant 20, they enter the customer entry screen, a prompt will appear asking for search information (which can be phone, email, name, or account number) and based on this, I go check against the customer master and log the user to the plant that the customer belongs to. At this point, also based on the type of input, I may put them into the customer screen or contact screen or something else. UPDATE: I have achieved the plant change, so based on the search criteria, I get the user to the correct plant, however I am still trying to find a way to execute a command that places the user in the screen that I want them in. Currently I am executing this in this fashion... EXECUTE LOGTO :PLANT.NAME EXECUTE MSO-03 CALL PV.SENDKEYS(1,1) CALL PV.SENDKEYS(DW_IMP.PRM{ENTER},1) RETURN They get to NB-TRAINING but they do not get into the MSO-03 Screen, nor does it output the 1 value to the screen or any field on the screen. I also tried the EXECUTE MSO-03 command as a CALL PV.SENDKEYS(MSO-03,1). I even sprinkled SLEEP commands in between each execute and PV, and that did not seem to have an effect. That's where I am stuck at this point, still trying little things here and there. I think the problem I am running into is that once the LOGTO is executed, my program loses control and the rest does not execute. Thanks yet again... Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien Sent: Tuesday, November 08, 2005 12:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help The ERP system is DataFlo. The current systems are either running UniData or UniVerse on Unix or NT or Windows. DataFlo has a Multi-Plant module for which you would set up a UniData or UniVerse account (on the same system) for each Plant - for example: ACCOUNT-A could be Plant 0 in California ACCOUNT-B could be Plant 1 in New Mexico ACCOUNT-C could be Plant 2 in Florida With the Multi-plant module a couple of the features are that the plants can be setup to 'share' data (like General Ledger), to order from each other, and to drop-ship (Order from 1 plant but ship to customer from another). Jason, I'm not sure what you're trying to accomplish (need more info). * If user is trying to logon are you searching to see what Plant the user belongs in so you can log them onto to the correct account? You may wish to look at program SYS.35 and try Executing the LOGTO command (as mentioned below). * If user is at menu, they can use the LOGTO AccountPath or AccountName or simply enter PLANT and choose which plant they wish to go to. * If user is in an Inquiry screen, there are subroutines to allow you to pull data from another account... Note, I was with the DataFlo Tech Support from Budget Systems to DataWorks to Epicor (16 years) and have since joined Kore Technologies. Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a
[U2] Re: U2 Users Digest V1 #914
I will be out of the office on business, Tuesday 11/08/2005 thru Friday 11/11/2005. During this time I will not have access to my email. If you need to contact me, please call me on my cell phone. Thanks, Russ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Reading/Writing MySQL Records into/out of Universe 10.x from Universe 10.x {Unclassified}
I will do that, Mike. Thanks very much, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: HENDERSON MIKE, MR [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 08, 2005 11:20 AM Subject: RE: [U2] Reading/Writing MySQL Records into/out of Universe 10.x from Universe 10.x {Unclassified} Look for BCI in the archives, Dave. I have posted a couple of times in the past and there was a thread a month or so ago connection from UniBasic to a SQL database HTH Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Tuesday, 8 November 2005 19:14 To: u2-users@listserver.u2ug.org Subject: [U2] Reading/Writing MySQL Records into/out of Universe 10.x from Universe 10.x I've reviewed the archives and haven't found any definitive strategies for reliably reading/writing MySQL records into/out of Universe 10.x from Universe 10.x. Does anyone have any directly applicable and successful how-you've-done-it experience in this area? tia, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- 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] Plant hopping help
I have done similar things in the past with Dataflo and one problem I have noticed with the LOGTO command is that the LOGIN paragraph is still executed in full which can kill control from the calling program (mainly due to PV.LOGON and the preview menu). I got around this by placing a line in the LOGIN paragraph to skip to the end, and then setting the @LOGNAME to that user temporarily. If you want to call screens from there you can use the PREVIEW command. If you select the record before invoking the PREVIEW command it will automatically load the record. Ex: The LOGIN Paragraph: ... UDT.OPTIONS 103 OFF HUSHBASIC OFF STACKCOMMON ON FLOAT.PRECISION 3 IF @LOGNAME = bypass THEN GO END ... PV.LOGON END: * The calling Program: ... CUST.ID='1000' * * Logto Plant * PLANT.DIR='/dbms/live/PLANTNAME' [EMAIL PROTECTED] @LOGNAME='bypass' EXECUTE 'LOGTO ':PLANT.DIR @LOGNAME=SAVE.LOGIN * * Launch the screen * EXECUTE 'SELECT CUSTOMER ':CUST.ID:'' DATA CUSTOMER,SCRN1 ;* This is for the preview inputs (File Name/Screen ID) EXECUTE 'PREVIEW' Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 11:17 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help Here's the whole situation... There are plants 10, 20, 30, 40 and 50. If a user is in plant 20, they enter the customer entry screen, a prompt will appear asking for search information (which can be phone, email, name, or account number) and based on this, I go check against the customer master and log the user to the plant that the customer belongs to. At this point, also based on the type of input, I may put them into the customer screen or contact screen or something else. UPDATE: I have achieved the plant change, so based on the search criteria, I get the user to the correct plant, however I am still trying to find a way to execute a command that places the user in the screen that I want them in. Currently I am executing this in this fashion... EXECUTE LOGTO :PLANT.NAME EXECUTE MSO-03 CALL PV.SENDKEYS(1,1) CALL PV.SENDKEYS(DW_IMP.PRM{ENTER},1) RETURN They get to NB-TRAINING but they do not get into the MSO-03 Screen, nor does it output the 1 value to the screen or any field on the screen. I also tried the EXECUTE MSO-03 command as a CALL PV.SENDKEYS(MSO-03,1). I even sprinkled SLEEP commands in between each execute and PV, and that did not seem to have an effect. That's where I am stuck at this point, still trying little things here and there. I think the problem I am running into is that once the LOGTO is executed, my program loses control and the rest does not execute. Thanks yet again... Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien Sent: Tuesday, November 08, 2005 12:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help The ERP system is DataFlo. The current systems are either running UniData or UniVerse on Unix or NT or Windows. DataFlo has a Multi-Plant module for which you would set up a UniData or UniVerse account (on the same system) for each Plant - for example: ACCOUNT-A could be Plant 0 in California ACCOUNT-B could be Plant 1 in New Mexico ACCOUNT-C could be Plant 2 in Florida With the Multi-plant module a couple of the features are that the plants can be setup to 'share' data (like General Ledger), to order from each other, and to drop-ship (Order from 1 plant but ship to customer from another). Jason, I'm not sure what you're trying to accomplish (need more info). * If user is trying to logon are you searching to see what Plant the user belongs in so you can log them onto to the correct account? You may wish to look at program SYS.35 and try Executing the LOGTO command (as mentioned below). * If user is at menu, they can use the LOGTO AccountPath or AccountName or simply enter PLANT and choose which plant they wish to go to. * If user is in an Inquiry screen, there are subroutines to allow you to pull data from another account... Note, I was with the DataFlo Tech Support from Budget Systems to DataWorks to Epicor (16 years) and have since joined Kore Technologies. Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed
RE: [U2] Sort help needed
This solved my problem. Thanks for all the suggestions. Al -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, November 07, 2005 6:23 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed The problem is your ELSE POS=0 statement. You need something like this: LOCATE PART.NBR IN RECORD14 BY AL SETTING POS ELSE INSERT... END In a THEN condition, the value is already in RECORD14. You only need to do an INSERT when it's not found. When it's not found, POS will contain the position that the new value should be in so just use it. Don't override the value by setting it to zero. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Monday, November 07, 2005 3:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] Sort help needed Environment: UniData - Pick Flavor I'm trying to build a multi-value field in part number order. I begin with LOCATE PART.NBR IN RECORD14 BY AL SETTING POS ELSE POS = 0 The first time through RECORD14 is empty. The second time RECORD14 has one value. If PART.NBR is of greater value than what is now in RECORD14 then I want PART.NBR to be the second value, if it is of lesser value than I want PART.NBR to be inserted before the value in RECORD14. I will then do a second LOCATE to see where PART.NBR is stored (RECORD14,x) and use that position to insert data into associated attributes. My problem is that I haven't done this in a while and when I did it was in Universe. So not only am I suffering a senior moment I'm dealing with a language barrier. Any help would be greatly appreciated. Thanks. Al DeWitt Stylmark, Inc. --- 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] Plant hopping help
I don't think this will work unless he puts a bypass in the LOGIN paragraph which skips the PV.LOGON - otherwise the LOGTO will put him at the DW menu. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Kunzman Sent: Tuesday, November 08, 2005 11:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help Put a DW in front of the MSO-03 - EXECUTE DW MSO-03 and it should work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 1:17 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help Here's the whole situation... There are plants 10, 20, 30, 40 and 50. If a user is in plant 20, they enter the customer entry screen, a prompt will appear asking for search information (which can be phone, email, name, or account number) and based on this, I go check against the customer master and log the user to the plant that the customer belongs to. At this point, also based on the type of input, I may put them into the customer screen or contact screen or something else. UPDATE: I have achieved the plant change, so based on the search criteria, I get the user to the correct plant, however I am still trying to find a way to execute a command that places the user in the screen that I want them in. Currently I am executing this in this fashion... EXECUTE LOGTO :PLANT.NAME EXECUTE MSO-03 CALL PV.SENDKEYS(1,1) CALL PV.SENDKEYS(DW_IMP.PRM{ENTER},1) RETURN They get to NB-TRAINING but they do not get into the MSO-03 Screen, nor does it output the 1 value to the screen or any field on the screen. I also tried the EXECUTE MSO-03 command as a CALL PV.SENDKEYS(MSO-03,1). I even sprinkled SLEEP commands in between each execute and PV, and that did not seem to have an effect. That's where I am stuck at this point, still trying little things here and there. I think the problem I am running into is that once the LOGTO is executed, my program loses control and the rest does not execute. Thanks yet again... Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien Sent: Tuesday, November 08, 2005 12:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help The ERP system is DataFlo. The current systems are either running UniData or UniVerse on Unix or NT or Windows. DataFlo has a Multi-Plant module for which you would set up a UniData or UniVerse account (on the same system) for each Plant - for example: ACCOUNT-A could be Plant 0 in California ACCOUNT-B could be Plant 1 in New Mexico ACCOUNT-C could be Plant 2 in Florida With the Multi-plant module a couple of the features are that the plants can be setup to 'share' data (like General Ledger), to order from each other, and to drop-ship (Order from 1 plant but ship to customer from another). Jason, I'm not sure what you're trying to accomplish (need more info). * If user is trying to logon are you searching to see what Plant the user belongs in so you can log them onto to the correct account? You may wish to look at program SYS.35 and try Executing the LOGTO command (as mentioned below). * If user is at menu, they can use the LOGTO AccountPath or AccountName or simply enter PLANT and choose which plant they wish to go to. * If user is in an Inquiry screen, there are subroutines to allow you to pull data from another account... Note, I was with the DataFlo Tech Support from Budget Systems to DataWorks to Epicor (16 years) and have since joined Kore Technologies. Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To:
RE: [U2] Plant hopping help
Ummm...passwords are not kept at all in .rhosts / host.equiv, only host names and (optionally) user and group names. Users from hosts listed in .rhosts / host.equiv are simply logged in without supplying a password. Hopefully, one would not add untrusted hosts or users to their .rhosts file regardless of whether the host was on the LAN or the WAN. Hopefully also, system administrators will not open up rlogin or telnet (or any other unsecure ports) to the outside world. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Tuesday, November 08, 2005 11:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help Once it's setup, the trust is assumed (no further authentication required), and the problem with rhosts is that passwords are kept in plain text. But in order to make it a see-nothing do-nothing, full trust must be assumed (so no password will be asked). For internal network machines, the risk is minimal For machines across the internet, the risk could be tragic George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock Sent: Tuesday, November 08, 2005 1:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help There is no assumed trust between machines with rlogin, the trust relationship must be setup explicitly via the host.equiv or .rhosts files. If the machines are not listed in host.equiv or .rhosts, rlogin will prompt for a password. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Tuesday, November 08, 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help if each plant is on a different machine, and all machines are running unix, you could use the rlogin command. WARNING: rlogin has some very serious security risks however. rlogin is the equivilent of a telnet without the username/password authentication. There is an assumed trust between machines and usernames. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, November 08, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Plant hopping help You'll have to define this a bit more. Assuming you mean that each plant is a different account ... a simple EXECUTE 'LOGTO ':ACCT.NAME will do it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason K. Szemborski Sent: Tuesday, November 08, 2005 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Plant hopping help Hi all, I've been working on something that have run into a road block and know it can be done, but I can't figure it out. We have a multi-plant system and I need to take a user from one plant to another based on some search criteria. I have the search routine written out and have a place to call a subroutine to move someone from one plant to another but have yet to find anything that can log the user to another plant without them actually typing it. Any help would be greatly appreciated. Environment: Universe - Pick Thanks! Jason Szemborski --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/163 - Release Date: 11/8/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/163 - Release Date: 11/8/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Plant hopping help
Always put in positive checks if your system is sensitive and you are exposed to potentially hostile network environments. It is possible for someone with the right tools (and you can download them :-( ) to subvert inter-host authorisation at the TCP Network level. Port blockers and spoofed TCP packet credentials are just part of the game.. S.A.T.A.N. was just the first of a set of tools that have been developed for legitimate purposes and misused. Later tools were deliberately crafted. Once a trust is set up between two systems or networks you are potentially vulnerable. If you *have* to sue trusted relationships I am sure you use separate physical networks and IP filtering. Don't you ? B.T.W. System Auditing Tool for Analysing Networks Regards and let's just be safe out there JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] Analyst/Programmer - Full Time position, Newcastle, Australia
Stamina Software produces a broad range of world class software solutions, ranging from large-scale core ERP applications for the wholesale, retail, service, manufacturing jobbing sectors, through to our Ultra-RAD Visage application development framework. We are nearing the completion of the migration of our entire green-screen R5 ERP system to the Visage environment, which delivers traditional thick client functionality using thin client delivery mechanisms and technologies, and combined with strong demand for our Visage development tools, we need more motivated, skilled professionals like you! If you have experience with multi-valued databases, web technologies, and/or commercial applications, then we offer an environment that will enable you to leverage and extend your skills using cutting edge technology. Don't think you have the experience we are after? Don't worry, because if you have an aptitude, enthusiasm and willingness to learn, then we will train you! You will be working in a close-knit, dynamic team environment, and have the opportunity to participate in every aspect of a software development environment. This is an outstanding opportunity to be joining an established company, with a reputation for excellence, at an exciting, stimulating and challenging time in our evolution. We are looking to fill multiple full-time positions, working as a fully emersed team member from our offices in Newcastle (Wallsend), Australia. If you think you have what we are looking for, PROVE IT by sending a CV to rossf @t stamina.com.au Ross Ferris Stamina Software Visage Better by Design --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [AD] Analyst/Programmer - Full Time position, Newcastle, Australia
Hello, I have attached my resume. I have worked with something similar and would welcome the chance to work with a modern version. I know plant systems well and have a proven track record. Ken Carpenter [demime 1.01d removed an attachment of type application/octet-stream which had a name of kbcresume.doc] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [AD] Analyst/Programmer - Full Time position, Newcastle, Australia
Ken You may want to send the resume to Ross direct rather than to everyone on the U2List. Also the list strips attachements Ross's email is [EMAIL PROTECTED] Regards David Jordan Managing Consultant [EMAIL PROTECTED] DACONO Holdings Pty Ltd www.dacono.com.au PO Box 909 Lane Cove NSW 2066 Australia Phn: 61 2 9418 8320 Fax: 61 2 9427 2371 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/