RE: [U2] CSVs' (Different Question)
Thank you, I have been trying to find an answer to this problem for days myself, as we are about to do some major data extraction to excel. What a valuable list. Regards, J Garratt > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno > Sent: Tuesday, 17 January 2006 11:38 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] CSVs' (Different Question) > > > Mark Johnson wrote: > > Where do I quote these? > > "A","B","C","12345","000123" > > The info I posted about single quotes in my last post wasn't helpful in > this context. Let me try this way: > > A,"B","12,34",Hi "World" > Excel doesn't need quotes unless you're doing something special, which > explains why the A and B values are exactly the same. The "12,34" is > special because it embeds a comma. Quotes are also needed when spaces are > embedded, although sometimes leading or trailing spaces may also get > removed. The \Hi "World"\ example is interpreted as alpha in the first > place, so any quotes embedded in that value are considered part o the text > string. > > 000123,="000123" > The number with leading zeros is recognized it as numeric, so 000123 > becomes 123 in the sheet. The ="000123" value tells Excel that this is a > formula (preceded by equal sign). The formula returns a string which is > not reinterpreted as above. > > "12/10/05" > This date, even in quotes, is interpreted because there is not a forumula > telling Excel to do otherwise, and will get converted to display > "12/10/2005". The value itself will be converted to an internal numeric > much like the internal Pick date. > > "=""12/10/05""" , ="12/10/05" > These two values show equivalent formulas for expressing the date as a > string, not a date to be converted as above. This just goes to show that > sometime you need to "escape" a quote by preceding it with another quote. > > > There are no formal standards which govern how CSV files work. There are > generally accepted conventions, but of course these aren't all followed by > Excel. Using the guidelines above you can experiment with > certain kinds of > data to see how it behaves. > > And none of this is related to U2. There are thousands of websites with > this sort of information available. > > T > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Tony, Cripes! I can't even copy and paste properly At 19:37 16/01/06 -0800, you wrote: Bruce, you mean this 2 month old RFC?: ftp://ftp.isi.edu/in-notes/rfc4180.txt Yes, that is indeed what I meant. So sorry, folks Mitigation: I was also talking to a publican at the time... T -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CSVs' (Different Question)
Thank you Tony for a great expose on CSV. Well stated, especially this part: "There are no formal standards which govern how CSV files work. There are generally accepted conventions, but of course these aren't all followed by Excel. Using the guidelines above you can experiment with certain kinds of data to see how it behaves." Kudos man. Thanks again. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CSVs' (Different Question)
Mark Johnson wrote: > Where do I quote these? > "A","B","C","12345","000123" The info I posted about single quotes in my last post wasn't helpful in this context. Let me try this way: A,"B","12,34",Hi "World" Excel doesn't need quotes unless you're doing something special, which explains why the A and B values are exactly the same. The "12,34" is special because it embeds a comma. Quotes are also needed when spaces are embedded, although sometimes leading or trailing spaces may also get removed. The \Hi "World"\ example is interpreted as alpha in the first place, so any quotes embedded in that value are considered part o the text string. 000123,="000123" The number with leading zeros is recognized it as numeric, so 000123 becomes 123 in the sheet. The ="000123" value tells Excel that this is a formula (preceded by equal sign). The formula returns a string which is not reinterpreted as above. "12/10/05" This date, even in quotes, is interpreted because there is not a forumula telling Excel to do otherwise, and will get converted to display "12/10/2005". The value itself will be converted to an internal numeric much like the internal Pick date. "=""12/10/05""" , ="12/10/05" These two values show equivalent formulas for expressing the date as a string, not a date to be converted as above. This just goes to show that sometime you need to "escape" a quote by preceding it with another quote. There are no formal standards which govern how CSV files work. There are generally accepted conventions, but of course these aren't all followed by Excel. Using the guidelines above you can experiment with certain kinds of data to see how it behaves. And none of this is related to U2. There are thousands of websites with this sort of information available. T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Bruce, you mean this 2 month old RFC?: ftp://ftp.isi.edu/in-notes/rfc4180.txt Technically speaking, there are no standards. From that very document: Due to lack of a single specification, there are considerable differences among implementations. Implementors should "be conservative in what you do, be liberal in what you accept from others"... That said, I did speak too soon. The convention I referred to is for use within Excel and doesn't work for CSV. I have a bit more helpful related info in response to Mark's inquiry. My best, T Bruce Nichol wrote: > Goo'day, > > At 16:28 16/01/06 -0800, you wrote: > >> The convention for specifying alpha data vs numeric data >> is actually to precede the data with a single quote, not >> to surround it with double quotes. As far as tab >> delimited data that includes tabs, since this isn't >> supported in cells anyway it's not a problem. >> >> Tony Gravagno, Nebula R&D >> TG@ removethisNebula-RnD.com > > Perhaps a quiet look at ftp://ftp.isi.edu/in-notes.txt > wil help you in determining .csv "standards" > > Thankyou, Martin (private joke...) ... very apt and > pertinent... today... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Goo'day, At 16:28 16/01/06 -0800, you wrote: The convention for specifying alpha data vs numeric data is actually to precede the data with a single quote, not to surround it with double quotes. As far as tab delimited data that includes tabs, since this isn't supported in cells anyway it's not a problem. Tony Gravagno, Nebula R&D TG@ removethisNebula-RnD.com Perhaps a quiet look at ftp://ftp.isi.edu/in-notes.txt wil help you in determining .csv "standards" Thankyou, Martin (private joke...) ... very apt and pertinent... today... Michael Doyle wrote: > The convention, as I understand it, for handling embedded > commas in of csv data is to wrap each datum in double > quotes. This cheerfully introduces the problem of > embedded double quotes... > > TAB-delimited files do avoid this situation, but bank on > your not having tabs in your data. I am not aware of any > conventional method for dealing with tab-embedded > tab-delimited data. ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Freeing up AIX disk space
Sirulnick, Steve wrote on 01/16/2006 07:33:45 PM: > I keep deleting files from AIX, but when I run a df -k, the amount of free > space seems to be decreasing as opposed to increasing. Is there anything I > can do to free up more disk space? If somebody has a file open when you delete it, the directory entry will be removed but the space will not be reclaimed until after the file is closed. The process(es) will continue to read and even update the original contents in the original location. That is consistent with what you're seeing. Unfortunately, you'll have to wait until everybody who opened the now-deleted file has closed it. If the system isn't too busy, you may be able to track something down with filemon, but that's a real shot in the dark, since the only reference available will be by device and i-node, and you probably don't know what those were and there's no way to find out anymore. Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] CSVs' (Different Question)
Where do I quote these? I have MV basic programs that create csv's, ie "A","B","C","12345","000123" already. Thanks. - Original Message - From: "Kevin King" <[EMAIL PROTECTED]> To: Sent: Monday, January 16, 2006 10:08 AM Subject: RE: [U2] CSVs' (Different Question) > To get Excel to keep the leading zeroes when importing a CSV, quote > the value, aka: > > ="012345" > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Freeing up AIX disk space
I keep deleting files from AIX, but when I run a df -k, the amount of free space seems to be decreasing as opposed to increasing. Is there anything I can do to free up more disk space? This is a production server, so I can't really take it off line until a scheduled downtime. Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
The convention for specifying alpha data vs numeric data is actually to precede the data with a single quote, not to surround it with double quotes. As far as tab delimited data that includes tabs, since this isn't supported in cells anyway it's not a problem. Tony Gravagno, Nebula R&D TG@ removethisNebula-RnD.com Michael Doyle wrote: > The convention, as I understand it, for handling embedded > commas in of csv data is to wrap each datum in double > quotes. This cheerfully introduces the problem of > embedded double quotes... > > TAB-delimited files do avoid this situation, but bank on > your not having tabs in your data. I am not aware of any > conventional method for dealing with tab-embedded > tab-delimited data. ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML Extraction
Try this instead: http://www.informix.com/U2-xml";> ... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Monday, January 16, 2006 2:29 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] XML Extraction I am on UniData 6.1 (AIX) and I have an XML doc that I would like to extract data from and it looks like this: 12345 EX-50 12/14/2004 ESS123456 Approved ESS1234 90.50 Credit Card ESS1345 --- My .EXT file looks like this: (so far) http://www.ibm.com/U2-xml";> - I can run: PREPARE.XML "_XML_/FROM_ESS" junk_xml and it runs ok. I can also run: RELEASE.XML junk_xml and it runs ok. - But when I run: list XMLDATA junk_xml "_XML_/TEST.EXT" ESS.ID I get: Open XML data file failed. XMLParser error message: U2XMAP/U2XML_extraction: Illegal U2XMAP file, missing t he . Open file error. Any help would be GREATLY appreciated Thanks in advance Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Redux
The driver is from the Udt6 clients download (from about a year ago). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Horwitz Sent: Monday, January 16, 2006 1:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC Redux What Client CD did you get your ODBC driver from? IBM UniData driver 3.01.05.7073 from the UniData Client 6b CD is okay. Steven Horwitz Pelican Professional Services (626) 675-8459 www.pelicansvcs.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, January 16, 2006 10:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC Redux Pursuant to my ODBC issues of last week, I installed regmon on one of the machines with the problem and wouldn't you know it: The current version of the ODBC driver installed the registry entries at HKLM\IBM and yet the driver was looking for HKLM\Informix! I personally think this is a bug - any other opinions? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date: 1/14/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
The convention, as I understand it, for handling embedded commas in of csv data is to wrap each datum in double quotes. This cheerfully introduces the problem of embedded double quotes in of csv data, of course, and the conventional solution is to substitute two adjacent double quotes for each double quote. Very easy to generate, but it makes writing csv parsing routines deplorable. Your parser has to have 1-character of read-ahead to distinguish an embedded double quote from the end of the cell. TAB-delimited files do avoid this situation, but bank on your not having tabs in your data. I am not aware of any conventional method for dealing with tab-embedded tab-delimited data. Almost makes XML seem like a good idea. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:01 -0800, Kent Walker wrote: > George, > > Mike is right - a Perl script can make the conversion easy and highly > automated. However, I like to use TAB-delimited output to avoid the > occasional messy situation when valid data contains commas or > quotes. Write the program or paragraph such that it generates a text > file and then shells to the Perl program to do the conversion. > > ActiveState's Perl for Windows does have the > "Spreadsheet::WriteExcel" and "Text::CSV" modules available. > > Let me know if you want some samples to hack. > > Kent > > At 01:02 PM 1/13/2006, Michael Doyle wrote: > > >On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and > >Text::CSV modules. My csv2xls.pl script is only about 47 lines long. > > > >The Spreadsheet::WriteExcel module was utter garbage a few years ago, > >but thanks to the efforts of OpenOffice.org and the obvious benefits of > >open source software, the module has improved by leaps and bounds. > > > >On Windows, I can only presume that Visual Basic can generate Excel > >spreadsheets. > > > >Mike Doyle > >Unix Developer / Administrator > >AMO Recoveries > > > > > >On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote: > > > Our UV system creates an ASCII .csv file for another > > > system to import on a daily basis. The 3rd party software > > > after a recent upgrade now only imports .xls files. > > > > > > Is there an easy way to "automate" Excel to load the .csv, > > > then save as .xls? > > > > > > Or how much more difficult is it to create the .xls instead of > > >a .csv? > > > > > > I thought about getting one of those programs that records > > > mouse clicks, and create a macro of the conversion (since the > > > filename is the same each day), but wonder if there was > > > something we could do in a batch file and run every day under > > > the Windows scheduler. > > > > > > George > > > > > > George Gallen > > > Senior Programmer/Analyst > > > Accounting/Data Division > > > [EMAIL PROTECTED] > > > ph:856.848.1000 Ext 220 > > > > > > SLACK Incorporated - Delivering the best in health care information and > > > education worldwide. > > > http://www.slackinc.com > > > --- > > --- > Kent Walker - Datatel Analyst > Information Technology - U.C. Hastings College of the Law > 415-565-4635 > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML Extraction
I am on UniData 6.1 (AIX) and I have an XML doc that I would like to extract data from and it looks like this: 12345 EX-50 12/14/2004 ESS123456 Approved ESS1234 90.50 Credit Card ESS1345 --- My .EXT file looks like this: (so far) http://www.ibm.com/U2-xml";> - I can run: PREPARE.XML "_XML_/FROM_ESS" junk_xml and it runs ok. I can also run: RELEASE.XML junk_xml and it runs ok. - But when I run: list XMLDATA junk_xml "_XML_/TEST.EXT" ESS.ID I get: Open XML data file failed. XMLParser error message: U2XMAP/U2XML_extraction: Illegal U2XMAP file, missing t he . Open file error. Any help would be GREATLY appreciated Thanks in advance Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ODBC Redux
- Original Message - From: "Jerry Banker" <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC Redux Date: Mon, 16 Jan 2006 13:41:32 -0600 > > Sounds like it to me. > > - Original Message - From: "Kevin King" <[EMAIL PROTECTED]> > To: > Sent: Monday, January 16, 2006 12:27 PM > Subject: [U2] ODBC Redux > > > > Pursuant to my ODBC issues of last week, I installed regmon on one of > > the machines with the problem and wouldn't you know it: The current > > version of the ODBC driver installed the registry entries at HKLM\IBM > > and yet the driver was looking for HKLM\Informix! I personally think > > this is a bug - any other opinions? > > > > -Kevin > > [EMAIL PROTECTED] > > http://www.PrecisOnline.com > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ODBC Redux
Get some time up! My Registry also has HKLM\VMARK (for HyperSTAR) and HKLM\Ardent. I'll clean it out one day! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Redux
What Client CD did you get your ODBC driver from? IBM UniData driver 3.01.05.7073 from the UniData Client 6b CD is okay. Steven Horwitz Pelican Professional Services (626) 675-8459 www.pelicansvcs.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, January 16, 2006 10:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC Redux Pursuant to my ODBC issues of last week, I installed regmon on one of the machines with the problem and wouldn't you know it: The current version of the ODBC driver installed the registry entries at HKLM\IBM and yet the driver was looking for HKLM\Informix! I personally think this is a bug - any other opinions? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ODBC Redux
Sounds like it to me. - Original Message - From: "Kevin King" <[EMAIL PROTECTED]> To: Sent: Monday, January 16, 2006 12:27 PM Subject: [U2] ODBC Redux Pursuant to my ODBC issues of last week, I installed regmon on one of the machines with the problem and wouldn't you know it: The current version of the ODBC driver installed the registry entries at HKLM\IBM and yet the driver was looking for HKLM\Informix! I personally think this is a bug - any other opinions? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC Redux
Pursuant to my ODBC issues of last week, I installed regmon on one of the machines with the problem and wouldn't you know it: The current version of the ODBC driver installed the registry entries at HKLM\IBM and yet the driver was looking for HKLM\Informix! I personally think this is a bug - any other opinions? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML with UO7.1
I'm working on a project using C# with UO.net with UniData 7.1 on Win2003 Server. I'm using the uniXML class to retrieve an XML document from which includes both single-value and multi-value columns. I then convert the XML to a dataset. I'm ending up with two tables in my data set. The first table holds the single-value fields, the second table all the multi-value fields. The name of the second table is always AssociationName-MV. Example MyFile: <1> myAttribute1 someAtt <2> myAttribute2 someValue1]someValue2 <3> myAttribute3 someValue1]someValue2 With a query like 'list MyFile myAttribute1 myAttribute2 myAttribute3 ID.SUPP TOXML Assumming myAttribute2 and myAttribute3 are in an association named myAssoc I currently get the following I would like to get an XML document something like: So far I've been able to use the default XML created by UniData without having to setup any mapping files. I'm hoping there is a way to accomplish this without using the mapping files. Is there a way to create a UniQuery statement that will flatten out the results before the XML document is created? Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Active select list in BASIC
From: "David Wolverton" <[EMAIL PROTECTED]> To: Sent: Monday, January 16, 2006 10:58 AM Subject: RE: [U2] [UD] Active select list in BASIC > Select lists are always unique in your workspace, aren't they? -- t\That is, > even if 5 users are accessing a select list named BPLIST (which is set =2), > they will not conflict with each other any more than any other select list > would... So getting a unique name should not be necessary -- why do you > think that it would be? (You're scaring me!) Select Lists *are* unique in your workspace. I think Marilyn was actually referring to SAVEDLISTS, which as file system objects are available to whoever is accessing the directory they're stored in. -- Allen Egerton --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
Ah. I understand. I am not accustomed to running select lists in a program. Excuse the interruption. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, January 16, 2006 10:21 AM To: u2-users@listserver.u2ug.org Subject:RE: [U2] [UD] Active select list in BASIC In this case, "BPLIST" is a variable name--we aren't saving the list to &SAVEDLISTS& so there's no conflict. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Hilb > Sent: Monday, January 16, 2006 10:27 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Active select list in BASIC > > > Just an added note. It there is any possibility that multiple > users could be running this at the same time.. You may want > to make sure "BPLIST" is unique, I use port# to assure it is > Unique and user ID to identify it. > > ~Marilyn > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Bill Haskett > Sent: Friday, January 13, 2006 9:30 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Active select list in BASIC > > David & Ed: > > Thank you. The "SELECT TO BPLIST" (I couldn't get the SELECT > TO 1 then the READNEXT FROM 1 to compile) works fine as long > as I assign BPLIST a value before using it (another quirk > with UniData). :-) > > I wish the "quirky things that don't work like PICK" would be > listed somewhere. It'd sure save me a lot of time. :-) > > Thanks again, > > Bill > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
Ah -- this thread was not about saved lists... No wonder I was confused!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, January 16, 2006 10:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Active select list in BASIC -Original Message- >From: David Wolverton >Select lists are always unique in your workspace, aren't they? Active lists, yes. Saved lists, no. Saved lists are no different than any other record in a file somewhere. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] Universe on RedHat (which version to use ?)
I've loaded and run UV and UVpe on: RH7.2, 7.3 , RH8 , RH9 FC1, FC2, FC3 and FC4. Now I didn't do intensive testing just a basic load, and ran some test programs. George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Jacques G. > Sent: Monday, January 16, 2006 11:21 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] RE: [UV] Universe on RedHat (which version to use ?) > > > I've downloaded the evaluation version of Universe for > RedHat Linux. It seems to be destined for RedHat > version 7.1. Does this mean that it will not work > with more recent versions such as 8.0 or 9.0 ? > > If it will work, I'd rather have a newer RedHat than > an older version. > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
-Original Message- >From: David Wolverton >Select lists are always unique in your workspace, aren't they? Active lists, yes. Saved lists, no. Saved lists are no different than any other record in a file somewhere. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CSVs' (Different Question)
You can do an HTML document but save it with the .XLS extension and EXCEL will open it by default. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, January 15, 2006 7:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] CSVs' (Different Question) Subject: Exporting leading zero fields in csv. I have been exporting from MV to CSV for years and one of my pet peeves is that leading zero fields, like customer numbers, product codes and zip codes lose their leading zeros when the csv is opened in Excel. I will save everyone the trouble with prior suggestions by illustrating what hasn't worked yet. I've tried exporting as simple HTML but null cells don't get the proper frames. I've tried prepending a single quote but the single quote appears as data in Excel. I've also tried pre/append a single space but it still loses the leading zeros. I've noticed that when manually entering a value in Excel with a leading single quote, it retains the leading zeros. But when the CSV cell is "'07748" it keeps '07748. I know that the user can re-format the cell to be zip code or custom but that gives the impression that the main system can only do part of the job. I also know that if the user is in Excel, they can import the TXT file and follow the import wizard to change the column's style to TEXT and not GENERAL. Again, this puts the burden on the users. HTML retains the value and the missing frames on null cells is okay but the users are used to clicking on the filename in Windows Explorer and HTML 'opens with' Internet Explorer. Great for viewing but not useful if they desire any data manipulation in excel. I am not versed in java or perl but if they can accomplish the job then maybe I'll learn them. I don't mind having the difficult part be on my side (MV) as long as the users get their simplicity. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
You hadn't specified that you were setting bplist to = "2", I likely just missed that in the conversation. Yes.. using a select list number is unique to that session.. using a list name (I often use my initials to save temporary lists that I am working with) is not unique in my experiences. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, January 16, 2006 9:59 AM To: u2-users@listserver.u2ug.org Subject:RE: [U2] [UD] Active select list in BASIC Select lists are always unique in your workspace, aren't they? -- t\That is, even if 5 users are accessing a select list named BPLIST (which is set =2), they will not conflict with each other any more than any other select list would... So getting a unique name should not be necessary -- why do you think that it would be? (You're scaring me!) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Hilb Sent: Monday, January 16, 2006 9:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Active select list in BASIC Just an added note. It there is any possibility that multiple users could be running this at the same time.. You may want to make sure "BPLIST" is unique, I use port# to assure it is Unique and user ID to identify it. ~Marilyn -Original Message- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
In this case, "BPLIST" is a variable name--we aren't saving the list to &SAVEDLISTS& so there's no conflict. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Hilb > Sent: Monday, January 16, 2006 10:27 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Active select list in BASIC > > > Just an added note. It there is any possibility that multiple > users could be running this at the same time.. You may want > to make sure "BPLIST" is unique, I use port# to assure it is > Unique and user ID to identify it. > > ~Marilyn > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Bill Haskett > Sent: Friday, January 13, 2006 9:30 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Active select list in BASIC > > David & Ed: > > Thank you. The "SELECT TO BPLIST" (I couldn't get the SELECT > TO 1 then the READNEXT FROM 1 to compile) works fine as long > as I assign BPLIST a value before using it (another quirk > with UniData). :-) > > I wish the "quirky things that don't work like PICK" would be > listed somewhere. It'd sure save me a lot of time. :-) > > Thanks again, > > Bill > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [UV] Universe on RedHat (which version to use ?)
I've downloaded the evaluation version of Universe for RedHat Linux. It seems to be destined for RedHat version 7.1. Does this mean that it will not work with more recent versions such as 8.0 or 9.0 ? If it will work, I'd rather have a newer RedHat than an older version. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
Select lists are always unique in your workspace, aren't they? -- t\That is, even if 5 users are accessing a select list named BPLIST (which is set =2), they will not conflict with each other any more than any other select list would... So getting a unique name should not be necessary -- why do you think that it would be? (You're scaring me!) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Hilb Sent: Monday, January 16, 2006 9:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Active select list in BASIC Just an added note. It there is any possibility that multiple users could be running this at the same time.. You may want to make sure "BPLIST" is unique, I use port# to assure it is Unique and user ID to identify it. ~Marilyn -Original Message- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CSVs' (Different Question)
Try making it an html file and write it out with a .xls file extension. Excel will be quite happy to open it -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Sunday, January 15, 2006 7:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] CSVs' (Different Question) Subject: Exporting leading zero fields in csv. I have been exporting from MV to CSV for years and one of my pet peeves is that leading zero fields, like customer numbers, product codes and zip codes lose their leading zeros when the csv is opened in Excel. I will save everyone the trouble with prior suggestions by illustrating what hasn't worked yet. I've tried exporting as simple HTML but null cells don't get the proper frames. I've tried prepending a single quote but the single quote appears as data in Excel. I've also tried pre/append a single space but it still loses the leading zeros. I've noticed that when manually entering a value in Excel with a leading single quote, it retains the leading zeros. But when the CSV cell is "'07748" it keeps '07748. I know that the user can re-format the cell to be zip code or custom but that gives the impression that the main system can only do part of the job. I also know that if the user is in Excel, they can import the TXT file and follow the import wizard to change the column's style to TEXT and not GENERAL. Again, this puts the burden on the users. HTML retains the value and the missing frames on null cells is okay but the users are used to clicking on the filename in Windows Explorer and HTML 'opens with' Internet Explorer. Great for viewing but not useful if they desire any data manipulation in excel. I am not versed in java or perl but if they can accomplish the job then maybe I'll learn them. I don't mind having the difficult part be on my side (MV) as long as the users get their simplicity. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date: 1/14/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date: 1/14/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
I recently looked into auto formatting text files ready for EXCEL, e.g., take a CSV file and change it to xls and at the same time format the columns widths etc. I know it can be done other ways, xml etc, but this way we could convert all out current reports without changing any code. There where a few utilities that could do this, they also convert from CSV to xls by simply calling the utility and specifying the name. Here is just one example, not the one I tested. http://www.softinterface.com/Convert-XLS/Convert-XLS.htm If you look for other software it must be able to do the business from the command prompt so it can be automated into you code. Create the report, issue the command and there you go, one xl file ready to use. Re andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 13 January 2006 20:46 To: u2-users@listserver.u2ug.org Subject: [U2] making a .csv file into an .xls file? Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to "automate" Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
Just an added note. It there is any possibility that multiple users could be running this at the same time.. You may want to make sure "BPLIST" is unique, I use port# to assure it is Unique and user ID to identify it. ~Marilyn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, January 13, 2006 9:30 PM To: u2-users@listserver.u2ug.org Subject:RE: [U2] [UD] Active select list in BASIC David & Ed: Thank you. The "SELECT TO BPLIST" (I couldn't get the SELECT TO 1 then the READNEXT FROM 1 to compile) works fine as long as I assign BPLIST a value before using it (another quirk with UniData). :-) I wish the "quirky things that don't work like PICK" would be listed somewhere. It'd sure save me a lot of time. :-) Thanks again, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CSVs' (Different Question)
To get Excel to keep the leading zeroes when importing a CSV, quote the value, aka: ="012345" --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CSVs' (Different Question)
Try this, LINE=LOCAL LINE<2>="=":QUOTE(REP.ID) CONVERT @AM TO ',' IN LINE Subject: Exporting leading zero fields in csv. I have been exporting from MV to CSV for years and one of my pet peeves is that leading zero fields, like customer numbers, product codes and zip codes lose their leading zeros when the csv is opened in Excel. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] CSVs' (Different Question)
Subject: Exporting leading zero fields in csv. I have been exporting from MV to CSV for years and one of my pet peeves is that leading zero fields, like customer numbers, product codes and zip codes lose their leading zeros when the csv is opened in Excel. I will save everyone the trouble with prior suggestions by illustrating what hasn't worked yet. I've tried exporting as simple HTML but null cells don't get the proper frames. I've tried prepending a single quote but the single quote appears as data in Excel. I've also tried pre/append a single space but it still loses the leading zeros. I've noticed that when manually entering a value in Excel with a leading single quote, it retains the leading zeros. But when the CSV cell is "'07748" it keeps '07748. I know that the user can re-format the cell to be zip code or custom but that gives the impression that the main system can only do part of the job. I also know that if the user is in Excel, they can import the TXT file and follow the import wizard to change the column's style to TEXT and not GENERAL. Again, this puts the burden on the users. HTML retains the value and the missing frames on null cells is okay but the users are used to clicking on the filename in Windows Explorer and HTML 'opens with' Internet Explorer. Great for viewing but not useful if they desire any data manipulation in excel. I am not versed in java or perl but if they can accomplish the job then maybe I'll learn them. I don't mind having the difficult part be on my side (MV) as long as the users get their simplicity. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Excel isn't the problem, it's the other program, which won't open XML either. Thanks for suggestion, might be able to use that on future project (especially imbedding the formulas). George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik > Sent: Friday, January 13, 2006 5:31 PM > To: 'u2-users@listserver.u2ug.org' > Subject: RE: [U2] making a .csv file into an .xls file? > > > >Is there an easy way to "automate" Excel to load the .csv, > > then save as .xls? > > Or, your universe program can output an XML file which you > then name to have > an .xls extension. Excel will open that natively. > > In Excel, you can do a FILE | SAVE AS as an XML file to see > what Excel is > looking for in an XML format. With XML you can do all kinds > of Excel things > like embedding formulas, specifying fonts, colors, multi-rows > within single > cells, freezing rows/columns, etc. > > Barry > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Dave S > Sent: Friday, January 13, 2006 4:56 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] making a .csv file into an .xls file? > > > > Our UV system creates an ASCII .csv file for another > > system to import on a daily basis. The 3rd party software > > after a recent upgrade now only imports .xls files. > > How particular is the 3rd party software? Excel is happy to > load a csv > file that has had it's extension changed from .csv to .xls. > Would that > work for your needs? It's VERY particular. > > > Is there an easy way to "automate" Excel to load the .csv, > > then save as .xls? > > Yes you can. Create a macro in an Excel spreadsheet that does the > conversion. Have the Workbook_Open subroutine run the macro. Set the > windows scheduler to open the spreadsheet at the desired time > and viola! not sure if I can do this with a macro, as the file is not created on the windows machine, but rather on the unix side. As well, there is the possiblity that for security reasons, some of the PC's used to load this file, may possibly have macros disabled. And to start have very non-savvy people to override that feature could be very dangerous to our network. > George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Michael Doyle > Sent: Friday, January 13, 2006 4:03 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] making a .csv file into an .xls file? > > > On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and > Text::CSV modules. My csv2xls.pl script is only about 47 lines long. I'll have to look into this...I don't mind a PERL routine the unix side to create the .xls from a UV file. > > The Spreadsheet::WriteExcel module was utter garbage a few years ago, > but thanks to the efforts of OpenOffice.org and the obvious > benefits of > open source software, the module has improved by leaps and bounds. > > George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
see comments within > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Gordon J > Glorfield > Sent: Friday, January 13, 2006 3:59 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] making a .csv file into an .xls file? > > > Gordon J. Glorfield > Sr. Applications Developer > MAMSI (A UnitedHealth Company) > 301-360-8839 > > [EMAIL PROTECTED] wrote on 01/13/2006 02:45:46 PM: > > > Our UV system creates an ASCII .csv file for another > > system to import on a daily basis. The 3rd party software > > after a recent upgrade now only imports .xls files. > > How particular is the 3rd party software? Excel is happy to > load a csv > file that has had it's extension changed from .csv to .xls. > Would that > work for your needs? I tried changing the extension, and the program bombed out, it is specifically looking for an .xls format, otherwise it fails... :( > > > Is there an easy way to "automate" Excel to load the .csv, > > then save as .xls > > Yes you can. Create a macro in an Excel spreadsheet that does the > conversion. Have the Workbook_Open subroutine run the macro. > Set the > windows scheduler to open the spreadsheet at the desired time > and viola! Problem is I would need UV to create the spreadsheet with the macro.. > > > George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
accuterm would not a viable option for this project. Not that it wouldn't work, but, for this project is not a good choice for a solution. Thanks for the idea however, George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Scott > Ballinger > Sent: Friday, January 13, 2006 3:43 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] making a .csv file into an .xls file? > > > I think Accuterm can create a legit .xls file on a windows client with > the FT utility. This is easily scripted from the UV side. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniVerse Internals course (UK)
It's that time again I keep publicising this because the course keeps being cancelled due to lack of participants. So, the next UK delivery of the UniVerse Internals course is scheduled for w/s 6 February at IBM's training centre in Staines. Contact IBM's training department if you're interested. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Data download in XLS in different worksheets
Hi, I would like to know how we download data from UniVerse file into an XLS in separate worksheet with 5 lines of data in each worksheet Thanks in Advance, Regards, Hari Varma CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/