Write a PHP & MySQL utility to dress company info to an excel list
$30-100 USD
Suoritettu
Julkaistu noin 12 vuotta sitten
$30-100 USD
Maksettu toimituksen yhteydessä
We have several excel lists with, among other data, company names that may or may not be the fully correct company name. We would like to dress this data with ca 10 additional columns containing phone, fax, address fields, turnover, number of mployees and registration year. We have this info in 7 big excel lists containing around 360 000 company entries, and its updated once per year. Your task will be to write a web utility in PHP & MySQL with an "API-light" to allow us to: A. Send just one company name and get back an xml list of the added details. B. upload a list of company names, with any number of columns and have all rows prepended with the added details. C. Be able to add/replace the ca 360 000 entries with the new excel lists we have every year