Customization

OpenEMR Development
1

1 It is possible for the prescriptions to remove the input fields from the form.
2 What is the table that calls the medications in prescription?
3 Can i import the AIFA Italian drug database into a table?
Is there a way to keep the changes even after installing update of openemr?

Thanks

2

Hi tresrob,

Answering to your questions:

1 Is it possible for the prescriptions to remove the input fields from the form?
Yes you can remove the fields in the prescriptions form.
Please check out the file.–>> openemr/templates/prescription/general_edit.html

2 What is the table that calls the medications in prescription?
Please check with the openemr table name --> prescriptions

3 Can i import the AIFA Italian drug database into a table?
Yes,You can import the data into openEMR database -> table_name -> drug.
Make sure,whether the importing column fields matches with drug column fields.
If you want to add your own table and fields in OpenEMR database,it needs more customization.

4 Is there a way to keep the changes even after installing update of openemr?
Yes,You can keep the changes even after updating the OpenEMR.
Please check out the files in the folder openemr/sql/.

Thanks,
ViSolve

3

I understand now i try.
Thanks again

4

And now how i can customize drugs form.
i woul’d like remove some input field and add other

Thanks

5

Hi @tresrob,

To add/remove the fields in drug form,check the files -> /interface/drugs/add_edit_drug.php

For lot entries/destroies check the files -> /interface/drugs/add_edit_lot.php

To make changes in mysql table/column check the files -> /interface/drugs/drugs.inc.php

MySQL tables which are related to drug forms are drugs,drug_inventory,drug_sales,drug_templates.

Let us know for further questions.

Thanks,
ViSolve

7

Many thanks

8

@tresrob @visolveemr hi, i am italian too. You solved with prescriptions and AIFA db?
if yes, you can tell me how.
thx