Importing a CSV or EXEL file to a Newly created list and making it visible from the patients Summary screen

kmendis56 wrote on Saturday, April 04, 2015:

What I want to do

Have a list of medication with generic and brand names (and possibly the ATC codes) available from the patient summary/visit screen - MEDICATIONS, ALLERGIES, PRESCRIPTION

I can create a LIST from ADMIN-LIST with the default fields
(Is there any possibility of changing these fields?)

What is a ‘simple’/non-programmers method of importing a list that I have in Excel/CSV file into this list I created?

How can I make this list available instead of the default MEDICATION list that is available now from the patients summary screen

Thank you in advance

Kumara

mdsupport wrote on Saturday, April 04, 2015:

If your list is big, you can check mysql excel tools. But if you are asking for help, you should consider manual entry.

kmendis56 wrote on Sunday, April 05, 2015:

OK. list is large and I have imported into mysql. How can I make it available from the medication lists. Can you indicate the pathway to do this as I am not a programmer but a physician.
Thanks in advance

mdsupport wrote on Sunday, April 05, 2015:

Summary screen displays medications used by the patient whose record id is shown on the top. What would be the purpose of showing your big list of all medications for every patient?

If you are referring to data displayed by clicking on the ‘Issues’ link, that is a cumbersome way for large list. If you are willing to live with that and if you imported your data into correct list, it will be visible now. Correct lists are _issue_list (e.g. “medical_problem” options are in list labelled as “medical_problem_issue_list”, “medication” options are in “medication_issue_list”).

Others can pitch in since we have customized this part for our users.

blankev wrote on Sunday, April 05, 2015:

Take one of the many DEMO sites for OpenEMR. Just make some entries in the fields you tink are important to get some insight in your goal. Most places are list and add. Use medications with the ADD function. Make about five entries for any medication.

Go to Administration => Database and try to find the Tables that have changes.

Now import values of the medications you added. Import more medications through CSV of SQL files.