Using phpMyAdmin to enable and register forms - is this possible?

OpenEMR Development
1

fnv4a wrote on Thursday, October 24, 2013:

Hi,

I’d like to know if it is possible to use phpMyAdmin to enable/register forms in OpenEMR.

I offer remote support to clinics having OpenEMR and need to enable some forms for them. I’m looking at the possibility of using SSH to copy forms from ‘/openemr/contrib/forms’ into ‘/openemr/intefcae/forms’ and then instead of using the OpenEMR web based forms interface, I use phpMyAdmin to enable and register the forms I have copied.

Thanks.

2

fsgl wrote on Friday, October 25, 2013:

I wonder if it’s feasible to copy the Contributed Forms to your interface/forms folder, register them, go to phpMyAdmin, export the .sql file, then import into the client’s copy.

I noticed that there are tables for the registered forms such as the ROS forms, see attachment.

If it is do-able, then the corresponding .sql file can be used multiple times without having to manually install the forms for each client.

Did a quick test with the 4.1.1 Demo. Tony’s form, Physical Exam was unregistered in Adminstration/Forms. Later it was registered, database installed and listed under the Administrative tab.

Next the files were exported and the form_physical_exam and the registry tables were eliminated, thus deleting the form. The zipped files were imported and the form reappeared.

So the answer is “yes”. Very nice method of copying the non-LBV forms into the client’s copy of OpenEMR in a quick and painless way.

Thanks for asking the question. Learned something new today.

I have attached files from Tony’s 2 forms for your experimentation.

3

fsgl wrote on Sunday, October 27, 2013:

It was an intriguing thought, but in the end, the contributed form must be copied into the interface\forms folder. Replicating the tables is not enough, therefore phpMyAdmin cannot be used for the intended purpose, sorry.

This is an argument in favor of the LBV forms, which can be quickly reproduced via phpMyAdmin. As Sam Hameed said, the sky is the limit with NationNotes. Perhaps we should concentrate on LBV forms, which are easier to construct and to replicate.