Mass Import

[Rascal@1]

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]

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

[Rascal@1]

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]

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]

Good day

Will upload so screen prints shortly...

Thank you, might just have to contact tech support

[ne_moj]

Good day

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

Regards.

[Rascal@1]

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