- This topic has 4 replies, 5 voices, and was last updated 12 years, 8 months ago by
.
-
Topic
-
Enhancement short description: In the Table configurator, it would be nice to be able to import a comma separated file as a table.
Date:
06/06/2005
Operating System:
All
Version of OS:
All
Cloverleaf Version:
5.3 and above
Revision:
Tool:
Table Configurator
Enhancement Long Description:
It would be nice to be able to ‘import’ a comma separated (.csv) or other simple text file into the tool to create (or update) a table. This would save potential typographic errors, and eliminate hand entry for larger tables. We often receive requests to create lookup tables, and get provided Excel spreadsheets or comma-separated files that we could use to load the tables. We have a tcl script that we created to do this, but it would be nice to have this feature in the toolset.
Thanks,
Jim Cobane
PHNS, Inc.
-
Replies
-
-
-
csv is ok .. but .. I prefer tab delimited .. one can save it from Excel.
I then take the file .. let’s call it tbl
perl -pi -ne ‘s/n/n#n/g’ tbl
perl -pi -ne ‘s/t/n/g’ tbl
I then cut and paste a header from another table ..
kind of manual .. but .. it’s pretty quick and easy ..
One common problem is that people will insert spaces in Excel and not know it..
Dennis
-
We use an AIX script and a tcl to convert a file with the physician code and name to a Table, then purge the caches for the process. This has worked well for us and I have changed the tcl to create other tables but it would be nice to be able to import the data when it is a one-shot process of creating a table….. If you want a copy of the script and tcl, just send me an e-mail…..
Have a Great New Year…..
😀 -
Or for CSV (without quotes) I found this worked:
perl -pi -ne ‘s/n/n#n/g’ tbl
perl -pi -ne ‘s/,/n/g’ tbl
Table ended up being to big and went with SQLite as per:
-
- The forum ‘Product Enhancements’ is closed to new topics and replies.
