Import

Discussions about iCompta on macOS
Post Reply
Amnion
Posts: 5
Joined: 25 October 2009, 20:27

Import

Post by Amnion »

Hi,

great programm! I'm just fooling around with it the first time.
I want so import my data, but i've problems to get the amount right.

Here's a sample

Code: Select all

"Kontoinhaber"	" Amnion"	""
""	""	""
""	"Girokonto Nr.237462734"	""
"Saldo (EUR)"	"1269,52"	""
"Zeitraum"	"25.09.2009 - 25.10.2009"	""
""	""	""
"Nr."	"Buchungsdatum"	"Umsatzinformation"	"Wertstellung"	"Soll (EUR)"	"Haben (EUR)"
"1"	"21.10.2009"	"Lastschrift XXbla "	"21.10.2009"	"231,00"	""
"2"	"20.10.2009"	"Lastschrift BELEG sdfsdfsdf"	"20.10.2009"	"73,00"	""
"3"	"20.10.2009"	"Lastschrift BELEG sdfsdfsdfsdf"	"20.10.2009"	"26,00"	""
....
"13"	"05.10.2009"	"Überweisung ÜBERTRAG sdfsdfsdf	"05.10.2009"	"600,00"	""
"14"	"02.10.2009"	"Gutschrift Dauerauftrag sdfsdfsdf"	"02.10.2009"	""	"358,00"
The amout ist in 2 different fields. a negativ amout is in field "Soll (EUR)", positiv ones are in "Haben (EUR)".

The second Problem is that there is an cartigre return in the last line and therefore an empty transaction is insered.

I can also cannot get the dates correct.
Bild 1.png
Bild 1.png (67.27 KiB) Viewed 7916 times
Bild 2.png
Bild 2.png (76.82 KiB) Viewed 7917 times
is it possible to get these problems managed ?
Thx
User avatar
Angeman
Administrateur
Posts: 2340
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Import

Post by Angeman »

Import is working as expected on my computer however I had to add the missing quote on line 13 juste before the second date. Before I did it was acting like you described so please check for missing quotes in your file.
Amnion
Posts: 5
Joined: 25 October 2009, 20:27

Re: Import

Post by Amnion »

Angeman wrote:Import is working as expected on my computer however I had to add the missing quote on line 13 juste before the second date. Before I did it was acting like you described so please check for missing quotes in your file.
thx for the reply.
The missing quotes are just caused from my editing to remove sensitve data.

despite of this the import doesn't work for me:
Bild 3.png
Bild 3.png (72.51 KiB) Viewed 7867 times
Bild 4.png
Bild 4.png (81.63 KiB) Viewed 7867 times
Bild 3.png
Bild 3.png (72.51 KiB) Viewed 7867 times
Any ideas ?
Attachments
Bild 2.png
Bild 2.png (153.39 KiB) Viewed 7868 times
User avatar
Angeman
Administrateur
Posts: 2340
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Import

Post by Angeman »

Which version do you have ? Make sure you have 3.3.5 because this looks like an old bug.
Amnion
Posts: 5
Joined: 25 October 2009, 20:27

Re: Import

Post by Amnion »

It's Version 3.3.5.

best regards
User avatar
Angeman
Administrateur
Posts: 2340
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Import

Post by Angeman »

Can you send me the whole file by mail, there must be something special with it ?
Amnion
Posts: 5
Joined: 25 October 2009, 20:27

Re: Import

Post by Amnion »

Problem was UTF-16 versus UTF-8.

Thx Cyril!
Post Reply