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

I've now moved this post to the Skrooge forum, where it will likely receive more attention.

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

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

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

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.

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.

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

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.

Hi,

Sorry for my ignorance I tried to find about of Skrooge cant find.
Please be kind send me some instructions.
Thank you

In the Skrooge menu:
Help / About Skrooge

Then in the About panel:
Autors / Stephane MANKOWSKI

You should have an icon to send an email.