Good Day
I would like to know if there is a way to do a mass import of doctors with addresses?
All my data is currently in a excel spreadsheet, with the addresses, phone numbers etc. (13000 lines of data)
It will take forever and a day to do it manually - line by line
Please help!!!!
Mass Import
Moderators: alexandrleonenko, Milton
-
- Site Admin
- Posts: 6170
- Joined: Jan 7th, '09, 23:18
- Contact:
Re: Mass Import
If you're familiar with SQL - you may do it via phpMyAdmin.
Re: Mass Import
Good Day
I am qute familiar with SQL, and have tried it, but there seems to be a error when uploading it.
I suspect it might be a "Mapping" problem as some of the fields are not used.
What format would you sugest I try to use, to upload it into SQL? I have tried CSV format, and SQL format "insert into table"
Regards
I am qute familiar with SQL, and have tried it, but there seems to be a error when uploading it.
I suspect it might be a "Mapping" problem as some of the fields are not used.
What format would you sugest I try to use, to upload it into SQL? I have tried CSV format, and SQL format "insert into table"
Regards
Re: Mass Import
Hello Rascal@1
I think you need to contact tech support (link - http://www.apphp.com/support/open). I also do not understand how an error occurs.
Regards
I think you need to contact tech support (link - http://www.apphp.com/support/open). I also do not understand how an error occurs.
Regards
Re: Mass Import
Good day
Will upload so screen prints shortly...
Thank you, might just have to contact tech support
Will upload so screen prints shortly...
Thank you, might just have to contact tech support
Re: Mass Import
Good day
Could you describe how can I repeat this mistake, so I can you help solve it.
Regards.
Could you describe how can I repeat this mistake, so I can you help solve it.
Regards.
Re: Mass Import
Good Day All
I have managed to load 30'000 records in less than 5 min with "CSV using LOAD DATA" function.
Thank you for the support renderd, If you have any questions on how to do it, leave me a PM and i will send the load template with instructions
Regards
I have managed to load 30'000 records in less than 5 min with "CSV using LOAD DATA" function.




Thank you for the support renderd, If you have any questions on how to do it, leave me a PM and i will send the load template with instructions
Regards