I need a database mysql and management in php for the webb to handle companies and contacts related to them with import and export function ( excel or csv files )
The unique ID is AddressID
So I need 2 tables
One for the company details and one for the related persons both with datestamp
Import function needs to handle insert, update ( when I pick the file to import I want to have so I pick were the column should go example, company name to company name etc etc ( I have several thousands of files and they are not in the same order ) problably I need to have 2 imports stage one for the company details and one for the personal details and problably I need the unique ID to be in both tables for the easiest way to import personal details to the right company ( all details is in the same file ) ( see attached example file i have done easy header so you better understand what is what in the file and wich table it has to go to )
If I have the company in the database it should update the details and put the today date in the datestamp
If I have the person related to the company it should update if new details and put today date in the datestamp
Else if the company not exists create a new
Else if the person not exists for the company create a new
Then I need to have search function for all details and export from search results ( advanced search were I can add new conditions example OR, Contains, AND etc.)
The export should be one file with all the details from company and related persons
Also need delete function from search criterias
18 freelancere byder i gennemsnit €186 for dette job
Hello sir. I read all your requirements. And i am good at all that. Please check attached doc for my previous works. Hope to hear from you soon. Thanks!!
Located in Iowa (US) and available via Skype and Email throughout course of the project. I am quoting a very simple UI (no graphic design) with login required to add/edit/remove company or contact information.