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
Hi, I'm devops AWS php developer, apparently your project seems simple we can talk in detail about it
Bu iş için 12 freelancer ortalamada $163 teklif veriyor
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
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