Excel friendly output csvs

SWS-Methodology / faoswsProduction

Repository to contain the code for imputing production data in the statistical working system.

0 stars 1 forks source link

Excel friendly output csvs #139

Closed sebastian-c closed 8 years ago

sebastian-c commented 8 years ago

One of the issues Tomasz brought up in his email was:

Any improvements or suggestions on the output (attachments in the email) - in many cases in "measuredItemCPC" are missing "0", for example: 1371 instead of 01371 (Almonds, in shell)

Excel is just awful at opening csvs. I've attached two. One is Excel compatible, and the other isn't. It's a pretty awful hack, but it's something to consider. I understand if you file this as wontfix.

badcsv.txt goodcsv.txt

mkao006 commented 8 years ago

Had a small discusision with Tomasz and also searched online. This is an excel problem and I have not find an immediate quick solution. Will not fix it for now.

mkao006 commented 8 years ago

Tomasz found a way to correctly import the file into excel.

Great, thank you.

Then, the solution for "0" is to import txt file into Excel file choosing the correct format (Text) for item codes.

Tomasz