Find Jobs
Hire Freelancers

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.
Proje No: 9115023

Proje hakkında

13 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 8 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
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
Kullanıcı Avatarı
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.
$126 USD 1 gün içinde
5,0 (233 değerlendirme)
8,6
8,6
Kullanıcı Avatarı
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
$105 USD 1 gün içinde
5,0 (925 değerlendirme)
8,5
8,5
Kullanıcı Avatarı
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
$100 USD 2 gün içinde
4,9 (778 değerlendirme)
8,3
8,3
Kullanıcı Avatarı
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
$100 USD 0 gün içinde
4,9 (71 değerlendirme)
7,5
7,5
Kullanıcı Avatarı
A proposal has not yet been provided
$59 USD 1 gün içinde
4,8 (32 değerlendirme)
5,9
5,9
Kullanıcı Avatarı
HELLO I M EXPERT IN PRODUCT UPLOADING BY CSV PLZ REFER TO MY FEEDBACK FOR OLD PROJECTS AND ITS FEEDBACKS
$222 USD 1 gün içinde
5,0 (81 değerlendirme)
5,7
5,7
Kullanıcı Avatarı
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.
$80 USD 3 gün içinde
4,9 (58 değerlendirme)
6,0
6,0
Kullanıcı Avatarı
A proposal has not yet been provided
$80 USD 1 gün içinde
5,0 (40 değerlendirme)
5,4
5,4
Kullanıcı Avatarı
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.
$100 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
A proposal has not yet been provided
$106 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED STATES bayrağı
Salt Lake City, United States
5,0
4
Ödeme yöntemi onaylandı
Eki 24, 2015 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.