noscrodamus wrote on Wednesday, April 27, 2016:
I have generated a custom form using the xmlform generator. I am able to successfuly enter in values using the openemr GUI and have it populate in the encounter summary.
I want to be able to import data into the form table in my database using csv files.
I have manually entered a single record but it does not create a form entry in encounter summary.
Is there a way to do this?
fsgl wrote on Wednesday, April 27, 2016:
Ensure that install of the form has been done correctly.
Once a new form has been successfully installed, there should be a new table for it in the database.
If the new table exists, check that each of the columns is configured correctly.
noscrodamus wrote on Wednesday, April 27, 2016:
I believe I have installed it correctly - could be wrong though.
When using the form in the GUI It works perfectly: (See attachment)
I am trying to get this same table in ‘encounter summary’[patient/client>patients>encounter drop down ontop > encounter summary tab] by adding the record manually in the database.
fsgl wrote on Wednesday, April 27, 2016:
Note that pre-installed contributed forms are either in the Administrative or the Clinical tab. Try changing the Category to see if it helps.
Do you have a new table named “form_testing_form” in the database?
Do you have a save function in your form?
Once you’ve saved the form, the entries in the 3 fields should automatically populate the appropriate columns in the new table.
There is no reason to manually enter the data directly into the database.
yehster wrote on Wednesday, April 27, 2016:
Corresponding entries are also needed in the forms table and the form_encounter table.
In order for data imported through your manual process to show up, appropriate entries need to be created in 3 tables, including the table specific to your form.
The interface only knows to look in the specific form tables after it checks in the forms table, and entries in the forms table are only valid if there’s a corresponding encounter (hence the need to update form_encounter
Create a new entry through the GUI which you’ve confirmed is working then take a look in those other tables for reference and see what updates are made.
If you are only making entries in the one table, that’s why they aren’t showing up. Nothing to do with the registry/improper setup of the form itself.