Open

Script - Download different data files from FTP, make a master file and update a SQL Table - or better solution for different suppliers in prestashop

I'll be brief,

I need a script in ubuntu linux 18.04 (VPS server) to be able to download 2 different files from an FTP, a 3rd local data file, combine data in a common file and update a database (SQL) with the data from this common file

- File 1: downloaded from FTP server 1, file data is in xml format

- File 2: downloaded from FTP server 2, file is in a .zip, file data is in .txt (comma separated - csv)

- File 3: local .xls file

The delivarable is a file with the 3 datas combined and organized, and this data is going to be used to upload a SQL DB for an e-commerce page in prestashop

If you have a better solution for multiple suppliers in prestashop let me know

Skills: Linux, Prestashop, PHP, MySQL, Software Architecture

See more: import text file existing table sql server 2005, update database using script file, import csv file existing table sql server 2005, import csv file table sql server 2005 express, script file sql server oracle, sql update xls file, extract table sql backup file bak, php script csv update table sql, mysql execute script file table update, sql update database file, convert sql table sql script, sql update csv file, fill table sql xml file, import text file existing table sql 2005, asp script export table sql dts, installation create table sql php script, extract table sql bak file, update table sql management studio csv file, Specification 1. The program should read the data that is contained in a comma-separated text file and store the information in

About the Employer:
( 0 reviews ) Mexico City, Mexico

Project ID: #21718987

7 freelancers are bidding on average $29 for this job

gopal1995

I am senior Prestashop & wordpress developer and having more than 8 years of experience.I have developed a wide range of websites using HMTL, DHTML, PHP, Prestashop, Wordpress.I am working only on prestashop around la More

$20 USD in 7 days
(77 Reviews)
7.0
kaloyan13

I am master in bash, and can write you a script to process your data files into one master file. Thank you.

$30 USD in 1 day
(293 Reviews)
6.9
inforafeesoft

Hi sir I'm a [login to view URL] Engineer Database Administrator and System Administrator Also Network Administrator I'm expert in Web Development,Database (My SQL,MS SQL,Azure,AWS,Mongo Db,Postgre DB,Magento ...etc), Java, Ja More

$30 USD in 1 day
(2 Reviews)
3.2
Appicsoftwares

Hello, We are a Prestashop Premium Partner Webdevelopment Agency with 7+ years of experience in Website Development Domain. We helped many of our clients on board with their website and transit them from older to the n More

$20 USD in 7 days
(3 Reviews)
2.5
achyuthdeb

I HAVE MY OWN VPS @[login to view URL]  RUNNING ON CENTOS 7 AND THEREFORE I CAN DO IT EASILY. I can start the work as soon as you approve me the same and submit the deliverables in agreed timeline with quality and optimize More

$30 USD in 1 day
(0 Reviews)
0.0
l0ginp

Hi, I am keen to work for those who need an expert in SQL Language and Database System. More than 7 years experience in many project on SQL, non-SQL, and Database Management such as MS SQL, Oracle, mySQL, Postgresql, M More

$50 USD in 5 days
(0 Reviews)
0.0
sj5934416

Laptop Relevant Skills and Experience Laptop

$25 USD in 1 day
(0 Reviews)
0.0