importing from CSV erroк

Discussions about iCompta on macOS
Post Reply
zh_olga
Posts: 55
Joined: 19 November 2013, 21:48

importing from CSV erroк

Post by zh_olga »

Hi
I'm trying to import from CSV file
exhibition july.csv
(3.45 KiB) Downloaded 62 times
But iCompta only see 3 out of 12 transactions

I suppose it's because there's many semicolons (;) in comments in some lines.

Any workarounds or maybe I need to make different settings from these
Screen Shot 2020-12-16 at 12.16.52 PM.png
Screen Shot 2020-12-16 at 12.16.52 PM.png (329.59 KiB) Viewed 861 times
Last edited by zh_olga on 16 December 2020, 15:50, edited 1 time in total.
User avatar
Angeman
Administrateur
Posts: 2144
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: importing from CSV erroк

Post by Angeman »

Start importing from line should be set to 1 instead of 2.
zh_olga
Posts: 55
Joined: 19 November 2013, 21:48

Re: importing from CSV erroк

Post by zh_olga »

Thanks but this doesn’t help at all
User avatar
Angeman
Administrateur
Posts: 2144
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: importing from CSV erroк

Post by Angeman »

I looked into your file and it's because there are quotes " in the lines and they should be escaped with a backslash before like this \".
Post Reply