Page 1 of 2

No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 15:33
by Sonnet
Hi there,

after upgrading to iCompta V6 I'm unable to import new transaction as the old V4 import settings are not working anymore. Alining V4 and V6 works for almost all columns but I can't find the trick to show up the correct amount. This value stays a zero for all transactions.

Is there a guide how to save the downloads from the bank correctly (Windows comma separated csv etc.) and how to adjust iCompta than correctly to allow the import (coding, date format, csv separator etc.)?

Help is much appreciated.

BR Sonnet

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 15:57
by Angeman
You can copy the first lines of a CSV file and I'll tell you the correct import settings to use.

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 16:06
by Sonnet
Is a screenshot enough or do you the a sample file via pn?

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 17:02
by Angeman
A screenshot should be ok.

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 17:29
by Sonnet
Here you go:

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 17:39
by Angeman
I need of screenshot of the text file directly because I think you opened it in Excel and so I can't see what I need.

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 17:52
by Sonnet
Sorry. Please find attached a screenshot from the file opened with TextEdit
Sample_compta_V02.jpg
Sample_compta_V02.jpg (22.99 KiB) Viewed 7548 times

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 18:27
by Angeman
Ok so CSV separator is ; and the date format is dd.MM.yy and the encoding probably ISO Latin 1 but I can't tell for sure without having access to the file.

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 18:42
by Sonnet
Well, I got this before. But this brought no transaction value - just 0,00€

Encoding in V4 worked with ISO Latin 1. So I've chosen this here too. In addition I've saved the downloaded file from the bank as "Windows comma separated" file (csv)

So there must be another trick to get this working

Re: No transaction amount - correct import settings for csv file needed

Posted: 02 March 2017, 20:20
by Angeman
Can you send me a sample file by email so I can check the encoding ?