Find Jobs
Hire Freelancers

Convert XML import to a sql database

$250-750 USD

Ukończony
Opublikowano ponad 8 lat temu

$250-750 USD

Płatne przy odbiorze
. We are importing an XML file daily and converting it to a csv manually, then importing that into SQL. The conversion is creating multiple columns of the same name adding a numberic value to the new columns and we are coalescing these columns to the original column, IE,, Routeid, will create a new routeid1, routeid2 etc, etc...We need to automate that process. The previous attempt has been unsuccessful and lacked follow through to verify the conversion works. Do not submit a proposal if you lack the ability to check your work, as I am not checking your work for you.
Identyfikator projektu: 9061437

Informację o projekcie

52 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
Hi, I have worked with SQL Server since 7.0. I was active on community websites [login to view URL], [login to view URL] and also [login to view URL] On that last website, I was Expert of the Year 2010 (overall) for exemplary contribution to mostly SQL Server problems. I also hold a day job as part DBA, part Software Architect team lead. Now my questions - what was your previous attempt done in? Which edition of SQL Server is this - is it enterprise with integration tools (SSIS)? If not SSIS, then we can use a custom program such as a Powershell script. Do you have a sample XML file for me to look at and a schema of the destination table? Regards.. Richard
$350 USD w 8 dni
5,0 (39 opinii)
5,6
5,6
52 freelancerzy składają oferty o średniej wysokości $454 USD dla tej pracy
Awatar Użytkownika
Hello!!! I have full experience in JSP, JQuery, PHP technologies. also , i have master laravel and codeigniter frameworks and anglar js, node js templates. keep in touch. my dear.
$526 USD w 10 dni
5,0 (13 opinii)
6,1
6,1
Awatar Użytkownika
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactorily completed. I estimate a 5-7 day turnaround (including weekends) on this project. ftp details to your server will be required. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$550 USD w 6 dni
4,8 (89 opinii)
6,4
6,4
Awatar Użytkownika
Hi, I am Nallakumar. I have more than 9 years of experience in SQL Server. We can create a Desktop application in C# that will allow you to import the CSV file (we can even create a scheduler event in the server to run this application to get the file from a selected location and process). The program will do the necessary conversion and do a bulk import to the database. I will be able to verify the program is working 100% and deliver you. Thanks, Nalla
$300 USD w 2 dni
5,0 (17 opinii)
5,7
5,7
Awatar Użytkownika
Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. Please check my my recent work for the technical expertise along with reviews & feedback on my profile page.
$721 USD w 10 dni
4,9 (4 opinii)
5,7
5,7
Awatar Użytkownika
Hello Sir, I implemented many ETLs process at my company to handle the big of XML data files from 3rd party data. I can show you by screen share the ETLS which i worked. Hope we can work together on this project. Also, i can change/improve your SSIS packages to run all correctly. I worked with SSIS many before. Thanks Thanh
$500 USD w 7 dni
5,0 (39 opinii)
5,5
5,5
Awatar Użytkownika
I have lots of experience doing this type of import/conversion work. I'm sorry to hear that you had a failed attempt previously. I do have a couple of questions for you: 1. What database engine are you using? MySQL, Oracle, SQL Server, etc? 2. What language would you like the import process written in? 3. Can you tell me where the XML file comes from? This doesn't matter for purposes of my bid, I'm just curious. Ideally, I'd like to start with a copy of the database as you generated it by hand from the XML file. That way I can make sure my import process generates identical results, or at least go over any discrepancies with you and make sure they're what you expect. Also, I note that while I do ask that you create the milestone payment before I begin work, I definitely don't ask that you release it I've delivered the code and you're completely satisfied. Thanks very much for considering my bid!
$350 USD w 2 dni
5,0 (7 opinii)
5,0
5,0
Awatar Użytkownika
Hello Sir /Ma'am , Greetings from Votive Technologies!! We have good experience team of Core PHP, PHP frameworks, PHP- CMS's, PHP - Ecommerce, Mysql, Responsive Web Designs, Ajax, jquery, JavaScript, Json, Photoshop, Graphics, Banner, Flyer and Logo Designs, Payment-Gateways, gMap. Please review my profile at: www.freelancer.com/u/michale21.html ******************************************* Please do not hesitate to contact us and feel free to share your queries, we will glad to assist you. Kindly give us an opportunity to work for you at our best. Regards, Nakul Votive Technologies
$450 USD w 7 dni
4,5 (10 opinii)
5,7
5,7
Awatar Użytkownika
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: I am an expert in excel/VBA, VB.net and C#. Databases are not a problem. Please check my portfolio/profile/reviews. Please more info in PM if you are interested. Thank you. :) I await your reply. With Kind Regards Boris
$600 USD w 7 dni
4,9 (22 opinii)
5,2
5,2
Awatar Użytkownika
This can be done using the SSIS which will basically import the xml file into a temp table and then do the transformations on it to provide correct data which can be then imported into a main table . This can be run as a job which runs every n hours or but creating a job which will basically look for the file every 5-10 mins if it finds the file import is done else the job will not continue further
$611 USD w 5 dni
5,0 (3 opinii)
4,9
4,9
Awatar Użytkownika
Hi sir , I have more than 6 years of experience in .net technologies. I can complete your work fast. Please send me more details. Thank you.
$250 USD w 3 dni
4,9 (9 opinii)
4,7
4,7
Awatar Użytkownika
Dear Sir, I am expert in this. I have done several projects like this one. Please take a look at my reviews. Thanks...........
$250 USD w 5 dni
4,9 (13 opinii)
4,5
4,5
Awatar Użytkownika
Hi. I'm professional software developer and I'm interesting in your project because I have experience with XML parsing and data processing (similar jobs: https://www.freelancer.com/projects/Java-Cocoa/Build-Application-Extract-Data-from.4741688/ https://www.freelancer.com/projects/project-4845877/). I preferred in TDD (Test-Driven-Development) and I'm providing free one month support/bugfix for my applications. Regards, Dmitry
$598 USD w 7 dni
5,0 (15 opinii)
4,3
4,3
Awatar Użytkownika
Hi, I am 5 years experienced web developer. I understand your point. I can complete this project within two days. Please check my profile for my work quality . Thanks, Bhaskar Mandal
$250 USD w 3 dni
4,9 (7 opinii)
3,9
3,9
Awatar Użytkownika
Hi, This is not a complicated doable project. However, why do you want to create multiple columns instead of multiple rows on a related table? Can I know how this is the data being consumed so I can provide you a better solution? Multiple column really violates a lot of data modelling designs. Looking forward hearing from you
$555 USD w 10 dni
4,8 (7 opinii)
4,0
4,0
Awatar Użytkownika
Hi Myself expert in asp.net (webforms and mvc5), c#.net and sql server with 10 yrs of experience in software development. Developed various applications for finance, insurance , education and research domains. Will create a web based application using ASp.net , c# and sql server. First will show u proof of concept. If u want desktop application then will convert that application in Desktop based. Payment terms: (After showing proof of concept) 1. 30% release on Awarding the project 2. 40% release on UAT 3. 20% release on UAT sign off 4. 10% release on Project Completion Awaiting for positive reply. Thanks and Regards..
$250 USD w 10 dni
4,7 (8 opinii)
4,2
4,2
Awatar Użytkownika
Hello! The task description is lacking detail, so is there any way you can send a set of three things: one of those XML source files(one that had already been manually processed, so it can be used for cross-referencing against the CSV), the CSV that was produced out of this exact XML file and the database shema where the CSV is headed towards, so I can do some proper assessment of the job laying ahead? Regards, Dobri
$400 USD w 2 dni
4,8 (16 opinii)
4,2
4,2
Awatar Użytkownika
We are SQL Professionals and we have experts more than 10 YRS . We will deliver you in less time with quality for sure. So please let us know if we can help you .
$333 USD w 1 dzień
4,7 (11 opinii)
4,2
4,2
Awatar Użytkownika
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
$773 USD w 20 dni
4,4 (4 opinii)
4,3
4,3
Awatar Użytkownika
Hi, Your project sounds interesting and simple enough. I've done similar conversions of XML files, and generally it's not that complicated to do. However, I see that you mentioned testing and this is exactly the reason that significantly expands the time required for this and the price. Then again, the price I offered includes this testing as well. As for my experience, I worked for over 15 years as Physics and Math teacher, but I've also done a lot of both Excel and MS Word work (Macros, Templates, complex formulas), some web scraping using my software, desktop applications, web browser extensions, etc. In my portfolio you can find some screenshots of application that I made for my school-related needs. Should you have any questions about me, my work or my experience, I'll be happy to answer. In the meantime, see my reviews and kindly consider my proposal. Kindest regards. Milan
$500 USD w 10 dni
5,0 (10 opinii)
3,8
3,8
Awatar Użytkownika
I have around 8+ years experience in Java/J2EE development. Following are the list of expertise I have - 1. Frontend Technology - HTML,CSS,JQuery, ExtJS, Dojo,D3.js, AngularJS,NodeJS,ExpressJS and Javascript 2. J2EE frameworks - Struts, Spring, JSF 3. Databases - MySQL, Oracle, MSSQL server,PostgreSQL MongoDB 4. Expert in REST API/Web services development using JAX-RS, Spring 5. Expert in JSON and XML programming 6. Build Tools - Maven, Ant, Jenkins 7. Test frameoworks - Junit, TestNG, Mockito, Rest Assured, JBehave 8. Mobile website development using HTML5, CSS3, Bootstrap
$555 USD w 10 dni
5,0 (1 opinia)
3,5
3,5

O kliencie

Flaga UNITED STATES
Lodi, United States
5,0
19
Zweryfikowana metoda płatności
Członek od gru 9, 2011

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.