119.2 How to import XML using the Data Loader?

Introduction #

SKYVVA´s Free Dataloader is part of the SKYVVA´s Integration Cloud App and is a
native force.com App. As a true Cloud Service data can be uploaded over the Web without the need to install any software or hardware
The DataLoader is mainly used for importing data from file in csv, XML or json format. We can do import Starting from inbound interface.
Data Loader is running in Bulk mode. If we want to send data to email, we can check the flag batch mode.
In this tutorial we are showing usecase with different XML format:

1. Flat XML,
2. Hierarchical XML,
3. Attribute XML,

Usecase1: For flat XML #

Objective: How to import flat xml using the Data Loader #

Pre-require:

• Create or upload Message Type.
• Create Integration and Inbound Interface
• Do mapping

Steps to use flat xml File with inbound Interface: #

Step 1: Create or Upload Message Type.

• Go to Metadata provider => create Repository => Upload or create Message Type.
• Here’s Message Type.

Step2: Create Integration and Inbound Interface.

• Create Outbound Interface and Linked Message Type with the Interface.
• Click save.

Step3: Do mapping.

• Go to Interface => Click Open Mapping
• Here’s Mapping.

Step4: Go to Integration to using Data Loader.

• Click Data Loader

• Choosing function Import Data.

• Choosing Interface and click next

• Select format, in this case we use XML so choosing Data Type XML. And click Next.

• Click Choose file that is format match with Message Type. And click Upload File.

• We can use Select All button or select only with record that we want to push to salesforce.

• After we select records, we need to click button Push.

• Go to Monitor to check the result.

Usecase1: Attribute XML #

Objective: How to import Attribute XML using the Data Loader #

Pre-requisite:

• Create or upload Message Type.
• Create Integration and Inbound Interface
• Do mapping

Steps to use Attribute xml File with inbound Interface: #

Step 1: Create or Upload Message Type.

• Go to create Metadata provider => create Repository => Upload or create Message Type.
• Here’s Message Type.

• In Message Type Account has Message Entry type Attribute. Because the data that I will upload has attribute field.

Step2: Create Inbound Interface and link with Message Type.

Step3:  Do mapping.

Step4: Go to Integration and click Data Loader.

• We do like the same way as the first case.

• After we push, we can go to monitor to see the result.

Usecase3: XML Special Character #

Objective: How to import XML Special Character using the Data Loader #

Pre-require:

• Create or upload Message Type.
• Create Integration and Inbound Interface
• Do mapping

Step 1: Create or Upload Message Type.

• Go to create Metadata provider => create Repository => Upload or create Message Type.
• Here’s Message Type special character “.”.

Step2:

• Create Inbound Interface and linked with Message Type.

Step3: Do mapping.

Step4: Go to Integration and click Data Loader.

• We do like the same way as the first case.

• Go to Monitor to see the result.