During a large migration this week there are varying errors that we came across due to issues with the data being exported. This is just a very brief note about the most cryptic of these errors and a quick fix to hopefully get around it.
While using the DMM (Data Migration Manager) to process CSV files for import into the CRM some files through up the following error:
“The data for this file is not in the required format.”
”The request failed with HTTP status 400: Bad Request.”
After a bit of hunting around and checking out the files it turned out this was being caused by two things, firstly the CSV file had commas inside the text parts (enclosed in double quotes”), this was easily fixed in excel (remember to not let excel butcher your number fields on import). The second cause of the error was due to unprintable characters being included in the import e.g. carriage returns or currency symbols. To fix this error the easiest way seems to be to use Notepad++ to open the csv file, select the whole file and then pick “TextFX”, “TextFX Characters” and “Zap all non printable characters to #”. This will as it says replace all the weird characters with # symbols leaving the data free to import. Chances are you didn’t even need the crazy characters in the first place. Thanks to Theresa for working out the solution to that one.
I imagine there are going to be a few more of this type of error that will be encountered this week. If theres anything that I can’t find a solution to easily around the net I’ll post something here in a “part 2”
[tags]crm 4.0[/tags]
Thanks for the heads up on “Zap All Characters”. I use Notepad++ for a lot of data editing for CRM, but I was stumped on the error you mentioned.
I was banging my head against the wall for 3 days trying to import a .csv file into MS Dynamics CRM 4.0 and getting “400 Bad Request”
Even opened a support case with MS CRM support, they were absolutely clueless!
Your solution worked instantly!
Great job, thanks a lot for your help!
DM
This was a real time saver for me!
Thanks for your quick and easy solution, I don’t want to know how long it would have taken until I would have found a solution.
Many thanks.
CG
Great tip, worked perfect thanks! Nice theme btw 😉
Thanks for this, you stopped a grown man from crying! Top posting!
Thanks a lot for this… saved me hours!
Hi everyone,
I am also doing an import, but I’m not as savvy in using notepad. How do i do the following as Ben mentioned above?
“use Notepad++ to open the csv file, select the whole file and then pick “TextFX”, “TextFX Characters” and “Zap all non printable characters to #”.”
What menu or keyboard command do I use to do the above steps?
Thanks so much
This is a really useful post, this issue was beginning to grind on me… cheers!
Same here… I had lots of people look at this doc to figure out the issue and this ended up being the problem. Thanks a TON for this!
Thank you a million times thank you! I will end this day with my sanity in tact directly due to this post.