mike-h30 wrote on Saturday, January 26, 2008:
I am in the process of migrating Microsoft Access data via a text file into the OpenEMR database. I am using the GUI tool Navicat8 to import the text file and map the fields accordingly. The first table I am trying to populate is patient_data. I believe the source of my error stems from the default value of ‘0’ for the following 3 fields in patient_data: “pharmacy_id”, “pid”, “fitness”.
I do not have values to populate for these fields in my text file. Please advise.
Regards,
-Mike