[GNC] Are accountants happy with CVS exports?
Michael or Penny Novack
stepbystepfarm at comcast.net
Thu Jan 5 16:52:58 EST 2023
> I would expect that the .csv file could be imported in a "modern" spreadsheet
> program (Excel, localc, etc.) by the accountant. If there is a header row, the
> columns would be labeled. I expect most modern spreadsheet programs can
> re-order columns.
No offense, but this sort of thing is what I used to do for my living.
It would be absolutely no trouble at all for me to describe a file that:
1) Was a perfectly well defined .csv file
2) Could not simply be opened into a spreadsheet
3) Was representing accounting data (and could read into a program that
was expecting in this logical format.
MIchael D Novack
<< hint >> the assumption you are making is that all records of a .csv
file have to be the same (can't be type1, type2, etc. with the type
indicated by what was in the first field). And one of the sorts of
things I used to do would be to "write something" that could rewrite
such a file into a logical format that could simply be read into a
spreadsheet. Or there could be just one type of record but the fields
not be positional (ultimately .csv is positional, but can mimic
"keyword" data if every other field is the keyword and the net field the
value)
In other words, what we are asking is "are accountants happy with a .csv
file that they CAN simply read into a spreadsheet?" Not JUST that it be .csv
More information about the gnucash-user
mailing list