Problem importing CSV file

Discussions about iCompta on macOS
Post Reply
techgurl
Posts: 3
Joined: 23 March 2009, 03:18

Problem importing CSV file

Post by techgurl »

Hi,

I just downloaded iCompta and now I'm trying to import my bank transactions. The file I get from the bank has only 4 fields: Date, Description, Debit amount, Credit amount.

I tried setting these values on the import screen (DATE, NAME, DEBIT, CREDIT), but after it finishes, it only imported the debit amounts and there are no credits on the account.

Should I do something different? Here are a few lines from the file:

Code: Select all

2008-06-23,Inter-Branch Banking DEPOSIT                    IBB CHURCH AND CARLTON  TORONTO ,,10000
2008-06-23,Automated Banking Machine INSTANT TELLER WITHDRAWAL CHURCH + CARLTON          3E38 ,60,
2008-06-23,Point Of Sale or Debit Card RETAIL PURCHASE   000001396001 GOLDEN GRIDDLE ,16.48,
Thank you.
User avatar
Angeman
Administrateur
Posts: 2302
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Problem importing CSV file

Post by Angeman »

Yes there is a bug with credit amounts not being imported during CSV import. This will be fixed shortly.
techgurl
Posts: 3
Joined: 23 March 2009, 03:18

Re: Problem importing CSV file

Post by techgurl »

Angeman wrote:Yes there is a bug with credit amounts not being imported during CSV import. This will be fixed shortly.
Thank you for the reply. I'll just change my files for now.
techgurl
Posts: 3
Joined: 23 March 2009, 03:18

Re: Problem importing CSV file

Post by techgurl »

For the record, I think this program is great. I just downloaded the newest version and I'm enjoying it.

If the first line is credit, like the one below, the import works fine, but if it's debit, the line ends with a comma and then when splitting the values, there are no credit value (2nd line below).

The file format is the following (Date, Description, Debit, Credit):

Code: Select all

2008-06-23,Inter-Branch Banking DEPOSIT IBB CHURCH AND CARLTON  TORONTO ,,10000
2008-06-23,Automated Banking Machine INSTANT TELLER WITHDRAWAL CHURCH + CARLTON 3E38 ,60,
2008-06-23,Point Of Sale or Debit Card RETAIL PURCHASE   000001396001 GOLDEN GRIDDLE ,16.48,
Is there a way to fix this without me having to write the header in each file I import?

Thanks.
User avatar
Angeman
Administrateur
Posts: 2302
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Problem importing CSV file

Post by Angeman »

Thanks for the bug report, I'll fix this in next update.
Post Reply