Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
import_and_export:import_abbrev [2011/06/05 12:31] – Craig Drown | import_and_export:import_abbrev [2021/05/10 14:07] – [16.05. Importing abbreviations] Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Importing abbreviations ===== | + | {{indexmenu_n> |
- | {{entry> | + | ====== 16.05. |
- | This feature | + | Importing |
- | You may import | + | To create the import |
- | Your list should be in the format of a 2-column spreadsheet, | + | {{ : |
- | Your tab delimited file would appear something like this: | + | Enter the short abbreviation you will type in the // |
- | {{ : | + | <WRAP center round important 60%> |
+ | Note: your abbreviations cannot contain the underscore ('' | ||
+ | </ | ||
+ | |||
+ | 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 ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||