Find Jobs
Hire Freelancers

Incoming zipped XML file parsing to Microsoft SQL

$250-750 USD

Kapalı
İlan edilme: 9 yıldan fazla önce

$250-750 USD

Teslimde ödenir
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!
Proje No: 6841057

Proje hakkında

34 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 9 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
34 freelancers are bidding on average $537 USD for this job
Kullanıcı Avatarı
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 think the best way is to decompress these files using .net and feed it to SQL Server (using stored procedures if you like) Thanks Othman
$631 USD 5 gün içinde
5,0 (123 değerlendirme)
8,3
8,3
Kullanıcı Avatarı
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 to various databases and I am an expert with ColdFusion, which I would like to use to complete this particular project. First, I would backup your SQL database and import it to my own server for testing purposes. I can use my own server to create the necessary ColdFusion scripts. Once I have validated the results, I can move all scripts to your ColdFusion server and setup a scheduled tasks to import the XML files at whatever time interval you would like. I would need database access and FTP access to do this project and all necessary XML files. Looking forward to hearing back from you. Please let me know if you have any questions/concerns. Thanks! Sincerely, Travis Walters
$400 USD 15 gün içinde
5,0 (44 değerlendirme)
7,8
7,8
Kullanıcı Avatarı
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 that I'm able to get started and within 1-2 days deliver a fully working, testable prototype. I belive the best way to address this is to create a windows service application. It will be developed using industry standard, robust error-handling and logging and work 100% according to the agreed specs. Furthermore, I will make myself available for any future additions or modifications within a maximum of one week. I deliver complete .net source code with sufficient xml comments and a well designed application that is easy to maintain. I look forward to working with you. Should you have any questions, please just PM me via freelancer or award the project at the same time completing escrow for getting started with the preliminary skype clarification and commencing work today. thanks and regards, Janos
$778 USD 4 gün içinde
5,0 (34 değerlendirme)
7,1
7,1
Kullanıcı Avatarı
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 database. Proper error handling and logging will be implemented. I have 9 years experience in C#, Win-Forms, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web ApI and SQL Server 2008/R2/2012 for back-end. Thanks
$833 USD 3 gün içinde
4,9 (61 değerlendirme)
6,9
6,9
Kullanıcı Avatarı
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 and feedback. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander
$722 USD 10 gün içinde
4,9 (37 değerlendirme)
6,6
6,6
Kullanıcı Avatarı
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, Amanat Ali
$555 USD 10 gün içinde
4,7 (184 değerlendirme)
6,4
6,4
Kullanıcı Avatarı
A proposal has not yet been provided
$600 USD 15 gün içinde
5,0 (54 değerlendirme)
5,4
5,4
Kullanıcı Avatarı
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 as-is, then query it using SQL Server's XML syntax. The documents would be flushed and re-loaded each time you receive a new set. Another option would be to use SQL Server Integration Services (SSIS) to parse and store the required data from the input documents. This option is great for future flexibility, adding in new kinds of parsing or additional steps to the pipeline. Regarding my qualifications, I have Microsoft certification for SQL Server and have developed SQL Server based solutions for over ten years now. I am confident that I would be able to produce a solution that meets the expectations set out in your project description. Please feel free to contact me if you have any questions. I would be able to start immediately, based in Canada (Mountain Time Zone). Best regards, Jay
$340 USD 5 gün içinde
5,0 (10 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
A proposal has not yet been provided
$666 USD 5 gün içinde
5,0 (7 değerlendirme)
4,7
4,7
Kullanıcı Avatarı
A proposal has not yet been provided
$631 USD 10 gün içinde
4,9 (17 değerlendirme)
4,5
4,5
Kullanıcı Avatarı
I intend to use one of two approaches: 1.) SSIS package to run and load the Xmas files. 2.) .Net app loads the xml data, calls stored procedures with xml parameters, parses the xml data a loads it into tables for processing, Depending on the environment, there are pros and cons to both approaches.
$737 USD 3 gün içinde
5,0 (7 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
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 provide the sample of files I can say what will be simple - C# or MS SQL parser. My last project was at the same task - paring xml. Regards
$388 USD 2 gün içinde
4,6 (17 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
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 3 gün içinde
4,9 (7 değerlendirme)
4,1
4,1
Kullanıcı Avatarı
Hi, Please feel free to discuss the project with me ............................................................................. Thanks, Murtaza
$650 USD 14 gün içinde
5,0 (7 değerlendirme)
4,1
4,1
Kullanıcı Avatarı
Hello, I have familiarized with the description and I am confident I can implement a procedure that can do all of the mentioned. However, I believe it would be best to move source XML files to an another directory with ColdFusion. If it is fine with you, please send me a more detailed description, please. I would like to learn as much as possible re: this job. Thank you. Best regards, Jacek Francuz
$400 USD 3 gün içinde
4,2 (2 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
Lets do this. Give your skype for discussing about this requirement. You can pay me once completed and satisfied with the results.
$250 USD 10 gün içinde
4,8 (8 değerlendirme)
4,2
4,2
Kullanıcı Avatarı
Hello What is your version of MSSQL? The simpliest and independent of versions way is use xp_cmdshell. Then a CLR that will read and return a file content. Then default internal msxml tools I'm working in top 10 retail in Russia as SQL deleveloper. So I know what is big data and how to work with data Regards, Yuriy
$530 USD 5 gün içinde
4,9 (7 değerlendirme)
3,8
3,8
Kullanıcı Avatarı
Dear sir expert here with c# programming. already have done few similar tasks for parsing data with xml or binary and shorting with queries. let us give chance and we can complete is ASAP. we believe in long term business relationship. thanks
$555 USD 2 gün içinde
5,0 (8 değerlendirme)
3,8
3,8
Kullanıcı Avatarı
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 2 gün içinde
5,0 (9 değerlendirme)
3,7
3,7
Kullanıcı Avatarı
A proposal has not yet been provided
$666 USD 10 gün içinde
5,0 (2 değerlendirme)
0,8
0,8

Müşteri hakkında

   UNITED STATES bayrağı
Denver, United States
5,0
52
Ödeme yöntemi onaylandı
Eyl 21, 2012 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.