Re: [U2]: Epicor
Is it getting to the point where every change to the system requires a call to a lawyer to check to see if it is ok? Yes ! or atleast it seems that way here. We've gone from complete freedom to no changes without the appropriate documentation and approval overnight. All changes must be user requested. Even if I know there is a bug, I can't just go quick fix it. I have to actually go out to a user and ask them to request it to their boss who makes the entry in PRC. The helpdesk elevates it to IT/Development director, then it can be fixed. In turn if it's a major issue where the AR is getting botched up daily, it could take a while to get to it, in turn making the problem worse. Then prove that the changes were made and approved before making it into production. On top of it all auditing every other month to make sure this protocal is followed to the T. And it's just starting here. It all comes down to placing the blame and covering each ones bum from a law suit. The whole process stinks, but is for our own good in the long run. Especially in the world where people will cook the books and point there finger at you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV to Web interface
Ok... I'll bite... But I can't guarantee the no mischief part ;-) Here's the beginning of a simple record editor. html head titleSimple UniObjects File Read/title /head body h3ASP UniObjects Item Display/h3 form action=? name=Testfrm method=post table tr td table border=0 trtdServer/tdtdinput type=text name=server value=%= request(server) %/td/tr trtdAccount/tdtdinput type=text name=account value=%= request(account) %/td/tr /table /td td table border=0 trtdUserName/tdtdinput type=text name=user value=%= request(user) %/td/tr trtdPassword/tdtdinput type=text name=pwd value=/td/tr /table /td td table border=0 trtdFileName/tdtdinput type=text name=FileName value=%= request(FileName) %/td/tr trtdItemID/tdtdinput type=text name=ItemID value=%= request(ItemID) %/td/tr /table /td /tr tr td align=center colspan=3 table border=0 trtdnbsp;/tdtdinput type=submit/td/tr /table /td /tr /table /form % if request.form(server) then Dim Sess, Text Set Sess = CreateObject(Universe.session.1) ' Universe.session.1 or Sess.HostName = request(server) Sess.UserName = request(user) Sess.AccountPath = request(account) Sess.Password = request(pwd) ' Now connect Sess.connect ' if Sess.error then response.write SCRIPT LANGUAGE='JavaScript1.1' response.write alert('Cannot connect to Database... Sess.ERROR ') response.write /SCRIPT response.write h1[ Sess.hostname ] - Database Error/h1 else ' ' Setup and read the record ' Set File = Sess.OpenFile(request(filename)) File.RecordId = request(ItemID) File.Read AMS = File.record.Count() % form TEXTAREA Name=text COLS=80 ROWS=25 % ' ' Display item in a text box ' for AM = 1 to AMS response.write File.record.Field(AM) vbcrlf next % /TEXTAREA % end if end if % br br You can see how easily this could be modified to create an ASP file editor.br Of course another dangerous tool to allow public access with no encryption. br IMHObr /body /html - Original Message - From: Wendy Smoak [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 15, 2005 5:38 PM Subject: RE: [U2] UV to Web interface [EMAIL PROTECTED] wrote: The example is just a way to get started. Okay, in my excitement that someone was posting an ASP example, I didn't look all that closely at it. http://www.pickwiki.com/cgi-bin/wiki.pl?SimpleASP Perhaps a 'safer' example is in order. Instead of showing how to execute any colon prompt command, how about prompting for a filename and record ID, then reading and printing the contents of the record? Then at least someone who tries this out and loses interest, but leaves the example code on a public web server, won't be exposing his system to *quite* so much mischief. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV to Web interface
Glen, Apparently this is a hot topic... Maybe you should throw it up on picksource as well... It's nothing special. Will, In one of your responses you said you added username and pwd to the form. I hope this form is not web accessible, and if it is, you should atleast be serving it ssl. Way to easy to sniff in pure http Just my 2 cents... The web server (IIS in this case) will require UniObjects not the client side. The same code can also be taken and slightly modified to work in a VB app as well, then the client would need the UvObject loaded. Vance - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 14, 2005 8:58 PM Subject: RE: [U2] UV to Web interface Does require each user to have UniObjects loaded on their PCs or is UniObjects only loaded on the web server? TIA Stewart Only on the web server Stewart. The asp pages serve up pure HTML to the remote browser and it's only by clicking something that the user requests a new asp page, which again, just runs on the web server. So the user needs nothing special to make it do the HOW of what it's doing. Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: UV to web interface
In the example I used Universe.session.1 as the object pointer. I was using UVDK2.0 to test it before I sent it out, on a newer version change the line. Set Sess = CreateObject(Universe.session.1) to Set Sess = CreateObject(UniObjects.UniOaifCtrl) Vance - Original Message - From: Jeff Schasny [EMAIL PROTECTED] To: U2 Group u2-users@listserver.u2ug.org Sent: Tuesday, February 15, 2005 1:31 PM Subject: [U2] Re: UV to web interface Evidently my IIS isnt aware of the Uniobjects. I have Uniobjects working fine on the same machine in Visual Basic. What have I missed? I'm getting the form page just fine but when I click the Submit Query button I get the following: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. -- -- Please try the following: Click the Refresh button, or try again later. Open the localhost home page, and then look for links to the information you want. HTTP 500.100 - Internal Server Error - ASP error Internet Information Services -- -- Technical Information (for support personnel) Error Type: Microsoft VBScript runtime (0x800A01AD) ActiveX component can't create object: 'Universe.session.1' /jas/simple.asp, line 16 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Page: POST 27 bytes to /jas/simple.asp POST Data: uvcommand=SORT+VOC+SAMPLE+5 Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- 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] UV to Web interface
Exactly... http is transmitted in plain text accross networks and anyone can sniff it out. Subnet is not even an issue if it's a public page. It is insecure for your system as well. Don't forget when you submit from another location on the internet you are sending that data through switches and routers that all see your username and password in plain text. If it's all internal with no outside access that's different but when you make it public it's a bad idea. As a general rule. If it's plugged in, it's accessable, it's vulnerable in some way. If you want to see some sniffing in action download 'cain and able' from oxid.it or ethereal and you'll see how easy it really is. Scary how easy it is actually... Vance . - Original Message - From: George Gallen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 15, 2005 2:27 PM Subject: RE: [U2] UV to Web interface yes, but if someone is sniffing the lines, unless the initial page is a https:// page, the username and password will be transmitted across the internet in plain text. Generally this isn't a problem, but if you are on a cable line, anyone on that subnet could realistically view the username/password, for future playing. It isn't so much insecure for your system, but insecure from the users standpoint. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to Web interface Vance wrote: Will, In one of your responses you said you added username and pwd to the form. I hope this form is not web accessible, and if it is, you should atleast be serving it ssl. Way to easy to sniff in pure http Just my 2 cents... Vance not sure why you think it's insecure. It's not like they can make up any old username and password. It's still validated against the Windows system username and password. The reason I had to add it, is that without it anyone could run any command they wanted since it would have logged in with a static username and password every time. Since the page will be accessible to the outside, I need some way to prevent anyone from running any command. So now they have to at least be validated through the Windows password system. Will --- 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] UV to Web interface
I'm not saying with that example you should leave it the way I posted it, where access is global. In fact I agree with you. The user and pwd should be verified on a user basis for something so open as the example. But what I do say, is that I do not recommend allowing http access to this script if it will be accessable to the internet. Even SSL is not bullet proof, but atleast it's not plain text. 'CLEAR-FILE DATA VOC' is exactly the reason it should be behind some kind of encryption, or even better yet (DOS /c 'FORMAT C: | y') or (SH -c 'rm -r'). I did'nt mean to give anything other than a clear cut example, but the example is like giving a hacker a back door to the command line, so be safe with it. That's really all I can say. In most of my uses the user an pwd are defined behind the scenes because the server is out to do a specific chore. Like in a POS E-Commerce site. You don't allow your customers access to your database, but you do allow your servers to retrieve information from the database. Vance - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 15, 2005 3:11 PM Subject: Re: [U2] UV to Web interface Vance: I'm looking forward to having the user type 'CLEAR-FILE DATA VOC' and clicking the submit button. Watch the fur fly. Ian the example is just that :) It's not really meant, at least as far as I go, to actually execute in that manner. It's just an example of how to talk to a session so THAT you can build something better. A lot of us have a problem getting our foot in the door without at least some kind of simple example to start with. Will --- 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] Print Spool Number
I don't know if this fits into what you need to accomplish, but try this. Assigning the printer in mode 3 and set the spooler ID in the Banner param. The output will go to HOLD. Then you can easily take it and assign it to a printer of choice or do anything you like with it from there. Vance - Original Message - From: Gordon J Glorfield [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 14, 2005 10:29 AM Subject: Re: [U2] Print Spool Number I don't believe there is anyway to get that number prior to closing the print job. But you can get the number assigned to the job that just closed. Look for a subroutine in the VMARK.BP called SPOOL.NUM. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/14/2005 09:13:33 AM: Does anyone know if there is any way in Universe to determine what the job number of the currently open printer will be while the process is still running? Dave Barrett, Lawyers' Professional Indemnity Company --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail 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] Universe to Web interface
Sorry I see I missed it when I pasted it in... The enitre file should like so html head titleWill Test/title /head body h3Test Submitting a UV Command/h3 form action=index.asp name=Testfrm method=post input type=text name=uvcommand value=SORT VOC input type=submit /form % if request.form(uvcommand) then Dim Sess, UVCommand, TheCommand, Text TheCommand = request.form(uvcommand) response.write Command : TheCommand br Set Sess = CreateObject(Universe.session.1) Sess.HostName = Machine or IP Sess.UserName = uv username Sess.AccountPath = account or account path Sess.Password = uv user password ' Now connect Sess.connect ' if Sess.error then response.write SCRIPT LANGUAGE='JavaScript1.1' response.write alert('Cannot connect to Database... Sess.ERROR ') response.write /SCRIPT response.write h1[ Sess.hostname ] - Database Error/h1 else response.write UV Session is active...br ' To issue a command set UVCommand = Sess.Command UVCommand.Text = TheCommand UVCommand.Exec ' Now write the response to the page Response.Write UVCommand.Response end if end if % /body /html - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 14, 2005 3:25 PM Subject: Re: [U2] Universe to Web interface Vance you sent some code that used asp to get information out of Universe, but is it missing something? When I load that page in my browser all I get is a blank page. You have a line that says TheCommand = request.form(uvcommand) but you don't have anywhere where you setup a form called uvcommand. Does this line mean I also need a form called uvcommand and that it's whatever you type into that form that will eventually (later in your sample code) get executed? Thanks Will --- 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] Universe to Web interface
The @ in a bat file supresses the command from display. Like echo off. Write a simple MV program and call it Hello in your account. BP HELLO PRINT HELLO END In the batch file change the directory to that account then execute uvsh like below c:\ibm\uv\bin\uvsh RUN BP HELLO You should see the output of hello. The list VOC was most likely blinking because it was displaying all records and the ctrl chars in the VOC file as well and your cmd display window did'nt like it. Bad example I guess. However Lance's UniObjects example is a great place to start if you are looking to use ASP/UniObjects rather than CGI. If you have no reason you are trying to go about this via a CGI batch file then I would'nt, especially using IIS. Just allowing bat files to run under IIS is a dangerous proposition if you don't have to. Vance - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 08, 2005 9:49 PM Subject: Re: [U2] Universe to Web interface Vance wrote: @REM Assuming this is a folder with a uv account @cd \ibm\uv @REM Execute the uv command @c:\ibm\uv\bin\uvsh LIST VOC I don't know what the @ signs do, but when I try this fromthe DOS command prompt window c:\something\uvsh LIST VOC it just kinda blinks and returns to the DOS Command Prompt window. I don't see any kind of output. I don't know why. Where did my output go? Thanks Will --- 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] Universe to Web interface
Forgot in my example I used Universe.session.1 as the object pointer. I was using UVDK2.0 to test it before I sent it out, on a newer version change the line. Set Sess = CreateObject(Universe.session.1) to Set Sess = CreateObject(UniObjects.UniOaifCtrl) It does not do anything with the output to format it at all so it's just going to spit it out to the browser. If you want to fix it up you should probably convert LF to br in the response before displaying it... It's not perfect but I know it works. Vance - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 09, 2005 1:30 PM Subject: Re: [U2] Universe to Web interface In a message dated 2/9/2005 5:34:48 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I still don't get why you want to use a BAT file to do this at all. IF you're using IIS, you should really be using ASP. I don't. Here is what I want From a web page, click on something, which in ANY fashion reaches into Universe and displays the results on that web page. Focusing on the ANY fashion, any way, any how, any method, with example code please so I don't go insane trying to follow the hand-waving. And preferable I'm looking for the absolutely simplest manner of doing this. And the free way too ... btw. PS thanks for those of you who sent various examples of doing this. Will --- 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] Universe to Web interface
You can use php. You have to use COM... Example below ... html head titleTest Using Object/title /head body Attempting connect p ? // // Create COM object for UV object // $objUV = new COM(Universe.Session) or die(Unable to initiate UV Session); $objUV-HostName = machine;// Universe Host $objUV-AccountPath = ACCT; // Universe Account Name/Path $objUV-UserName = user;// System Login $objUV-Password = pwd; // Password // // Let just display it to make sure the object accepted th assignment // print (HostName . $objUV-HostName . br\n); print (Account . $objUV-AccountPath . br\n); print (UV Username . $objUV-UserName . br\n); print (Password . $objUV-Password . br\n); // // Connect to UVRPC service // $connect = $objUV-Connect(); $active = $objUV-isactive(); if ($active = true) { print(Is connected); } else { print(Is NOT connected); } print ( Session Status [ . $active . ]br\n); $objUV-Command-Text=LIST VOC; print (Test Command . $objUV-Command-Text . br\n); $sts = $objUV-Command-Exec(); print (Command Status [ . $sts . ] br\n); $Rsp = $objUV-Command-Response(); print (Response . $Rsp . br\n); $active = $objUV-isactive(); print (Session Status [ . $active . ]br\n); $sts = $objUV-disconnect(); // Close UVRPC connection $active = $objUV-isactive; print (Session Status [ . $active . ]br\n); ? /body /html Vance - Original Message - From: Dave Walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 09, 2005 3:53 PM Subject: RE: [U2] Universe to Web interface Wouldn't a php interface to U2 be nice? Then we could have LAUP instead of LAMP. Or some such. Python would be gravy too. -- Dave Walker 8..7 4(()) -::- -::-8.74 .74(()) ((88.74 ..74 -::- ((88.74 * Peace -Original Message- From: CDMI [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 2:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Will - this is what 'web servers' do. Good ones that are integrated with multivalue (that I know of) are typically not free. Steve T [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 12:30 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface In a message dated 2/9/2005 5:34:48 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I still don't get why you want to use a BAT file to do this at all. IF you're using IIS, you should really be using ASP. I don't. Here is what I want From a web page, click on something, which in ANY fashion reaches into Universe and displays the results on that web page. Focusing on the ANY fashion, any way, any how, any method, with example code please so I don't go insane trying to follow the hand-waving. And preferable I'm looking for the absolutely simplest manner of doing this. And the free way too ... btw. PS thanks for those of you who sent various examples of doing this. Will --- 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] Universe to Web interface
I don't think it would work on *nux... As far as I know the UV objects is only for a windows client. The may be a *nix version that I am unaware of, but if there is not then the answer would have to be no it does not work. Vance - Original Message - From: Richard Wilson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 09, 2005 5:37 PM Subject: RE: [U2] Universe to Web interface Does this work for both Windows and Linux? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 February 2005 8:45 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface You can use php. You have to use COM... Example below ... html head titleTest Using Object/title /head body Attempting connect p ? // // Create COM object for UV object // $objUV = new COM(Universe.Session) or die(Unable to initiate UV Session); $objUV-HostName = machine;// Universe Host $objUV-AccountPath = ACCT; // Universe Account Name/Path $objUV-UserName = user;// System Login $objUV-Password = pwd; // Password // // Let just display it to make sure the object accepted th assignment // print (HostName . $objUV-HostName . br\n); print (Account . $objUV-AccountPath . br\n); print (UV Username . $objUV-UserName . br\n); print (Password . $objUV-Password . br\n); // // Connect to UVRPC service // $connect = $objUV-Connect(); $active = $objUV-isactive(); if ($active = true) { print(Is connected); } else { print(Is NOT connected); } print ( Session Status [ . $active . ]br\n); $objUV-Command-Text=LIST VOC; print (Test Command . $objUV-Command-Text . br\n); $sts = $objUV-Command-Exec(); print (Command Status [ . $sts . ] br\n); $Rsp = $objUV-Command-Response(); print (Response . $Rsp . br\n); $active = $objUV-isactive(); print (Session Status [ . $active . ]br\n); $sts = $objUV-disconnect(); // Close UVRPC connection $active = $objUV-isactive; print (Session Status [ . $active . ]br\n); ? /body /html Vance - Original Message - From: Dave Walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 09, 2005 3:53 PM Subject: RE: [U2] Universe to Web interface Wouldn't a php interface to U2 be nice? Then we could have LAUP instead of LAMP. Or some such. Python would be gravy too. -- Dave Walker 8..7 4(()) -::- -::-8.74 .74(()) ((88.74 ..74 -::- ((88.74 * Peace -Original Message- From: CDMI [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 2:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Will - this is what 'web servers' do. Good ones that are integrated with multivalue (that I know of) are typically not free. Steve T [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 12:30 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface In a message dated 2/9/2005 5:34:48 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I still don't get why you want to use a BAT file to do this at all. IF you're using IIS, you should really be using ASP. I don't. Here is what I want From a web page, click on something, which in ANY fashion reaches into Universe and displays the results on that web page. Focusing on the ANY fashion, any way, any how, any method, with example code please so I don't go insane trying to follow the hand-waving. And preferable I'm looking for the absolutely simplest manner of doing this. And the free way too ... btw. PS thanks for those of you who sent various examples of doing this. Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe to Web interface
Glen, I have'nt done extensive research on it, but from the samples provided by IBM using a dimensioned array, I believe UV would manage the forking off the sockets itself. Don't quote me on this though. I'll dig out the sample I have and send it on to ya... If you want you can test it out on my system and play since you don't have access to a UV box. For you no problem. Vance - Original Message - From: Glen B [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 09, 2005 5:21 PM Subject: RE: [U2] Universe to Web interface Kevin, I read through the PDF. However, it is not clear on how the handles can be used. A lot of the API's I've seen have the same level of functionality, but they all lack the ability to pass handles from the acceptor process to a totally separate user process. This isn't really an issue of the API, it's more of a user environment issue. You can pass the handle value itself, but the other process loses the 'meaning' of the handle and it just becomes a worthless string. An example would be launching a new phantom and passing it the handle variable, after accepting an incoming connection. The same situation occurs when you pass any kind of memory reference(or offset) to anything outside the current user heap. Unix fork()ing generates a mapped/duplicate user heap, so all file/handle references still work properly without having to munge underlying memory addresses. If you can truly pass a UV socket handle to another UV process, then there's no reason why anyone can't write a stable multi-threaded socket server directly in UV BASIC. Is this true? If so, I want a developer copy so I can try to blow it up. :P eg -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 3:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface you manage the connections from basic, the whole interface is a set of basic extensions. basically you open a socket on a port , accept a connection on that socket and write to the socket. here is the appropriate manual : http://publibfi.boulder.ibm.com/epubs/pdf/25119080.pdf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, February 09, 2005 2:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Must be nice. I wish that capacity existed in every flavor. It would make the integration world a breeze. Well my real question would be; is the service external or internal? I'd be interested in knowing how the socket service is laid out. Do you have to manage connections yourself? How are socket handles passed to children under multiple listening conditions? Or, do you tell the UV service to listen 4-at-a-time, on port , and then call MYAPP when a connection is accepted? -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 1:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Glen, The UV socket server interface works the same in Unix and Windows, I have server programs running in both environments with no changes. Kevin Lynch The Systems House -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, February 09, 2005 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Stewart, Socket implementations don't work across flavors. I've written many socket apps for D3, but even the small differences in the socket designs between Win and *nix causes problems. Sockets are easy to implement, but only if you want to maintain separate code-sets for Win and *nix under each flavor you want to support. I won't get into the details here, since I'm not familiar with the UV socket API. Service sockets are meant for the O/S, not Pick. Doug Dumitru bit the bullet and wrote his own TCP stack in Pick ASM. That is about the only way I would recommend even contemplating Pick server sockets. For clients, the socket APIs are fine. The calls are nearly identical between Win and *nix. The only issue there is blocking control, which unfortunately most of MV socket developers are unknowledgeable of. OK...I'm not going to get into that... meditating The SELECT can be handled several ways, but it still comes down to global locking of some kind. Another method is to use a stack file, instead of a directory. Since there's no need to close the pick file pointer, the overhead of opening(refreshing) and closing a local directory is eliminated. The only problem here, is the fact that every phantom has to lock the file before it checks any kind
Re: [U2] Universe to Web interface
Will, Since you are using IIS, is an ASP an option for you ... Using unobjects to call a UV program, sub or even read an write data is as easy as cake CGI would be a bit cumbersome if you are trying to accomplish this from a batch file. Using a bat file would make you have to parse all the posted data from IIS environment. We have both ways running from here and using ASP is ALOT cleaner. You can even use php if your not an ASP fan. Vance - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 08, 2005 12:28 PM Subject: Re: [U2] Universe to Web interface I appreciate all the messages pointing me to this or that commercial product. However all I need is to know, how a .bat file (or any other type of file) running in Windows is able to log into Universe. I'm sure it can be done, but how is the question. Will --- 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] Universe to Web interface
Will, This will work if you need to use a batch file but don't forget you have to parse the environment to find out what's in the put/post values if you need it to be interactive with the user. test.bat @REM Change directory to the UV account @REM Assuming this is a folder with a uv account @cd \ibm\uv @REM Execute the uv command @c:\ibm\uv\bin\uvsh LIST VOC Vance - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 08, 2005 12:42 PM Subject: Re: [U2] Universe to Web interface In a message dated 2/8/2005 9:33:25 AM Pacific Standard Time, [EMAIL PROTECTED] writes: It sounds like you want to visit a web page and see the output of a UV BASIC program, but I might be misunderstanding you. Really it doesn't matter so much what I'm trying to do. I'm just looking for an example of how ANYONE has done this UV on Windows. Examples for Unix or Linux aren't helping me :) Thanks Will --- 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] [UV] SOX Compliance and Universe
We have just been through our SOX compliance here at Caligor. We are a fortune 500 company, so SOX has been an obligation for us as well. We were going to use an inhouse system that was already partially developed. As it turns out there were to many curveballs that the auditors threw at us for us to possibly develop something in a timely fashion, that would be fully functional. So I set out to look at other options. I remember back in this mailing list to a message I had seen in '01' from Susan Joslyn. Her package, PRC, is a project management/tracking system as well as a source control package for the MV/U2 environment. It helps tracking along by hooking into the system verbs and editors. It logs user requests to project flow, another requirement. It's extremely versatile as well. I don't think I've asked many questions that was not a simple config change to accomplish for our site. As for using the software. There is not much of a learning curve to get used to. It's pretty much setup so that you can work as you used to. As a programmer, not a full time documentation clerk. Quietly as it can, tracks your actions. Of course there is going to be some changes to your daily routine, but it's not all that much of an inconvenience. It eliminates the need for ALOT of paper tracking and authorizations. Our AS400 staff that has a LARGER staff than our UV actually wishes they could use PRC on there system to minimize all the extra work and documentation SOX compliance has imposed on them. With the help of Susan Joslyn and PRC, we were able to go from dead, with major compliance issues, to no critical issues in a matter of 2 weeks. I really don't see us being able to do this in the time frame we were presented or as efficient. She has been willing to go the extra mile it took to get us by the auditors and is helping us work towards a goal of no issues for the next audit cycle. Check out her site at : http://www.sjplus.com Not to mention she's really great to work with as well. As far as system security goes, we had to implement better rules/documentation. Make sure all users are accounted for, breaks disabled for users, cron jobs lists, etc. Vance Forste Caligor Hospital Supply a Division of Henry Schein Inc. 846 Pelham Pkwy Pelham Manor, NY 10803 - Original Message - From: Meeta Advani [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, January 27, 2005 10:08 AM Subject: [U2] [UV] SOX Compliance and Universe Hi all, The company I work for, Mothers Work Inc., is a publicly held company, traded on NASDAQ. As a result, we are obliged to comply with the Sarbanes-Oxley Act. I'm sure others of you are in the same position. We run our business on a DG-UX machine with Universe 9.411. The guidance we have been given is that we need to put stronger access controls on programmers, track programmer actions, make sure that sensitive commands at TCL such as DELETE, CLEAR-FILE, and DELETE/FILE/etc. within ED are locked down to a certain extent. Although we normally do all of our programming in-house, in this case we are interested in finding out if there is already a product out there (or code that is used internally at some other company) that accomplishes this, and works as a wraparound. If anyone has insight on this or other comments about SOX and the MV world, I'd like to hear how you are dealing with this situation. Thanks, Meeta Advani === Meeta Advani Programmer/Analyst Mothers Work, Inc. [EMAIL PROTECTED] --- 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] ThoroughBred to U2 file conversion
I know nothing about ThoroughBred, so I'm talking in general. I've done a couple of conversions from some relics and picked up this little trick. The Monarch method works great for any conversion, but if you know nothing about the system and/or it's database and the reports provide enough data to do the conversion. Setup a Laptop/PC as a printer and use a terminal emulation package to capture the output to a file. Then use Monarch to map and covert the data. Rather clumsy way of doing it but it works and needs no knowledge of the database you are converting from. The only requirement is that the existing system can produce reports. -- Vance Forste (Senior Programmer/Analyst) Caligor Hospital Supply a division of Henry Schein Inc. - Original Message - From: Richard Taylor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 26, 2005 9:50 AM Subject: RE: [U2] ThoroughBred to U2 file conversion Wow, I have not heard that name in a while. I had to convert a client off ThoroughBred to a Universe base ERP system many years ago. We never did find a good, direct export function. Instead we printed reports to text files then used a product called Monarch to map these files and covert the data to a format we could import into U2. A bit tedious yes, but it worked fairly well. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Wednesday, January 26, 2005 3:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] ThoroughBred to U2 file conversion Hi guys: I am looking at dumping data held in a ThoroughBred system, which I understand uses its own ISAM/B-Tree file access methods, to delimited flat ascii so that I can then upload onto a U2 database (Universe 10 under AIX 5.2) Does anyone know of software which will do this or is there anyone out there who has done it and could point us in the right direction ? Bob Witney Senior Sage Seer EXPLORE! 1 Frederick Street Aldershot, Hampshire GU11 1LQ, UK Tel: 01252-760329 Fax: 01252 760001 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- 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] [UV] Exit BASIC program with SELECT list?
Try this. I've done this in a simple search program... It works fine. IF LIST.B THEN WRITELIST LIST.B ON 'TEMP':@TTY:'' CHAIN 'GET-LIST TEMP':@TTY:'' END Vance - Original Message - From: Brian Leach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 9:23 AM Subject: RE: [U2] [UV] Exit BASIC program with SELECT list? Barry, Another way is to CHAIN the select statement, rather than execute it. Brian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/