Đã hoàn thành

Write a PHP script to repeatedly import a number of CSV files into a relational database.

I have around 50 .CSV files which are exported daily (automatically sent to remote FTP server) from a proprietary CRM/billing system.

I do not have access to the database used for the CRM, only the exported .CSVs. Because of the difficulty in working with CSV files, I wish to convert the flat files to a relational database by running a script against the exported .CSV files every day.

Each CSV file is already roughly equivalent to a the desired table in the relational database, for example "[login to view URL]", "[login to view URL]" and "[login to view URL]". Within the .CSVs the data is structured using primary and foreign keys, with one record per row.

The structure of the .CSVs (columns etc.) does not change, but each time the .CSV files are generated they will contain all records to date i.e additional rows. Most files are 1-2MB in size but the largest is 600MB.

A sample dataset will be provided with rows limited to sample data only.

The brief for this project is to generate a script/scripts in PHP that will import all data from the CSV files into a mysql/mariadb database, using appropriate column data types, relationships, and other best practices in database design.

Kĩ năng: PHP, MySQL, SQL, Relational Databases

Xem nhiều hơn: script import access csv files, php script genrating unique number, php script save form data csv, import gbpusd csv files, php script parse phone number, write php script, example import outlook csv files, import number csv mysql, write php script collect number 100, write php script collect numbers 100, import export csv files sql express 2005, php script checkbox download list zip files, write php script collect data form, need someone write php script, import multiple csv files excel folder macro, php script wordpress import csv, write a php script to count number of lines in a file.

Về Bên Thuê:
( 0 nhận xét ) Balcatta, Australia

ID dự án: #28351159

Được trao cho:

natapataykina02

Hi, there. Glad to see you here. I have read your requirements carefully and notice that's the suitable one for me. Database management such as MySQL is my major skill. I can give you full satisfactory result for you c Thêm

$140 AUD trong 7 ngày
(26 Đánh Giá)
5.8

15 freelancer chào giá trung bình$202 cho công việc này

(121 Nhận xét)
8.6
coolguyinus2004

PHP/MYSQL/CSV script expert here with 15+ years of experience. 50 csv files with MIN 2MB size and MAX 600MB file i need to see sample of each. 1) I need to develop the database from the csv file headers with foreign ke Thêm

$300 AUD trong 7 ngày
(360 Nhận xét)
7.7
iglobalvn

Hi sir, i have read your requirement carefully. I can do PHP script that read csv and import to database daily perfectly and exactly without any risk. If you wanna confirm me, please check my work history and portfoli Thêm

$200 AUD trong 5 ngày
(103 Nhận xét)
7.3
techplusintl

Hi there, ★★★ PHP / MySQL Expert ★★★ 5+ Years of Experience ★★★ I've read requirements and ready to write a PHP script to repeatedly import a number of CSV files into a relational database.. Websites we built with PHP Thêm

$250 AUD trong 3 ngày
(189 Nhận xét)
7.3
crtvecode

Hello, Can you please show me the sample csv data file, I can able to convert the 50 .csv files into a MySQL table. I am an experienced PHP Developer. Please check my client's feedback. [login to view URL] Thêm

$249 AUD trong 10 ngày
(92 Nhận xét)
6.7
fadata

Hi I have 18 years of software development experience.I can implement a php script to import your files to the db. Lets talk about the details Regards Fatih

$240 AUD trong 3 ngày
(19 Nhận xét)
6.0
dilshadbukhari

Hi I have read the project description carefully and understood. I have extensively experience in Php. I will give you 100% accuracy work. Looking Forward Thank you

$250 AUD trong 7 ngày
(32 Nhận xét)
4.9
Ggov

Hi I have experience parsing csv files and inserting/updating related tables in relational database tables using php. Thank you for your time and attention. Looking forward to hearing from you. Regards

$180 AUD trong 7 ngày
(2 Nhận xét)
4.9
shrushtiponda

Hello There , I have 4.5 years of experience in PHP / MySQL. I have gone through the definition.I have done such works of developing scripts to import data from CSV files. Here you also need the relations while import Thêm

$225 AUD trong 6 ngày
(12 Nhận xét)
3.2
cre8ivelezend

hello, I checked your description that you entered in your project details you need a (website designer/developer)okay I can do your work with proper in manner I have a 8+ yeas of experiences of this kind of work I did Thêm

$140 AUD trong 2 ngày
(8 Nhận xét)
3.3
mantsoetoro

Hi, I see you need php program to read the data from .csv file in the hosting and then upload it to database. I can do this because i have experiences develop php program for uploading file and upload it into databas Thêm

$40 AUD trong 1 ngày
(3 Nhận xét)
2.2
arajat0

Hello, I can create you application with your specification in Node, which can be triggered manually or automatically timebound each day. Will pull files and import all data to MSSQL. Thanks

$150 AUD trong 7 ngày
(1 Nhận xét)
1.6
marlonabeykoon

I have 7+ years in PHP and python and data related development. I think this can be easily done within the agreed time period.

$190 AUD trong 5 ngày
(0 Nhận xét)
0.0
sankarveluturla

I undenrstood ur requirement,I already developed these type of projects daily so work can be done easily and fast .I will convert all .csv files as a database structure without lose of data and I prefer quality. After Thêm

$120 AUD trong 3 ngày
(0 Nhận xét)
0.0