In this article, we will go through the following:
- Creating a Custom Medication Library by importing a CSV file
- Content type needed for the CSV file
- Archive a Custom Medication Library
Creating a Custom Medication Library by importing a CSV file
To create a custom library, navigate to Settings > Libraries > Medications tab and click on "Add library" button.
You should then input the following fields:
- Library name (mandatory)
- Description (optional)
Click on "Upload file" button, choose the csv to be imported, then click on "Save".
The csv that needs to be uploaded should contain the columns provided in the sample file attached to this article. Code and Generic/Chemical Name are the only required fields for each Medication entry; all other fields are optional.
Different types of Update Statuses
Once saved, import will start and the status of library will be displayed as "Importing". During the import, the upload status will be displayed as "Started".
When the upload is complete, the status of the library will be shown as "Active". Once the CSV has been uploaded, the upload status will be displayed as "Finished".
If the importing of the CSV file fails, the library's status will be shown as "Active" and the update status will be displayed as "Failure".
If the import was only partially successful, the library's status will be displayed as "Partial success" and the update status will be displayed as "Finished".
Content type needed for the CSV file
Your CSV file should contain the columns in the same order as shown below. You may also refer to the sample attached to this article for additional reference.
| Sno | Column | Mandatory (Yes/No) | Field type | Maximum characters allowed | Condition |
| 1 | Code | Yes | Alpha-numeric | 10 | Must contain a unique string, number or an alphanumeric string |
| 2 | Generic/Chemical Name | Yes | Alpha-numeric | 200 | This cell does not have to be unique |
| 3 | Brand name | No | Alpha-numeric | 200 | This cell can be left blank if not applicable |
| 4 | Ingredient strength | No | Alpha-numeric | 10 | This cell can be left blank if not applicable. Also accepts decimal values |
| 5 | Ingredient strength unit | No | Alpha-numberic | 10 |
This cell can be left blank if not applicable This field must use values from the Settings > Medication > Units > Values from Standard label Alternatively, you can use only the values from the Unit column from the attached file (Values for Drug family, Medication type, Narcotic, High-alert, Status) |
| 6 | Drug number | No | Alpha-numeric | 30 | This cell can be left blank if not applicable |
| 7 | Medication type | No | Drop-down | N/A |
This field must use values from the Settings->Medication->Medication type>Values from Standard label Alternatively, you can use only the values from the Medication type column from the attached file (Values for Drug family, Medication type, Narcotic, High-alert, Status) |
| 8 | Administration instructions | No | Alpha-numeric | 5000 | This cell can be left blank if not applicable |
| 9 | Drug family | No | Drop-down | N/A |
This field must use values from the Settings > Medication > Drug family > Values from Standard label Alternatively, you can use only the values from the Drug family column from the attached file (Values for Drug family, Medication type, Narcotic, High-alert, Status) |
| 10 | Website | No | Alpha-numeric | 250 | This cell can be left blank if not applicable. If a website is defined, you must include the fully qualified URL to allow it to be launched from within the ACC application. (Example: https://drugs.com) |
| 11 | Narcotic | No | Boolean | 1 | Accepts only 'Y' or 'N'. 'Y' corresponds to 'Yes' and 'N' corresponds to 'No'. For instance, if a medication item has been marked 'Y' it will be tagged as a Narcotic drug when added to the Medication profile |
| 12 | High-alert | No | Boolean | 1 | Accepts only 'Y' or 'N'. 'Y' corresponds to 'Yes' and 'N' corresponds to 'No'. For instance, if a medication item has been marked 'Y' it will be tagged as a High-alert drug when added to the Medication profile |
| 13 | Status | No | Drop-down | N/A | Accepts only 'Active' or 'Archive'. If a medication item is marked as 'Active' it will show up when the medication lookup in the Add medication form. If the medication item is marked as 'Archive' you would be able to search for that item in the Add medication form. |
Archive a Custom Medication Library
To archive a medication library, go to the "Edit" drop down menu, select "Archive" and you will see the pop-up dialog below. Note that archiving the library will not affect the selected clients' medication profiles, and you can reactivate this archived library at a later time. Click "Confirm" to continue.
To find your archived libraries, toggle the tab next to the add library button to "Archived".
Comments
0 comments
Article is closed for comments.