Đã Hủy

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

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.

Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.

Kỹ năng: MySQL, Thiết lập Bản thảo, Kiến trúc phần mềm, Màn hình Windows

Xem thêm: sql database program, project xml export, export project, excel windows, data host, 2000 seconds, xml export, xml excel, sql software, sql commands, sql access, sql 2012, ms sql, MS excel, install database, field steps, data text file, access sql, access 2000 database, database question, sql created, excel project use database, check data excel files, sql different, excel number word

Về Bên Thuê:
( 91 nhận xét ) Cairo, Egypt

Mã Dự Án: #1735341

8 freelancer đang chào giá trung bình $215 cho công việc này

softtechy

Understood Hi, Please view my Private message for more information. THanks,

$250 USD trong 5 ngày
(4 Đánh Giá)
3.3
dleder

Greetings. Understood. Please check your PM.

$200 USD trong 5 ngày
(1 Đánh Giá)
3.0
NightCoders

Plz See PMB.

$220 USD trong 5 ngày
(1 Đánh Giá)
3.0
agiletechonline

Hello, We are a team of developers who are experts in .Net technology and working on this field for more than 5 years. We have previously made xml parser.

$150 USD trong 10 ngày
(0 Đánh Giá)
0.0
FN9xuQ2D5

Custom software development - The Administrator removed this message due to advertising which breaches our Terms and Conditions.

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0
webindeed

Dear Client, We (Webindeed) have gone through your requirements, and are pretty sure can provide you the quality solution which you are expecting. Further details are provided in the private message box.

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0
assuranceES

Hello, "Understood". We can work on this project. Thanks K

$250 USD trong 4 ngày
(0 Đánh Giá)
0.0
deepakdwi

Understood, Please check PM.

$200 USD trong 5 ngày
(0 Đánh Giá)
0.0