This forum has been archived. All content is frozen. Please use KDE Discuss instead.

import from csv inverting the amount sign and a fake date

Tags: None
(comma "," separated)
fluca1978
Registered Member
Posts
81
Karma
0
OS
Hi all,
I'm just starting using the great Skrooge to manage my accounts, and I have to import a lot of data via csv files.
I'm facing two problems:
1) the sign of my csv operations is the opposite of what Skrooge expects (i.e., such files are based on expenses being positive and incomings being negatives); is there a way to change the sign to a set of operations?
2) some of such CSVs do not report a date but rather a month the operation refers to, is there a way to force Skrooge to substitue a month name to a fixed date in such month? (otherwise I have to do 12 replace all in the file, not an hard work).

Thanks
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS
fluca1978 wrote:Hi all,
I'm just starting using the great Skrooge to manage my accounts, and I have to import a lot of data via csv files.
I'm facing two problems:
1) the sign of my csv operations is the opposite of what Skrooge expects (i.e., such files are based on expenses being positive and incomings being negatives); is there a way to change the sign to a set of operations?

No, this is not possible but you can use LibreOffice or Excel to change the sign of transactions (by using a formula for expample).
fluca1978 wrote:2) some of such CSVs do not report a date but rather a month the operation refers to, is there a way to force Skrooge to substitue a month name to a fixed date in such month? (otherwise I have to do 12 replace all in the file, not an hard work).

Same answer, you can use LibreOffice or Excel to change the dates.
fluca1978 wrote:Thanks

Thank for using Skrooge.


Skrooge, a personal finances manager powered by KDE
Image - PayPal
fluca1978
Registered Member
Posts
81
Karma
0
OS
smankowski wrote:
No, this is not possible but you can use LibreOffice or Excel to change the sign of transactions (by using a formula for expample).
fluca1978 wrote:


Ok, I was suspecting this...but it was worth asking!


Bookmarks



Who is online

Registered users: Bing [Bot], daret, Google [Bot], Sogou [Bot]