fsgl wrote on Wednesday, September 25, 2013:
Add CPT codes first.
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
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);
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.