Desperate GnuCash user (CSV import into GnuCash)

tcare dave at gripmail.net
Tue Apr 10 15:44:16 EDT 2012


Below is a rough sketch of how to import CSV files:


>From the main menu, File->Import->Import CSV/Fixed-Width.  The way I do it,
is to have at least 3 columns in my source CSV file:

Date, Description, Amount (represented in positive or negative numbers).

On the Import Dialog screen, do the following:

- Choose your correct Date format
- Choose the correct field mapping where it says 'Select the type of each
column below' (mapping your field names to those in the GNUCash transaction
table.)  Also, map the column Amount to GNUCashs' field 'Deposit', it will
handle handle it correctly during the import.
- Click O.K.

You should be prompted which Account you want to place imported transactions
into.  Select one and click O.K. 

If any errors appear, click Cancel button (unless you are prepared to fix
them ...).

Another box should appear with your data - just click to continue and it
should import them. 

The reason you are having the errors you are reporting is because you are
not doing the "mapping" step mentioned above.

Good luck ...


--
View this message in context: http://gnucash.1415818.n4.nabble.com/RE-Desperate-GnuCash-user-CSV-import-into-GnuCash-tp4533123p4546731.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list