Overview
With DataBridge it is possible to import (nested) XML files into SuperOffice CRM Online.
If you want to know what other types of files are supported, please visit our System Requirements page.
How to
In the Configure Profile page in your profile, you can upload your XML file. In the Configure Source page, you can set what text encoding is used in your file. A preview is also shown at the bottom of the screen.
...
What does a well formated XML look like (this example is also attached to this article)
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<?xml version="1.0" encoding="UTF-8"?> <companies> <company> <name>...</name> <contacts> <contact> <firstname>...</firstname> <lastname>...</lastname> </contact> <contact> <firstname>...</firstname> <lastname>...</lastname> </contact> </contacts> </company> <company> <name>...</name> <contacts> <contact> <firstname>...</firstname> <lastname>...</lastname> </contact> </contacts> </company> </companies> |
<contacts>
<contact>
<firstname>John<<?xml version="1.0" encoding="UTF-8"?>
<companies>
<company>
<name>...</name>
<contacts>
<contact>
<firstname>...</firstname>
<lastname>Doe</lastname>
<phone>0123456789 </phone>
<email>johndoe@mail.com</email>
</contact>
<contact>
<firstname>John< <lastname>...</lastname>
</contact>
<contact>
<firstname>...</firstname>
<lastname>...</lastname>
</contact>
</contacts>
</company>
<company>
<name>...</name>
<contacts>
<contact>
<firstname>...</firstname>
<lastname>Doe< <lastname>...</lastname>
<phone>9876543210</phone>
<email>janedoe@mail.com</email>
</contact>
</contacts> </contact>
</contacts>
</company>
</companies>
The options would be:
companies
companies/company ← select this one if “company“ is the entity to import
companies/company/contacts
companies/company/contacts/contact ← select this one if “contact“ is the entity to import
If the file contains only one entity to import instead of a collection, then the root tag should be selected. See this example file provided by a customer: it contains only one invoice, represented by the root tag <Invoice>.
The rules for a successful XML import are:
...