How to generate demo data for openEMR

How to generate demo data for openEMR

Download the program from the following link

https://github.com/openemr/demo-data-generator

cd demo-data-generator
virtualenv venv
. venv/bin/activate
if you haven’t installed, please type below command
pip install .

count 1 means only 1 record, if u need 20 records, just change to count 20
demodata patients ‐‐count 1 (generate patient records, it is double hyphen ‐‐)

INSERT INTO `patient_data` (title, language, financial, fname, lname, mname, DOB, street, postal_code, city, state, country_code, drivers_license, ss, occupation, phone_home, phone_biz, phone_contact, phone_cell, pharmacy_id, status, contact_relationship, date, sex, referrer, referrerID, providerID, ref_providerID, email, email_direct, ethnoracial, race, ethnicity, religion, interpretter, migrantseasonal, family_size, monthly_income, billing_note, homeless, financial_review, pubpid, pid, hipaa_mail, hipaa_voice, hipaa_notice, hipaa_message, hipaa_allowsms, hipaa_allowemail) VALUES (“Mrs.”, “”, “”, “Casey”, “Benefield”, “”, “2003-02-11”, “2214 Van Tassel Parkway”, “37148”, “Portland”, “TN”, “US”, “B613-753-3-348”, “524905784”, “Engineering Manager”, “(931)125-2822”, “(423)331-4549”, “(865)948-4720”, “(423)625-1598”, “1”, “”, “”, “2020-07-13”, “Female”, “”, “”, “0”, “0”, “[email protected]”, “”, “”, “”, “”, “”, “”, “”, “8”, “”, “”, “”, “2019-05-19”, “”, “5263676173”, “yes”, “yes”, “yes”, “yes”, “no”, “yes”);

Generate demodata facilities ‐‐count 1 (generate facility records)

INSERT INTO `facilities` (name, street, city, state, country_code, postal_code, phone, fax, tax_id_type, federal_ein, facility_npi, website, email, billing_location, accepts_assignment, service_location, color, primary_business_entity, pos_code, attn, domain_identifier, facility_id)
VALUES (“Electronics Design East”, “9169 Cedar Lane Drive”, “Miami”, “FL”, “US”, “33163”, “(904)751-5706”, “(727)664-1173”, “EI”, “65404359090”, “7201219879”, “”, “[email protected]”, “1”, “1”, “1”, “#393C18”, “1”, “21”, “”, “”, “Electronics Design East-52182”);

Go to phpmyadmin or any other database client app and run the above sql query. For the Facilities, you need to change the words in red.

INSERT INTO `facility` (name, street, city, state, country_code, postal_code, phone, fax, tax_id_type, federal_ein, facility_npi, website, email, billing_location, accepts_assignment, service_location, color, primary_business_entity, pos_code, attn, domain_identifier, facility_code)
VALUES (“Electronics Design East”, “9169 Cedar Lane Drive”, “Miami”, “FL”, “US”, “33163”, “(904)751-5706”, “(727)664-1173”, “EI”, “65404359090”, “7201219879”, “”, “[email protected]”, “1”, “1”, “1”, “#393C18”, “1”, “21”, “”, “”, “Electronics Design East-52182”);



Start typing and press Enter to search