Reply to topic

Skrooge Import csv error

Lumaja
Registered Member
Posts
11
Karma
0
OS

Skrooge Import csv error

Fri Oct 18, 2013 3:27 pm
Ubuntu 12.04 LTS
Skrooge Ver. 1.7.1

I am new to Skrooge and trying this application.
Fill Accounts with my accounts and Import csv file a error come up [ERR-5].
Click History [ERR-5]: Columns date and amount not found. Set import parameters in settings.
My CSV files from my bank don’t have the date and amount headers, I edit and insert Date and
Amount headers saved as CSV, import again but the some error come up.
The CSV files have date as 31Dec2012. In Import Settings set for CSV files on Date Format: DDMMYYYY,
In Automatic Search of the Columns: “Edit regular expressions” I don’t know how to modify
this section, need help.
Need directions how to this Import successfully.
Can I import from Kmymoney and Import from LibreOffice Calc?
Thank you

Last edited by Lumaja on Sat Oct 19, 2013 6:49 am, edited 1 time in total.
User avatar bcooksley
Administrator
Posts
18605
Karma
83
OS

Re: Skrooge Import csv error

Sat Oct 19, 2013 6:06 am
I've now moved this post to the Skrooge forum, where it will likely receive more attention.


System Settings and Device Actions KCM maintainer
Image
Lumaja
Registered Member
Posts
11
Karma
0
OS

Re: Skrooge Import csv error

Sat Oct 19, 2013 11:06 am
I don’t understand “I've now moved this post to the Skrooge forum, where it will likely receive more attention.” I thought I post in Skrooge forum please direct me to this other forum to see if there is any answers to my post.
Thank you
User avatar smankowski
Moderator
Posts
292
Karma
3
OS

Re: Skrooge Import csv error

Sat Oct 19, 2013 11:45 am
Hi,

Skrooge doesn't support date format like "31Dec2012".

You have to translate these dates in an accepted format (exemple: 31122012).

Regards,
Stephane

PS: I will update Skrooge to support 31Dec2012 but this will be for next version


Skrooge, a personal finances manager powered by KDE4
http://skrooge.org
Lumaja
Registered Member
Posts
11
Karma
0
OS

Re: Skrooge Import csv error

Sat Oct 19, 2013 2:57 pm
Hi Stephane

Thank you for your help, on translate the date to 31122012 I did that but the same error come up,
went to Configure skrooge and found all configure date options and none is DDMMYY and change
to this is not allowed.
Need more guidance on this Please

Regards
Luis
User avatar smankowski
Moderator
Posts
292
Karma
3
OS

Re: Skrooge Import csv error

Sat Oct 19, 2013 7:59 pm
Hi,

If you are sure that you csv file has:
-A header with at least 2 columns named "amount" and "date"
-All dates are in format DDMMYY

Then:
-Set the 2 options (Automactic...) in CSV settings enabled
-Try an import

If you still have an issue, please post here the error message returned by Skrooge.
If possible, send me a sample of CSV file to reproduce the issue by email.


Skrooge, a personal finances manager powered by KDE4
http://skrooge.org
User avatar bcooksley
Administrator
Posts
18605
Karma
83
OS

Re: Skrooge Import csv error

Sun Oct 20, 2013 2:38 am
In regards to the topic being moved - it was opened in the Forum Feedback forum previously. When I moved it, the full history of the topic along with my reply was also moved to the new forum. You don't need to do anything further to receive notifications about replies to your topic.


System Settings and Device Actions KCM maintainer
Image
Lumaja
Registered Member
Posts
11
Karma
0
OS

Re: Skrooge Import csv error

Sun Oct 20, 2013 6:21 am
Hi Stephane,

CSV file has date, payee and amount. Dates are format DDMMYY.
Settings of CSV:
Date format: Automatic detection
Automatic search of the header: enabled
Automatic search of the columns: Edit regular expressions
Debit values of “sign” column: |debit|withdrawal
Import result: [ERR-5]: Columns date and amount not found. Set import parameters in settings.
Don’t know how to send sample of CSV file, Please send instructions.

Luis
User avatar smankowski
Moderator
Posts
292
Karma
3
OS

Re: Skrooge Import csv error

Sun Oct 20, 2013 6:38 am
Hi,
The error shows that Skrooge is not able to find the columns names "Date" and "Amount".
My name is Stephane MANKOWSKI, you can find my email address in the about of Skrooge.

Regards.


Skrooge, a personal finances manager powered by KDE4
http://skrooge.org
Lumaja
Registered Member
Posts
11
Karma
0
OS

Re: Skrooge Import csv error

Sun Oct 20, 2013 10:16 am
Hi,

Sorry for my ignorance I tried to find about of Skrooge cant find.
Please be kind send me some instructions.
Thank you
User avatar smankowski
Moderator
Posts
292
Karma
3
OS

Re: Skrooge Import csv error

Sun Oct 20, 2013 11:11 am
In the Skrooge menu:
Help / About Skrooge

Then in the About panel:
Autors / Stephane MANKOWSKI

You should have an icon to send an email.


Skrooge, a personal finances manager powered by KDE4
http://skrooge.org

 
Reply to topic

Bookmarks



Who is online

Registered users: Alexa [Bot], Baidu [Spider], Bing [Bot], dniitall, Exabot [Bot], Google [Bot], google01103, koriun, Majestic-12 [Bot], north, ooker, paulus3005, psbot [Picsearch], rulet111, scummos, SecretCode, Uri_Herrera, vascobasque, wimwillemsen, Yahoo [Bot]