You have chosen to sponsor your bid up to a maximum amount of .
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 ASp.net 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).