Differences

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

--- import_and_export:import_abbrev [2011/06/05 12:31] – Craig Drown
+++ import_and_export:import_abbrev [2021/10/08 09:31] (current) – Gary Willetts
@@ Line 1: / Line 1: @@
-===== Importing abbreviations =====
+{{indexmenu_n>50}}
-{{entry>85.Import & Export/8.Importing Abbreviations|*}}
+====== 17.05. Importing abbreviations ======
-This feature is normally used in Dispensary mode for patient instruction abbreviations. It is accessed from the //File// menu by choosing //Import 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 may import the list of abbreviations used for patients' directions - e.g. the abbreviation // tid// would appear on the label as // three times daily// .
+To create the import file, create a spreadsheet with two columns like this:
-Your list should be in the format of a 2-column spreadsheet, saved as a tab delimited file. The first column should contain the abbreviation, and the second column should contain the expanded text as it should appear on the label.
+{{ :import_and_export:import_abbrev.png }}
-Your tab delimited file would appear something like this:
+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.
-{{ :import_and_export:import_abbrev.png }}
+<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>
+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]]** | | Next: **[[import_and_export:importing_customer_budgets]]** //  |
 ---- struct data ----
+pagestatus.status    :
 ----