Import recalls and referral physicians

Medchart version 14.09 or older missed importing referrla physicians and recalls. To import the data follow these steps:

• in Medchart 24 go to Tools - SQL scratchpad
• copy the text below and paste it into the scratchpad to import referrals (change the last line to the correct file if you have moved your Medchart 13 data file)

INSERT INTO [Referral Physicians] ( surname, first_name, initial, address, city, postal_code, phone_1, phone_2, phone_3, billing_number, speciality, email, fax, notes, id )
SELECT [referral physicians].surname, [referral physicians].first_name, [referral physicians].initial, [referral physicians].address, [referral physicians].city, [referral physicians].postal_code, [referral physicians].phone_1, [referral physicians].phone_2, [referral physicians].phone_3, [referral physicians].billing_number, [referral physicians].speciality, [referral physicians].email, [referral physicians].fax, [referral physicians].notes, 0 AS Expr1
FROM [referral physicians] IN 'c:\program files\medchart\patients.mdb';

• click the 'execute sql button.
• to import recalls perform the same steps with the commnad below:

INSERT INTO recall ( reason, chartnumber, date_completed, [date], icd9, checked, [note], [user], doctor, pt_aware, aware_date, id, date_entered )
SELECT recall.reason, recall.chartnumber, recall.date_completed, recall.date, recall.icd9, recall.checked, recall.note, recall.user, recall.doctor, recall.pt_aware, recall.aware_date, recall.id, recall.date_entered
FROM recall IN 'c:\program files\medchart\patients.mdb';

updated July 27, 2008