With all this information you should be able to change one patient and use 11275 as External ID and continue with the next. If you can’t… try find a professional or someone who can help you with a distant Internet connection. (Next week I have some spare time and we could try to make this work.
I am “CSV wise” to a certain extend. Do not know much about SQL import.
How many clients/patients do you want to import after 11275? If this is only the start of a new database, than continue step wise. If you need to import more than 1000 clients it is worth to continue with this info and start investigating SQL import as MDSupport suggests.
BTW it is easy to change the PID and Ext-ID within phpMyAdmin. Click on the correct row and correct field (in browse tab), make a change and Click on the next Field (this saves the new input). It worked in Demo-V4.1.2, I did not try this in other versions.
Created 3 providers Dr., Visual Screening and Paper Work. It appears that this makes it much easier for the girls to find openings when the schedule gets full, but maintaining a schedule that is very flexible. When the schedule gets full they can work backwards. Starting where they see an empty spot for me and work the time forward to when the pt should arrive. Still need to do a little more work on the forms before we go live. Its taken longer than I estimated. Hope to go live Monday.
PS, There seems to be a glitch in that the 4.1.2 (2) Demo skipped # 11277. I inputted 11275 into both pubpid and pid for pt Allen then created John Doe as new pt and it worked fine (11276), but when I inputted Jane Doe as an existing pt then another new pt was inputted it skipped 11277. If you look at the tables it gave 11277 pid to Jane Doe.
Not sure what that means i.e., if it would continue to skip as new and existing pts get inputted.
Thanks again for all your help. Its been invaluable.
So pleased that you are resourceful and that OpenEMR is flexible enough to meet your scheduling needs. Rather ingenious to have 3 “providers”.
The tables appear ok. I think that someone else entered Tucker Testing and he did not get the properly sequenced pid. 11280 is missing and it probably belongs to him.
I noticed that Jane Doe has an external number of 5, which is not what you want. You may need to change the id column after all to avoid such problems.
If you are planning a batch import of patient data, backup before doing so; just in case, the id’s and pid’s turn out wrong. It may be safer to add patient information one at a time, instead of a batch import. I don’t know how to do batch imports and probably you don’t either; therefore this may not even be a problem.
There will be other “growing pains” until you are fully comfortable. Feel free to start new threads as the need arises.
Download the CSV file import the file in any spreadsheet program and take a careful look.
PID should be identical to EXT-ID. The other ID and Keys are optional to make them comparable. I like it to have all ID’s the same.
Next thing “empty” the table and import the new file. Replace is another option but I have no experience wiht that.
If you have other info connected to the Patient-data table, than there will be problems if you change the first ID field. Could also be for other fields, but that is to find out.