已完成

Excel to OSClass data conversion

Only those who know osclass, apply

I have an excel file (attached sample).

I also have an OSclass installation containing a directory listing of doctors (now empty with dummy data)

I need a small utility (preferably PHP script), that can read the excel file, process each row and populate the osclass database with the data in the excel.

osclass db structure :

oc_t_item -> contains basic details of each doctor (primary key, created date, etc)

oc_t_item_description contains 'title' and 'description' -> title needs to be the full name from the excel (first + middle + last + suffix + title). 'Desc' can be blank for now.

oc_t_item_location contains location details. there is an excel plugin that geocodes addresses. I need you to research on the plugin and use that plugin and try to populate lat long, so that the address + generated latlong from the excel can go into this oc_t_item_location table.

oc_t_meta_fields contain the meta information of custom fields (Phone, Fax, Email, Residency Training, etc)

oc_t_item_meta contains the actual data of these custom fields and the data like residency training, phone, fax, email etc must go here to this table.

This is a standard osclass installation. Include the answer for 5 X 4 in your bid so that I know you have read the project brief fully.

Only those who know osclass, apply

技能: 数据处理, MySQL, PHP

查看更多: Primary research, use of data structure, table data structure, script doctor, process data structure, primary data, phone directory data structure, key data structure, date utility, basic of data structure, answer phone fax, meta data, lat long, Excel training, excel to, small data table, excel file mysql, mysql populate table, excel sample project data, excel project use database

关于此雇主:
( 8个评论 ) Kassel, Germany

项目ID: #5214819

授予:

v86web

Hello Sir. My name is Vinicius and although I'm from Brazil I'm a fluent English speaker. Your question's answer is 20; Thank you for your time and looking forward to work with you. Shouldn't be hard to co 更多

€29 EUR 在3天内
(0条评论)
0.0

4 威客就此工作平均出价 €28

CristianPopa

5x4 = 20. I can write you a PHP bot that does this. It reads the CVS line by line and enters the data on the OSclass database. If you are interested please contact me.

€34EUR 在1天里
(5条评论)
3.0
dmitryionov

Предложение еще не подано

€27 EUR 在3天内
(0条评论)
0.0
FxSolution

5x4 = 20 Dear sir, I'm an expert in web development with 8 years experience in PHP. I do know OSClass deeply. I've read your requirements and check the attach csv file carefully It's easy to me to populate the o 更多

€20 EUR 在0天内
(0条评论)
0.0