forums.lyricapps.com

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

You can copy the first lines of a CSV file and I'll tell you the correct import settings to use.

Is a screenshot enough or do you the a sample file via pn?

A screenshot should be ok.

Here you go:

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.

Sorry. Please find attached a screenshot from the file opened with TextEdit

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.

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

Can you send me a sample file by email so I can check the encoding ?