FrontAccounting forum — Import Transaction issue

Re: Import Transaction issue

2015-04-02T16:22:36Z

@rossaddison, @joe: wherever csv files are used in FA, we need to take care of line endings making it OS agnostic. Just replace all CRLF with LF and start to work.

Re: Import Transaction issue

2015-04-02T13:54:21Z

CR/LF did it for me. I am using a Mac and the lines in the file were terminated by CR.
Import works after I changed the line terminations.
Both Windows termination, CR/LF or Unix termination, LF worked for me.
Thanks for your help.
Ion

Re: Import Transaction issue

2015-04-02T03:42:25Z

Working example:

reference,date,memo,amount,accountcode,taxtype,dim1_ref,dim2_ref,person_type_id (supplier=1 customer=2),person_id
JNL1,01/12/2014,Bad debts using account 8100,222.24,8100,0,D1,D2,,
JNL1,01/12/2014,Debtors Control using account 1100,-222.24,1100,0,D1,D2,2,2
JNL2,02/12/2014,Rent outstanding,122.25,7100,1,D1,D2,,
JNL2,02/12/2014,Accruals,-122.25,2109,0,D1,D2,,
JNL3,03/12/2014,Prepayments,322.26,1103,0,D1,D2,,
JNL3,03/12/2014,Rent Prepaid,-322.26,7100,1,D1,D2,,
JNL4,04/12/2014,Prepayments,400,1103,0,D1,D2,,
JNL4,04/12/2014,Prepayments,400,1103,0,D1,D2,,
JNL4,04/12/2014,Rent Prepaid,-800,7100,1,D1,D2,,

Do not use double quotes (or any quotes) in the file and use commas as the separateor - do not use it in the description / content of any of the fields. Make sure that the CR/LF is proper and does not occur within a field.

Import Transaction issue

2015-04-02T01:04:03Z

I am trying to import journal entries in FA with no luck.
I have installed the module, activated successfully, however whenever I run the import I always receive this error:

Skipped header. (line 1 in import file 'import-test-3.csv')
Error: Debits do not equal credits.
1

I have tried on my installation as well as the UK demo site with the sample file.

Here is the file I have used:

"reference","date","memo","amount","accountcode","taxtype","dim1_ref","dim2_ref","person_type_id (supplier=1 customer=2)","person_id"
"JNL2",02/12/2014,"Rent outstanding",122.25,7100,1,"D1","D2",,
"JNL2",02/12/2014,"Accruals",-122.25,2109,0,"D1","D2",,

Can you share a sample that is working?
Any help would be appreciated.
TIA
Ion