import_and_export:import_abbrev

Differences

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
Last revisionBoth sides next revision
import_and_export:import_abbrev [2018/02/07 21:49] – [Importing abbreviations] markimport_and_export:import_abbrev [2021/05/10 14:07] – [16.05. Importing abbreviations] Gary Willetts
Line 1: Line 1:
 {{indexmenu_n>50}} {{indexmenu_n>50}}
-===== Importing abbreviations =====+====== 16.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).
  
-You can import a tab-delimited text file of abbreviations by choosing **File > Import > Import abbreviations...**.+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. 
 +</WRAP>
  
-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: 2021/10/08 09:31
  • by Gary Willetts