Import data from XML file to Azure without programming

Want to import data from XML file to Azure?

Using FileToDB, a native GUI tool, you can import data from XML file to Azure easily and fast.

• Step by step, just a few mouse clicks.
• Avoid uploading big XML file(s) to online services.
• Support large XML files (big than 4GB).
• Support Windows, Linux, macOS.

Download FileToDB

Here’s how to.

• Example
• Import
• Save/load session
• Run in command line
• Run as scheduled task

Example of importing XML to Azure

Example source XML file

After converting, data in Azure table

Import data from XML file to Azure

Choose Azure and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select the “XML” file type.

then show the wizard.

1. Open a XML file.

2. Select a Azure table and config fields.

3. Preview data.

4. Import XML data Azure .

View imported data in Azure table

Download FileToDB

Save/load session of importing XML to Azure

You can save/load session to run “XML to Azure” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

click “OK” button.

2.Load Session.

Click the “Open a Saved Session” in task window, select a session file.

then show the wizard form, click a few “Next” to import XML to Azure.

Download FileToDB

Run in command line for importing XML to Azure

You can run “XML to Azure” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

The “Save & Make Batch File” form shows.

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\FileToDB"
FileToDB task="C:\Users\pansh\Documents\test.ldr" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Download FileToDB

Run as scheduled task for importing XML to Azure

You can run “XML to Azure” conversion automatically at specific time.

On Linux/macOS, you can use Crontab.

For macOS, How to Fix Cron Permission Issues in macOS.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.

And then, with scheduled task wizard, step by step.

You’ll see created task listed in scheduled task list.

Download

Here you can download FileToDB, and buy FileToDB.