Completed wizard for importing XML data into MS SQL

This project was successfully completed by shiefuzzaman for $100 USD in 7 days.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
7 days
Total Bids
Project Description

I have 3 URLs generated by a 3rd party's Rest API Web Service. Each of these 3 URLs contains data in a structured XML format. The fields in any of these XML files correspond to columns in a single table in the database where that data needs to be imported (each XML file corresponds however to a different table).

I would like to have an import wizard in an [url removed, login to view] web interface to automate the importing of that data into the already existing MS SQL database. The screens of the wizard should be as follows:

1st step) User chooses the datasource (i.e. chooses URL A, B or C)

2nd step) User is presented with the data for the first 3 items in the chosen data source so that the user can confirm the data values 'looks' correct before importing

3rd step) The user is presented with a 3 column tabular presentation of (a) the name of all fields in the XML file that are available for importing (b) the corresponding name of the database table-column into which that field will be imported and (c) a check box for each field where the user checks the box to confirm they want that data to be imported into that column. On this page the user will click an 'Import' data button to launch the importing of data (whose check box was checked).

4th step) the user is brought to a confirmation page. This page should also present info on the results of the import (number of rows update, any SQL errors in the process, etc).

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online