{"id":11230,"date":"2018-02-20T18:15:11","date_gmt":"2018-02-20T12:45:11","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=11230"},"modified":"2018-02-20T18:15:11","modified_gmt":"2018-02-20T12:45:11","slug":"fixed-unable-to-import-csv-file-due-to-error-the-source-data-is-not-in-the-required-format-in-dynamics-365","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/02\/fixed-unable-to-import-csv-file-due-to-error-the-source-data-is-not-in-the-required-format-in-dynamics-365\/","title":{"rendered":"Fixed – Unable to import CSV file due to error The source data is not in the required format in Dynamics 365"},"content":{"rendered":"

We had a business requirement to \u201cCreate\u201d entity records in bulk using OOB \u201cImport Data\u201d feature of Dynamics 365.<\/p>\n

While doing so, we were experiencing an issue while importing data in Dynamics 365, the error we were getting was \u201cThe source data is not in the required format\u201d<\/strong><\/p>\n

We were importing the data as CSV file. Let\u2019s say, we have one entity named \u201cReferral\u201d in CRM and we need to create multiple \u201cReferral\u201d records after importing CSV file.<\/p>\n

As you can see in below table, CSV data needs to be mapped with \u201cReferral\u201d record field in CRM as below:<\/p>\n

\"Unable<\/p>\n

Now to import the CSV file in Dynamics 365, perform these steps – Navigate to Setting\u2192Data Management\u2192Import\u2192Click on Import Data\u2192 and then choose the file<\/p>\n

We were experiencing failures while processing some of the data present in the CSV file, when we were trying to import CSV file with above data into Dynamics 365 containing \u201cDate\u201d and \u201cSingle Line of Text\u201d data type. CRM was giving the OOB error \u201cThe source data is not in the required format\u201d<\/strong> and hence, failed few of the records specifically for Date fields <\/strong>while processing.<\/p>\n

As shown in below screenshot \u201cReferred Date\u201d was failed, as it was the date field with a format (MM\/DD\/YYYY) in CRM but while importing through CSV file the date format used was (DD\/MM\/YYYY).<\/p>\n

\"Unable<\/p>\n

We were not sure why this was happening, so to explore it further we did below:<\/p>\n

We navigated to \u2192Options\u2192Formats for checking the current format for Date.<\/p>\n

\"Unable<\/p>\n

And found that Current Format in CRM selected was \u00a0English (United States)\u00a0 as shown below:<\/p>\n

\"Unable<\/p>\n

When we continued exploring, we found that there was a discrepancy in the date format (DD\/MM\/YYYY) passed in CSV file and date fields format (MM\/DD\/YYYY) present in CRM. And hence while processing through OOB import functionality it failed with the description \u201cThe source data is not in the required format\u201d<\/strong>.<\/p>\n

It was happening, because in the US they follow MM\/DD\/YYYY format for date where as in UK they follow DD\/MM\/YYYY format. And in our case source system was the UK and target system was US due which we were getting that OOB error while processing the data with date field such as one which is processed above 30\/01\/2018, as there are no 30 months in the year.<\/p>\n

Also, we noticed while importing, there were few data with date field which were processed successfully in excel like with date 12\/01\/2018. (Because there are 12 Months in a year)<\/p>\n

We were able to get rid of this failure, just by one step as below:<\/p>\n

Navigate to\u2192Options\u2192Formats\u2192Select the Current Format as English (United Kingdom)<\/p>\n

\"Unable<\/p>\n

And it did work.\u00a0 We were able to import the CSV file. Without any failure.<\/p>\n

Note: while using OOB importing functionality make sure that \u201cSource\u201d and \u201cTarget\u201d date formats are same. Because if \u201cSource\u201d system format is different than \u201cTarget\u201d then system will not allow to do so instead it will throw an error.<\/em><\/strong><\/p><\/blockquote>\n

\"Easily<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

We had a business requirement to \u201cCreate\u201d entity records in bulk using OOB \u201cImport Data\u201d feature of Dynamics 365. While doing so, we were experiencing an issue while importing data in Dynamics 365, the error we were getting was \u201cThe source data is not in the required format\u201d We were importing the data as CSV\u2026 Read More: Fixed – Unable to import CSV file due to error\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":11238,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,19],"tags":[1748],"class_list":["post-11230","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-crm","tag-unable-to-import-csv-file"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t