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
No transaction amount - correct import settings for csv file needed
- Angeman
- Administrateur
- Posts: 2307
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: No transaction amount - correct import settings for csv file needed
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
Is a screenshot enough or do you the a sample file via pn?
- Angeman
- Administrateur
- Posts: 2307
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: No transaction amount - correct import settings for csv file needed
A screenshot should be ok.
Re: No transaction amount - correct import settings for csv file needed
Here you go:
Last edited by Sonnet on 02 March 2017, 17:52, edited 2 times in total.
- Angeman
- Administrateur
- Posts: 2307
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: No transaction amount - correct import settings for csv file needed
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
Sorry. Please find attached a screenshot from the file opened with TextEdit
- Angeman
- Administrateur
- Posts: 2307
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: No transaction amount - correct import settings for csv file needed
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
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
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
- Angeman
- Administrateur
- Posts: 2307
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: No transaction amount - correct import settings for csv file needed
Can you send me a sample file by email so I can check the encoding ?