Importing csv vile

Discussions about iCompta on macOS
Post Reply
lecycliste
Posts: 3
Joined: 10 November 2010, 14:10

Importing csv vile

Post by lecycliste »

Hello,

I am trying to import a semi-colon separated file.

My bank includes several date columns (value date, final date, search date etc) for each transaction.

I have configured the import to select the value date field , but when I import all the columns works as I have configured .... except every time, the date fields are today's date in every field. Any advice?

In fact, it doesn't matter what column in the file I configure to go in the "Date" field, it ends up importing the current date.

thanks
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Importing csv vile

Post by Angeman »

Give me a sample date from your CSV file and I'll tell you the right date format to use.
lecycliste
Posts: 3
Joined: 10 November 2010, 14:10

Re: Importing csv vile

Post by lecycliste »

x
Last edited by lecycliste on 10 November 2010, 16:42, edited 1 time in total.
lecycliste
Posts: 3
Joined: 10 November 2010, 14:10

Re: Importing csv vile

Post by lecycliste »

ok I had date set to dd/mm/YY and have changed it to exactly how the file does date: dd.mm.yyyy.

all works now . I didn't understand I had to change the "/" into "."

Merci de votre aide!!
Post Reply