Mass Import

Discuss everything related to Medical Appointment. All versions. Any questions related to the Medical Appointment developing or using should be posted to this forum.

Moderators: alexandrleonenko, Milton

Rascal@1
Newbie
Newbie
Posts: 7
Joined: Dec 29th, '16, 21:51

Mass Import

Postby Rascal@1 » Dec 29th, '16, 22:09

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!!!!

administrator
Site Admin
Site Admin
Posts: 6004
Joined: Jan 7th, '09, 23:18
Contact:

Re: Mass Import

Postby administrator » Dec 30th, '16, 07:27

If you're familiar with SQL - you may do it via phpMyAdmin.

Rascal@1
Newbie
Newbie
Posts: 7
Joined: Dec 29th, '16, 21:51

Re: Mass Import

Postby Rascal@1 » Jan 4th, '17, 10:23

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

ne_moj
Master
Master
Posts: 243
Joined: Jan 1st, '16, 14:11

Re: Mass Import

Postby ne_moj » Jan 5th, '17, 07:00

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

Rascal@1
Newbie
Newbie
Posts: 7
Joined: Dec 29th, '16, 21:51

Re: Mass Import

Postby Rascal@1 » Jan 5th, '17, 07:09

Good day

Will upload so screen prints shortly...

Thank you, might just have to contact tech support

ne_moj
Master
Master
Posts: 243
Joined: Jan 1st, '16, 14:11

Re: Mass Import

Postby ne_moj » Jan 6th, '17, 10:23

Good day

Could you describe how can I repeat this mistake, so I can you help solve it.

Regards.

Rascal@1
Newbie
Newbie
Posts: 7
Joined: Dec 29th, '16, 21:51

Re: Mass Import

Postby Rascal@1 » Jan 25th, '17, 17:57

Good Day All

I have managed to load 30'000 records in less than 5 min with "CSV using LOAD DATA" function. :D :D :D :D

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


Return to “ApPHP Medical Appointment / uDoctorAppointment Talk {developers/users}”