Problem with date field in CSV import

Discussions about iCompta on macOS
Post Reply
pdavide
Posts: 2
Joined: 21 July 2009, 12:41

Problem with date field in CSV import

Post by pdavide »

I tried to import a CSV file in iCompta, but had problems with getting the date field imported correctly.

These are the steps I followed:

1 - set import csv
2 - set encoding "utf-8" and date format "MM/DD/YY", separator "comma". This is a sample transaction I tried to import in iCompta (first row defines columns):

Code: Select all

Date,Category,Subcategory,Vendor,Amount,Note
09/29/08,Utilities,CellPhone,Vodafone,15,some note
3 - associated imported columns with iCompta fields:

name = note
date = date
amount = amount
type = subcategory
comment = category

4 - launched the conversion and got everything fine except for the date: the date of the transaction above got changed to 24/12/06

Any clues?
User avatar
Angeman
Administrateur
Posts: 2302
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Problem with date field in CSV import

Post by Angeman »

Use MM/dd/yy instead.
pdavide
Posts: 2
Joined: 21 July 2009, 12:41

Re: Problem with date field in CSV import

Post by pdavide »

Perfect! Thanks a lot :D
Post Reply