From XML-data to MS SQL database to MS Excel file

Selesai Dipasang Jul 3, 2012 Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

We need to have a program that use XML commands to access a database and collect information every hour or minute and store the information in a MS SQL-database.

We also need a form to export the information from the MS SQL-database to a MS Excel file.

## Deliverables

We need to have a program that use XML commands to access a database and collect information every hour or minute and store the information in a MS SQL-database. This program will be running on our server all the time, but must be possible to start and stop.

All setting to this program will be done in the the form (se below).

The database has about 3 million records, but we already have information for the first 2,9 million records. Every day, about 2000 new records are created, and all new records use a serial number such as: 8089847, 8089848, 8089849 and so on. This Field is called "CompanyNumber"

It is possible to send only one XML question every 2 seconds (I think).

All technical information about the XML-database is found at: Companieshouse

Click on "File Information" | "XML Gateway"

The first 2,8 million records is in four different Excel-files and I can send that files to you.

After that, the XML program must check for new information every minute.

We also need a form to export the information from the MS SQL-database to a MS Excel file. The search criteria will mostly be the "IncorporationDate", but we also want to use other search criteria and be able to export to a plain text file. Before we press the button 'Export' we need to know the numbers of records to be exported.

We will host all data, script, software and forms on our servers. We have the control of the server and are able to install any kind of plug in's or software.

MySQL Pemasangan kode program Shell Script Perancangan Perangkat Lunak Destop Windows

ID Proyek: #2756176

Tentang proyek

7 proposal Proyek online Aktif Jul 7, 2012

Diberikan kepada:

muhammadilyas14

See private message.

$100.3 USD dalam 24 hari
(31 Ulasan)
3.9

7 freelancer rata-rata menawar $421 untuk pekerjaan ini

DandDSolutions

See private message.

$297.5 USD dalam 24 hari
(195 Ulasan)
6.7
sinharavi

See private message.

$467.5 USD dalam 24 hari
(82 Ulasan)
5.9
vnb400sl

See private message.

$350.2 USD dalam 24 hari
(116 Ulasan)
5.8
expertcoder1vw

See private message.

$400.35 USD dalam 24 hari
(36 Ulasan)
5.3
oasis21

See private message.

$340 USD dalam 24 hari
(38 Ulasan)
4.7
prakashmondal

See private message.

$191.25 USD dalam 24 hari
(17 Ulasan)
3.4
badawivw

See private message.

$1200.2 USD dalam 24 hari
(10 Ulasan)
2.7