mrpicante wrote on Thursday, June 25, 2009:
How can I make custom forms based on the ones in paper that we are currently using.
Im working on a pc with windows vista.
Thanks,
Sam
markleeds wrote on Thursday, June 25, 2009:
Here is info on one way to do it:
http://www.oemr.org/modules/wiwimod/index.php?page=FormTool&back=WiwiHome
If you don’t have the time to get involved with making forms, consider getting help:
http://www.oemr.org/modules/wiwimod/index.php?page=CommercialHelp
mrpicante wrote on Thursday, July 02, 2009:
I have looked into that info about making forms but when i go to the /contrib file the forms file is missing
mrpicante wrote on Thursday, July 02, 2009:
Also i would like to add an additional item in the sex category on the demographics page
blankev wrote on Thursday, July 02, 2009:
What other sex items do you have? I know male, female, unknown (?), or what kind of sexes do you have in your population? You can add another sex through Admisistration => lists => Sex and add your “No-sex” don’t forget to fill the number so you can have them sorted.
cfapress wrote on Monday, July 06, 2009:
Sam,
If you’re looking for highly custom forms and have a developer then you might consider checking out the sample form in <oemr>/contrib/forms/example2. There are some brief instructions in there. With a talented developer you could end up with a perfect replica of your paper forms.
Jason
mrpicante wrote on Monday, July 06, 2009:
I have hit another wall. when I try to make changes in the Layout options( example: adding a new option to a category ) and then go to the patient info to input the data on the new field i get an error:
"ERROR: query failed: UPDATE patient_data SET date = NOW(), id = ‘6’, title = ‘Mr.’, fname = ‘Ben’, mname = ‘’, lname = ‘Gaddy’, pubpid = ‘1’, DOB = ‘1983-03-16’, sex = ‘Male’, ss = ‘’, drivers_license = ‘’, status = ‘’, genericname1 = ‘’, genericval1 = ‘’, genericname2 = ‘’, genericval2 = ‘’, street = ‘’, city = ‘’, state = ‘AL’, postal_code = ‘’, phone_home = ‘’, phone_biz = ‘’, contact_relationship = ‘’, phone_contact = ‘’, phone_cell = ‘’, email = ‘’, pharmacy_id = ‘0’, hipaa_notice = ‘’, hipaa_voice = ‘’, hipaa_mail = ‘’, hipaa_allowsms = ‘NO’, hipaa_allowemail = ‘NO’, hipaa_message = ‘’, employed = ‘’, occupation = ‘’, language = ‘English’, ethnoracial = ‘’, family_size = ‘’, monthly_income = ‘’, homeless = ‘’, reg_doc = ‘’ WHERE id = ‘6’
Error: Unknown column ‘employed’ in 'field list "
I have added the "employed" option on the employer database
cfapress wrote on Tuesday, July 07, 2009:
Sam,
There is a bug in v3 that has been corrected in the 3.1. Which version are you using?
The bug is such that if you use the Layout tool in the Admin section that it doesn’t properly updated your table structure.
To work around the bug you need to manually add the missing field to the database table. Let me try to give you some steps to take:
Go into the Admin section
Choose Database
From the left-hand column click on the table named ‘patient_data’
Scroll to the bottom of the right-hand column and look for " Add new field … at end of table"
Click on the Go button next to it
In the next screen type the name of the new field, ‘employed’
Click on the Save button
That should do it. Now try to save your patient’s data and see if the error persists.
Jason
mrpicante wrote on Wednesday, July 08, 2009:
Thank you so much Jason it solved my problem
mrpicante wrote on Thursday, July 09, 2009:
Now I have found some useful forms in <openemr>/contrib/forms but they dont show in the unregister side of the admin/forms. how can I include one of those forms in there?
Sam.
jerry42 wrote on Friday, July 10, 2009:
They need to be copied from contrib/forms to /var/www/openemr/interface/forms/ first.
Then they will show up in Admin/forms
jerry
docaltmed wrote on Monday, July 13, 2009:
I operate a gender-affirming clinic, so I modified the gender field to accommodate phenotype/genotype. I actually think this should be made standard in the stock software. I believe that gnumed comes that way.
mrpicante wrote on Monday, July 27, 2009:
hit yet another wall. I have finished creating the custom form. load it to open emr and when I press save changes i get this:
ERROR: insert failed: insert into nvr set pid = 1,groupname=‘samm’,user=‘mrpicante’,authorized=1,activity=1, date = NOW(), allergies = ‘’, reactions = ‘’, medname1 = ‘’, medname2 = ‘’, medname3 = ‘’, medname4 = ‘’, dose1 = ‘’, dose2 = ‘’, dose3 = ‘’, dose4 = ‘’, often1 = ‘’, often2 = ‘’, often3 = ‘’, often4 = ‘’, ltaken1 = ‘’, ltaken2 = ‘’, ltaken3 = ‘’, ltaken4 = ‘’, pmedhist = ‘’, other = ‘’, bps = ‘’, bpd = ‘’, pul = ‘’, rr = ‘’, temp = ‘’, wt = ‘’, ht = ‘’, in = ‘’, pulse = ‘’, phq2r = ‘’, phq9r = ‘’, pcptsdr = ‘’, gad7r = ‘’, notes = ‘’
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in = ‘’, pulse = ‘’, phq2r = ‘’, phq9r = ‘’, pcptsdr = ‘’, gad7r = ‘’, notes = ‘’ at line 1
tmccormi wrote on Monday, July 27, 2009:
The word "IN" is reserved as MYSQL command syntax . Change the name of that variable.
–Tony
mrpicante wrote on Monday, July 27, 2009:
thanks also how do I remove a registered form?
tmccormi wrote on Monday, July 27, 2009:
You can disable a registered form in the Form, but there is no ‘user oriented’ way to remove it entirely, that I can find.
–Tony
blankev wrote on Tuesday, July 28, 2009:
Try to find in MySQL the rigt tables and delete the items.
One of them is to brows to registry table and delete the row that is unwanted. But thanyou still have to delete the rows that you entered somewhere else for this form.
Should be the tables related to the Form that you don’t want. Something like Form_Ankle_exam
Re installation goes again from the Administration Form screen. You might have to leave OpenEMR and login again.
Pimm
mrpicante wrote on Tuesday, July 28, 2009:
I got the form to operate almost completely i can store and view data with no problems, no when on the navigation panel on the left if I select "encounter" i get this:
ERROR: query failed: select * from form_nvr where id = 1
Error: Table ‘openemr.form_nvr’ doesn’t exist
have looked several places but cant figure it out
sam.
cfapress wrote on Wednesday, July 29, 2009:
Hi Sam,
I’ve you have hand-edited the database data and structure you might have created some trouble for yourself. We can help you get it fixed, though.
First, did you drop a table from the database named "form_nvr" ?
If so, were you trying to permanently remove the form from OpenEMR?
Simply dropping the table is not enough to make it go away. You also need to remove the row in the ‘registry’ table that refers to “form_nvr”.
Try that and see if it fixes your trouble.
Jason
mirando wrote on Wednesday, August 05, 2009:
I would like to do a custom forms for ophthalmology. Anyone did that or any help for how to?