blankev wrote on Tuesday, July 08, 2008:
I tried several options while using IMPORT TEXT FILE window (with patient_data in open in other OpenEMR window.
I use WINDOWS-XP OpenEMR 2.3.8 and a text file created with Windows Excel2003 with … ; … ; separated fields and nothing visible the end of a line. I save the Excel file like a xxxxxxx.CSV file and name the variables available in the import text-file window like:
id,lname,fname,DOB,street,ss,occupation
but can’t get any results. What am I doing wrong? Or may be is the better question:
What should I write/use in the SQL windows command line to get results?
Thanks for your time invested reading this message. Any response towards a solution of my ignorance is welcome…
Pimm Blankevoort