Re: [U2] Web services at 11.x
We query outside services for information via soap. Universe 10.3. Nancy Fisher Federal Way, Washington -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 13, 2014 10:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Web services at 11.x https://en.wikipedia.org/wiki/Enterprise_service_bus -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:11 am Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER
Thanks. I'm beginning to think we're having printer commands stopped by our (accuterm) terminal interface. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Hammerle Sent: Tuesday, March 26, 2013 5:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER This is what I use to print barcodes on an OKI 420 printer. The barcode is 3 rows high. *PROGRAM.TYPESUBROUTINE/PROGRAM.TYPELANGUAGE.CONVERTNO/LANGUAGE.CONVE RTROLL.TO.DEAD.CODENO/ROLL.TO.DEAD.CODE $BASICTYPE 'U' SUBROUTINE SUB.BARCODE.STRING( TEXT.FOR.BARCODE, BARCODE.STR ) *com- * Written By : ??? Date : ??? * * Purpose : Create a barcode string where the first 3 fields are the * actual barcode and the last string is the human readable * barcode text in wide format. * * Notes : I would like to have seen this just build the string 1 time * just for the barcode and let the program print it 3 times. * Also I would have liked to see the wide format printing removed * from this sub and called separately. But to keep the calling programs * the same, I will leave it the same. * * Send In : TEXT.FOR.BARCODE - the string to print * * Send Out : BARCODE.STR * * Modifications : * * 11/08/10 George Hammerle * - added call to DC.GET.CURRENT.PRINTER.MODEL * */com BARCODE.STR = '' EQU ESC TO CHAR(27) EQU CHAR16TO CHAR(16) *com-- * oki 420 printers */com- BARCODE.STRING = CALL *DC.GET.PID.ATTRIBUTE( CURRENT.PRINTER.MODEL, '', PRINTER.MODEL, '' ) *CALL *DC.GET.CURRENT.PRINTER.MODEL( PRINTER.MODEL, '', '' ) IF PRINTER.MODEL = 'TALLY 2365' THEN * The TALLY barcodes are much different than the OKI 420, so I will * load the barcode up in field 1. Field 2 and 3 will be nill. This could cause * additional spacing below the barcode. * In some cases you may be able to call this sub. But if you have text before * and after the barcode on the same lines of the barcode, this sub cannot be * used. * LCP secured mode TALLY.BARCODE.LINE = CHAR(27):[?11~ TALLY.BARCODE.LINE := CHAR(27):PSC1:CHAR(27):\ * set character size to 5 TALLY.BARCODE.LINE := CHAR(16):5:CHAR(25) TALLY.BARCODE.LINE := CHAR(27):[?11~:CHAR(26): F3;000:CHAR(25):CHAR(20):*:TEXT.FOR.BARCODE:*:CHAR(20):CHAR(27):[?10~ BARCODE.STR1 = TALLY.BARCODE.LINE END ELSE * for OKI 420 THE.BARCODE = ESC:CHAR16:CHAR(65):CHAR(8) * the documentation is not the greatest on what each of these indicates N1 = CHAR(2) ;* 2 = code 3 of 9 N2 = CHAR(0) ;* N3 = CHAR(0) ;* vertical length of the bars N4 = CHAR(2) ;* some formula N5 = CHAR(1) ;* width of the narrow bars N6 = CHAR(1) ;* sets the narrow space characters width in n/144 inch N7 = CHAR(1) ;* number of columns ( 144 dpi ) ? N8 = CHAR(0) ;* 0 = no human readable barcode 1 = Utility2 = NLQ THE.BARCODE := N1:N2:N3:N4:N5:N6:N7:N8 THE.BARCODE := ESC:CHAR16:CHAR(66) LENGTH.BARCODE = LEN(TEXT.FOR.BARCODE) ;* number of characters in the barcode THE.BARCODE := CHAR(LENGTH.BARCODE):TEXT.FOR.BARCODE FOR ZZ = 1 TO 3 BARCODE.STRZZ = THE.BARCODE NEXT ZZ END CALL *DC.DOUBLE.WIDE.STRING( TEXT.FOR.BARCODE, DOUBLE.WIDE.STRING ) BARCODE.STR4 = DOUBLE.WIDE.STRING RETURN George Hammerle Programming Dude Hubert Company LLC. 9555 Dry Fork Road Harrison, Ohio 45030 513-367-8974 zhammerle@hubertREMOVE_THIS.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Monday, March 25, 2013 3:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 47, Issue 20 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than Re: Contents of U2-Users digest... Today's Topics: 1. ODBC Errors 81001/81002 (Kevin King) 2
Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER
No luck on that. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, March 26, 2013 8:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER Alt-P will manually turn on your AUX printer, inside Accuterm. So you can do that, then try your commands again, to see if it works now. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Mar 26, 2013 8:33 am Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER From: Nancy Fisher Thanks. I'm beginning to think we're having printer commands stopped by our (accuterm) terminal interface. Accuterm!? Heck yeah. You didn't mention that part! :) Those ESCape sequences tell AccuTerm to do all sorts of cool stuff. You'd hope that it's smart enough to not process the codes until it receives the AUX-off, but... Check with Pete Schellenbach. You might be able to execute a script to turn off command processing and then do something to turn it back on something that would not occur during the printing process. T [snipped mile-long digest] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER
DIRECT CONNECT gives us a nice barcode. We'll need a script for AccuTerm - to let the command codes thru. Thanks! Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nancy Fisher Sent: Tuesday, March 26, 2013 9:15 AM To: 'U2 Users List' Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER No luck on that. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, March 26, 2013 8:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER Alt-P will manually turn on your AUX printer, inside Accuterm. So you can do that, then try your commands again, to see if it works now. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Mar 26, 2013 8:33 am Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER From: Nancy Fisher Thanks. I'm beginning to think we're having printer commands stopped by our (accuterm) terminal interface. Accuterm!? Heck yeah. You didn't mention that part! :) Those ESCape sequences tell AccuTerm to do all sorts of cool stuff. You'd hope that it's smart enough to not process the codes until it receives the AUX-off, but... Check with Pete Schellenbach. You might be able to execute a script to turn off command processing and then do something to turn it back on something that would not occur during the printing process. T [snipped mile-long digest] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER
I mean dynamic connect. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nancy Fisher Sent: Tuesday, March 26, 2013 9:43 AM To: 'U2 Users List' Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER DIRECT CONNECT gives us a nice barcode. We'll need a script for AccuTerm - to let the command codes thru. Thanks! Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nancy Fisher Sent: Tuesday, March 26, 2013 9:15 AM To: 'U2 Users List' Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER No luck on that. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, March 26, 2013 8:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER Alt-P will manually turn on your AUX printer, inside Accuterm. So you can do that, then try your commands again, to see if it works now. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Mar 26, 2013 8:33 am Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER From: Nancy Fisher Thanks. I'm beginning to think we're having printer commands stopped by our (accuterm) terminal interface. Accuterm!? Heck yeah. You didn't mention that part! :) Those ESCape sequences tell AccuTerm to do all sorts of cool stuff. You'd hope that it's smart enough to not process the codes until it receives the AUX-off, but... Check with Pete Schellenbach. You might be able to execute a script to turn off command processing and then do something to turn it back on something that would not occur during the printing process. T [snipped mile-long digest] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER
AccuTerm transparent printing command works for this. Barcode printing accomplished. Thanks! Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nancy Fisher Sent: Tuesday, March 26, 2013 9:59 AM To: 'U2 Users List' Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER I mean dynamic connect. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com From: Nancy Fisher Thanks. I'm beginning to think we're having printer commands stopped by our (accuterm) terminal interface. Accuterm!? Heck yeah. You didn't mention that part! :) Those ESCape sequences tell AccuTerm to do all sorts of cool stuff. You'd hope that it's smart enough to not process the codes until it receives the AUX-off, but... Check with Pete Schellenbach. You might be able to execute a script to turn off command processing and then do something to turn it back on something that would not occur during the printing process. T [snipped mile-long digest] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SENDING BARCODE COMMANDS TO OKI PRINTER
I'm having some problems getting the internal barcode to print on an okidata 320 turbo: Sending to an aux printer: PRINT CHAR(18): PRINTTEST PRINT PRINT CHAR(27):CHAR(16):CHAR(65):CHAR(8):CHAR(2):CHAR(0):CHAR(1):CHAR(1):CHAR(2):C HAR(2):CHAR(3):CHAR(1): PRINT CHAR(27):CHAR(16):CHAR(66):CHAR(10):1234567890 PRINT PRINT PRINT CHAR(20) I get the TEST and sometimes I get '67890'. I could certainly have the Aux codes messed up, or just about anything as this is my first attempt at sending codes to an OKIDATA. It says it's the IBM PPR emulation Mode, and has the internal barcode (using code 39). Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website http://www.peninsulatruck.com www.peninsulatruck.com mailto:nan...@peninsulatruck.com nan...@peninsulatruck.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UNIVERSE/SB+ AND BLUE TOOTH
Has anyone done an integration using data from a blue tooth device? We currently have a wireless application on a handheld device (ttwin) we'd like to use to receive input from wireless scales via blue tooth. Thanks! Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website http://www.peninsulatruck.com www.peninsulatruck.com mailto:nan...@peninsulatruck.com nan...@peninsulatruck.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
Sb+ has an ON.EXIT process, I was going to replace with my own, but don't know what the SB+ process does, and haven't found an explanation in docs. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, October 12, 2012 1:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User timeout question On 12/10/12 02:28, nancy wrote: How does autologout work in SB ? (windows/universe) How does ON.EXIT work? If ON.EXIT exists, then it is called by UV as part of the normal logout process. For example, what I used it for was to turn the default stack saving mechanism off. Then I used ON.EXIT to do a SAVE.STACK username and in the LOGIN command (which runs at login, of course) I did a LOAD.STACK username. It's provided so that your programs have a way to clean up after themselves when your user quits UV. Just be aware it doesn't always work - lusers will always find some way to avoid the safeguards you've put in place - every time we invent something idiot-proof, nature invents a better idiot. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: [MailServer Notification]Content Filtering Notification
Not me. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, March 27, 2012 11:28 AM To: U2 Users Subject: [U2] FW: [MailServer Notification]Content Filtering Notification Is this real? Or did I get spammed by a bot scraping the U2 archives? I couldn't figure out what anything in my post that would have triggered it. Anyone else getting these? George -Original Message- From: Administrator [mailto:sme...@omnicare.com] Sent: Tuesday, March 27, 2012 1:44 PM To: George Gallen Subject: [MailServer Notification]Content Filtering Notification This email has violated the PROFANITY. and Quarantine entire message has been taken on 3/27/2012 1:43:37 PM. Message details: Server: OCR2K8EXHUB01 Sender: ggal...@wyanokegroup.com; Recipient: u2-users@listserver.u2ug.org; Subject: Re: [U2] Detecting idle time in INPUT statement. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date Problem
I also quit using @DATE and changed to DATE() as @DATE was not 100% reliable. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, January 20, 2012 10:20 AM To: 'U2 Users List' Subject: Re: [U2] Date Problem If it were just a few programs, I would not be too concerned. However, it is an INCLUDE that is included in hundreds of programs, so the impact could be huge (even if the impact is to be correct). However, I have pulled the trigger and replaced the @DATE to DATE() in the INCLUDE. Some programs will need to be re-compiled, others will take the effect when next re-compiled. This is NOT the solution I wanted, but appears to be the solution I must take... Bummer John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Friday, January 20, 2012 1:14 PM To: U2 Users List Subject: Re: [U2] Date Problem I ran into an issue with @DATE many years ago, but this was on UV and probably around version 8.3 or 9.5.1. The problem I ran into was @DATE failed in programs run as phantoms but worked fine if the program was run via a terminal. DATE() always worked correctly. We had migrated from Ultimate not too many years before, and all of our legacy code used DATE(), so it wasn't a big deal for me to replace the few instances of @DATE with DATE(). I haven't used @DATE since. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, January 20, 2012 9:36 AM To: 'U2 Users List' Cc: Conway, Bruce; Majors,Larry Subject: [U2] Date Problem I have an INCLUDE that I use in ALL programs I touch. It simply does a bunch of assigning of variables so that I can use them as needed. One of these assignments is: TODAY = @DATE I have 1 program in 1 account that is consistently returning: 16066 (which is 12/26/11). This program is initiated via a Redback call but so are many many others. In the pgm that is failing, immediately after my INCLUDE, I just added code to write the following to disk: TODAY DATE() @DATE Both TODAY and @DATE ALWAYS return 16066 for this 1 program, but no others. The same program is working correctly in other accounts, and the value of TODAY is correct in EVERY other program I have ever used. Does anyone have a clue? I could replace @DATE with DATE() in my INCLUDE, but to do my due diligence, I should recompile EVERY program that uses the INCLUDE (and that is NOT going to happen). John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
We consume data. VERY reliable. Not serving anything, though. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, January 28, 2011 10:51 AM To: 'U2 Users List' Subject: [U2] What do you do with CallHTTP? What uses have you found for CallHTTP for in your applications? Are you 'eating' someone else's data with it - like doing lookups against a web service call? Or are you using it to 'serve' data to others? Rocket says you can do this, but I can't see how it would work offhand and would like to know the scenario. How complex have you found it and how stable? Thanks for your thoughts! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) [not-secure]
It sounds like the beginning of a poem though. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Friday, April 16, 2010 8:07 AM To: 'U2 Users List' Subject: Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) [not-secure] I was thinking the same thing. Maybe we need a Where's Haydon Bishop? Book... or perhaps we should form a Find Haydon Bishop group on Facebook -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, April 16, 2010 9:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) I'm beginning to think Hayden Bishop doesn't actually have an office... He's never in it from all appearances. Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Haydon Bishop haydon.bis...@adserve.co.uk 4/15/2010 3:59 PM I am out of the office until 16/04/2010. I will respond to your message when I return. Note: This is an automated response to your message U2-Users Digest, Vol 12, Issue 15 sent on 15/04/2010 20:00:02. This is the only notification you will receive while this person is away. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Change is a coming!
No attachment? Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com - Original Message - From: Doug dave...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tuesday, September 15, 2009 11:18 AM Subject: [U2] Change is a coming! September 15, 2009: IBM has signed an agreement to sell the U2 assets to Rocket Software, a global software development company. Founded in 1990, Rocket is a provider of OEM software to IBM, HP and other Fortune 500 companies. Rocket's RD focus has the potential to accelerate the growth of U2's business. Please read the attached document from Susie Siegesmund regarding the announcement. Surprise surprise ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What ever happened...
You really made my day. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com - Original Message - From: Larry Hiscock lar...@wcs-corp.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thursday, August 27, 2009 9:50 AM Subject: Re: [U2] What ever happened... Fruit Loops wanted him back ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: Thursday, August 27, 2009 9:36 AM To: 'U2 Users List' Subject: [U2] What ever happened... Whatever happened to the Toucan? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple email copies
Me too - just 1 copy. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com - Original Message - From: George Gallen ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Sent: Wednesday, March 04, 2009 12:06 PM Subject: RE: [U2] Multiple email copies No. I've only been getting 1 each. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Wednesday, March 04, 2009 2:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multiple email copies Is anyone else receiving 5 copies of each mail sent to the u2-users list ? Last week I was only receiving 3 copies of each mail. --- --- 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] SELECT problem with quote characters
LIKE ...LLOYD'S... Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington Visit our Website www.peninsulatruck.com [EMAIL PROTECTED] - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, August 06, 2008 8:18 AM Subject: [U2] SELECT problem with quote characters I'm trying to select a string that contains a single-quote, using the LIKE operator. It works fine with EQ. So if I do a SELECT FILE WITH FIELD EQ LLOYD'S , the select returns exactly what I expect. But if I do a SELECT FILE WITH FIELD LIKE ...LLOYD'S... it returns pretty much the entire file And if I do a SELECT FILE WITH FIELD LIKE \...LLOYD'S...\ it returns nothing. What on earth is the syntax for picking up an embedded quote in data in a LIKE comparison? PIOPEN flavour, by the way. Cheers, Wol --- 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] xml-namespace-parsing
At U2 University (San Francisco) I learned that an Options entry in the XML map could tell the XDOM (soap download-parsing) to ignore namespaces. Alternately if I could 'use' the namespaces I would but that's not working either. There are 2 namespace links http://web.webservice... and http://web1.webservice... OPTIONS IgnoreNameSpace/ /OPTIONS I continue to get Error code: 10 The location path 'LocPathResponse/LocPathResponse' was not found. In the xml download the appearance is: (abbreviated...) RESP DATA soap:Envelope xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soap:Bodyns1:LocPathResponse xmlns:ns1=http://web.webservicesXX.com; ns1:LocPathResponse GrossCharge xmlns=http://web1.webservicesXX.com;201.30/GrossCharge Surcharge xmlns=http://web1.webservicesXX.com;20/Surcharge /ns1:LocPathResponse /ns1:LocPathResponse /soap:Body /soap:Envelope I've also tried several variations of the location path..I think it's the namespace issue but I could be wrong. Is the 'options' valid for ignoring namespaces? thanks, Nancy [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML (AGAIN!)
I got the impression (it says so in my notes!) while I was at U2 University that an Options entry in the XML map could tell the XDOM (soap download) to ignore namespaces. OPTIONS IgnoreNameSpace/ /OPTIONS I continue to get Error code: 10 The location path '/LocPathResponse/LocPathResponse' was not found. In the xml download the appearance is: (abbreviated...) RESP DATA soap:Envelope xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soap:Bodyns1:LocPathResponse xmlns:ns1=http://web.webservicesXX.com; ns1:LocationPathResponse GrossCharge xmlns=http://web1.webservicesXX.com;201.30/GrossCharge Surcharge xmlns=http://web1.webservicesXX.com;20/Surcharge /ns1:LocPathResponse /ns1:LocPathResponse /soap:Body /soap:Envelope I've also tried several variations of the location path..I think it's the namespace issue but I could be wrong. Is the options valid for ignoring namespaces? thanks, Nancy [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] group locks and user nbr's
I like to know what worked... Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 Visit our Website www.peninsulatruck.com [EMAIL PROTECTED] - Original Message - From: Dave Taylor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, June 19, 2008 3:00 PM Subject: RE: [U2] group locks and user nbr's Doug, I vote for snip-the-msg-and-say-thanks. Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Doug Chanco [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, June 19, 2008 12:08 PM Subject: RE: [U2] group locks and user nbr's snip --- 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] XML ISSUE
I have an xml map that looks like: (partial) ColumnMap Node=REASON Column=REASON/ ColumnMap Node=ODOMETER Column=ODOMETER/ ColumnMap Node=TRAVELTIME Column=TRAVELTIME/ The record is built and each of the Columns is a dictionary item. The xml used to look like this (partial): VEHICLE ID=23485 REASONu/REASON ODOMETER39781632/ODOMETER TRAVELTIME3406182/TRAVELTIME /VEHICLE and the record looks like this (partial): 0013: u 0014: 39781632 0015: 3406182 (Has worked fine for years!) The vendor has just has changed the driver and driver status to this (partial) inside a PARAMS tag. VEHICLE ID=23485 REASONu/REASON ODOMETER39781632/ODOMETER TRAVELTIME3406182/TRAVELTIME PARAMS PARAM name=Driver ID1234/PARAM PARAM name=Driver Name5599 FRANKLIN, WADE/PARAM PARAM name=Driver StatusLogout/PARAM /PARAMS /VEHICLE To my map I added: ColumnMap Node=PARAMS Column=PARAM/ And I added a dictionary item called PARAM. I now get 3 blank lines returned in the new dictionary field. (I was willing to parse it myself as there can be other things in the PARAMS besides driver info) I've tried lots of stuff in the map like: ..Node=PARAMS/PARAM etc but the program usually bombs. Does anyone have something I could try? Do I need a more complete path to the new items? thanks so much, Nancy [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe: IF statements in parargraphs don't work anymore
Thanks! Good to know. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 Visit our Website www.peninsulatruck.com [EMAIL PROTECTED] - Original Message - From: Louie Bergsagel [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, June 05, 2008 12:56 PM Subject: Re: [U2] Universe: IF statements in parargraphs don't work anymore I found the problem. Somebody had deleted the = VOC record. ED = Unable to open =, not a file in VOC. I restored it from EQ. -- Louie CT VOC =EQ = 0001 K 0002 4 EQ 0001 K 0002 4 --- 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: IBM DOCS was: RE: [U2] sigh phantom ?
We've never been able to use the fixtool with uniadmin (universe 10.2/windows2003). We get Unable to access file: no matter which file - then we have to break out as the 'OK' button never goes away. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Jeff Schasny [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 13, 2007 10:42 AM Subject: Re: IBM DOCS was: RE: [U2] sigh phantom ? I don't understand. Why don't you just use Uniadmin? I not sure if the old motif (Agh) stuff even exists any more. Besides it was pretty much evil and ugly anyway. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2 University
Is anyone going to the San Francisco end of Nov venue? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Forms printing
Is that the name of the product: Create!form/Create!Print ? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: phil walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 28, 2007 1:04 PM Subject: RE: [U2] Forms printing Create!form/Create!Print does the same thing. You basically create a data map overlay of the existing print job and then position these maps on the designed form. You can use data within the map to do conditional processing. Very good. Phil -Original Message- I was wondering if anyone could suggest a method or product they have used to take reports normally spooled to a line printer with preprinted forms, and print them on alaser printer using a stored form and logo, with the data overlaid. Ideally it should be transparent in that the UniVerse report program does not have to be modified, with only the output sent to a special uv print queue. This needs to run on AIX. Thanks in advance. Andrea --- 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] UniData 7.1 vs. MS SQL 2005 performance
Why doesn't IBM allow access to all information that would help users - we've already bought the product? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Smith, Robert [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 18, 2007 6:14 AM Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Good Morning, I really enjoyed reading this thread. I can honestly say that the diversity of experiences and people who comprise this listserv is amazing. And I've found the shared knowledge to be invaluable. As one who has not been immersed in the U2 environment for an extended period of time, there is one item that serves as a continued source of frustration. And it's exactly what Phil mentions below...sparse documentation. Not only for new stuff, but also for what I consider to be general items. More than once I have had a problem and through research, found that a PDF containing possibly pertinent information could be obtained from the IBM web site. Knowing it was there did me absolutely no good at all. Because my connection to the U2 world is through our software vendor, IBM has consistently refused to acknowledge/honor any request that I've made for information. And based upon the feedback I have gotten at times from the vendors support center, they (the support center) has a equ! ally difficult time extracting U2 information from IBM. And it's not like there are selves full of books on U2 that I could turn to for research...at least not that I've seen. I can go to any major book store and find two or three selves of books on MS SQL and NONE on U2. This was particularly frustrating when I was first getting started with U2 four years ago. How could there be no books? Regardless of the bookstores I've visited over the years, the results has always been the same. I have since learned that, outside of spending thousands of dollars to go to vendor sponsored training classes (and receiving their training books), the best way to learn about things in this environment is through the listservs...word of mouth...trial and error. For one who has spent a considerable amount of time (with past systems I've supported) over the years plowing through technical manuals learning the nuances of how to best work with a product, being denied that information is very ! frustrating. The only consolation are listserves such as this one. The U2 industry is ill served by what I perceive to be an informational void relative to the product. And the tragedy is that this is a really good family of products. Very worthy of recognition along with the other major players in the RDBMS arena. Something should be done to free up this log-jam. And the first thing that would be really helpful is if IBM allowed both their direct customers AND the clients of those customers (such as myself), direct access to all aspects of the critical information contained upon their web site. Maybe then people will start writing books about U2. My two cents, Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of phil walker Sent: Tuesday, July 17, 2007 4:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Nick, Here, here to your following statements To me, this is part of the problem that we have in the MV world. We look at how things are being done elsewhere and say, Pick does it better, we aren't going to do that. The problem with this approach is that everyone else is adopting these standards and using them. We are going to be left further behind if we don't start using some of the technologies available to us. . And this is where this list breaks down in that a lot of the new features IBM are building into the product are not used/discussed and the documentation is VERY, VERY sparse. So people like myself and a few others are left to trial and error techniques to implement these new technologies because we HAVE to talk to the outside world and people expect some sort of standard method to do this. Because of this approach we take a lot longer to do something which I am sure is reasonably easy if one was to have good quality examples available like most other dbms/development environments have on the web Phil (my 2c) Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Wolthuis Sent: Monday, July 16, 2007 11:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance I do understand the advantages to that approach, Nick. But that was also the thinking of those who prepared the current industry benchmarks by locking in on SQL. My concern was that if you specify technologies, you can make it difficult for solutions that are outside the box. --dawn On 7/16/07, Nick Cipollina [EMAIL PROTECTED] wrote: If the consumer
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
My var retrieved some info on setting up PDF from SB+ report writer for me one time. It was barely legible and not helpful. I was still glad to get it. VAR said they could try and get access for me but hadn't any success in the past... I never heard back. Still can't use HTML or PDF from (character based) SB+. I do recall hearing the VAR angle but my experience with our VAR didn't really support that. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 18, 2007 9:42 AM Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Nancy this was discussed in the past at great length! To summarize: When the U2UG was formed, we petitioned for IBM to open up their knowledge sources. The problem is their vars, some of whom do not want their users to get access (and presumably show up how p*ss p**r their support may be). So a compromise was reached - if the var agrees, you can get access. Of course, some vars won't - but then you could always buy a single user UV from a sensible and capable var who will. that's probably worth the cost of the material anyway. it's also one of the reasons we started the U2UG knowledge base - and we're about to launch a Wiki on the same site. Brian Why doesn't IBM allow access to all information that would help users - we've already bought the product? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [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] KB access - with var permission
Precisely what I heard. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Marc Harbeson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 18, 2007 10:04 AM Subject: [U2] KB access - with var permission Does anyone have a known process that works for getting this access setup? I've been round and round on this access, and my var does not know what else to do. The var has no issue granting the access - but IBM has made it SO complicated that apparently it takes a rocket scientist to figure it out. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, July 18, 2007 12:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Nancy this was discussed in the past at great length! To summarize: When the U2UG was formed, we petitioned for IBM to open up their knowledge sources. The problem is their vars, some of whom do not want their users to get access (and presumably show up how p*ss p**r their support may be). So a compromise was reached - if the var agrees, you can get access. Of course, some vars won't - but then you could always buy a single user UV from a sensible and capable var who will. that's probably worth the cost of the material anyway. it's also one of the reasons we started the U2UG knowledge base - and we're about to launch a Wiki on the same site. Brian --- 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] Users of UniVerse
Peninsula Truck Lines, Inc a northwest regional carrier... using UniVerse for at least 15 years. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Liesse, Dave [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, April 27, 2007 6:28 AM Subject: [U2] Users of UniVerse Hi, all. My sales group has a need to convince some prospects that real companies do, indeed, use UniVerse. Naturally and logically, there are no references on the IBM web site. I've been tasked with coming up with the names of a few UniVerse users - no contacts, just companies. If any of you is willing to let it be known that your employer uses UV, please respond as soon as possible. Of course, this was a last-minute request, so I don't have time to go through the normal channels to get reference lists. Again, I emphasize that we're NOT looking for contact information, and it's doubtful anyone will even think of trying to get in touch with you; we're just facing the usual concern that UV is a minor product at which real companies turn up their noses and sniff haughtily before they go off and use a real system like SQL Server. Dave Liesse Quality Manager SSC Technologies, 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/
Re: [U2] FTP
Thanks Tony. Nancy [EMAIL PROTECTED] - Original Message - From: Tony Gravagno [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, March 11, 2007 7:49 PM Subject: RE: [U2] FTP I see security has been mentioned a couple times but I hope that sinks in - FTP is not a secure protocol. Your EDI headers and detail are open for viewing. Seeing that you're in the trucking business someone might find it worth their time to watch your packets or maybe even make modifications in order to redirect or intercept shipments. No, not paranoia, it happens. In your case where you could be sending data from the client or the server, I'd recommend using cURL, which has consistent cross-OS syntax (unlike Windows FTP and *nix FTP which are different) as well as security via OpenSSL. I've used FTP from AccuTerm and I use AccuTerm for a lot of other purposes, but there are limits to what we can do from the client, especially in a dynamic environment. Also, FTP itself is not a guaranteed protocol. Any code you have written around it should be able to recognize and handle faults. As one simple example, FTP may be blocked at any time by updates to Windows Firewall or other firewall/anti-virus software or hardware. A new PC may not be able to FTP out. Someone doing work from home may have completely different network conditions. Unless you capture the results of connections and return them to the server, you may not know when errors happen. In the trucking business you need to ensure that your transactions are received and acknowledged. This is why EDI has traditionally moved through Value-Add Networks. They are expensive but they do manage transactions effectively. If you don't use a VAN then be sure to code for faults, and record successful transactions yourself to answer those we didn't get it issues. HTH Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com --- 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] FTP
Pete (AccuTerm) was able to make it work. Hi Nancy - The Windows command processor does not handle redirection properly. Try explicitly launching the command processor using CMD.EXE with the '/C' option: cmd = CMD.EXE /C FTP -s:\\OURSERVER\Flatfile\FTP.EXPORT\ftpscript1.txt ftp.log PRINT ESC:STX:'':CMD:CR:I had to put C:\in front of the ftp.log and then it worked. Thanks to everyone for your help - and running from the Server would be best and hopefully we will get there - in the meantime Woo Hoo !!! Nancy [EMAIL PROTECTED] - Original Message - From: MAJ Programming [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 08, 2007 6:17 AM Subject: Re: [U2] FTP I was focused more on clearing up the accuterm syntax. I do FTP perhaps once a year so I don't remember it directly. I use the ESC:STX stuff a whole lot. Thanks - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, March 07, 2007 9:49 PM Subject: RE: [U2] FTP Mark: My thoughts on this subject are usually the same...keep it simple. There has to be some pretty serious conditions existing before I'd move ftp services off the server and onto any client, and just because it can is not one of them. :-) Every O/S we use has an ftp client as part of it (Windows ..nix). Networking is a difficult business where all kinds of things go wrong. Moving a service like ftp off the UniVerse server is just asking for an additional layer of problems. I'm late to ftp processing but I'm sure most on this list do ftp processing and it would be wise to follow advice given in this thread...ftp from the UV server. The script I posted works well and includes sftp processing. I'd be happy to post more but I'm sure everyone already does this kind of thing. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Wednesday, March 07, 2007 6:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FTP My 2 cents on accuterm: This may not clear up the FTP script, but It will set things straight for the ESC:STX sequence. Accuterm has beaucoups of PC facilities just waiting to run. They are typically preceed by the ESC:STX (27 : 2). The command means that the Pick session will wait until the DOS session is complete. PRINT ESC:STX: SOL.EXE The command means that the Pick session will continue while the DOS session remains open. PRINT ESC:STX: SOL.EXE I don't know specifically, But I have had timing concerns with issuing commands to DOS and then expecting to use those results back in Pick. If I write a textfile to a shared file and then execute notepad to play with it, Pick has to wait until notepad is finished. The ESC:STX command may finish promptly but re-reading the shared file textfile may result in beating notepad to the punch and you get the same record. Putting a SLEEP or READ within a LOOP to compare the before and after may be the trick. Mark Johnson --- 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] FTP
Yes! He is the man. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: MAJ Programming [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 08, 2007 4:12 PM Subject: Re: [U2] FTP If you're referring to Peter Schellenbach, then he's the man. He can interface anything with anything else. - Original Message - From: Nancy Fisher [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 08, 2007 12:34 PM Subject: Re: [U2] FTP Pete (AccuTerm) was able to make it work. Hi Nancy - The Windows command processor does not handle redirection properly. Try explicitly launching the command processor using CMD.EXE with the '/C' option: cmd = CMD.EXE /C FTP -s:\\OURSERVER\Flatfile\FTP.EXPORT\ftpscript1.txt ftp.log PRINT ESC:STX:'':CMD:CR:I had to put C:\in front of the ftp.log and then it worked. Thanks to everyone for your help - and running from the Server would be best and hopefully we will get there - in the meantime Woo Hoo !!! Nancy [EMAIL PROTECTED] - Original Message - From: MAJ Programming [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 08, 2007 6:17 AM Subject: Re: [U2] FTP I was focused more on clearing up the accuterm syntax. I do FTP perhaps once a year so I don't remember it directly. I use the ESC:STX stuff a whole lot. Thanks - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, March 07, 2007 9:49 PM Subject: RE: [U2] FTP Mark: My thoughts on this subject are usually the same...keep it simple. There has to be some pretty serious conditions existing before I'd move ftp services off the server and onto any client, and just because it can is not one of them. :-) Every O/S we use has an ftp client as part of it (Windows ..nix). Networking is a difficult business where all kinds of things go wrong. Moving a service like ftp off the UniVerse server is just asking for an additional layer of problems. I'm late to ftp processing but I'm sure most on this list do ftp processing and it would be wise to follow advice given in this thread...ftp from the UV server. The script I posted works well and includes sftp processing. I'd be happy to post more but I'm sure everyone already does this kind of thing. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Wednesday, March 07, 2007 6:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FTP My 2 cents on accuterm: This may not clear up the FTP script, but It will set things straight for the ESC:STX sequence. Accuterm has beaucoups of PC facilities just waiting to run. They are typically preceed by the ESC:STX (27 : 2). The command means that the Pick session will wait until the DOS session is complete. PRINT ESC:STX: SOL.EXE The command means that the Pick session will continue while the DOS session remains open. PRINT ESC:STX: SOL.EXE I don't know specifically, But I have had timing concerns with issuing commands to DOS and then expecting to use those results back in Pick. If I write a textfile to a shared file and then execute notepad to play with it, Pick has to wait until notepad is finished. The ESC:STX command may finish promptly but re-reading the shared file textfile may result in beating notepad to the punch and you get the same record. Putting a SLEEP or READ within a LOOP to compare the before and after may be the trick. Mark Johnson --- 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] FTP
I'm using AccuTerm DOSSVC to place a file on remote FTP site. It always shows up exactly like I want. But I need to capture the results so I can automate it (just in case it doesn't go). The Basic program (AccuTerm) DOSSVC uses this syntax: EQU ESC TO CHAR(27) EQU STX TO CHAR(2) EQU CR TO CHAR(13) PRINT ESC:STX:'':CMD:CR The command is: CMD = FTP -s:\\OURSERVER1\Flatfile\FTP.EXPORT\ftpscript1.txt and the ftpscript1.txt is: open ftp.somesite.com ourusername ourpassword ascii cd / send \\OURSERVER1\Flatfile\OURCLIENT\FILETOSEND.EDI bye I don't know if I need to know DOS/FTP or BASIC or AccuTerm syntax to return the result of the transfer absolutely ANYWHERE (variable or file). I am practically clueless on DOS/FTP and have struggled to get this far. Since I can send the file I am very frustrated at not being able to manage the result. I have tried the AccuTerm forum...and no luck so far. We are on Windows/UniVerse. thanks, Nancy [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FTP
Is the '' after the 'ftpscript1.txt' on your sample part of the syntax? I thanks, Nancy - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, March 07, 2007 2:08 PM Subject: RE: [U2] FTP Nancy: If I understand you correctly you're using your client PC to ftp the file. I believe you can direct the ftp output like: CMD = FTP -s:\\OURSERVER1\Flatfile\FTP.EXPORT\ftpscript1.txt C:\FtpTransfer.txt I do this in backup scripts on various servers that email the results to me. So, theoretically, you could set up the script on the Windows server (if you're using Windows), or on a Linux server, to do the same thing without using AccuTerm. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nancy Fisher Sent: Wednesday, March 07, 2007 1:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] FTP I'm using AccuTerm DOSSVC to place a file on remote FTP site. It always shows up exactly like I want. But I need to capture the results so I can automate it (just in case it doesn't go). The Basic program (AccuTerm) DOSSVC uses this syntax: EQU ESC TO CHAR(27) EQU STX TO CHAR(2) EQU CR TO CHAR(13) PRINT ESC:STX:'':CMD:CR The command is: CMD = FTP -s:\\OURSERVER1\Flatfile\FTP.EXPORT\ftpscript1.txt and the ftpscript1.txt is: open ftp.somesite.com ourusername ourpassword ascii cd / send \\OURSERVER1\Flatfile\OURCLIENT\FILETOSEND.EDI bye I don't know if I need to know DOS/FTP or BASIC or AccuTerm syntax to return the result of the transfer absolutely ANYWHERE (variable or file). I am practically clueless on DOS/FTP and have struggled to get this far. Since I can send the file I am very frustrated at not being able to manage the result. I have tried the AccuTerm forum...and no luck so far. We are on Windows/UniVerse. thanks, Nancy [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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FTP
I tried just one '' and then I tried 2 '' and still nada. I tried with spaces around the and all run together. I tried it with and without a path (C:). I don't get results but with the addition of or the file doesn't get sent either. thanks, Nancy [EMAIL PROTECTED] - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, March 07, 2007 2:24 PM Subject: RE: [U2] FTP Hi Nancy, I've done a pretty fair bit of work with DOS command scripts of late. You might be looking for the function added to the end of your CMD command. Something like this: CMD = FTP -s:\\OURSERVER1\Flatfile\FTP.EXPORT\ftpscript1.txt ftp.log I'd have to do some playing around but I think that might be what you're looking for. This should result in the displayed information of your FTP process ends up in the ftp.log which is a text file in your current directory. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nancy Fisher Sent: Wednesday, March 07, 2007 1:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] FTP I'm using AccuTerm DOSSVC to place a file on remote FTP site. It always shows up exactly like I want. But I need to capture the results so I can automate it (just in case it doesn't go). The Basic program (AccuTerm) DOSSVC uses this syntax: EQU ESC TO CHAR(27) EQU STX TO CHAR(2) EQU CR TO CHAR(13) PRINT ESC:STX:'':CMD:CR The command is: CMD = FTP -s:\\OURSERVER1\Flatfile\FTP.EXPORT\ftpscript1.txt and the ftpscript1.txt is: open ftp.somesite.com ourusername ourpassword ascii cd / send \\OURSERVER1\Flatfile\OURCLIENT\FILETOSEND.EDI bye I don't know if I need to know DOS/FTP or BASIC or AccuTerm syntax to return the result of the transfer absolutely ANYWHERE (variable or file). I am practically clueless on DOS/FTP and have struggled to get this far. Since I can send the file I am very frustrated at not being able to manage the result. I have tried the AccuTerm forum...and no luck so far. We are on Windows/UniVerse. thanks, Nancy [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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FTP
Woo Hoo ! From a command window when I enter: FTP -s:\\OURSERVER1\Flatfile\FTP.EXPORT\ftpscript1.txt C:\ftp.log it sends the file and writes the log !!! It will not write the log from inside the program as shown above. Thanks. I've come a long way just seeing that it will work. Nancy [EMAIL PROTECTED] - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, March 07, 2007 4:01 PM Subject: RE: [U2] FTP Nancy: Sure it works. I just got to a DOS prompt and did the following (remember the prompts don't work too well when I'm redirecting output so I have to know what the prompt would normally say). Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\myuserftp 192.168.1.26 e:\ftp.log myuser -note: the authorized user on the ftp server Password: -note: the password for the above authorized user quit-note: I'm on so quit the ftp session C:\Documents and Settings\myuser Then I looked at the C:\ftp.log file and it looked like: Connected to 192.168.1.26. 220 FTP server ready. User (192.168.1.26:(none)): 331 Password required for myuser. 230 User myuser logged in. Access restrictions apply. ftp 221-You have transferred 0 bytes in 0 files. 221-Total traffic for this session was 194 bytes in 0 transfers. 221 Thank you for using the FTP service on dbserver. If I ran this from the script I posted earlier, everything would work without input from you. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nancy Fisher Sent: Wednesday, March 07, 2007 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FTP I tried just one '' and then I tried 2 '' and still nada. I tried with spaces around the and all run together. I tried it with and without a path (C:). I don't get results but with the addition of or the file doesn't get sent either. thanks, Nancy [EMAIL PROTECTED] - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, March 07, 2007 2:24 PM Subject: RE: [U2] FTP Hi Nancy, I've done a pretty fair bit of work with DOS command scripts of late. You might be looking for the function added to the end of your CMD command. Something like this: CMD = FTP -s:\\OURSERVER1\Flatfile\FTP.EXPORT\ftpscript1.txt ftp.log I'd have to do some playing around but I think that might be what you're looking for. This should result in the displayed information of your FTP process ends up in the ftp.log which is a text file in your current directory. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Printer Creeping
If you have a print server did you cycle that off and on? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, November 30, 2006 8:12 AM Subject: [U2] Printer Creeping Just lately, one greenbar printer (we only have one left, hurray), has started creeping less than a line per page. For 2 or 3 pages, who cares, other than me, but for any jobs more than a few pages, the text is running over the perforation. This printer has been in service for more than a couple years without any problems. This showed up on one job last month and I turned the printer off and then back on and re-printed and it worked fine. This morning, a report printed during the night crept and after turning the printer off and back on, it did it again on a reprint. Help? It's Month-End and I have over 1000 pages to print and can't afford to have this problem, as you can imagine... Any ideas? grasp, grasp... -- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Repeats from the list server
I recevd dupes also... Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Gordon J Glorfield [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 22, 2006 6:52 AM Subject: [U2] Repeats from the list server My mailbox was full of messages I'd already read from the list. It was a deja vous moment there at first. Is there a server somewhere that is bouncing the messages back to our list server or has our server had a hickup? Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 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] HTTP ERROR
According to the manual it is basically timing out ? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Nancy Fisher [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 10, 2006 9:20 AM Subject: [U2] HTTP ERROR Error in submitRequest: 2 The network subsystem has failed. I'm getting the above error - maybe again - but I'm not recalling the 2. Does this specify what the problem is in connecting to their server? If I could give them any clues - it would help them in trying to troubleshoot why I suddenly can't connect to their server. UniVerse/Windows 2003 thanks, Nancy Fisher [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/
[U2] HTTP Error
Error in submitRequest: 2 The network subsystem has failed. What is the meaning of this error message on an HTTP Call? Does that refer to our network as opposed to the vendors network I'm trying to retrieve the data from? thanks, Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Importing Data from Universe into Excel
If you use AccuTerm they have some very nice programs for dynamically reading dictionaries from Excel. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Dave Taylor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, April 22, 2006 12:31 PM Subject: [U2] Importing Data from Universe into Excel One of my customers is interested in extracting data from Universe into Excel by himself without having to have a program written for each import to Excel. If he learns the names of the files and their dictionaries, and which attributes are multi-valued, or even sub-valued, (and of course Excel), what strategies are available to him - eg. SQL commands, a macro in Excel, Web Services (next rel. of Universe), some reporting product designed to import data from Universe, etc.? The customer is considering a server upgrade using XP Pro, and I'm trying to talk him into W2003, so any strategies that would require IIS or something else that W2003 includes that is not offered by XP Pro will strengthen my argument. I am scheduled to discuss this with the customer again Monday morning about 10:00 AM Pacific Time, so any thoughts you can provide will be greatly appreciated. Many thanks, 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 (C) 310-561-5200 (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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RETURN FLAG
windows 2003 UniVerse 10+ SB+ 5+ Why would a blank (zero?) @rtn.flag have a length of 4 ? thanks Nancy Fisher --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Fw: RETURN FLAG
Sorry. should have sent to sb+ not U2 - Original Message - From: Nancy Fisher To: u2-users@listserver.u2ug.org Sent: Thursday, April 13, 2006 3:53 PM Subject: RETURN FLAG windows 2003 UniVerse 10+ SB+ 5+ Why would a blank (zero?) @rtn.flag have a length of 4 ? thanks Nancy Fisher --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] TIME
Windows 2003 / UniVerse 10+ We recently expanded into a different time zone! Our server time is syncronized to pacific time (daylight savings or not). Now we have electronic timecards as well as many other entry processes being performed in a Mountain Time Zone. Of course all of the processes continue to show Pacific Time: on the timecards and delivery times reported to customers. I suppose there is no easy fix for this? Shortsighted maybe, but we've been happy for 55 years in a single time zone! Does anyone have any suggestions for us? We also have drivers who cross time zones now...will clock in at one time zone and clock out in another. I'm just wondering how others might handle UniVerse / SB+ applications across zones, especially since all processes were built with only one timezone in mind. Thanks for any and all suggestions! Nancy Fisher [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] TIME
Thanks for all the help and suggestions. I believe we are going to standardize on Pacific Time... Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Gordon J Glorfield [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, April 06, 2006 11:41 AM Subject: Re: [U2] TIME Nancy, The best practice on this is to standardize on a single time zone. In your circumstance, due to your legacy systems, perhaps standardizing on PT may be the best course. However, if there are future expansions into other time zones in the works a change to GMT as a standard may work better in the long run. This applies to most entry processes. Timecards are a different issue all together due to labor laws, etc. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 04/06/2006 01:29:32 PM: Windows 2003 / UniVerse 10+ We recently expanded into a different time zone! Our server time is syncronized to pacific time (daylight savings or not). Now we have electronic timecards as well as many other entry processes being performed in a Mountain Time Zone. Of course all of the processes continue to show Pacific Time: on thetimecards and delivery times reported to customers. I suppose there is no easy fix for this? Shortsighted maybe, but we've been happy for 55 years in a single time zone! Does anyone have any suggestions for us? We also have drivers who cross time zones now...will clock in at onetime zone and clock out in another. I'm just wondering how others might handle UniVerse / SB+ applications across zones, especially since all processes were built with only one timezone in mind. Thanks for any and all suggestions! Nancy Fisher [EMAIL PROTECTED] --- 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/
[U2] Re: XML Issue
Thanks for your help. I'm not opening it with any editor. I do the HTTP Call to the URL the vendor gives me. When I look at the RESPDATA (response data) just with a CRT during the download, that's when I see the structure I'm referring to. (I have to remove the 'standalone' or remove the heading entirely in order for the xdom parser to even receive it.) I remove line feeds after the XDOM parser has done it's thing before I write to my U2 file. What was throwing me was that I suddenly had to add the extra steps of altering the heading and removing line feeds. I've downloaded so many xml docs (and I do this all directly through UniBasic using the extentions) that I got used to seeing it a certain way. Another difference I noted in the URL response header that worked w/o the extra steps is content type text/xml and on the new URL it's shown as content type text/html. I can make it work. It just worries me that I don't know exactly why I needed to blank out the header and manage line feeds.. thanks again, Nancy From: Stuart.Boydell at spotless.com.au Subject: RE: [U2] Re: XML Issue Newsgroups: gmane.comp.db.u2.general Date: 2006-02-03 00:00:14 GMT (18 hours and 57 minutes ago) Nancy, I am presuming that you are opening the document using a text editor and then saving it to an operating system file, not a U2 file?? XML is `structure' agnostic. The layout of an XML document when opened in a text editor (for example) is unaffected by the encoding of the document. What you are seeing is probably just the difference in how the line feeds are represented in your text editor. If you need to manipulate the XML before writing it, use a specific XML editor like XMLSpy. Otherwise a text editor like EditPlus can figure out your linefeeds and is also excellent for dealing with XML. If you want to view the document with `pretty' layout, open the document with a web browser (Firefox, Internet Explorer etc). Cheers, Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: XML Issue
(Windows/UniVerse) I do have an '.xsd'. I can get either encoding (ISO-8850-1 or UTF-8) to work as long as I don't use the 'standalone=yes'. However it is different than the download I get with the heading that COMES WITH 'UTF-8'. That download has a better 'structure' when it comes with UTF-8 than with ISO-8850-1... (When I change the ISO.. to the UTF it doesn't help the structure) (partial snippets only). ?xml version=1.0 encoding=UTF-8? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=555 LON-122.65788/LON LAT45.504333/LAT DATE2006-01-26 20:58:25.0/DATE SPEED0/SPEED DIRECTION1/DIRECTION NAME333/NAME ?xml version=1.0 encoding=ISO-8859-1? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=222 LON-122.70442/LON LAT45.545563/LAT DATE2006-01-26 15:34:59.0/DATE SPEED0/SPEED DIRECTION36/DIRECTION NAME1100/NAME And in the 2nd download I have to remove linefeeds before writing to the file. (p.s. Is there a convention for changing the heading? I just replace and append...) thanks for your help, Nancy From: [EMAIL PROTECTED] Subject: RE: [U2] Re: XML Issue - 'ISO-8859-1' The standalone attribute is unrelated to the encoding attribute and tells the parser that a DTD is required or not. The attribute is optional and if you aren't using a DTD, leave it out. If you don't know what a DTD is then you probably aren't using one - they're a way to validate the structure of an XML document but they're becoming less common these days and have largely been replaced by xml schemas (.xsd). Also, be aware that UniVerse without NLS uses an ISO-8859-1 based character set. For example, XML documents generated by UniVerse which included a character greater than char(128) (eg Cafi blend coffee) will be misinterpreted by most XML parsers if the encoding attribute is set to UTF-8. Try using the following header: ?xml version=1.0 encoding=iso-8859-1? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: XML Issue
When I replace 'ISO-8859-1 standalone = yes' with 'UTF-8' then I get a mostly successful download of the xml document. There is a problem with a line return in my file after parsing thru the XDOM. Is there something I can do with a map to resolve this? It downloads in a garbled way with the 'ISO-8859-1 standalone = yes' and won't parse at all Yet to look at at it with a browser it is a valid xml document. Sent: Friday, January 27, 2006 9:07 AM Subject: RE: XML Issue This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from the new URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? I tried to look up what standalone means - but didn't really get it. I wondered if it meant it wasn't using mapping? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: XML Issue
My email is currently blocking list mail for SOME reason... I just read your answer in the new feed at the website. Perhaps the standalone = yes is the issue? We are on Windows circa 2003... thanks, Nancy From: Symeon Breen symeonb at gmail.com Subject: Re: [U2] RE: XML Issue Newsgroups: gmane.comp.db.u2.general Date: 2006-01-31 11:04:23 GMT (11 hours and 58 minutes ago) I use PREPAREXML and OPENXMLDATA on Unidata and have some UTF-8 and some ISO-8859-1 encoded XML files and they all work fine. FYI ISO-8859-1 is the old standard which is now no longer developed as they have moved to UTF-8/16, but it should still work fine... Are you on NT or *nix ? On 1/27/06, Andy Pflueger andypflueger at gmail.com wrote: This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from this URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? Could the problem be the difference of the type of encoding used in the first resp header versus the second? Does your system which UniVerse is running on support ISO-8859-1 character set? Just a thought... Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: XML Issue
Maybe it is just the way you have cut and pasted but the new xml does not have the closing /VEHICLE and /VEHICLEPOSITIONS tags. Yes. It was just a cut and paste... This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from this URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? I tried to look up what standalone means - but didn't really get it. I wondered if it meant it wasn't using mapping? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML Issue
I've got a new URL to download some XML data and although the xml data is supposed to be nearly identical to what I was getting previously I am getting errorred out. This is what I get from the old URL: ?xml version=1.0 encoding=UTF-8? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=555 LON-122.65788/LON LAT45.504333/LAT DATE2006-01-26 20:58:25.0/DATE SPEED0/SPEED DIRECTION1/DIRECTION NAME333/NAME SPEEDLIMIT99/SPEEDLIMIT STREETNAMESE 8th Ave/STREETNAME STREETNUM2575/STREETNUM CITYPortland/CITY STATEOR/STATE SITENAME PORTLAND DIRECT TILE amp; MARBLE/SITENAME REASONi/REASON ODOMETER4113367/ODOMETER TRAVELTIME462849/TRAVELTIME /VEHICLE This is what I get from the new URL: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=222 LON-122.70442/LON LAT45.545563/LAT DATE2006-01-26 15:34:59.0/DATE SPEED0/SPEED DIRECTION36/DIRECTION NAME1100/NAME SPEEDLIMIT99/SPEEDLIMIT STREETNAMENW 26th Ave/STREETNAME STREETNUM3280/STREETNUM CITYPortland/CITY STATEOR/STATE SITENAMEPortland Terminal/SITENAME REASONi/REASON DRIVERSTATUSLogout/DRIVERSTATUS DRIVER555 SMITH, DAVID L./DRIVER ODOMETER7997907/ODOMETER TRAVELTIME702207/TRAVELTIME /VEHICLE VEHICLE ID=42699 LON-122.70442/LON Error with XDOMOpen(). ERR STATUS -1 I was using the same mapping - just adding for the 2 new fields of info at the new url. I notice the 'encoding' is different (but I don't know what that means). I don't know if it's a problem at the vendors website or a problem with mapping...(this is new programming on their part). When I use the URL to access it directly (not through UniVerse) I can see it as a regular XML document so everything appears to be as it should on their end. We are using the latest version of UniVerse... Thanks, Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: Problem on XMAPReadNext
Universe 10.1.11 (Windows 2003) I'm not getting any errors returned on the XMAPOpen But there is no data being read into 'record' on the XMAPReadNext: Status = XMAPReadNext(Xfile, someFILE, Record) Would that indicate a problem with the map ??? Any help is appreciated. Thanks, Nancy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Just checking!
Well since you asked, I'm having trouble with loading XML into a database: Error with XMAPOpen(). The error description and code: -- Error desc: The document named '' did not exist. Error code: 5 -- I do have a map in the XML file - I'm assuming it's saying it can't find the map. I have used the xmldom api successfully once before but it's a struggle. Thanks, Nancy - Original Message - From: Brenda Price [EMAIL PROTECTED] To: U2-Users (E-mail) u2-users@listserver.u2ug.org Sent: Monday, October 17, 2005 12:12 PM Subject: [U2] Just checking! Haven't seen anything from the list all day. Just checking to see if it is active or if are company is receiving the list today. Brenda --- 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] Good Programming Practice Question.........
RETURN with a comment..that is an excellent suggestion. Nancy - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, September 27, 2005 2:51 PM Subject: Re: [U2] Good Programming Practice Question. Another suggestion: Since the RETURN statement actually has 2 meanings, I add a comment at the end of the RETURN that concludes a called subroutine, especially if there are internal subroutines within it. RETURN ;* TO CALLING PROGRAM I'm glad we don't have POP and wince when I see RETURN TO. Mark Johnson P.S. I would also love to see an analyzer program that identifies whether OPENed files READ, WRITE, CLEAR and/or DELETE. It could be a comment at the end of the OPEN statement. Often times I FIND a BP file for CUSTOMER and WRITE but they're not necessarily attached. OPEN CUSTOMER TO F.CUSTOMER ELSE STOP ;* RWCD - Original Message - From: Keith W. Roberts [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, September 27, 2005 5:14 PM Subject: RE: [U2] Good Programming Practice Question. I most heartily agree! Numbers in the labels don't elucidate; they merely increase the length. And I'm pretty sure I know that U comes somewhere after S. :) My $0.02 (on issues ancillary to the code itself) ... - make your BP files Type19 (DIR), so you can edit them outside of U2 using whatever cotton-pickin' editor you like - use source code control; absolutely anything is better than nothing, and there are good free ones for all platforms - agree on an indentation scheme and stick to it as a group, else get/create a beautifier which enforces the chosen standards before code checkin -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill_H Sent: Tuesday, September 27, 2005 1:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Good Programming Practice Question. Kevin: Not if you alphabetize the labels; then it works just like numeric. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Tuesday, September 27, 2005 1:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Good Programming Practice Question. And here's where the conflict begins. When looking through a big program, I much prefer numeric labels in order with comments vs. alphanumeric labels. With numeric labels in order you find 1800 and if you're looking for 2000 you know to look farther down, 1000, go up. With alpha labels if you find SELECT.FILE and are looking for UPDATE.FILES, you have nothing but experience to know whether to look up or down from there. Numeric labels are good. Not ordering or commenting them is bad. And not putting comments around all labels to make them more easily distinguished from the rest of the program is near unforgiveable. -K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, September 27, 2005 12:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Good Programming Practice Question. My addition to this would be to use alphanumeric labels, and to *have* a main calling section. A main calling section that looks like: GOSUB OPEN.AND.INIT GOSUB SELECT.FILE GOSUB PRE-PROCESS.VALIDITY.CHECKS GOSUB PRINT.INVOICES GOSUB UPDATE.FILES Looks so much better and is so easier to figure out than GOSUB 100 a bunch of statements a bunch of statements a bunch of statements GOSUB 1250 a bunch of statements a bunch of statements a bunch of statements GOSUB 1375 a bunch of statements a bunch of statements a bunch of statements GOSUB 4000 a bunch of statements a bunch of statements a bunch of statements GOSUB 9755 a bunch of statements a bunch of statements a bunch of statements IMNSHO - *=aee=* --- 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/