Coping LBV forms

Day-to-Day Users
#21

hamdpa wrote on Thursday, November 12, 2015:

Hi MD Support,
Tried https://10.0.0.30/openemr/custom/imex_lbf.php and nothing happens. Keeps me at the login screen. Am I supposed to see a mew window listing the available forms? Downloaded the php file with save target as. Was able to open it with notepad and its readable. Not sure how to proceed.

Thank you,
Henry

#22

hamdpa wrote on Thursday, November 12, 2015:

Hi MD Support

Just a thought. Can I execute the file via webmin?

#23

fsgl wrote on Thursday, November 12, 2015:

A. Backup first.

B. To copy the “hospital consult” form:

  1. Go to database, page 3 to layout_options. See a.
  2. Search for LBFcompexamnt. See b.
  3. Click Export tab. See c.
  4. Click Go button. See d. New file will be named layout_options.sql.

C. To test the accuracy of new .sql file, use phpMyAdmin in 4.2.0 Demo by importing:

  1. Components & list options zipped files as shown here.
  2. Your new layout_options.sql into layout_options.

D. If everything looks good in the Demo, do the following in production copy:

  1. Change the name of “hospital consult” form as shown in 1. png in the prior post.
  2. Add 1 from approximately Line 53 onward as shown 4a.png. Every line with LBFcompexamnt must have 1 appended, otherwise it won’t be imported & you’ll get a duplicate entry error.
  3. Add LBFcompexamnt1 & pick a new Title for the copy. See 3.png from above.
  4. Import copy into layout_options.
#24

hamdpa wrote on Thursday, November 12, 2015:

Hi fsgl,

Like the idea of only pulling out the one forms info. Looks straight forward.
Will try it on a backup copy first as experiment. Thats the beauty of the appliance.
Thank you,
Henry

#25

fsgl wrote on Thursday, November 12, 2015:

If an appliance floats your boat…

Another little tweak, the date picker means less clicking.

If date picker is helpful, will need to change the field to Date - Time

#26

hamdpa wrote on Friday, November 13, 2015:

#27

hamdpa wrote on Friday, November 13, 2015:

Hi fsgl,
What do you usually use to open and manipulate the sql file?
Would it work to export as csv, open and manipulate in excell then import back?
Thanks for the tip.

Henry

#28

hamdpa wrote on Friday, November 13, 2015:

Hi fsgl
Thanks for the tip. What do you usually open the sql file with?
Would it be ok to export as csv file, open and manipulate with excell and import?
Thank you
Henry

#29

fsgl wrote on Friday, November 13, 2015:

Hi Henry,

When you double click the .sql file; the default text editor, Pluma, will open it automatically. I have Pluma in Linux Mint, so you should have it in Ubuntu.

Very important to enable line numbers; otherwise Esotropia sets in quickly.

Appending 1 to each insert line, before the re-import, may be easier in a spreadsheet by dragging the lower right corner of the first cell. Never tried it myself.

I’m sure there is a way to accomplish the same task with Bluefish Editor. It’s just that I don’t know how at this moment.

Both of us have more experience with .sql files. Things usually go more smoothly with known quantities.

#30

fsgl wrote on Friday, November 13, 2015:

O.K, I’ve tried dragging lower right corner in the spreadsheet. It did not work for me.

Better to stick with appending 1 in 1st column of .sql file.

#31

fsgl wrote on Friday, November 13, 2015:

Well, Henry; here is your Christmas present (Feliz Navidad):

  1. Double click .sql file.
  2. Help tab/Contents/Finding & Replacing/ Replacing Text. See 1.
  3. See 2.
  4. Save.

Sweet, huh?

#32

hamdpa wrote on Saturday, November 14, 2015:

Hi fsgl,
Looks great! Will have to check how i can use similar method. Ubuntu server is not graphical the way Linux Mint is. Will see what is available in Windows, as the sql file downloads to windows download file.
Thank you, your terrific!!
Henry

#33

fsgl wrote on Saturday, November 14, 2015:

I was wondering why you were using Excel.

Just install Notepad++.

Right click on .sql file to open with Notepad++.

Crtl + H will take you to the Replace function.

Alternatively you can deploy the Find & Replace command in Ubuntu.

One of these days we need to talk about the portability of CVerk’s backup.

#34

hamdpa wrote on Saturday, November 14, 2015:

Super! Will give Notepad++ a try!
Thanks a bunch!

#35

hamdpa wrote on Saturday, November 14, 2015:

Perfect!!

What about CVerks’s backup?

#36

fsgl wrote on Saturday, November 14, 2015:

CVerk’s backup on a flash drive, when plugged into a Windows machine, is as portable as a VM. See part 4 of this.

No fooling around with host/guest & upgrades of VM/guest.

No headaches with hardware that does not permit virtualization. Both my desktop & laptop don’t have the BIOS for virtualization.

With Windows there are 3 different ways to backup. More than enough redundancy. There is a method of backing up to the cloud, but that makes me queasy.

Staff will have an easier time with Windows & OpenEMR, so training is reduced.

Only wrinkle is what to do when Windows 8 is no longer supported. I’ve started a new thread about the matter.

#37

hamdpa wrote on Saturday, November 14, 2015:

Hi fsgl,
Looks good. This seems to work for xammp ( Windows xammp) install and appears to be a database backup. The appliance just needs the vmware program running on any machine. I am able to spot check the backup by comparing the # and size of files in backup vs the shut down appliance.
Interesting. Appears to be many ways to “skin the backup”.
Thanks gor the additional info.

Henry

#38

fsgl wrote on Saturday, November 14, 2015:

Great fidelity with CVerk’s backup. Used it for the past 4 years with zero problems.

It’s a differential backup of the whole kit & kaboodle, not just a mysqldump. That’s why it’s a working copy on the flash drive (or whatever medium that you choose), hence very portable.

If & when you’re ready to use OE only in Windows; start a new thread, because the transfer of data from Ubuntu to the Windows XAMPP package is slightly different than described in Wiki articles. Your staff will thank you for it.

O.K, now that you have all the tools for copying the “hospital consult” form, it should take less than 30 minutes tops.

#39

hamdpa wrote on Saturday, November 14, 2015:

Hi fsgl

Thanks again, but need server capability and Ubuntu gives me that.
Really appreciate you help.
Henry

#40

hamdpa wrote on Saturday, November 14, 2015:

I thought you had switched over to Linux Mint for OpenEMR, so why xampp?