Importing cpt codes

minus7 wrote on Wednesday, December 03, 2014:

Happy Thanks giving to Tom, Jerry, and all the very animated posters.
We return now to the thrilling days of yester month where I was seeking to manually load some cpt 4 codes to pursue a walk through of encounter to fees to potentially generating a paper HICFA 1500
or document of similar character.
Looking forward to insights from fsgl and the happy company in this connection.
Best Wishes
Scott

fsgl wrote on Thursday, December 04, 2014:

Even though it may seem like learning to run before learning to crawl, it’s easier to walk you through import of codes into phpMyAdmin first. You will want to acquire this skill at some point in time. It might as well be now. Just have #1 Son nearby.

The import of the .sql file will give you a set of the Ophthalmic CPT & ICD9 codes that we use in the office. You may not need the surgical codes, but they can be shared with colleagues. There are no fees attached to the CPT codes. We will work on that later.

The attachment, 1.png, is self-explanatory; but to be more explicit:

  1. click the attached codes.sql file to save it to your Downloads folder (found in Windows Explorer).
  2. Go to the Menu & click Administration, Other, Database. This will take you to phpMyAdmin.
  3. Click the + sign before openemr to open the database.
  4. Click codes to open it.
  5. Click the Import tab.
  6. Click Browse, go to the Downloads folder & double click codes.sql. This will tell phpMyAdmin which file to import & where to find it.
  7. “No file selected”, which is to the right of the Browse button, will be replaced with “codes.sql”. This means that the correct file was located.
  8. Click Go. There should be an apple green banner on top, if the import had been successful. See 2.png.
  9. Click the Browse tab (tab, not button), which is to the left of the Structure tab. If everything went well, the codes table will have Eye codes starting at the end of page 5. See 3a.png.

If I were to be any more explicit, I would need to drive to Virginia.

fsgl wrote on Friday, December 05, 2014:

A dry run in the 2099 Demo will be a good confidence booster before attempting the codes.sql import on your laptop.

Brady’s Demo’s are indestructible, (from personal experience).

minus7 wrote on Tuesday, December 09, 2014:

Dear fsgl,
It appears that we have numerous ocular cpt codes thanks to your kind directions.
Have learned that Dan’s download of Open EMR does not afford access to phpMyAdmin.
I think our IT man should eval. his machine as it only works on the office net via WiFi.
Upon resolution of this mystery, would it be appropriate to uninstall current open EMR
related programs and start afresh? Perhaps we should be directed to trouble shooting lit.
in the WIKI or other source.
Thanks for nurturing my guarded optimism.
Respectfully,
Scott

fsgl wrote on Tuesday, December 09, 2014:

It’s my conjecture that father & son are working on this exercise away from the main server, on another device & that Dan logged in as physician or clinician.

Every copy of OpenEMR has phpMyAdmin. I know that for a fact because there had been a thread earlier in the year about decoupling it. I had argued strenuously against the idea.

The easiest thing to do would be to download this, not as service to Dan’s machine & follow the rest of the tips on the Wiki page.

Upon completion, login with admin, pass. Administration should be a part of the left navigational menu. Don’t login to the office copy. Just work offline with this new copy.

Rather than messing up the copy in the office, it is probably more reassuring just to use this test copy. That way you won’t have to do a dry run in the 2099 Demo.

blankev wrote on Tuesday, December 09, 2014:

Don’t know if this is a solution, but the SUPER USER, OpenEMR gives it the name admin pass can make changes to global settings. One of these is accept or Decline use of PhpAdmin.

It can be toggled on for a short period of time so you can include the CPT-codes.csv and decline access immediately afterwards.

minus7 wrote on Monday, December 15, 2014:

Hi All,
I naively sought to enter fees for code Put $ amounts in appropriate (?) field…
Quite pleased with me-self.
Only trouble… the fees don’t show up when trying to generate a fee for service in
open EMR. I think I’m ready for that part about : “We will work on that later.”

fsgl wrote on Monday, December 15, 2014:

Add fees in the group of CPT’s as demonstrated in the attachments.

blankev wrote on Monday, December 15, 2014:

Why do you try make your life miserable. Please take some time to read. It is all there in the WIKI pages.

Fee is there to make money. So you have to activate the money part.

Take the example of CPT4. These show fees. Take a peak in Codes and follow the examples of the Demo. You can also make ICD9 with FEES just activate: in CODE-types activate FEES

You can find an example in this demo:

http://demo.open-emr.org:2107/openemr/

ICD9 for civilian… has a fee and is activated for fees and shows in the FEE sheet.