Export/Import transactions

[nvsoar]

On 9/4/2014 6:24 PM, Andy Lavarre wrote:
>
> Easy when you know how, but I don't know how.
>
> I followed the instructions but it doesn't work for me: Can someone 
> help with links?
>
> I'm exporting a file following what I understand to be the rules and 
> then trying to import the same information into the same account but 
> it fails.
>
> Details below. Thanks in advance, Andy
>
> ====================
> OK, this is reproducible:
>
> * Start GnuCash on an earlier file.
>
> * Export the Account tree as xxx_tree.csv
>
> * Create or open a new clean template file.
>
> * Import the previous account tree, and clean out the errors. This 
> leaves you with a new
>
> template account file that is virginal.
>
>     A blank template file but with operative account tree. Save it as 
> such, e.g.,
>
>      140904_virginal.gnucash
>
> * Create a dummy transaction in, say, Assets:Cash:USD to transfer $100 
> to Assets:Cash:GBP
>
> Save the lot.
>
> * Now export that transaction to 140904_transactions_USD.csv
>
>     File exported correct!!
>
> I have chosen comma delimitations,  but also tried semi-colon 
> delimitation, quotations, etc. You can examine the output and be sure 
> that it is correct, which it is.
>
> Now try reimporting the same transaction into the same account you 
> used to export.
>
> It doesn't work:
>
> Choose the date format (d-m-y). Actually, it is DD-MM-YYYY but that is 
> not an option.
>
> Click on the row that shows your format: Date, Account, etc. It shows 
> you the contents of the file.
>
> And it fails:
>
>     "There are problems with the import settings
>     The date format could be wrong or there are not enough columns 
> set..."
>
> I  go back and try to format each column but the choices for field 
> type do not include the many
>
> types that GnuCash itself has defined so there is no way to 
> appropriately assign the column type
>
> manually.
>
> So it's not working.
>
> TIA, Andy
> alavarre at gmail.com
FWIW - Years ago I tried to use an unambiguous date format (ddmmmyyyy) 
in GnuCash.  Didn't work for beans.  Went back to default format - works 
well.  Thus the question becomes - do you get the same result using the 
default date format throughout your test?
nvsoar