S3 to Mysql

I have a S3 bucket that will be populated with CSV files with the identifier of the source and table name in the CSV file name.

I need an automated PHP script (possibly open to other solutions) to:

1. Grab the file/contents of the CSV file immediately upon it hitting the S3 bucket,

2. Insert the file into a MySql DB using the Identifier from the file name and insert them into a table corresponding to the file name.

File name example: [login to view URL]

File contents example: FirstName, LastName, FavoriteColor

All rows will be put into mysql table = Table1

INSERT INTO 'table1' (id,source,firstName,lastName,favColor,lastUpdate) VALUES (null, 'Source1','FirstName','LastName','FavoriteColor','timestamp')

If there are added fields in the source file, the table should be altered an add the field to insert.

The file on S3 should be removed or placed into an archive for a week, then deleted.S

Beceriler: PHP, MySQL, Yazılım Mimarisi, Javascript, XML

Daha fazlasını gör: import rows mysql table, delete multiple rows mysql check box, send mail multiple rows mysql, load data from s3 to aurora postgres, load s3 data into rds postgresql table, select into outfile s3, load s3 data into amazon rds mysql table, load data from s3 to aurora mysql, aws rds import csv, aurora serverless load from s3, s3 copy activity, php display multiple rows mysql array, updating multiple rows mysql, null integer php mysql, php display rows mysql, iterate rows mysql, loop columns rows mysql php, ajax mysql php checkbox delete rows, deleting duplicate rows mysql php, draggable table rows mysql php

İşveren Hakkında:
( 17 değerlendirme ) Wilmington, United States

Proje NO: #22275433



Hi, I'm devops AWS php developer, apparently your project seems simple we can talk in detail about it

%selectedBids___i_period_sub_7% gün içinde 200%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(7 Değerlendirme)

Bu iş için 12 freelancer ortalamada $163 teklif veriyor


I am 7+ years experienced in HTML5, CSS, PHP, CRM, MVC, MySQL, Javascript, Wordpress, Shopify, joomla, drupal, opencart, jQuery, Ajax. I love to code. One thing I believe in is never quitting. I will work hard and lo Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(93 Değerlendirme)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. A Javascript, MySQL, PHP, Software Architecture, XML Expert Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(71 Değerlendirme)

Hi Mate, Hope you are doing well !! I have read job description and your requirements are fully clear to me and I am applying only because I meet all the requirements that you are looking for. I am Sr. PHP/MySQL De Daha Fazla

$250 USD in 7 gün içinde
(72 Değerlendirme)

I have AWS experience along with php and mysql. I can get this project done for you without any issues. You'd be dealing with a freelancer and not an agency and communication wouldn't be an issue

$400 USD in 4 gün içinde
(4 Değerlendirme)

Hi. I have read your job post and I am very interested in your project. I am an expert in PHP/XML/MySQL/Javascript. I am sure I can complete your project perfectly. I'd like to discuss your project on chat. Thanks for Daha Fazla

$100 USD in 4 gün içinde
(13 Değerlendirme)

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is Daha Fazla

$140 USD in 7 gün içinde
(18 Değerlendirme)

Greetings, my name is Ahmad. I am Head of Client Relations and a web-developer myself. I would love to have an opportunity to discuss your project with you. With over 5 years of experience in mobile/web design and de Daha Fazla

$140 USD in 7 gün içinde
(5 Değerlendirme)

Hello, Dear. I am a full time free develop and Web expert. CSV export/import is no problem. I have over 8 years of programming experience on the web. For details, please refer to the portfolio. Looking forward to start Daha Fazla

$140 USD in 7 gün içinde
(9 Değerlendirme)

Hello I have carefully studied the description of your project S3 to Mysql. I have deep expertise and hands on experience of 5 years with Javascript, MySQL, PHP, Software Architecture, XML I enjoy brilliant ideas of Daha Fazla

$110 USD in 6 gün içinde
(5 Değerlendirme)

hello there your job is what I can do because, it can be done by AWS lambda, and S3 invoke function That's all what I have experienced in the past Please contact me and let me know your AWS info. I can start right now Daha Fazla

$100 USD in 2 gün içinde
(3 Değerlendirme)

How are you? Thanks for your posting job. I am interested in your description of job. If you contact me, you can save your time. As a senior expert, your project is no problem for me. Please send me a message and let's Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)