Have Geek Brain

Data integration

I am trying to insert some data into a CRM system via XML import.

I have XML schemas for a CRM system (XSD) which are quite complex (large files with a lot of names), I am struggling to figure out what XML is supposed to look like and the names don't help at all.

I need an easy way to prototype XML documents, once I have a set of working XML templates I can properly process the data feed.

Any suggestions?

+1


a source to share


4 answers


We've been using Liquid XML Studio for ages, XSD diagrams make XSD easy to understand. There is also a function where you can create a sample XML document, sometimes this can be a good start. Finally, intellisense in the XML editor gives you all the options and makes sure you have the correct namespaces.



+1


a source


Presumably the connection works in both directions. Can you tell CRM to output some XML so you can view it?



+1


a source


I think you just need a good XML Editor .

I'd go with Liquid XML Studio (the free version will do whatever you need it to sound).

Or Visual Studio 2003 or higher. Intellisense is fine, but can be a pain to set up - take a look at How to set up Visual Studio 2005 to use custom XSD files for IntelliSense "

If you want schema visualization though Liquid XML is the way to go.

0


a source


Brian,

If you are working in Microsoft.NET, you can create C # or VB classes from your XML schemas using XSD.EXE .

0


a source






More articles:


All Articles