fsgl wrote on Saturday, October 19, 2013:
Hi Pimm,
I knew empirically from working on the .sql files for Henry Alvarez’s Eye forms that the 4.1.2 and the 4.1.3 Demo’s won’t import. Kevin did explain in your Browser thread about the version of Php being 5.2 and not 5.4 causing the importation problem.
Because I’m not home and cannot open up the HCPCS .sql file, as you had asked me to do; the next best thing was to try importing into the 4.1.0 Demo, with 4.1.1 Demo being unavailable earlier.
OK, the 4.1.1 Demo is available now, but:
Error
SQL query:
– -- Dumping data for table codes
– INSERT INTO codes
(id
, code_text
, code_text_short
, code
, code_type
, modifier
, units
, fee
, superbill
, related_code
, taxrates
, cyp_factor
, active
, reportable
, financial_reporting
) VALUES (147, ‘Dressing for one wound’, ‘Dressing for one wound’, ‘A1’, 3, ‘’, 0, NULL, ‘’, ‘’, ‘’, 0, 1, 1, 1), (148, ‘Dressing for two wounds’, ‘Dressing for two wounds’, ‘A2’, 3, ‘’, 0, NULL, ‘’, ‘’, ‘’, 0, 1, 1, 1), (149, ‘Dressing for three wounds’, ‘Dressing for three wound’, ‘A3’, 3, ‘’, 0, NULL, ‘’, ‘’, ‘’, 0, 1, 1, 1), (150, ‘Dressing for four wounds’, ‘Dressing for four wounds’, ‘A4’, 3, ‘’, 0, NULL, ‘’, ‘’, ‘’, 0, 1, 1, 1), (151, ‘Dressing for five wounds’, ‘Dressing for five wounds’, ‘A5’, 3, ‘’, 0, NULL, ‘’, ‘’, ‘’, 0, 1, 1, 1), (152, ‘Dressing for six wounds’, ‘Dressing for six wounds’, ‘A6’, 3, ‘’, 0, NULL, ‘’, ‘’, ‘’, 0, 1, 1, 1), (153, ‘Dressing for seven wounds’, ‘Dressing for seven wound’, ‘A7’, 3, ‘’, 0, NULL, ‘’, ‘’, […]
MySQL said: Documentation
#1062 - Duplicate entry ‘147’ for key 1
Well, there no point in all this frenetic activity until the original poster has additional comments. Sometimes they just read the answers and don’t bother to post again.