Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
import_and_export:import_abbrev [2017/07/03 21:05] – rozanna | import_and_export:import_abbrev [2021/10/08 09:31] (current) – Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Importing abbreviations ===== | + | {{indexmenu_n> |
+ | ====== 17.05. | ||
+ | Importing abbreviations is a great way of quickly entering a large number of abbreviations for use in [[dispensing: | ||
+ | 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' | + | Enter the short abbreviation |
- | 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 | + | <WRAP center round important 60%> |
+ | Note: your abbreviations cannot contain | ||
+ | </ | ||
- | Your tab delimited file would appear something like this: | + | When the spreadsheet is complete, export it as a tab delimited |
- | {{ : | + | 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: |
+ | |||
+ | {{ : | ||
+ | |||
+ | If the first row in your spreadsheet contained the column headers and not an abbreviation, | ||
+ | |||
+ | 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: | + | \\ |
+ | \\ | ||
+ | | | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||