[GNC] Example of importing Stock transactions from CSV

[Michael or Penny Novack]

On 8/19/2022 10:33 PM, Jon Schewe wrote:
> So I didn't get the CSV import tool to work.

Perhaps a reminder on what CSV is and is not.

CSV stands for "common separated variables. That means the data is in 
the form of a record consisting of a number of fields delineated by 
commas. Which means two important things. The fields (individual data 
elements) cannot contain commas but even more important, ORDER MATTERS.

In other words, the record A,B,C,D is not the same a B,A,C,D << A, B, C, 
and D being elements of data, names, amounts, etc. >>

The CSV data you are importing must not only be in CSV format but the 
data must be in the right order AND any data that is null (not present 
still has its space in the record.

Thus if a record was supposed to include A, C, and D  (B is not relevant 
to this record) it would look like A,,C,D and not A,C,D


But even the "wrong" examples are in CSV format.


Michael