Hi, I am trying to build our medication database. How to either bulk import from a CSV or link it to drug online database?
Thanks @volkswagner ,
I checked the âallow data importâ, and it is enabled. But still I canât find the document in the list.
Please check the attached.
I am trying now with Medication Class to add it prior to medication.
Hi
Should the doctype not be âMedicationâ instead of âMedication Classâ ?
Edit : I only see now that you tried both docs.
@volkswagner is correct.
And @maidoo according to your screenshot you are on the correct place / doc to set the permissions as suggested by @volkswagner . Just select the correct doctype ( âMedicationâ ) and remember to âReloadâ.
Thank you @trainingacademy.
I was able now to do it.
Now I am encountering another issue.
1- I filled the Dosage Form doctype with the required dosage forms
2- I added the Brand Name to the Brand doctype
3- then I attempted to upload the medication list (which contains the brand name along with the dosage forms).
Yet, I am encountering errors as seen in the screenshot.
Isnât mentioning the records in the other documents (such as dosage form and brand) enough for successful linking? or how does it work ?
To me it seems as if there are some doctypes not completed on your system.
Instead of importing all medications all at once, why donât you have one medication in your spreadsheet or CSV file.
In this way you can find out, in a more controlled and manageble way, what is outstanding on your system. You can complete the required docs / lists until the one medication loads properly and then you can extend that to all the medications.
Does your Brand doctype include the dosage in the name?
Either your csv is malformed, or you should have a Brand doctype for all listed brands in your import file.
there are some masters you need to add first before you upload this medication, you can see Brand, Dossage Form etc are masters, those values you are trying to add, first add those in to the corresponding masters, then you can import medication.