Transaction amount not mapping from csv import (V5)

Discussions about iCompta on macOS
Post Reply
ubar
Posts: 15
Joined: 11 April 2013, 14:30

Transaction amount not mapping from csv import (V5)

Post by ubar »

Hi,

I'm sorry if I'm missing something really obvious but I'm having problems importing from a csv file. And I've given this the wrong title - I'm using V6, not V5!

I have a spreadsheet with columns called date, name, debit, credit and amount. The date and name data maps with my iCompta but the amount, debit and credit doesn't. The amount, debit and credit fields are formatted as number in the spreadsheet. The amount always shows up as zero when it has been imported to iCompta. Could somebody suggest where I might be going wrong?

These are the settings:
Untitled.png
Untitled.png (107.82 KiB) Viewed 3635 times
User avatar
Angeman
Administrateur
Posts: 2131
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Transaction amount not mapping from csv import (V5)

Post by Angeman »

Set the CSV separator to ',' in the import settings.
ubar
Posts: 15
Joined: 11 April 2013, 14:30

Re: Transaction amount not mapping from csv import (V5)

Post by ubar »

Thank you so much, that was really helpful. Sorry it took me so long to respond, I thought I'd already acknowledged your last post.

I'm importing transactions again but this time I can't figure out why all the transactions are importing with today's date.

I'm importing from .csv, I have made sure that the date column is configured so that the cell data format is set to dd-mm-yyyy. All other data is mapping correctly. In the screenshot showing the log, I've left one transaction in rather than cropping them all out.

Again, I know I'm probably overlooking something really simple but I haven't been able to find the answer in any of the documentation or by running a G**gle search...
Attachments
Screen Shot 2017-04-09 at 12.12.39.png
Screen Shot 2017-04-09 at 12.12.39.png (112.56 KiB) Viewed 3591 times
Screen Shot 2017-04-09 at 12.13.06.png
Screen Shot 2017-04-09 at 12.13.06.png (170.44 KiB) Viewed 3591 times
Screen Shot 2017-04-09 at 12.16.04.png
Screen Shot 2017-04-09 at 12.16.04.png (51.49 KiB) Viewed 3591 times
User avatar
Angeman
Administrateur
Posts: 2131
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Transaction amount not mapping from csv import (V5)

Post by Angeman »

The date format for your file seems to be yyyy-MM-dd.
ubar
Posts: 15
Joined: 11 April 2013, 14:30

Re: Transaction amount not mapping from csv import (V5)

Post by ubar »

Thank you, I changed the date format to the one you said and it worked. :)
Post Reply