This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
import_and_export:import_abbrev [2017/07/03 21:05] rozannaimport_and_export:import_abbrev [2021/10/08 09:31] (current) Gary Willetts
Line 1: Line 1:
-===== Importing abbreviations =====+{{indexmenu_n>50}} 
 +====== 17.05. Importing abbreviations =====
 +Importing abbreviations is a great way of quickly entering a large number of abbreviations for use in [[dispensing:dispensary_mode|dispensary mode]] (see the [[dispensing:abbreviations|Abbreviations]] section for details).
 +To create the import file, create a spreadsheet with two columns like this:
-This feature allows [[dispensing:abbreviations|patient instruction abbreviations]] to be loaded into mSupply so that they can be used in [[dispensing:dispensary_mode|Dispensary mode]]. It is accessed from the //File// menu by choosing //Import abbreviations//.+{{ :import_and_export:import_abbrev.png }}
-You may import the list of abbreviations used for patients' directions - e.g. the abbreviation // tid// would appear on the label as // three times daily// .+Enter the short abbreviation you will type in the //Abbreviation// column. Enter the text this will be expanded to in the //Expanded text// column. Make a new row for each abbreviation.
-Your list should be in the format of a 2-column spreadsheetsaved as a tab delimited fileThe first column should contain the abbreviationand the second column should contain the expanded text as it should appear on the label.+<WRAP center round important 60%> 
 +Note: your abbreviations cannot contain the underscore (''_'')period (''.'') or comma ('','') characters.\\ \\ If there are any non-printable characters or spaces in the abbreviations they will be removed on import. 
-Your tab delimited file would appear something like this:+When the spreadsheet is complete, export it as a tab delimited text file.
-{{ :import_and_export:import_abbrev.png }}+Close the spreadsheet application then choose **File > Import > Import abbreviations...** from the menus in mSupply. Select the file you just created in the window that opens (navigate to it and either double-click it or single-click on it and click on the **Open** button). The following import options window will be displayed: 
 +{{ :import_and_export:abbreviations_import_options.png?500 |}} 
 +If the first row in your spreadsheet contained the column headers and not an abbreviation, check the **First line contains column headers** checkbox to tell mSupply to ignore it. 
 +If the spreadsheet software has added quotes around any of the fields during the export to a text delimited file then check the **Remove quote characters on import** checkbox (you can use the **Previous** and **Next** buttons in the preview panel to see if quote characters have been added). 
 +Select one of the options in the //If duplicate codes are detected// section to tell mSupply what it should do if an abbreviation already in mSupply or previously in the spreadsheet is detected. 
 +When you're ready, click on the **Import now** button to carry out the import.
-// Previous: [[import_and_export:import_prescribers|Importing prescribers]]     Next: [[dispensing:printer_setup|Printing Preferences]]//+\\ 
 +|  //  Previous:  **[[import_and_export:import_prescribers]]** | | Next: **[[import_and_export:importing_customer_budgets]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  • Last modified: 2017/07/03 21:05
  • by rozanna