Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
import_and_export:import_abbrev [2011/05/23 05:45] – john | import_and_export:import_abbrev [2020/04/24 12:52] – lou | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Importing abbreviations ===== | + | {{indexmenu_n> |
+ | ====== 16.05. | ||
+ | Importing abbreviations is a great way of quickly entering a large number of abbreviations for use in [[dispensing: | ||
- | 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 |
- | You may import the list of abbreviations used for patients' | + | {{ : |
- | Your list should be in the format of a 2-column | + | Enter the short abbreviation you will type in the // |
- | Your tab delimited file would appear something like this: | + | <WRAP center round important 60%> |
+ | Note: your abbreviations cannot contain the underscore (_), period (.) or comma (,) characters | ||
+ | </ | ||
- | {{ : | + | 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: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | 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: | ||
---- struct data ---- | ---- struct data ---- | ||
---- | ---- | ||