Sedang Disiapkan

Import an XML feed

Hi,

I need a program to be written which imports a XML files into an Microsoft SQL server 2012 (Express) DB.

The program needs to be written in C# with .NET 4.0 or 4.5.

The XML files contains holidays and they need to be inserted into multiple tables. Database schema is provided on request. XML files are found on a web address (available on request).

This is whats needs to be done.

There are 2 types of files.

1. Seeder file, this file contains the whole feed of all items.

2. Update File, this file contains all alterations to the master database from a specific time stamp.

Per record found in the XML the following needs to be done:

Check type of record, (Update/Delete/Insert) if type cannot be found handle as a Update/Insert

For update/Insert

Check if Accommodation is found in Accommodation, table, if not insert, if found update

Check if country is found in country table, if not insert

Check if region is found in country table, if not insert

Check if city is found in city table, if not insert

Check if tour operator is found in tourOperator table, if not insert

Check if category is found in Category table, if not insert

Check if subcategory is found in SubCategory table, if not insert

Check if trip is found in Trip table , if not insert, if found update with new values from XML and other tables

For Delete

Find trip in Trip table, if found delete

Not every XML record contains the same fields. If fields are found they need to be inserted, if not they need to be left empty.

Inserts/Updates per table as shown in the DB schema.

The program needs to be written in C# with .NET 4.0 or 4.5 and well documented.

Delivery will be the source code for this written/available in Visual Studio 2010.

The code should be written Object oriented and in such a way that it can be extended later on.

Before the final payment the code will be audited and should be shown working/delivered.

Kemahiran: .NET, Pengaturcaraan C#, Kejuruteraan Perisian, SQL, XML

Lihat lebih lanjut: schema update, find master program, find operator, tour operator, need net operator, category object, import category, update insert sql, sql insert net, net 2010 express database, update sql table xml, xml request net, feed server, feed file, payment database schema, 2010 import xml sql, import xml file database, feed file database, sql server update file, import xml files, xml file import sql, feed import, insert xml tables, microsoft server 2012, import visual studio 2010

Tentang Majikan:
( 11 ulasan ) Leusden, Netherlands

ID Projek: #4055707

Dianugerahkan kepada:

RockStone435

It looks to be an interesting job. However, the XML link may please be provided to analyse it in more detail. It should also be conveyed whether the program needs to be a windows service or a desktop application?

$175 USD dalam 14 hari
(293 Ulasan)
7.5

31 pekerja bebas membida secara purata $177 untuk pekerjaan ini

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$240 USD dalam 7 hari
(58 Ulasan)
6.8
siberiangirl

Hello, Please, check PM. Regards, Elena

$250 USD dalam 10 hari
(133 Ulasan)
5.9
MMaghawry

I'm professional in .Net with SQL Server , so pleas let me do it.

$150 USD dalam 4 hari
(53 Ulasan)
5.7
samitXI

i am interested and fit your requirement . i am honest, dedicated,self-motivated, result oriented and time bound person. i deliver what you need.

$300 USD dalam 7 hari
(27 Ulasan)
5.5
orangelab

Hi there, Greetings! I've gone through your requirements to imports a XML files into an Microsoft SQL server 2012 DB with mentioned features and We have an integrated team of web professionals, creative designe Lagi

$200 USD dalam 8 hari
(2 Ulasan)
5.5
nextGenSol2002

Hi We are interested in your project. Thanks

$100 USD dalam 4 hari
(150 Ulasan)
5.5
ITservice

Hi Pls check PMB for complete proposal detail. regards

$200 USD dalam 3 hari
(25 Ulasan)
5.4
H3Solutions

We deliver quality with excellence. More info in PM

$200 USD dalam 7 hari
(10 Ulasan)
5.5
ArsenMkrt

Hi, You can find this kind of project done completed with excelent rate in my already done projects list. the main purposes of that project was to request feeds and insert to db. Originally I created windows service Lagi

$230 USD dalam 14 hari
(14 Ulasan)
5.0
kalpesh2804

Hi, I have experience in Conversion of XML to MSSQL. Please Check PMB.

$80 USD dalam 7 hari
(41 Ulasan)
4.9
manhpham

Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. Please refer feedbacks from my customers. About your project, I read your requirements and very interested in your post. D Lagi

$150 USD dalam 3 hari
(31 Ulasan)
4.9
codedeveloperin

Hi, WE have good experience in Microsoft technologies and completed 20+ projects successfully through freelancer.com. Kindly consider us for this project . From experience i would recommend SSIS (Microsoft tec Lagi

$165 USD dalam 3 hari
(35 Ulasan)
4.9
csharpdotnettech

sir we are expert .Net, C#, php, html, css developer(among Top 10% programmers with 91% percentile) u can view my profile https://www.odesk.com/o/profiles/users/Dot-Net-Tech_~~1c816a9808195aeb/ we have 100% compl Lagi

$100 USD dalam 5 hari
(14 Ulasan)
4.7
dumbraveanualin

----------------------------

$180 USD dalam 10 hari
(20 Ulasan)
4.7
kultech

I can done. Please check PM. Thank you

$200 USD dalam 5 hari
(17 Ulasan)
4.7
mehboobafridi786

Highly experienced in .Net and MS-SQL. I have done similar projects in past. Our aim is not to outbid but to satisfy our clients with good ROI focusing on quality, not quantity. Ready to go for your project. Than Lagi

$350 USD dalam 10 hari
(3 Ulasan)
4.2
murtaza1981

I(Myself a senior ASP.NET programmer) have a team having experience of more than 7+years in developing web and mobile applications.We have expert programmers who can write a robust and bug-free system at the very first Lagi

$250 USD dalam 7 hari
(11 Ulasan)
4.1
ultrasonicsoft

Hi, I have very strong hands on C#.NET. I can deliver you this project. Please check inbox.

$200 USD dalam 10 hari
(4 Ulasan)
4.0
Devoji

With the .NET version specified, it simply make the work easier. I intend to make use of my LINQ TO XML which makes the XML data read, parsed and queried easily. I will develop it as a library with comments for e Lagi

$55 USD dalam 3 hari
(6 Ulasan)
3.8
aegansys

c/c++/c# developer

$50 USD dalam 2 hari
(9 Ulasan)
3.7