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 [2015/03/15 23:44] fergusimport_and_export:import_abbrev [2021/10/08 09:31] (current) Gary Willetts
Line 1: Line 1:
-===== Importing abbreviations ===== +{{indexmenu_n>50}} 
-{{entry>40.Import & Export/7.Importing Abbreviations|*}}+====== 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).
-This feature is normally used in Dispensary mode for patient instruction abbreviations. It is accessed from the //File// menu by choosing //Import abbreviations//.+To create the import file, create a spreadsheet with two columns like this:
-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// .+{{ :import_and_export:import_abbrev.png }}
-Your list should be in the format of a 2-column spreadsheet, saved as a tab delimited fileThe first column should contain the abbreviation, and the second column should contain the expanded text as it should appear on the label.+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 tab delimited file would appear something like this:+<WRAP center round important 60%> 
 +Noteyour 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. 
-{{ :import_and_export:import_abbrev.png }}+When the spreadsheet is complete, export it as a tab delimited text file. 
 +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: 2015/03/15 23:44
  • by fergus