IETC 'UT' csv spreadsheet import
Tuesday 23 August 2011 at 07:30 am.
Mon, 04/20/2009 - 10:20 — admin
4/1/2009 - import spreadsheet to IETC batch.
number one, phil had to convert the excel column to literal numbers from formulas. Then he exported it to var-tmp. However the file name was unwieldy and he renamed it to xxxx.csv, this looked good but when we looked at var-tmp, the name was xxxx.csv.csv.
So I issued the following bash command in var-tmp, mv xxxx.csv.csv xxxx.csv.
Then we went to IETC, 'UT', option 3, now was able to open Will2009.csv, select a , delimiter, tell it that the cost is in field two, and away we go.
