windows 2012 server
ms sql server
some sort of script to run the process
-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
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 Daha Fazla
Bu iş için 13 freelancer ortalamada $161 teklif veriyor
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
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 Daha Fazla
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
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 Daha Fazla
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.
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 Daha Fazla
Hi, Greetings... I can load xml files from ftp site into sql server tables.I have good experience in this field and definitely meet your requirements.I will give you 100% quality [login to view URL] have a look at my Daha Fazla
Hi, CONTACT US FOR OUR PREVIOUS WORK PLEASE HAVE A LOOK INTO MY PORTFOLIO NiGELLA SOFTWARES is very interested in your job post as we are having related work experience in fulfilling the need for the job posted an Daha Fazla
Hello sir!! Myself Sumit Singh, I read the job details extremely carefully and I am absolutely sure that I can do the project very well.I have experience more than 8+ yrs. My skills are : - PHP, MySql,Python MVC Frame Daha Fazla