meddev wrote on Thursday, April 11, 2013:
I’ve seen mention of ophthalmology forms but find nothing under contrib/forms or
interface\forms. Am I overlooking these somewhere?
If not anyone have any they could share?
fsgl wrote on Thursday, April 11, 2013:
I have LBV forms for a Comprehensive Eye Exam, Intermediate Eye Exam, Visual Field Exam, Pre and Post Op Visits, Glasses (Spectacles) Check, and a form for A-Scans. I have not had a chance to put all that stuff in the Wiki yet because the planned pictorial guide requires lots of screenshots.
Once you get the hang of the LBV forms, you can use the templates above to tailor the forms to the needs of your practice.
meddev wrote on Thursday, April 11, 2013:
Are these designed for Optometrists of Ophthalmology?
How could I get a copy of the forms?
fsgl wrote on Thursday, April 11, 2013:
For Ophthalmology specifically but they can be readily adapted to Optometry. Optometrists don’t need the Pre and Post Op Forms nor the form for A-Scans.
I have to post the forms to the Wiki, which I hope to accomplish over this next month. Next month go to User Manuals->Supplementary and it should be just under Pimm’s article on LBV forms (probably the 4th item).
fkasmani wrote on Friday, April 12, 2013:
I had made some Ophthalmology forms for a client and would be happy to share them. Let me know how I can share LBF made forms.
Regards.
tmccormi wrote on Friday, April 12, 2013:
If you dump the layout table and any list_options sets you created to
support it I can help clean it up and make it “share-able”…
Tony
fsgl wrote on Sunday, April 14, 2013:
LBV Forms For Ophthalmology has been posted to the Wiki.
meddev wrote on Tuesday, April 16, 2013:
Nice, looks comprehensive, I’ll pass it along. The quick work is greatly appreciated!
fsgl wrote on Tuesday, April 16, 2013:
It gave me great satisfaction to give back. You are most welcome.
tmccormi wrote on Tuesday, April 16, 2013:
Can you please post the SQL dump of these forms and supporting list options
so that they may be easily imported, rather that recreated by hand. That
would be awesome.
If you need help with this I would be happy to help make a package out of
it.
Tony
On Tue, Apr 16, 2013 at 10:27 AM, fsgl fsgl@users.sf.net wrote:
It gave me great satisfaction to give back. You are most welcome.
Ophthalmology formshttps://sourceforge.net/p/openemr/discussion/202506/thread/a1141b6a/?limit=25#b952
Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / DevelopersTo unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net
fsgl wrote on Tuesday, April 16, 2013:
Hi Tony,
Please bear in mind that I am nowhere near the proficiency of Cverk in matters related to Computer Science.
I am quite capable of following complex instructions, however. I also enjoy learning new things.
Be very specific as to where I need to look for the data that you required. It would be most helpful if you can provide detailed step-by-step instructions as to how to organize the information in a format useful to developers. If you have a template where I can fill in the blanks, it would be brilliant. If that is not possible, tell me what to copy and paste.
tmccormi wrote on Tuesday, April 16, 2013:
In Administration->Globals->Features make sure Configuration Export/Import is checked.
In Administration->Backup click the Export Configuration Button
Now select “List” and “Layout” and click “Continue”.
This will create and file called: openemr_config.sql and ask you to save it locally somewhere.
Rename the file to ophthamology_lbv.sql and email it to me and I will clean out the stuff that is not needed and post it on the wiki.
There will not be any PHI/Patient or otherwise private data in that sql file.
How’s that?
–Tony (tony ‘-AT-’ mi-squared.com)
www.mi-squared.com
tmccormi wrote on Wednesday, April 17, 2013:
OH wow, I just noticed you can now add attachments to a post. Cool! So you can zip the sql file up and attach it here if you like.
–Tony
fsgl wrote on Wednesday, April 17, 2013:
As the Brits would say: “Brilliant!” (it’s their version of “Cool” ten years ago).
Thanks for the reassurance that no patient health information will be divulged. All of us are so conscious of HIPAA admonitions these days.
I think I will opt for the first method so that you can scrub out the extraneous stuff. A link to the Wiki can be posted here after the scrubbing. I would guess that the Wiki audience is larger than the number of Forums members, so it would be more efficient to put the file in the Wiki. I will email the file to you at your work place.
If there is a problem, I’ll give a holler.
fsgl wrote on Wednesday, April 17, 2013:
Holler: Upon step 4, the process stopped dead with this message:
Creating export file…
“C:/xampp/mysql/bin\mysqldump -u “openemr” -p"escargot” --opt --quote-names “openemr” list_options layout_options | C:/xampp/perl/bin\perl -pe ‘s/ DEFAULT CHARSET=utf8//i; s/ collate[ =][^ ;,]*//i;’ > C:\Windows\TEMP/openemr_config.sql;" returned 255:
I was afraid something like this would happen because I have not been able to download the emr_backup.tar file after my laptop crashed in February and I did a restore using an old .tar file. The problem was described in this thread. No one has posted a solution so I did a work-around. Unfortunately the fundamental problem, which has persisted, is preventing the export and download of the .sql file. I looked in the Windows Temp folder and the openemr_web_backup subfolder. Both were devoid of the config.sql file. Solution, please. Perhaps we will be able to kill 2 birds with one stone.
tmccormi wrote on Thursday, April 18, 2013:
If you open a windows CMD box and paste this command it may work or a least give you a readable error message…
C:\xampp\mysql\bin\mysqldump -u “openemr” -p"escargot" --opt --quote-names “openemr” list_options layout_options > ophthamology_lbv.sql
If it works you’ll end up with a file “ophthamology_lbv.sql” in the current directory where you ran the command.
fsgl wrote on Thursday, April 18, 2013:
Will give it the old college try.
If Command Prompt fails and does not deliver the desired file nor an actionable message, I have a work-around.
If I download another copy of OpenEMR to my desktop and replicate the Ophthalmic forms, I should be able to get that config.sql file. If I need to handcraft those forms again, I might as well do a Comprehensive Ophthlmic Exam with radio buttons, for the Ophthalmologist who can’t touch type.
Command Prompt is a better and more efficient use of my time, so I’ll do that first.
I would not mind re-doing the forms by hand.
This sounds wacky, but LBV forms are fun to do (like crossword puzzles).
One way or another, you will get the file (even if it kills me).
fsgl wrote on Thursday, April 18, 2013:
The little black box rolled over and played dead:
C:\Users\fsl>C:\xampp\mysql\bin\mysqldump -u “openemr” -p"escargot" --opt --quot
e-names “openemr” list_options layout_options > ophthamology_lbv.sql
C:\Users\fsl>
Then I did this and it remained recalcitrant:
C:\Users\fsl>C:\Users\fsl\xampp\mysql\bin\mysqldump -u “openemr” -p"escargot" –
opt --quote-names “openemr” list_options layout_options > ophthamology_lbv.sql
The system cannot find the path specified.
C:\Users\fsl>
Additional thoughts, please
meddev wrote on Thursday, April 18, 2013:
You changed from this:
C:\xampp\mysql\bin\mysqldump
To this:
C:\Users\fsl\xampp\mysql\bin\mysqldump
The path to mysqldump appears to be the first one: C:\xampp\mysql\bin\mysqldump
fsgl wrote on Thursday, April 18, 2013:
I ran both commands. The first did not even give me an error message, so I changed the path hoping for something magical to happen, but command prompt only gave me the error message above.
OK, fellas, put your thinking caps on; otherwise I will have to go via the non-geek route.