importing CSV problem date valour

[paxter]

Hi there,

I have a estrange situation when importing CSV into icash.
It seem it recognizes all my data and the importation works but the date add +2 days automatically.
Example:

my CSV contains 13/10/10 and it appear in icash as 15/10/10
the same with the rest movements I want to import.

Please kindly help!

Many thanks

 

[stanbusk]

Is your system date format the same as your CSV file date format?

 

[paxter]

Yes, I have the same format in both.
I´m a mac use, the date format is 2/11/2010
on my CSV file the same format as well.

If you have any other question, please let me know.

many thanks!

 

[stanbusk]

Weird, if the date format is identical in the OS, the file and iCash, I don't know why you get that difference :-/ Are the separator '/' in all places as well?

 

[paxter]

yes the separator are in all the places as well. each column have own valor.
The CSV i created in office 2008 for mac and I´m running snow leopard updated.

 

[stanbusk]

Do you know what the encoding of that file is?

 

[paxter]

I don´t know...
Where I can see this info?

 

[stanbusk]

Open the file with free TextWrangler. You will see the encoding on the window status bar.

 

[paxter]

The encoding is:

Unicode UTF-8, no BOM

Thanks for the TextWrangler!

 

[stanbusk]

The encoding seems correct but try to change it to Mac Roman and try the import again.

 

[paxter]

I tried this unfortunately it doesn´t work...

any other idea?

thanks!

 

[stanbusk]

Please open a Support Ticket and add your file to it. I will try it here.

 

[paxter]

following your instructions of the format text I created a new file in Numbers and exported to CSV format.
Now Icash have imported perfectly!

Many thanks for your support!!