Urgent help with importing CVS Patient Data file

kainthe7th wrote on Tuesday, October 18, 2016:

Hi everyone.

I’m in urgent of importing patient data into openEMR. I’ve tried everything I can. I’ve even exported a CSV Fil from OpenEmr’s patient _ data Table. And repopulating it with the new data. But every time I try to import, I get "Invalid Column number on Line 1”.

I really need to get this done urgently.

visolveemr wrote on Tuesday, October 18, 2016:

Hello Melvin,

After exporting to csv, please open the file in Notepad instead of Microsoft Excel and share the first 2 or 3 lines which will be helpful to analyze further.

Thanks,
OpenEMR Customization/Support Team,
Visolve Inc

kainthe7th wrote on Tuesday, October 18, 2016:

Thank you very much, ViSolve. After many hours I finally realised my error: the data table I was trying to import had the wrong number of columns.

Now, however, I have another problem. After importing the 20,000+ patient details, openEMR is terribly slow and I’m getting wirong open