locked
Where is the Import Data Map Schema? RRS feed

  • Question

  • I have the v504 SDK and looked on MSDN, but I cannot find the schema for the CRM Data Map as used in imports. In fact there is no information about the map XML schema at all in the SDK. The online info I can find on the schema is within the CRM help. This seems a major oversight. We also need the schema so that we can validate our own map XML files. Schema files are provided for all the other XML files used within CRM, so why has this been omitted. Can someone from Microsoft post it for us?
    Wednesday, June 8, 2011 9:04 AM

Answers

  • I found the CRM2011 version of the schema at this location on the CRM server:

    C:\Program Files\Microsoft Dynamics CRM\CRMWeb\_Resources\ImportMapSchema.xsd

    • Marked as answer by Caratacus Wednesday, July 27, 2011 2:56 PM
    Wednesday, July 27, 2011 2:55 PM

All replies

  • Hi,

    You may get the XML file schema by performing the following steps:

    1. Create sample CSV file with 1 record

    2. Run CRM 2011 import wizard from the home page

    3. Select CSV sample data file, make sure to map all entity fields

    4. At the end of data import wizard before clicking on Sumit button make sure to type the Data Map Name

    5. Remove the sample record

    6. In CRM, go to Settings-> System -> Data Management ->Data Maps, select Data Map, click on export button and save data map in XML schema file.

    I hope this answers your questions.

     


    Thank You,
    Jehanzeb Javeed,
    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile
    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Wednesday, June 8, 2011 10:17 AM
  • That just saves the XML. I need the schema so that I can validate the XML against it.
    Thursday, June 9, 2011 11:36 AM
  • Hi,

    There is no schema available for data import XML file validations even there was no availavle for CRM 4.0. I am afraid you might have to create your own if required, you may also reffer to the following links:

    http://msdn.microsoft.com/en-us/library/x6c1kb0s(v=vs.80).aspx

    http://msdn.microsoft.com/en-us/library/asct4hkz(v=vs.71).aspx

    I hope your questions is answered.


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Thursday, June 9, 2011 11:46 AM
  • I found a schema posted on codeplex as part of an advanced map editor. As far as I am aware this should be compatible with CRM2011. It will do until such time as Microsoft release an official definition.
    See here: http://mscrmmapeditor.codeplex.com/releases/view/11777.
    • Marked as answer by Caratacus Tuesday, June 14, 2011 1:28 PM
    • Unmarked as answer by Caratacus Wednesday, July 27, 2011 2:56 PM
    Tuesday, June 14, 2011 1:27 PM
  • I found the CRM2011 version of the schema at this location on the CRM server:

    C:\Program Files\Microsoft Dynamics CRM\CRMWeb\_Resources\ImportMapSchema.xsd

    • Marked as answer by Caratacus Wednesday, July 27, 2011 2:56 PM
    Wednesday, July 27, 2011 2:55 PM