Encerrado

Incoming zipped XML file parsing to Microsoft SQL

Hi -

I get a zipped upload of usually a couple hundred XML files and one index xml file (to reference all of the xml files included) daily. I need to create a procedure inside of SQL that will both parse the data, store it, and loop through all of the XML files (and then move all "completed" files to a different directory). If all of this can be cone inside SQL, perfect. If not, please propose your methodology. We natively are a ColdFusion environment.

There are really 4 parsing requirements...parse out the base layers of the xml (so things like name of product, sku, etc, there are only about 10 elements you have to look for here). If the product already exists, we will need to update the product data, if not, insert. Secondly, you have to insert category data into a different table ONLY if that category does not exist. If it does, you need to find that category ID and insert it into the product information table where the rest of the data went. Thirdly, there are product specs that need to be inserted into a spec table, that also have spec categories that will need to be cross referenced or stored. There are 3 different types of specs you'll need to be parse in the xml file. Finally, there are related products that will need to be placed in another table, and included in the base table if that information does not exist yet.

We've done this recently for a similar catalog (but with a different protocol) and I think it took about 10 hours of work, I'm guessing it will take a solid day, but not a whole lot more.

Please let me know if you have questions. Thanks!

Habilidades: .NET, Vale Tudo, Cold Fusion, Microsoft SQL Server , SQL

Ver mais: where to find xml files, loop net, move sql, data elements products, cone, update sql file, data coldfusion, update insert sql, sql insert net, parse data file, update sql table xml, file cross, sql table parsing, product catalog net, sql cross table, parse rest, xml move, parse sql, catalog sku, update rest table, catalog data upload, xml insert, sql upload data, sql parse, xml rest

Acerca do Empregador:
( 46 comentários ) Denver, United States

ID do Projeto: #6841057

38 freelancers estão ofertando em média $528 para este trabalho

winmaclin

Hi, ▶ I just seen your post >>> INCOMING ZIPPED XML FILE PARSING TO MICROSOFT SQL and understood explained concept, Means need to create procedure of SQL that will parse data, store it and loop through all of the XM Mais

$789 USD in 20 dias
(298 Comentários)
8.6
OShuqair

Hello there, I have 8 years of .net experience ans SQL server. I can do this task using a .net application. i remember i've searched for a way to decompress text inside SQL procedure and that didn't go well so i thi Mais

$631 USD in 5 dias
(112 Comentários)
8.2
twalters84

Hey John, I am not sure if you remember me but I worked on a project with you awhile back. I am extremely interested in this particular project. In the past, I have imported hundreds if not thousands of XML files t Mais

$400 USD in 15 dias
(41 Comentários)
7.8
CodeAmbassador

hello, Thanks for your concise description of the scope, the requirements are overly clear and fairly simple. I do have some minor points I'd like to clarify prior to commencing work but in general, am in a position t Mais

$778 USD in 4 dias
(33 Comentários)
7.0
mehta2010

We can do this using c# and sql server. This would be easy (Though it would take around 13 hours). Please check our reviews for quality of our work. We have 8+ years of experience of working over asp/[url removed, login to view] se Mais

$250 USD in 3 dias
(48 Comentários)
6.5
sikandermandal

Dear Sir, This is Sikander. I am having 12+ years of experience in software development and I am ready to start this job. I will provide you best services in development. Please have a look at my Profile, Ratings an Mais

$722 USD in 10 dias
(37 Comentários)
6.2
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of my similar experience: Amazon/Ebay Bots: [url removed, login to view] Mais

$526 USD in 10 dias
(63 Comentários)
6.6
witscomputing

Hi, I am experienced and certified ColdFusion developer with excellent skills of MSSQL. I can create the require batch/stored procedure/script to do the required job. I can start right away. Regards, Amana Mais

$555 USD in 10 dias
(175 Comentários)
6.3
feninsoftech

Hi, This can be achieved by designing a C# Console application that you can schedule in windows scheduler. Application will read zip files, unzip them and send them to SQL Server one by one to parse and save in data Mais

$833 USD in 3 dias
(31 Comentários)
6.1
super2lao

A proposal has not yet been provided

$526 USD in 10 dias
(20 Comentários)
5.7
codeindiadigital

A proposal has not yet been provided

$600 USD in 15 dias
(54 Comentários)
5.4
expatdev

Hi- I'd like to work on your project. Your time estimation is realistic (1-2 days), and I am immediately available to work. I will need access to your database server, such as Remote Desktop or similar. If that's a pro Mais

$500 USD in 2 dias
(11 Comentários)
5.4
priyankjini

Hello Sir, I have read your full project description carefully and also understand your requirement. And I am clear and sure that I can do this project As I have done many projects in before I just want to know some Mais

$250 USD in 10 dias
(17 Comentários)
5.4
ta0soft

Hi I would be happy to help with your project :) I have over 10 years of experience with C++ and C#, I specialize in Windows applications and GUI design. I also have lots of experience parsing XML files and working wit Mais

$555 USD in 10 dias
(44 Comentários)
5.4
jcsconsulting

Hi My name is Jay. I just read your project description and two options come to mind. SQL Server (since 2008 R2) allows you to store XML documents as tables. This means that we could simply store each document Mais

$340 USD in 5 dias
(10 Comentários)
4.9
skywa1kervw

Hello. Need some clarification. I can use only C# for that (or VB.Net if you prefer it). Also need to know average size of each xml file with data. Not the size of index xml file. Thanks, Pavel.

$333 USD in 2 dias
(25 Comentários)
4.6
gargitservices

A proposal has not yet been provided

$631 USD in 10 dias
(17 Comentários)
4.5
murtaza1981

Hi, Please feel free to discuss the project with me ............................................................................. Thanks, Murtaza

$650 USD in 14 dias
(7 Comentários)
4.2
suresh3c

hi, i can help you. i am ready to start now.. I can finish in one or two days.. Thanks & regards SURESH C

$722 USD in 3 dias
(7 Comentários)
4.1
DeoTech

Hello, I have more than 14 years experience in MS SQl and 7 in C#. Unzipping can be done in C# WinForms, XML can be parsed in MS SQL if xml stored at the ms sql server or send by the param of the sp. If you pr Mais

$388 USD in 2 dias
(17 Comentários)
4.6