Import Date Incorrect

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

I’m having an issue where I am migrating data to a new install.

I am exporting all data in the module by clicking the dropdown, select all, then export. This works perfectly, i get the CSV as expected.

The issue is that when i go to import into the new install, the date is wrong, but the time is correct.

See images below for further details.

Below is the correct date in the old install.

Below is the same correct date in the exported CSV.

And Below is the incorrect format which is imported into the new install.

Any help would be greatly appreciated.

2

I’ve found out that if I copy and paste from the CSV to a new CSV and import just that one line, the date is correct.

So there seems to be an issue with importing multiple rows that is messing up the date.

3

Anyone?

4

Bump

5

SOLUTION

I managed to fix it. The encoding had to be changed to UTF-8 on import properties.