PHP script converting UTF-8 CSV file to field list sql insert statement.
$10-100 USD
Tamamlandı
İlan edilme: 8 yıldan fazla önce
$10-100 USD
Teslimde ödenir
I need a PHP script that can convert multiple UTF-8 ENCODED CSV files stored in a server folder into MYSQL compatible SQL insert commands which first truncate the destination tables, then execute data insertion. I need the columns to be inserted into SPECIFIC database columns, which are defined by the CSV headers (1st row). The tables are defined by the actual file name. The CSV column count will not always perfectly match the destination table! This is crucial to understand my problem and why the field list is needed. The PHP file should process & execute insertion for all CSV files in the folder.
NOTE!!! These are large CSV files - my server stack is configured to handle them. You will need to raise your resource limits to work on this project.
MYSQL CONNECTION: Must use PDO_MYSQL driver.
EXAMPLE:
[login to view URL] ---->>>>> Auto detect and transform to:
TRUNCATE TABLE `action-keys`;
INSERT INTO `action-keys` (`_ID`,`_IDfile-segments`,`action-key`,`action-keys`,`case-file`)
VALUES('1','1','00',' ','');
VALUES('1','45','00',' ','');
VALUES('1','100','00',' ','');
It must be very EXPLICIT table & column insertion for every row in every CSV file. If you can streamline the SQL more and still make this work as outlined, I'm fine with that.
Sample Database & CSV files are attached to this project.
Hello. At first note: you did not attach sample database, only CSV-files are in attached archive. So now it's impossible to check all output SQL. All other is absolutely clear for me and I'm ready to do this project
$80 USD 1 gün içinde
5,0 (50 değerlendirme)
5,8
5,8
13 freelancers are bidding on average $100 USD for this job
Hi Dear, I saw your description carefully, and very interested in your project.
I'm php, android, java developer, and can do it I think.
I'm highly experienced Web Shopping, Web design,Web development, Wordpress, Joomla, HTML etc.
and did successfuly similar project like this.
If you give me the chance, I'll do the best for you. thanks for Regards.
Hello!
With 98% to 99% completion rate, 850+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :)
I am available to get started on your project right away. I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
I have read your project details, and I am interested in offering my services.
I provide 100% satisfaction guaranteed on all my work.
Milestone is required to begin; to be released when the job has been satisfactorily completed.
I estimate a 24-48hr turnaround (including weekends) on this project.
ftp details to your server will be required.
Contact me at your soonest convenience so we may get your solution delivered quickly.
Thanks,
coderXO
Hi, I can START as soon as TODAY, I can work with your files, and provide you with mysql database ready for you to work with processed by a PHP script.
______________________________________________________________
___a) UNLIMITED REVISIONS ____________________ALWAYS!
___b) 100 DAYS FREE SUPPORT __________________ALWAYS!
___c) Have it DONE RIGHT the FIRST TIME _________________
___d) 10% OFF to returning customers ______________________
___e) 220+ POSITIVE REVIEWS _____________________________
___f) NOT a single red/bad review EVER!____________________
___g) 10+ years of EXPERIENCE as a PRO Developer _______
___h) SATISFACTION GUARANTEE ________________________
___i) WORK with REAL DEVELOPERS, not middle-men
I've developed many web applications using plain LAMP models, open source CMS such as WordPress, Joomla, Magento, Drupal and also general purpose languages like Ruby, Java, Python among other enterprise software for the last ten years. I could certainly program the CSV to MySQL database script you require within time, budget and to your satisfaction. Please view my portfolio for similar projects and contact me for more details.
Hello, i would like to make this project i have more than 8 years working with big data systems and this project seems to me like it has a lot of data process.
Please visit my protafolio to see my work, if you have any question please feel free to contact me.