Re: Data typing in MV Basic
Anthony Youngman... 'A = 1' and 'A = 1' both result in IDENTICAL p-code. This is certainly how the UD compiler works. I say its a bug, because 'A=1.1' and 'A=1,1' *don't* result in the same p-code - and it doesn't just differ by the comma - one is stored as a string the other as a number. This then causes problems running with 'SET.DEC ,' (which changes the decimal separator to a comma) since the 1.1 which was meant to be a literal gets changed to 1,1, eg... VERSION=1.1 READ VERSION.INFO FROM VFP,VERSION ELSE VERSION.INFO='' The version file is keyed on strings which happen to be numbers. The version code is hard-coded into a program as a string - ie it has qoutes round it. With 'SET.DEC ,' to please some Europeans, the s/w converts VERSION to 1,1 before doing the read since it is a number not a string - and so fails to read the item. I'd want this to happen with 'VERSION=1.1' which is specifying a number. As with everything, this can be worked around, but what a pita. Simon -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Data typing in MV Basic
And seeing as I'm playing around with a p-code compiler ... It's very simple for the compiler to do it that way. All the compiler cares about is is it a string or literal?. And if it's a literal, it processes it as unquoted ascii text. So, as far as I'm concerned, as it comes from the lexer into the parser I have already lost the distinction between '1' and '1', and can't tell them apart... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Lewington Sent: 01 April 2004 09:32 To: [EMAIL PROTECTED] Subject: Re: Data typing in MV Basic Anthony Youngman... 'A = 1' and 'A = 1' both result in IDENTICAL p-code. This is certainly how the UD compiler works. I say its a bug, because 'A=1.1' and 'A=1,1' *don't* result in the same p-code - and it doesn't just differ by the comma - one is stored as a string the other as a number. This then causes problems running with 'SET.DEC ,' (which changes the decimal separator to a comma) since the 1.1 which was meant to be a literal gets changed to 1,1, eg... VERSION=1.1 READ VERSION.INFO FROM VFP,VERSION ELSE VERSION.INFO='' The version file is keyed on strings which happen to be numbers. The version code is hard-coded into a program as a string - ie it has qoutes round it. With 'SET.DEC ,' to please some Europeans, the s/w converts VERSION to 1,1 before doing the read since it is a number not a string - and so fails to read the item. I'd want this to happen with 'VERSION=1.1' which is specifying a number. As with everything, this can be worked around, but what a pita. Simon -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
IOPS Per Unidata user
Hi guys Hope everybody is well. Very simple question, does anybody have any ideas as to an average IOPS count per user in Unidata 6.0.9 running on the Sparc version of Solaris 5.9? Thanks Martin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Fora posts
In fact, knowing who wrote the message would help greatly too (as I always make a point of reading the posts from the greats...Glenn Herbert, Ray Wurlod, Leroy Dreyfuss...etc, and avoid those written by contentious souls, eg Joe...) Knowing a post comes from [EMAIL PROTECTED] really does nothing for me -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Consult about SQL
Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query. Thanks. César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Volunteer Board
Hi Ross Australia and the UK is represented on the board as well as the USA Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Thursday, 1 April 2004 10:38 AM To: U2 Users Discussion List Subject: RE: Volunteer Board That said, I think that it would be nice to have some representation from each 'major' country where U2 is used ... UK is covered, USA (obvious) ./... haven't looked for Aus, SA, NZ, NL (and sorry for 'others' I just snubbed) should 'add' to the international flavour Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, 31 March 2004 5:56 PM To: 'U2 Users Discussion List' Subject: Volunteer Board The number of after-the fact non-volunteers pointing out what we *should* have done is always staggering... I think what you've done is excellent. I think that the who comparison thang came about as a result of the imminent demise of the oliver thing... Volunteer? No problem, only I wonder if - what I know - where I live - the currency I use would be of any use to you... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 22/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 22/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Question re SB+
Hi, I would like to ask a question regarding SB+ or SystemBuilder Plus. Can I use SB+ in Windows 2000 which I am already running on SCO UNIX system. I mean that can I simply copied the SB+, SB+.DEFN and SBDEMO directories from UNIX to Windows 2000 and use it. Is there any other thing I need to do. My Windows 2000 server already running UniVerse for Windows. Hope to hear from you soon. Best regards, Shoaib. _ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Question re SB+
Shaoib, I do not believe that that object code is compatible between these platforms. You're going to have to get SB+ versions for Windows from IBM. If you're on maintenance, there may not be a charge. Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Muhammad Shoaib Patel Sent: Thursday, April 01, 2004 5:57 AM To: [EMAIL PROTECTED] Subject: Question re SB+ Hi, I would like to ask a question regarding SB+ or SystemBuilder Plus. Can I use SB+ in Windows 2000 which I am already running on SCO UNIX system. I mean that can I simply copied the SB+, SB+.DEFN and SBDEMO directories from UNIX to Windows 2000 and use it. Is there any other thing I need to do. My Windows 2000 server already running UniVerse for Windows. Hope to hear from you soon. Best regards, Shoaib. _ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
XML or WORD Format???
Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
I believe WIN.PCRUN requires 2 parameters. Please provide the other. Thanks. You could provide your desired browser in the first parameter and the URL in the second. Just because a small fraction doesn't use IEXPLORE doesn't mean that 99.9 percent don't either. Everyone can figure this out for themselves. - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 4:46 AM Subject: RE: How to launch remote browser from UniVerse server? Except that it assumes that IE is the default browser. And at home, where my firewall is configured to BLOCK IE, it would probably get you nowhere. I'm not sure of the syntax, but something like CALL WIN.PCRUN(URL) should fire up the url in the default browser. There were reports on u2-users a couple of weeks back that this sort of thing (executing a document) does work fine. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 April 2004 04:53 To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? If running Wintegrate this databasic command works: CALL WIN.PCRUN(IEXPLORE.EXE, URL) where URL could be any web address. I use it often to retrieve shipping from UPS.com or hooking map sites to dispatching screens. my 1 cent. can't help you on topic 2 unless you post the report as HTML to a PC file and have the URL be the file reference. In fact, here's a sub to hook to any cust maint. 001 SUBROUTINE MAP01(ADDR, ZIP) 002 *** 003 * TO INSTANTIATE THE BROWSER FOR INTERNET FOR THIS URL 004 * MAJ 121002 005 *** 006 CONVERT TO + IN ADDR 007 CONVERT TO + IN ZIP 008 PROG=C:\Program Files\Internet Explorer\IEXPLORE.EXE 009 URL=http://maps.yahoo.com/py/maps.py?BFCat=Pyt=TmapnewFL=Use+Address +Belowaddr=:ADDR:csz=:ZIP:Country=usGet%A0Map=Get+Map 010 CALL WIN.PCRUN(PROG, URL) 011 RETURN 012 END I see that you are in AU so adjust the URL in this example for the appropriate country. I just go to the yahoo map page with an address and cut/paste that url into MV and fixup. Happy April 1. It's still yesterday here. - Original Message - From: LeRoi Keiller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:39 PM Subject: How to launch remote browser from UniVerse server? Hi I have a client (customer) who wishes to launch users' desktop browsers from a UniVerse server. 1/ How can this be done (actual instructions, if possible) So far, UniObjects has been mentioned and DDE - but, any other ideas. Or, what are the instructions to actually do this? 2/ Once the above is possible, how could a UniVerse report be displayed in the user's browser, for example? Thanks, LeRoi ___ LeRoi Keiller Client Support - Technical UltraData - Vision to Reality Ph +61 3 9291 1700 www.ultradata.com.au Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to launch remote browser from UniVerse server?
If WIN.PCRUN requires 2 parameters, then I guess the second parameter should be null. And which way of doing things is best? To throw up the url in the USER's choice of browser, or the PROGRAMMER's choice of browser? I'm afraid I come from the old school - give the user what they want, if it's easily done. I get well pissed off when my computer starts displaying things using the wrong app. And I don't see why I should impose such disfunctional behaviour on my users. (Plus it's a neat thing to know that windows will execute a document using its default app - it may be that IE is the default app for .html in 99% of cases, but what's the default for .jpg? - how do you know the app you're about to ask for even exists on the client?) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 April 2004 14:38 To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? I believe WIN.PCRUN requires 2 parameters. Please provide the other. Thanks. You could provide your desired browser in the first parameter and the URL in the second. Just because a small fraction doesn't use IEXPLORE doesn't mean that 99.9 percent don't either. Everyone can figure this out for themselves. - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 4:46 AM Subject: RE: How to launch remote browser from UniVerse server? Except that it assumes that IE is the default browser. And at home, where my firewall is configured to BLOCK IE, it would probably get you nowhere. I'm not sure of the syntax, but something like CALL WIN.PCRUN(URL) should fire up the url in the default browser. There were reports on u2-users a couple of weeks back that this sort of thing (executing a document) does work fine. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 April 2004 04:53 To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? If running Wintegrate this databasic command works: CALL WIN.PCRUN(IEXPLORE.EXE, URL) where URL could be any web address. I use it often to retrieve shipping from UPS.com or hooking map sites to dispatching screens. my 1 cent. can't help you on topic 2 unless you post the report as HTML to a PC file and have the URL be the file reference. In fact, here's a sub to hook to any cust maint. 001 SUBROUTINE MAP01(ADDR, ZIP) 002 *** 003 * TO INSTANTIATE THE BROWSER FOR INTERNET FOR THIS URL 004 * MAJ 121002 005 *** 006 CONVERT TO + IN ADDR 007 CONVERT TO + IN ZIP 008 PROG=C:\Program Files\Internet Explorer\IEXPLORE.EXE 009 URL=http://maps.yahoo.com/py/maps.py?BFCat=Pyt=TmapnewFL=Use+Address +Belowaddr=:ADDR:csz=:ZIP:Country=usGet%A0Map=Get+Map 010 CALL WIN.PCRUN(PROG, URL) 011 RETURN 012 END I see that you are in AU so adjust the URL in this example for the appropriate country. I just go to the yahoo map page with an address and cut/paste that url into MV and fixup. Happy April 1. It's still yesterday here. - Original Message - From: LeRoi Keiller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:39 PM Subject: How to launch remote browser from UniVerse server? Hi I have a client (customer) who wishes to launch users' desktop browsers from a UniVerse server. 1/ How can this be done (actual instructions, if possible) So far, UniObjects has been mentioned and DDE - but, any other ideas. Or, what are the instructions to actually do this? 2/ Once the above is possible, how could a UniVerse report be displayed in the user's browser, for example? Thanks, LeRoi ___ LeRoi Keiller Client Support - Technical UltraData - Vision to Reality Ph +61 3 9291 1700 www.ultradata.com.au Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify
RE: XML or WORD Format???
Are you running LMS from TMC?? If so, then I have a solution that will do what your after. I use a couple of perl scripts and a Word macro to allow our billing staff to get a text version of the invoice in Word, mark it up and then re-print it back to the HP-UX machine. The reprint process takes the print file and turns it into a PDF that is then stored for future reference via a web based lookup page. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 04/01/04 08:48AM Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
Unfortunately, the invoices themselves have the graphics embedded. However, I can capture just the text without loosing the structure. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:54 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? Ah ... This looks good. Are your invoices prettied up in any way, or are they just courier on preprinted paper? If the latter, any nix programmer worth his salt ought to be able to faff about with awk, sed or similar to strip out escape sequences, make sure the right characters are used for line feeds and page throws, and convert pcl to txt. Get a pcl manual, use Midnight Commander to view the pcl in binary mode, and get playing :-) If the invoices are pretty-pretty word-processed type stuff, it gets harder ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:49 To: U2 Users Discussion List Subject: RE: XML or WORD Format??? Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify
RE: XML or WORD Format???
Don, We are using LMS from TMC. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? Are you running LMS from TMC?? If so, then I have a solution that will do what your after. I use a couple of perl scripts and a Word macro to allow our billing staff to get a text version of the invoice in Word, mark it up and then re-print it back to the HP-UX machine. The reprint process takes the print file and turns it into a PDF that is then stored for future reference via a web based lookup page. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 04/01/04 08:48AM Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED]
RE: XML or WORD Format???
LMS only knows raw, plain text. That's all it's putting out. Have a look at /usr/spool/uv/drv. There's probably a couple of fancy scripts in there that are installing the image for you. If not, give me a holler offline and I can point you to the subroutine that puts out the invoice. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 04/01/04 09:02AM Don, We are using LMS from TMC. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? Are you running LMS from TMC?? If so, then I have a solution that will do what your after. I use a couple of perl scripts and a Word macro to allow our billing staff to get a text version of the invoice in Word, mark it up and then re-print it back to the HP-UX machine. The reprint process takes the print file and turns it into a PDF that is then stored for future reference via a web based lookup page. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 04/01/04 08:48AM Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or
RE: How to launch remote browser from UniVerse server?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It depends on what you use for a terminal emulator. For Accuterm you need to place something like the following in a Basic program to open IE: PRINT CHAR(27):CHAR(2)::iexplore:CHAR(13): There are numerous ways to get reports to display in the browser. One easy way to start testing is to set up a file that can be accessible by both U2 and mapped to the user's PC. For example create a U2 file called TEMP that is pointing to a location that can be mapped to by the user PC. Map that location to the S:\temp directory. Write your U2 report to the TEMP file with a record name of FILE.NAME. Then un the command: PRINT CHAR(27):CHAR(2)::iexplore S:\temp\:FILE.NAME:CHAR(13): This will load IE with the written data. Once your comfortable with this, you can explore tools like txt2html, txt2pdf, and the U2 print spooler. With these tools you can have a print queue automagically translate a print job into html or pdf and write them out to a file directory. mike - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of LeRoi Keiller Sent: Wednesday, March 31, 2004 10:40 PM To: [EMAIL PROTECTED] Subject: How to launch remote browser from UniVerse server? Hi I have a client (customer) who wishes to launch users' desktop browsers from a UniVerse server. 1/ How can this be done (actual instructions, if possible) So far, UniObjects has been mentioned and DDE - but, any other ideas. Or, what are the instructions to actually do this? 2/ Once the above is possible, how could a UniVerse report be displayed in the user's browser, for example? Thanks, LeRoi ___ LeRoi Keiller Client Support - Technical UltraData - Vision to Reality Ph +61 3 9291 1700 www.ultradata.com.au Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. - -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -BEGIN PGP SIGNATURE- Version: PGP 8.0 iQA/AwUBQGwkcLAst3KQK8kYEQKDogCg0bzg1ozWLQNeh2dYnXbY2fm6kUEAoOFm QDZOX7Cy0/cJqFR+ACkGAPla =oYUN -END PGP SIGNATURE- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
Don, Although we have LMS, it has been extremely customized over the years. The line draws are part of the print program using a different character set. So you are correct that the output is just text. The graphics I am referring to are the lines and the company logo that is also just a different font. We are currently writing the text to a download file and can open it in WORD. It looses the different sized fonts that are used and we do not have any way of importing back to LMS. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:08 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? LMS only knows raw, plain text. That's all it's putting out. Have a look at /usr/spool/uv/drv. There's probably a couple of fancy scripts in there that are installing the image for you. If not, give me a holler offline and I can point you to the subroutine that puts out the invoice. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 04/01/04 09:02AM Don, We are using LMS from TMC. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? Are you running LMS from TMC?? If so, then I have a solution that will do what your after. I use a couple of perl scripts and a Word macro to allow our billing staff to get a text version of the invoice in Word, mark it up and then re-print it back to the HP-UX machine. The reprint process takes the print file and turns it into a PDF that is then stored for future reference via a web based lookup page. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 04/01/04 08:48AM Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582
RE: [OT] America Has First Flight (?)
And also don't forget that we have total freedom of speech and there is no propaganda in the media like other countries. Freedom comes at a price, and the more money you have the freer you are. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Wednesday, March 31, 2004 4:25 PM To: 'U2 Users Discussion List' Subject: RE: [OT] America Has First Flight (?) A Greek or an Egyptian I think - it was a slipstick. Not sure whether it handled multivalues... Jayjay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cliff Bennett Sent: 27 March 2004 01:32 To: U2 Users Discussion List Subject: [OT] America Has First Flight (?) satire But, but ... I was taught since grade school that all important discoveries and inventions were made by (mostly) Americans in (always) America. Could it be otherwise? This understanding of our accomplishments and yes, even destiny, has underpinned our unparalleled prominence on the World Stage. This revelation that a red-white-and-blue American was not actually the first to fly is shocking. Perhaps we were second or third with railroads and automobiles also? Whoo-ee, I feel like Neo in the Matrix, removing the blinders that hid the vast incubation farms where people lived in ignorance. I guess I can handle sharing the credit for human knowledge and developments with other countries. Just don't ask me/us to share authority decisions or participate in ecological improvements. /satire OK, back to our regularly scheduled U2 topics. Say ... didn't an American invent the first computer and compiler and database and ... Happy Friday! -Cliff - Original Message - From: John Jenkins [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, March 26, 2004 3:49 PM Subject: RE: [OT] Airplane flights and stuff was Re: Optimisation ? : A Welshman flew a 'plane in the reign of the emperor Tiberius - you can see : the evidence yourself - there's a coin with a primitive 'plane on it and the : date on the coin says (in Roman numerals naturally) TIBERIVS IMPERATOR and : on the obverse LXVI B.C. : : Regards : : JayJAy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] America Has First Flight (?)
no propaganda in the media.WOW what an understatement. our media has more propaganda than I'd like. How many times have the news only reported one side of a story? or left out a lot of important facts? - That's propaganda. However, at least we have access to multiple views of propagranda thus allowing us to draw small truths from each, and hopefully building the actual events from these. Now...the propaganda isn't propaganda in regards to government controlled, but it is fueled by money. George -Original Message- From: Lettau, Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:38 AM To: U2 Users Discussion List Subject: RE: [OT] America Has First Flight (?) And also don't forget that we have total freedom of speech and there is no propaganda in the media like other countries. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: dhl shipping software integration
no right now Fedex is not our primary non-postal shipper. Depending on who we get our best deal from. In the past when we used DHL, we would just type in the info. They DHL are supposed to let us know our options for connection, but so far, have not had any meetings with the tech. Just checking what others are doing. George -Original Message- From: Phil Grant [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:44 PM To: [EMAIL PROTECTED] Subject: Re: dhl shipping software integration Hi George, I have also written interfaces into UPS using similar methods. I not sure what methods are available in DHL. I designed an interface in the past that wrote to a third party shipping system called Clippership using VB Objects to communicate in real-time with a UniData database. Let me know if I can be if further assistance Cheers Phil Grant Tel.:510.781.5132 Fax: 510.781.5139 Mobile.: 707-761-3707 George Gallen wrote: Currently We integrate with our UPS Worldship software by FTPing our shipping info over to the UPS machine, then an ODBC is setup to link the ftp file to it's own use. Snip Does anyone know if DHL's software can handle the same thing? or what methods you use to interface with DHL shipping software. Any not too pricy ($1000) 3rd party solutions ok as well. We are on UV on Unix, and the DHL machine is on the network. Thanks George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] America Has First Flight (?)
Can we turn off this road now, before this thread explodes into another endless geopolitical debate. I think we have had enough of those within this venue. Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, April 01, 2004 9:47 AM To: U2 Users Discussion List Subject: RE: [OT] America Has First Flight (?) no propaganda in the media.WOW what an understatement. our media has more propaganda than I'd like. How many times have the news only reported one side of a story? or left out a lot of important facts? - That's propaganda. However, at least we have access to multiple views of propagranda thus allowing us to draw small truths from each, and hopefully building the actual events from these. Now...the propaganda isn't propaganda in regards to government controlled, but it is fueled by money. George -Original Message- From: Lettau, Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:38 AM To: U2 Users Discussion List Subject: RE: [OT] America Has First Flight (?) And also don't forget that we have total freedom of speech and there is no propaganda in the media like other countries. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Volunteer Board
ye vote shall determine the makeup during the board elections Don Verhagen Tandem Staffing Solutions, Inc. Obviously American [EMAIL PROTECTED] 7:37:32 PM 03/31/2004 That said, I think that it would be nice to have some representation from each 'major' country where U2 is used ... UK is covered, USA (obvious) ./... haven't looked for Aus, SA, NZ, NL (and sorry for 'others' I just snubbed) should 'add' to the international flavour Ross Ferris Stamina Software Visage * an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, 31 March 2004 5:56 PM To: 'U2 Users Discussion List' Subject: Volunteer Board The number of after-the fact non-volunteers pointing out what we *should* have done is always staggering... I think what you've done is excellent. I think that the who comparison thang came about as a result of the imminent demise of the oliver thing... Volunteer? No problem, only I wonder if - what I know - where I live - the currency I use would be of any use to you... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 22/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 22/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: DATA statement Clearing?
Not sure about UniVerse, but UniData has a CLEARDATA verb. Rather than stuffing the data buffer with all this stuff, wouldn't it be just as easy to open the file from within a program and read/process it? Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Karl L Pearson Sent: Thursday, April 01, 2004 8:41 AM To: u2-users Subject: DATA statement Clearing? I have a program that takes a printed replenishment order (sent via smoke and mirrors to a text file on our uniVerse server from remote sites), parses through it and passes DATA to an Order Entry program (4580 lines long). I'm curious if there's a way to clear those data statements up as part of clean-up in case of an error in the data structure at the remote site. I.E, there are 3 lines of text for each ordered product. On the first line, is pricing, so I do a findstr for a $-sign, which allows me to know I'm on the first of 3 lines for one item. With some of our clients, the inventory item is on the first line and with others it's on the 2nd or 3rd line. My code knows the difference by client number and process correctly, however on some clients, the inventory item number isn't where it's supposed to be, causing the order entry program to go into cardiac arrest. My cleanup then has to undo the locking mechanism (prevents more than one process at a time), plus release locks, etc. I need to be able to clear the data statements because they are currently being passed to the menuing system, which causes the operator to wonder what's going on and hope nothing bad just happened. INPUTCLEAR and CLEARSELECT don't work (I thought inputclear would...). Help? -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Consult about SQL
You might try creating indexes or using the EXPLAIN clause to see if they are being used. --- Cesar Riba [EMAIL PROTECTED] escribió: Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query. Thanks. César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: DATA statement Clearing?
The theory is that our database (old version of ACCESS) will get on the client systems and clean up the data, thus making the different uses of this step unnecessary. Good old data consistency would be nice. Karl On Thu, 2004-04-01 at 10:50, Eugene Perry wrote: One thing you could do would be to pass the data a little more information. For example, you could pass it something like inventory#=xx etc. This way, your program could know which line it is on no matter which client. Eugene - Original Message - From: Karl L Pearson [EMAIL PROTECTED] To: u2-users [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:40 AM Subject: DATA statement Clearing? I have a program that takes a printed replenishment order (sent via smoke and mirrors to a text file on our uniVerse server from remote sites), parses through it and passes DATA to an Order Entry program (4580 lines long). I'm curious if there's a way to clear those data statements up as part of clean-up in case of an error in the data structure at the remote site. I.E, there are 3 lines of text for each ordered product. On the first line, is pricing, so I do a findstr for a $-sign, which allows me to know I'm on the first of 3 lines for one item. With some of our clients, the inventory item is on the first line and with others it's on the 2nd or 3rd line. My code knows the difference by client number and process correctly, however on some clients, the inventory item number isn't where it's supposed to be, causing the order entry program to go into cardiac arrest. My cleanup then has to undo the locking mechanism (prevents more than one process at a time), plus release locks, etc. I need to be able to clear the data statements because they are currently being passed to the menuing system, which causes the operator to wonder what's going on and hope nothing bad just happened. INPUTCLEAR and CLEARSELECT don't work (I thought inputclear would...). Help? -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniOLEDB setup
Other consultants who have previously been accessing my Unidata 5.1.3/HP/UX 11.0 data using ODBC are now trying to do it using OLEDB. Everything appears to be set up correctly - that is the UCI Config file (without making any changes from the ODBC setup, I presume). They are using a database name found in the ud_databases file (again, just as in ODBC). The connection string (live data x'd out) appears below, along with the resulting error message that is invariably returned. Any suggestions would be greatly appreciated. Thanks, Kebbon Irwin HP9000connString = Provider=IBM.UniOLEDB; _ Data source=xxx; _ Location=xxx; _ User ID=xxx; _ Password=xxx Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [IBM][SQL Client]UCI connections to non UniVerse databases is not allowed -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniOLEDB setup
Try removing the Provider element, Its either VB6 or VB.Net that doesn't like it from our experience. Cheers Nick -Original Message- From: Kebbon [mailto:[EMAIL PROTECTED] Sent: 01 April 2004 20:05 To: Info-Ardent List Subject: UniOLEDB setup Other consultants who have previously been accessing my Unidata 5.1.3/HP/UX 11.0 data using ODBC are now trying to do it using OLEDB. Everything appears to be set up correctly - that is the UCI Config file (without making any changes from the ODBC setup, I presume). They are using a database name found in the ud_databases file (again, just as in ODBC). The connection string (live data x'd out) appears below, along with the resulting error message that is invariably returned. Any suggestions would be greatly appreciated. Thanks, Kebbon Irwin HP9000connString = Provider=IBM.UniOLEDB; _ Data source=xxx; _ Location=xxx; _ User ID=xxx; _ Password=xxx Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [IBM][SQL Client]UCI connections to non UniVerse databases is not allowed -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
It seems the problem here is that you're going from pure data to StructureX, then you want to go from StructureX to StructureY. Going direct to StructureX is a fine first-off approach, but since your needs are now expanding I'd suggest that you need to rethink your approach. You need to go directly from data to Y rather than data to X to Y. Further, if the business rules are extracted from the UI, you can choose any UI X or Y that you want without recoding the app. It sounds to me like you should have your app generate XML documents for invoices, and then someone can custom code from XML to PDF, XML to PCL, XML to Word, XML to Excel, etc. Yes, there is some pain involved in this process, but you're digging yourself a deep hole by trying to go directly from PDF to something else. I do have tools to allow you to do this without PS, PCL or other funky escape codes, and a happy client as a reference. I offer the tools and methodology as part of a service, rather than offering the tools on their own. E-mail [EMAIL PROTECTED] if interested. Good luck in any case, Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: Thursday, April 01, 2004 5:49 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** * This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** * -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the
RE: Running total
Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
TOXML question
I am currently using '...TOXML ELEMENTS' and wonder if there is a way to suppress the .../... tags when there is no data in a multi-valued field. If this is possible, will it also remove the '...ASSOC-MV/...ASSOC-MV tags that surround the empty multi-valued fields? Thanks. Regards, Jim -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: XML or WORD Format???
John, The goal is to have a copy of our invoice that can be opened in WORD or Excel. try generating RTF or generate XML in Word 2003 format. Craig -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Running total
Pick flavor possibility. In your VOC. create item named CNTR 1=A 2=9998 9=R 10=8 (or whatever you think your maximum would be. SORT CUST CNTR CUST.NAME By putting it in your VOC, it's available for all files. Roger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Garth Joubert Sent: Thursday, April 01, 2004 5:19 PM To: U2 Users Discussion List Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PDF Manual [Data typing in MV Basic]
cOOL. Saves having to manually delete nasty unwanted plugins from the plugins folder ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Colquhoun If you use the above don't forget to install Acrobat reader speedup from: http://www.tnk-bootblock.co.uk/prods/misc/index.php ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
Alternatively, if you had a Win2K Pro or better machine on the network, you could consider our WordLynx product to produce your invoices natively into Word format (the WordLynx server component runs as a service on NT style platforms, so the machine can be used for other tasks - and green screens can also initiate production of Word documents. You can download an eval manuals from www.stamina.com.au - just follow the WordLynx links. The beauty of WordLynx is that an end user can change the format of an invoice/statement/etc, include graphics, change fonts etc by simply using Word - and there are no backend program changes. If you add Adobe Distiller to the WordLynx Server, then you can also produce .PDFs Good luck Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Colquhoun Sent: Friday, 2 April 2004 10:48 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? Hello, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. I might be completely wrong here as i have never used the product but someone recently told me Open Office can read in pdf files which you can edit and then save as ms-word documents. If you are really lucky there might be a version available that runs natively on HP-UX. - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 22/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 22/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PDF Manual [Data typing in MV Basic]
... except that on first inspection it stops the indexes from working. I normally just move the following plugins out of the plugins directory and Reader goes much faster... Accessibility.api AcroForm.api AcroSign.prc DigSig.api eBook.api MakeAccessible.api -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stuart Boydell Sent: Friday, 2 April 2004 11:03 To: U2 Users Discussion List Subject: RE: PDF Manual [Data typing in MV Basic] cOOL. Saves having to manually delete nasty unwanted plugins from the plugins folder ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Colquhoun If you use the above don't forget to install Acrobat reader speedup from: http://www.tnk-bootblock.co.uk/prods/misc/index.php ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman In one word - it's IMPOSSIBLE. The beta version of the Save As XML plug-in, a free download for Acrobat 5.0 (http://www.adobe.com/support/downloads/89a2.htm for Windows and http://www.adobe.com/support/downloads/89a6.htm for Macintosh), allows users to export text from a tagged Adobe PDF file to the eXtensible Markup Language (XML), accessible HTML, or TXT formats. The resulting documents can be re-purposed with a variety of applications, including word processors and screen reader software. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
(no subject)
Greetings one and all, I am trying to put together a demo application using UniObject for Java. I would like to be able to create a statement that selects names that start with SMI. In Unibasic I would use the following statement: SELECT UBFMSTR WITH LAST.NAME = SMI] The Java statement I used is: uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = SMI]) and uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = 'SMI]') and uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = \SMI]\) all to no avail. The first two get syntax errors and the last one seems to run be it returns nothing. There are over 300 records that start with SMI. Any help would be sincerely appreciated. TIA, Steve Mayo Software Engineer -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Running total
Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
At 10:47 AM 2/04/2004, Robert Colquhoun wrote: Hello, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. I might be completely wrong here as i have never used the product but someone recently told me Open Office can read in pdf files which you can edit and then save as ms-word documents. If you are really lucky there might be a version available that runs natively on HP-UX. Oops! wrong about being able to edit pdfs, feature list for open office 1.1 here: http://www.openoffice.org/dev_docs/features/1.1/index.html Can save as ms-word, xml or export to pdf though. - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PDF Manual [Data typing in MV Basic]
At 11:28 AM 2/04/2004, Stuart Boydell wrote: oops - hit send too soon... ... except that on first inspection the Speed Up stops the (UV docs) indexes from working. This may be an index version thing but I normally just move the following plugins out of the plugins directory and Reader goes much faster... Did you try selecting the 'search5' plugin in the speed up utility menu, maybe uv docs use that. - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Running total
Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unclassified RE: (no subject)
Steve, Is the U2 database UD or UV? This might be a 'flavour' issue, if it's UD try substituting sELECT for SELECT. if it's UV try WITH LAST NAME LIKE SMI... or WITH LAST NAME LIKE \SMI...\ HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Mayo Sent: Friday, 2 April 2004 05:52 To: [EMAIL PROTECTED] Subject: (no subject) Greetings one and all, I am trying to put together a demo application using UniObject for Java. I would like to be able to create a statement that selects names that start with SMI. In Unibasic I would use the following statement: SELECT UBFMSTR WITH LAST.NAME = SMI] The Java statement I used is: uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = SMI]) and uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = 'SMI]') and uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = \SMI]\) all to no avail. The first two get syntax errors and the last one seems to run be it returns nothing. There are over 300 records that start with SMI. Any help would be sincerely appreciated. TIA, Steve Mayo Software Engineer -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Running total
On Thu, 1 Apr 2004 17:08:02 -0500, you wrote: Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White In Universe, add a DICT item with the following fields: 0 LINE.NBR 1 I 2 @1 + 1 3 MD0 4 5 6R Then LIST CUST LINE.NBR CUST.NAME -- Allen Egerton [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Running total
Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:52 AM Subject: RE: Running total Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Running total
Stewart try this, works for me in universe information flavour and on R83 1 D 2 15 3 MV name 7 A;NV 9R 105 from ye olde pick pocket guide version IV NV returns the number of the mulit-value being processed hows life at fauldings ? jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:02 PM Subject: RE: Running total Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:52 AM Subject: RE: Running total Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Running total
Stewart, tried that and all i get is the entry of 1 beside each multivalue instead of incrementing mv numbers. I am wondering if this is a information flavour thing. Tried it in HS.SALES and its the same problem The EVAL works though but its still the pick solution jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:04 PM Subject: RE: Running total Hi John, Faulding is good, we are owned by Mayne now. Just as per Ken's example here is the UV equvilant Top. : 0001: I 0002: mvfield.name;@NV 0003: MD0 0004: Count 0005: 3R 0006: M 0007: : I could not get it to work without using good old pick conversions for EVAL. EVAL @RECORDmvfld.no CONV A;NV EVAL OCONV('','F;mvfld.no;NV') Regards, Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 13:32 To: U2 Users Discussion List Subject: Re: Running total Stewart try this, works for me in universe information flavour and on R83 1 D 2 15 3 MV name 7 A;NV 9R 105 from ye olde pick pocket guide version IV NV returns the number of the mulit-value being processed hows life at fauldings ? jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:02 PM Subject: RE: Running total Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:52 AM Subject: RE: Running total Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Running total
Stewart, thanks, i agree with the D version but do not get the I type to work as you suggest can you confirm LIST CUSTOMER SMM.CNT SMM.ICNT displays the same data? I would really like the itype work so i can reuse a static field to get an incrementing date against each mv jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:34 PM Subject: RE: Running total John, I got the same result as you in HS.SALES However, this worked in HS.SALES against the customer file field 11 is the product id field. CT DICT CUSTOMER SMM.CNT SMM.DCNT 0001 D 0002 11 0003 A;NV 0004 Count 0005 3R 0006 M SMM.ICNT 0001 I 0002 OCONV(PRODID,'A;NV') 0003 MD0 0004 Count 0005 3R 0006 M it is still using pick conversion but they are valid conversions in D I type dictionaries. Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 14:19 To: U2 Users Discussion List Subject: Re: Running total Stewart, tried that and all i get is the entry of 1 beside each multivalue instead of incrementing mv numbers. I am wondering if this is a information flavour thing. Tried it in HS.SALES and its the same problem The EVAL works though but its still the pick solution jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:04 PM Subject: RE: Running total Hi John, Faulding is good, we are owned by Mayne now. Just as per Ken's example here is the UV equvilant Top. : 0001: I 0002: mvfield.name;@NV 0003: MD0 0004: Count 0005: 3R 0006: M 0007: : I could not get it to work without using good old pick conversions for EVAL. EVAL @RECORDmvfld.no CONV A;NV EVAL OCONV('','F;mvfld.no;NV') Regards, Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 13:32 To: U2 Users Discussion List Subject: Re: Running total Stewart try this, works for me in universe information flavour and on R83 1 D 2 15 3 MV name 7 A;NV 9R 105 from ye olde pick pocket guide version IV NV returns the number of the mulit-value being processed hows life at fauldings ? jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:02 PM Subject: RE: Running total Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:52 AM Subject: RE: Running total Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list
RE: Running total
John, Try this for your itype SMM.CNT 0001 I 0002 @RECORD11 0003 A;NV 0004 Count 0005 3R 0006 M Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 15:14 To: U2 Users Discussion List Subject: Re: Running total Stewart, thanks, i agree with the D version but do not get the I type to work as you suggest can you confirm LIST CUSTOMER SMM.CNT SMM.ICNT displays the same data? I would really like the itype work so i can reuse a static field to get an incrementing date against each mv jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:34 PM Subject: RE: Running total John, I got the same result as you in HS.SALES However, this worked in HS.SALES against the customer file field 11 is the product id field. CT DICT CUSTOMER SMM.CNT SMM.DCNT 0001 D 0002 11 0003 A;NV 0004 Count 0005 3R 0006 M SMM.ICNT 0001 I 0002 OCONV(PRODID,'A;NV') 0003 MD0 0004 Count 0005 3R 0006 M it is still using pick conversion but they are valid conversions in D I type dictionaries. Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 14:19 To: U2 Users Discussion List Subject: Re: Running total Stewart, tried that and all i get is the entry of 1 beside each multivalue instead of incrementing mv numbers. I am wondering if this is a information flavour thing. Tried it in HS.SALES and its the same problem The EVAL works though but its still the pick solution jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:04 PM Subject: RE: Running total Hi John, Faulding is good, we are owned by Mayne now. Just as per Ken's example here is the UV equvilant Top. : 0001: I 0002: mvfield.name;@NV 0003: MD0 0004: Count 0005: 3R 0006: M 0007: : I could not get it to work without using good old pick conversions for EVAL. EVAL @RECORDmvfld.no CONV A;NV EVAL OCONV('','F;mvfld.no;NV') Regards, Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 13:32 To: U2 Users Discussion List Subject: Re: Running total Stewart try this, works for me in universe information flavour and on R83 1 D 2 15 3 MV name 7 A;NV 9R 105 from ye olde pick pocket guide version IV NV returns the number of the mulit-value being processed hows life at fauldings ? jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:02 PM Subject: RE: Running total Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:52 AM Subject: RE: Running total Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID Running
Re: Running total
Stewart, that will do nicely I can go home now jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 3:19 PM Subject: RE: Running total John, Try this for your itype SMM.CNT 0001 I 0002 @RECORD11 0003 A;NV 0004 Count 0005 3R 0006 M Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 15:14 To: U2 Users Discussion List Subject: Re: Running total Stewart, thanks, i agree with the D version but do not get the I type to work as you suggest can you confirm LIST CUSTOMER SMM.CNT SMM.ICNT displays the same data? I would really like the itype work so i can reuse a static field to get an incrementing date against each mv jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:34 PM Subject: RE: Running total John, I got the same result as you in HS.SALES However, this worked in HS.SALES against the customer file field 11 is the product id field. CT DICT CUSTOMER SMM.CNT SMM.DCNT 0001 D 0002 11 0003 A;NV 0004 Count 0005 3R 0006 M SMM.ICNT 0001 I 0002 OCONV(PRODID,'A;NV') 0003 MD0 0004 Count 0005 3R 0006 M it is still using pick conversion but they are valid conversions in D I type dictionaries. Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 14:19 To: U2 Users Discussion List Subject: Re: Running total Stewart, tried that and all i get is the entry of 1 beside each multivalue instead of incrementing mv numbers. I am wondering if this is a information flavour thing. Tried it in HS.SALES and its the same problem The EVAL works though but its still the pick solution jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:04 PM Subject: RE: Running total Hi John, Faulding is good, we are owned by Mayne now. Just as per Ken's example here is the UV equvilant Top. : 0001: I 0002: mvfield.name;@NV 0003: MD0 0004: Count 0005: 3R 0006: M 0007: : I could not get it to work without using good old pick conversions for EVAL. EVAL @RECORDmvfld.no CONV A;NV EVAL OCONV('','F;mvfld.no;NV') Regards, Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 13:32 To: U2 Users Discussion List Subject: Re: Running total Stewart try this, works for me in universe information flavour and on R83 1 D 2 15 3 MV name 7 A;NV 9R 105 from ye olde pick pocket guide version IV NV returns the number of the mulit-value being processed hows life at fauldings ? jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:02 PM Subject: RE: Running total Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:52 AM Subject: RE: Running total Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck.