supportseries2000.com

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.