[GNC] confusion on new fields in csv import
Michael or Penny Novack
stepbystepfarm at comcast.net
Sun Feb 9 11:34:29 EST 2025
On 2/9/2025 5:11 AM, David Cousens wrote:
> David
>
> I think the main issue is there is no well defined protocol/standard
> for CSV data and the importer does not know where the CSV file
> originates and whether the data is presented from the perspective of
> the entity which provided the data or that of the entity which has
> received the data which makes the use of the terms Debit/Credit and or
> Deposit/Withdrawal ambiguous.
>
> If these terms were used in the internal headers assigned to the
> columns of data there would be circumstances in which the header Debit
> had to be applied to a column which the source of the file labelled as
> Credit a common occurrence with data from Banks for example.
THIS issue is one of the factors we all should be taking into account
when making the decision whether to use the "user friendly" column
labels or "formal labels" (just "debit" or "credit"). If using the
latter, the only remaining issue is "from whose point of view". If using
the former, we have that issue PLUS no reason to suppose the "user
friendly" labels will match and that's account type by account type.
So IF expecting to be doing lots of importing/exporting another reason
to choose to use "formal"
Michael D Novack
Michael D Novack
More information about the gnucash-user
mailing list