forums.lyricapps.com

Posted: **25 October 2009, 20:45**

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 (67.27 KiB) Viewed 9364 times

: Bild 2.png (76.82 KiB) Viewed 9365 times

is it possible to get these problems managed ?
Thx

Posted: **27 October 2009, 00:20**

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.

Posted: **31 October 2009, 17:47**

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 (72.51 KiB) Viewed 9315 times

: Bild 4.png (81.63 KiB) Viewed 9315 times

: Bild 3.png (72.51 KiB) Viewed 9315 times

Any ideas ?

Posted: **02 November 2009, 10:45**

Which version do you have ? Make sure you have 3.3.5 because this looks like an old bug.

Posted: **04 November 2009, 23:09**

It's Version 3.3.5.

best regards

Posted: **06 November 2009, 11:57**

Can you send me the whole file by mail, there must be something special with it ?

Posted: **11 November 2009, 22:17**

Problem was UTF-16 versus UTF-8.

Thx Cyril!

forums.lyricapps.com

Import

Import

Re: Import

Re: Import

Re: Import

Re: Import

Re: Import

Re: Import