In Progress

C# complex XML parser

Hello,

I have an complex XML file which has lots of nested elements and need help in creating a program/method that parses this information into a single flat table (dataset object). Please refer to the sample XML file attached so you can get a better idea of what it looks like.

I'm currently working on a C# program that will read this xml file and put it in a SQL Server database/table.

However, because the file has a lots of nested elements I'm struggling a bit to turn this into a single table where I can see all of the data. Hoping that a skilled freelancer that has experience in working with XML and C# can create this.

Each base element (<ServiceFeeEventList> or <RefundEventList>) have its own columns but some are present in each, like CurrencyAmount or SellerSKU and so when every element is combined into the single table, use the same column wherever it appears (in other words, no duplicate columns)

So, here's what I need:

- a C# program/method that takes a string parameter to either A) path to the XML file or B) the actual XML text

- Generic enough so that it can work with other elements that are not present in the provided sample, ideally without having to adapt the code.

Looking forward to your input. Let me know if you've done something similar.

thank you

Skills: C# Programming, XML

See more: linq to xml c# query examples, xdocument namespace, parse xml c#, read xml linq c#, read xml node value in c# using linq, xdocument linq, read data from xml file in c# using linq, c# xdocument

About the Employer:
( 0 reviews ) Portugal

Project ID: #14901208

Awarded to:

BitSDestiny

With my 9+ years of Software Development experience like to work on your project XML Parser, Please see my reviews to consider me as your development member. Relevant Skills and Experience ASP.Net, C#, VB.Net, MVC, WP More

$150 USD in 3 days
(11 Reviews)
4.9

12 freelancers are bidding on average $146 for this job

mauricemarinus

XML to dataset / datatable? Easy peasy. I just need to find the code Relevant Skills and Experience 10+ years .Net Proposed Milestones $50 USD - Delivery

$50 USD in 3 days
(48 Reviews)
5.2
Ahmed818

hello, it is easy job for me i am expert in data conversion jobs from/to csv, xml , excel , sql server , json , txt waiting your answer Regards Relevant Skills and Experience c# Proposed Milestones $120 USD - c# More

$120 USD in 2 days
(15 Reviews)
4.3
IMExpertEngineer

Hi, I've seen your xml file and I can create single sql server table that will map to this xml file and will save data in sql server db according to file. Thanks Relevant Skills and Experience c#,xml Proposed Miles More

$250 USD in 3 days
(3 Reviews)
4.3
bailong19891228

If you're interested in top quality work and communication please read on! You can feel free to check out my portfolio available through my freelancer profile. Relevant Skills and Experience Keep in mind I have a wide More

$155 USD in 3 days
(5 Reviews)
3.1
$155 USD in 3 days
(1 Review)
3.1
$100 USD in 3 days
(2 Reviews)
2.3
$155 USD in 3 days
(2 Reviews)
2.6
$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$150 USD in 3 days
(1 Review)
0.0
$155 USD in 3 days
(0 Reviews)
0.0