Microsoft Dynamics CRM (Archived)

The source data is not in the required format "Trying to import Published Articles"

(0) Share

Report

Posted on by Lawrence Bassey

I have a knowledge base created on crm2011 which I exported to an excel and saved in csv file format.

I had this error on trying to import to crm online indicating that the source data is not in the required format.

I need your kind assistance.

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Royal King 27,686 on at

Like (1)

Report

Lot our customer run into this issue but the fix is very simple.Check your excel sheet whether you have any column values all in number , if so you may get this error because the field type of this column may be string in Crm. To fix this issue select the column in excel and go to format and set it to text save it and try to import.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

What kind of field is it? Is it a date field? For example if your target system is using a different date format to the source system its possible that that you will get errors because of this - in the US they use mm/dd/yyyy whereas in the UK we use dd/mm/yyyy so if the source system is UK and the target system is US then you will get an error with this date: 30/04/2015 because there are not 30 months in the year.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jack ,

May I know how is this Issue resolved, On excel my date format id dd-mm-yyyy, however when I try to import the error"Source data is not in correct format appears", However I have my date format set in dd-mm-yyyy format in user level and organization level

Was this reply helpful? Yes No
Koen VdV 1,219 on at

Like (0)

Report

Just as Neethuanna I am curious as to how this issue is resolved. Moreover, I'm having the issue on a date field, as Jack Nutkins posted. Next, at this moment I am having the same problem in a Dynamics CRM Online 2016 Update 1 environment where the system organisation is set up in Dutch.

Was this reply helpful? Yes No
Roxana 691 on at

Like (0)

Report

Hello Neethuanna, I would like to know how you solved this issue. I have the same trouble. Thanks in advanced.

Was this reply helpful? Yes No
Karuna Karan 1,212 on at

Like (0)

Report

Guys,

Make sure the Source and Target system's date formats are the same. Settings>Administration>System Settings>Formats.

If the Source system formats are different than Target, then change the Source system and then export the data to excel template.

Also once the data is exported to excel, right click the date column value and go to format cells, see the category whether its Date or Custom.

Was this reply helpful? Yes No
Roxana 691 on at

Like (0)

Report

Thanks for your answer.

The Source System Settings is in Format: España (Ecuador): dd/MM/yyyy

The Source User Settings is in Format: España (Ecuador): dd/MM/yyyy

The regional system of the computer: España (Ecuador): dd/MM/yyyy

The Template that is exported from CRM, has the format: dd/MM/yyyy. Even I can not enter other format. And it is in format of Datetime.

But I can not import, the message keeps: "Data is not in the right format"

Please your comments. Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I also have the same issue, all my setting match.

Did anyone find the solution?

Thanks

Was this reply helpful? Yes No
Roxana 691 on at

Like (0)

Report

No solution was found.

Its probably a bug in the version. I reported to Microsoft.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for all your posts on this. Am having the same problem and for now the OP's workaround of changing the date column in Excel to text (AFTER the dates have been entered) seems to work. Changing the format to text changes the date to a number (e.g. 02/04/1981 in UK date format shows as 29678 after changing the format to text) and this imports into the CRM as the correct date.

Was this reply helpful? Yes No