I gang

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.

The description has an error.
It will not be Microsoft SQL server 2012, it will be SQL server 2008 R2.

It should be a console app or a separate DLL which can be called from a console application

Færdigheder: .NET, C# Programmering, Software Arkitektur, SQL, XML

Se mere: schema update, find the operator, find master program, find operator, tour operator, need a net operator, import XML, import sql, 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

Om arbejdsgiveren:
( 11 bedømmelser ) Leusden, Netherlands

Projekt-ID: #4055707

Tildelt til:

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 in 14 dage
(293 bedømmelser)
7.5

31 freelancere byder i gennemsnit $177 for dette job

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 in 7 dage
(58 bedømmelser)
6.8
siberiangirl

Hello, Please, check PM. Regards, Elena

$250 USD in 10 dage
(133 bedømmelser)
5.9
MMaghawry

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

$150 USD in 4 dage
(53 bedømmelser)
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 in 7 dage
(27 bedømmelser)
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 Mere

$200 USD in 8 dage
(2 bedømmelser)
5.5
nextGenSol2002

Hi We are interested in your project. Thanks

$100 USD in 4 dage
(150 bedømmelser)
5.5
ITservice

Hi Pls check PMB for complete proposal detail. regards

$200 USD in 3 dage
(25 bedømmelser)
5.4
H3Solutions

We deliver quality with excellence. More info in PM

$200 USD in 7 dage
(10 bedømmelser)
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 Mere

$230 USD in 14 dage
(14 bedømmelser)
5.0
kalpesh2804

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

$80 USD in 7 dage
(41 bedømmelser)
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 Mere

$150 USD in 3 dage
(31 bedømmelser)
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 Mere

$165 USD in 3 dage
(35 bedømmelser)
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 [url removed, login to view]~~1c816a9808195aeb/ we have 100% compl Mere

$100 USD in 5 dage
(14 bedømmelser)
4.7
dumbraveanualin

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

$180 USD in 10 dage
(20 bedømmelser)
4.7
kultech

I can done. Please check PM. Thank you

$200 USD in 5 dage
(17 bedømmelser)
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 Mere

$350 USD in 10 dage
(3 bedømmelser)
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 [url removed, login to view] have expert programmers who can write a robust and bug-free system at the very first Mere

$250 USD in 7 dage
(11 bedømmelser)
4.1
ultrasonicsoft

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

$200 USD in 10 dage
(4 bedømmelser)
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 Mere

$55 USD in 3 dage
(6 bedømmelser)
3.8
aegansys

c/c++/c# developer

$50 USD in 2 dage
(9 bedømmelser)
3.7