RE: [U2] Plant hopping help
hmm. For some reasons I was thinking there were passwords in the rhosts files..not sure why. here is a wiki write up on it. http://en.wikipedia.org/wiki/Rlogin I use it currently between two system connected via a SLIP connection (modem), and it works nicely, but the chances of the other system being hacked (has to be physically, since it does not have an internet connection) is extremely small. I also used it between a Redhat machine at home with UV PE and our system here, but only for a test to see if I could pass connections from one UV machine to another. It worked, but I didn't feel comfortable with the exposure it opened up, although it was confined nicely, as that port was only allowed entry through the external firewall for only 1 IP address, so only my Home PC IP could actually get to the rlogin port of the machine, it was fairly secure for that connection. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock Sent: Tuesday, November 08, 2005 5:03 PM To: u2-users@listserver.u2ug.org Subject: 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 --- 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] 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] 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] 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
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] 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: u2-users
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/