CSV ramblings

[Stratford, Darren]

We have had to work with tab delimited tables from excel to load charge
tables into our main patient database.
It used to take ages to do manually, this way we are able use excel for
formulas and basically just export to tab delim tables and upload data.
I use a command line language DCL under open vms system, converts using
the tab spacing to set widths and create a subfile at the sum of all the
widest fields. Each fields is made character and widest of all fields
for that field.
Is run through the entire file, finding the widest width for each fields
and then re runs and packs out each field to the widest.
Then once in subfile format you just then need to play with the file to
ensure the data is valid, being in character is easy to play with.

But something in powerhouse that allows importing csv or tab delim would
be great even if just loads to character filled fields for later
formatting would be grand help.

Darren.

-----Original Message-----
From: powerh-l-bounces+dstratford=cabrini.com.au at lists.sowder.com
[mailto:powerh-l-bounces+dstratford=cabrini.com.au at lists.sowder.com] On
Behalf Of Bill Casey
Sent: 03 Sep 2007 09:11
To: Bob.Deskin at cognos.com
Cc: powerh-l at lists.sowder.com
Subject: CSV ramblings

Bob
Powerhouse users often provide data from Excel either as an .xls file or
(occasionally) in CSV format.  Converting it to CSV is of course no
chore.  However, loading the data into Powerhouse tables is an awkward
and time-consuming process, so a PH tool to streamline it would be most
welcome. 


Bill Casey
Programmer/Analyst
Corporate Information Services
University of Ballarat
03 5327 9786
b.casey at ballarat.edu.au



--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
--
Message  protected by MailGuard: e-mail anti-virus, anti-spam and
content filtering.
http://www.mailguard.com.au/mg

Click here to report this message as spam:
https://login.mailguard.com.au/report/1tlpVdq9Uo/4n2XqsW8WP2apyno9Fq7B8/
0