Dynamics Community Forum Thread Details

Configuration Migration Utility Issues

Hi All,

I'm experiencing a couple of issues with the Configuration Data Migration Tool that comes with the SDK, which I was hoping somebody could help with

Thanks

When I use the CRM Configuration Migration tool to import configuration data into a CRM organisation it incorrectly decides that the dates in the data.xml import file are in mm/dd/yyyy format (US format) but they are in dd/mm/yyyy format and therefore it imports dates incorrectly or not at all e.g. a date of 01/02/2015 (1st Feb) in data.xml is imported into CRM as 02/01/2015 (2nd Jan), a date of 13/01/2015 (13th Jan) is not imported into CRM as it is an invalid date in US format. The system locale, location, and formats are all set to United Kingdom on both the CRM server and the SQL Server. In CRM, in both the system settings and the user settings, formats are set to United Kingdom. How does CRM Configuration Migration tool decide what format dates in the data.xml import file are in?
I create a record in CRM that contains an option set and 4 currency fields, I export the record using the CRM Configuration Migration tool, I delete the record in CRM, and finally I import the record that I just exported. After the import I was expecting to see a record identical to the one that I exported and deleted however the option set field is populated but none of the currency fields are populated - weird. I open the zip file that was created by the export process, I open the data.xml file within it, and I locate one of the currency fields:
```
<field name="new_rate1" value="&amp;#163;‎1.00" />
<field name="new_rate1_base" value="&amp;#163;‎1.00" />
```
If I manually remove the '£' from the first row, i.e.
```
<field name="new_rate1" value="‎1.00" />
<field name="new_rate1_base" value="&amp;#163;‎1.00" />
```
and import the data the currency field value will be imported correctly. Surely I shouldn't have to manually edit the XML file. I believe that this is either a bug in Configuration Migration tool or that I am doing something wrong, but I can't think what. Does anyone have any thoughts or ideas?