Build a dynamic script to upload csv to mysql and use open rest APIs to query for additonal content

I'm looking for a developer that can build a php based script that provides

- a user interface (form) to select a file (csv)

- use the content of the file to fill a database

- use the concept of mapping tables to map the names of fields in the csv with those in the database

- use the content of the file to push a request through an API

- use the response (JSON) to fill a database

I do have 30+ variances of database tables to be filled. I don't want 30+ hardcoded scripts but effective use of a clever developed function.

Example: function upload_to_db_2 ($table,$mappingtable,$sourcefile,$api,$config){}

1) $table represents the database table which should be populated

2) $mappingtable represents the mapping of fields. Could a file or a stored mapping variable

3) $sourcefile represents the uploaded csv file

4) $api represents an array of apis (id) to be used. API's are stored in a table of such a format:

ID | api_url | api_key | s_fields (array) | r_fields (array)

5) $config is a variable that can contain more configurable elements.


1) Develop a clean coded "master" with 2 functions to upload and process data

2 Develop the 30+ other scripts that Would ideally only have a single line of coding:

Example: upload_to_db_2 ('m_sales_region',$_FILES['mapping_table_user1']['name']),'20,21,22,23,30','overwrite:yes') + the form to allow users to upload.

About the job:

I do have a specification in english and a pseudocode. Developers need to be able to discuss the coding with me in english. Developer should well document the coding and use latest php version/bootstrap

Skills: Bootstrap, MySQL, PHP

See more: easy upload csv mysql php, upload csv mysql script, script import csv mysql, adding markers to google maps from database, create json from mysql query, using php/mysql with google maps, mediawiki external data examples, google map php mysql store locator, google maps php mysql demo, show multiple markers on google map from database php, how to retrieve data from database in json format using java, php script upload csv file mysql, perl script import csv mysql linux, php script upload csv files, perl script insert csv mysql, script importer csv mysql, upload csv mysql, script upload csv file server web http, php script upload csv, perl script upload csv files mysql

About the Employer:
( 0 reviews ) Düsseldorf, Germany

Project ID: #18844085

35 freelancers are bidding on average €472 for this job


Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers I am an expert in many different area’s of web More

€333 EUR in 10 days
(242 Reviews)

Dear client. I read your requirement carefully and bid here. I can make a php script that upload CSV file and save CSV file content into database. I have plenty of experience in such a project. I can finish your t More

€500 EUR in 10 days
(57 Reviews)

Hi, thanks for your job posting. I am good at API design and development. Frankly to say, I have 10+ years of software experience The most important thing for me is the client's satisfaction, good result, and high q More

€500 EUR in 10 days
(46 Reviews)

Dear client. I read your job description with care, and it is all what I can do perfectly. Please contact and let me know you. I can start right now. Thanks Best regards.

€555 EUR in 10 days
(83 Reviews)

Hi, i see you need a php script which can parse csv files via file upload to fill in mysql tables with the data using a modular reusable approach where a single file can handle all the different csv files as well as se More

€666 EUR in 3 days
(22 Reviews)

Hello Sir/Madam!! I read your requirements, I can handle it and have already done this type of jobs. It will be my pleasure to work with you. Please give me an opportunity to work on your project. WHY US? I re More

€400 EUR in 10 days
(117 Reviews)

Nice to meet you. I have good skills about Web development. I can finish your project nicely. Please contact me. Thank you very much.

€250 EUR in 10 days
(56 Reviews)

Hello, I read your description and I'll do your work faster and professionally with in your time frame. Have a look at the websites that I built recently. [login to view URL] [login to view URL] http:/ More

€400 EUR in 8 days
(148 Reviews)

Hello there, I have read your description and understood all the requirements for Build a dynamic script to upload csv to mysql and use open rest APIs to query for additonal content. I am sure that I can provide More

€300 EUR in 6 days
(161 Reviews)

Skillful developer is HERE! [login to view URL] [login to view URL] [login to view URL] are all my portfolio. I have 9 years of web development experience and i have deep knowledge about web development. NodeJS, PHP, Python, RoR are all More

€500 EUR in 10 days
(12 Reviews)

Hi there, I can help you out with the PHP script. Can you please share english documentation? So, I'll have better idea about it. Regards, Adeel

€555 EUR in 10 days
(29 Reviews)

Dear Sir/Madam, I have 7+ years Experience in Web-Design and Web-Development.I building different types of Web Site (Ecommerce,Classified,Realstate,Weding,Porn,Personal,Dating,Event Management...etc ). I reading More

€388 EUR in 10 days
(78 Reviews)

Hello, I have expertise in PHP and am interested in your project. I can discuss all the requirements and technical issues with you and greatly complete all code. I will do my best and look forward to working with you More

€555 EUR in 5 days
(39 Reviews)

Hi I'm a PHP developer with 7 years of experience building web application for my clients. so you want a web application to dynamically import data from CSV to the database and then perform an API request and store t More

€500 EUR in 10 days
(44 Reviews)

Hi. i am a full web developer with over 5 years on ****SPECIAL very familiar with Responsive , Laravel***** I have read your description and have interests in your project. I have rich experiences i More

€250 EUR in 10 days
(42 Reviews)

Hello! I have read your job description carefully and i am very interested in this job. I am full stack web developer so i have a wealth of experience in PHP, bootstrap, Javascript. I can start working now and h More

€500 EUR in 10 days
(31 Reviews)

Hi, I really like your concept of using a single function to perform all the operations of mapping CSV files to database tables, then calling different APIs to upload data and then using the results to store in the dat More

€500 EUR in 10 days
(30 Reviews)

hi I have 11 years of php experience. I can develop your data import job with the highest quality. See my reviews. lets talk about the details. Regards Fatih

€1000 EUR in 10 days
(14 Reviews)

Hi, As a senior full-stack developer with 8+ years experience I'm a Javascript/Ruby ninja and Ruby on Rails, React.JS are my strongest skills. I've been concentrating on building marketplace, e-commerce, real estate, More

€555 EUR in 10 days
(32 Reviews)

⭐Dear sir.⭐ I have read your description with great interest. I have experiences with many project. Also i am able to finish the task on time. Please check my portfolio if you want to know my skill and experience. More

€300 EUR in 5 days
(81 Reviews)