Problem with date field in CSV import
Posted: 21 July 2009, 13:23
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):
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?
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
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?