Find Jobs
Hire Freelancers

load xml files from ftp site into sql server tables

$30-250 USD

Completed
Posted about 7 years ago

$30-250 USD

Paid on delivery
platform windows 2012 server ms sql server ftp some sort of script to run the process requirement -access ftp folder (at moment over 7000 files there) -read xml files (named .001 for some reason) in sequentially in order of creation date and obtain file name (samples attached) -files have many names, need to look inside to see if one of 2 xml formats, to load two sql server tables will be loaded KAARTEN and VERZILVERING, sql attached. - basic rule: kaarten / activation are xml type table KAARTEN redemption / verzilvering are table VERZILVERING there can also be empty files -note date/datetime fields are varchar(25) and added field import_date to be timestamp of when it is loaded. -for tables, sql used attached, -I imagined another table in sql server that would place timestamp of creation date of last file process, then next time it runs it will check after certain timestamp. Or we can place this is a flat file somewhere… open to suggestion here. this script should run often, maybe every 15 minutes. - Note, I have triggers that run on insert into each of the 2 tables, hope there is no problem with this. attached: sample xml, sql to create 2 tables, php scripts attached FOR REFERENCE created in phase one of project when thought we were on mysql. these could be used as basis, or someone can tell me if php runs on windows? in php version: tables ID, we can add if necessary, php version also does not have correct datatype for date fields. [login to view URL] has file names of files in ftp directory as of friday
Project ID: 13419561

About the project

13 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have worked on exactly the same project before (load XML into SQL Server) that's why I'm sure you'll be impressed with my work. I can create such script according to your need in less than two days and I can offer you best price here. You have pretty good project description so all I need to start is milestone payment from you. You'll release it only after you check everything on your side. Thanks. Roman
$100 USD in 2 days
4.9 (63 reviews)
5.5
5.5
13 freelancers are bidding on average $161 USD for this job
User Avatar
Hello there I know how to connect to ftp and read files and populate the sql server using php. I can do this project as per the rules outlined in your project. Looking forward to work with you. Thanks Rinsad
$157 USD in 3 days
4.9 (135 reviews)
7.0
7.0
User Avatar
Hi, I have read your requirement and ready to start work on it. I couldn't find the table script files though. I will build and exe file which we can then put into schedular (if you have dedicated server) or we can put it on your system and schedule it to run after every 15 minutes. Thanks, Girish
$250 USD in 5 days
4.9 (75 reviews)
7.1
7.1
User Avatar
HI Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif
$222 USD in 5 days
4.9 (41 reviews)
5.3
5.3
User Avatar
I am 9+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my working domain. I am confident to complete the project.
$150 USD in 3 days
5.0 (22 reviews)
4.8
4.8
User Avatar
As description in your requirement. I'm sure to complete this tool for you. inbox me if you have any question about my skill or this project. Thank for your attention HuyPQ.
$155 USD in 3 days
4.9 (3 reviews)
3.4
3.4
User Avatar
I am production support database Administrator/Architect with 15+ years of experience . I have worked on FTP scripts/ automated import into database using scripts. I have worked year long implementation plus 24 x 7 production support projects in MSSQL / Oracle from scratch, with RAID / SAN (dell/emc), replication / cluster for terabytes of data etc environments with advanced cluster configurations hosting multi-terabyte VLDBs.
$90 USD in 3 days
5.0 (1 review)
0.4
0.4

About the client

Flag of NETHERLANDS
Amsterdam, Netherlands
4.9
5
Payment method verified
Member since Oct 7, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.