Importing CPT4

Management and Administration
1

wolf3dgts wrote on Wednesday, May 22, 2013:

I have OpenEMR 4.1.1 installed on my centos 5.8 machine.But I cant import CPT4 codes. I tried to use this instruction http://www.open-emr.org/wiki/index.php/OpenEMR_Billing_Setup_Howtos#Load_and_Update_Billing_Codes but when i executed perl script it just frozed … i waited for 20-30 minutes but it didnt changed…I tried to do this tutorial few times but it didnt helped. Can you please help me with this issue?

2

kodusote wrote on Tuesday, August 20, 2013:

Dear Vladimir,
I am assuming you do not work or live in the US in which case you need the CPT codes for your test site.
The script for downloading the codes is ./openemr/contrib/util/load_doc_fees.plx. You need to comment line 44 and uncomment lines 46 and 47, which you would need to modify as appropriate (dbname, username, password). This script would load the code from a text file, which you need to download from http://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/PhysicianFeeSched/PFS-National-Payment-Amount-File.html. Unfortunately, the structure of the PFALL???.txt changed after 2010, so you cannot use the script to load any of the later files without modifying the code.
However, if you want this for a production site, I suggest you contact one of the organization providing support for implementation of OpenEMR in US.
Best of luck.
Kayode

3

fsgl wrote on Wednesday, September 18, 2013:

Here is an alternative to .plx import:

  1. Purchase & download CPT data set from the AMA Store.
  2. Download and deploy OpenOffice Calc.
  3. Paste this text into C1, leaving no space after the 2nd left parenthesis:
    INSERT INTO `codes` (`code_text`, `code`, `code_type`) VALUES(
    See attachment.
  4. Copy & paste the descriptions into Column A.
  5. Copy & paste the codes into Column B.
  6. Be certain in Tools/Options/OpenOffic Calc/View/Display that the Formula box is unchecked.
  7. Click C2 & fx, Function Wizard.
  8. In Formula box paste:
    $C$1& “’”& A2& “’”& “,’”& B2& “’”& “,”& “1”& “);”
    Leave no space after last quotation mark, then hit Enter.
  9. Output should look like this:
    INSERT INTO `codes` (`code_text`, `code`, `code_type`) VALUES('Comprehensive Exam, New ','92004',1);
    See second attachment.
  10. Drag the lower right corner of C2 down to the last row & the rest of Column C will have the corresponding output as in C2.
  11. Copy & paste from C2 downward into Notepad++.
  12. Backup your copy of OpenEMR before importation.
  13. Import via phpMyAdmin or Configuration Import from Administration/Backup.
  14. Check in Database/codes and Adminstration/Codes for proper importation.

Will add this to Brady’s article on Code Types with more explicit directions and screenshots.

This technique can be used for the CPT modifiers, which should be included in the data set.

I don’t have nor need the CPT data set, as a result I am working blind. Please test this method and post comments to help make the article addition more lucid and understandable.

4

mthambikeni wrote on Saturday, July 19, 2014:

I real need cpt4 codes, where can I get?

5

fsgl wrote on Saturday, July 19, 2014:

See this.