Process XML files into MySQL
€30-250 EUR
Plačilo ob prevzemu
I'm uploading XML files (see example) of invoices to my FTP from my ERP.
IMPORT
I want to process them and and import them into a MySQL database and then move the file into processed folder if sucessful. If failed moved into a folder which indicates files, not processed.
UPDATE
Also if a file with the same index/invoice number/same document number is processed, then process them and update the database record with the changes.
Desired structure is to process them into 3 tables:
- Customer table (Customer Number, Name, Adress, delivery adress, phone, etc)
- Invoices (With the OOI_HEAD information in the XML file) and then connect them Customer number.
- Articles ( With the OOI_ROW_ information ) and then connect them Invoice number and Customer number.
Then put a cron-job on the server to process them every 24 hours.
ID projekta: #31503660
Več o projektu
33 freelancerjev ponuja v povprečju za €147 na tem delu
Hello. Hope you're doing well ! I am expert at various programming and designing skills having 8+ years of experience in PHP, MYSQL, HTML, CSS, DATA PROCESSING, XML and many other. Please review our portfolio. I wo Več
Yes I can Process XML files into MySQL, message me i am ready to start work from now.
Hi, I have read your project details its pretty simple task for me please message me for other details I have good experience on MYsql please knock me on chat box thanks
Solution: - A custom PHP script can read your XML file and update your Mysql database. It can be scheduled with a common Linux cron task Comments: - Please send me examples of your XML files Questions: - What PHP Več
I have some queries regarding the specifications that you have provided. Could we please have a chat? My Skills: XML, Data Processing, PHP and MySQL
+++++++++++++++++++++++++++ Hello Johan, Hope you are doing well. I have read about your opportunity and my skills are matching your requirements and I have 5+ years of relevant experience in required skills Let's Več
Hi there, I'm able to create a tool to process your XML from a upload directory and save to your database. i need sample your XML file and your database structure for table Customer, Invoices, Articles. I am a FullSta Več
Hi, I have a lot of experience in data processing. I also have a master's degree in data science. You can see my reviews to prove to you that I worked well on data projects. Your project is a challenge for me. Let's d Več
Yo! I am an expert Full stack programmer with skills including MySQL, XML, PHP and Data Processing etc. Very Thanks for positing "Process XML files into MySQL" and I checked description carefully My main skills are fr Več
Hello, I can help you with Process XML files into MySQL I have more than 5 years of experience in below listed skills: PHP XML Data Processing MySQL I have gone through your job posting and become very much interes Več
hello i have read your requirements and suggestion.i appreciate your consideration ,i look forward to working with you and your organization. I await your reply with interest.
The extensive knowledge in tools like MySQL, Excel, .NET Application help us to achieve any goal as required. Please do allow us to serve you.
Hi! My name is Md Danish Mukarram and I am a data entry expert and I would love to work with you. I have completed many works like yours and I can assure you that I will send your work in less than no time. I will do Več
I have experience in doing these type of project ..... And I have done so many project like these ..... So I will definately do it