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:importing_locations [2018/01/22 07:10] – [Importing locations] mark | import_and_export:importing_locations [2023/08/14 23:26] (current) – [17.07. Importing locations] Mark Glover | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{indexmenu_n> | {{indexmenu_n> | ||
- | ====== Importing locations ====== | + | ====== |
- | + | ||
Locations are the labelled places in your warehouse where you store stock. Locations can be created individually (see [[items: | Locations are the labelled places in your warehouse where you store stock. Locations can be created individually (see [[items: | ||
- | As with the other import features of mSupply, this import uses a tab delimited text file (easily produced by exporting a spreadsheet from Excel or other spreadsheet programme). The columns that must be present in the file and their contents are as follows: | + | This import uses a <wrap em>tab delimited text file</ |
< | < | ||
+ | |||
+ | <WRAP center round alert 60%> | ||
+ | The import must take place when the user is logged in to the store on the site where the store is Active | ||
+ | </ | ||
+ | |||
^ Column number | ^ Column number | ||
Line 15: | Line 18: | ||
| 4 | D | Volume | | 4 | D | Volume | ||
| 5 | E | Priority | | 5 | E | Priority | ||
- | | 6 | F | Is summary location | + | | 6 | F | Is summary location |
| 7 | G | Location type | The name of the location type for this location (must be an exact match and the location type must already exist in mSupply, otherwise the location will be created with no location type). | | | 7 | G | Location type | The name of the location type for this location (must be an exact match and the location type must already exist in mSupply, otherwise the location will be created with no location type). | | ||
- | | 8 | H | Parent location code or description | The code or description of the location which is a parent to this one. If the parent does not already exist in mSupply | + | | 8 | H | Parent location code or description | The code or description of the location which is a parent to this one. If the parent does not already exist in mSupply |
An empty Excel spreadsheet containing these columns for you to use as a template is here: {{: | An empty Excel spreadsheet containing these columns for you to use as a template is here: {{: | ||
Line 37: | Line 40: | ||
When you're ready to carry out the import, click on the //OK// button. mSupply will carry out the import and tell you how many locations were imported, how many already in mSupply were modified and if there were any errors. You can see more details by viewing the log (see [[admin: | When you're ready to carry out the import, click on the //OK// button. mSupply will carry out the import and tell you how many locations were imported, how many already in mSupply were modified and if there were any errors. You can see more details by viewing the log (see [[admin: | ||
+ | <WRAP info center round 60%> | ||
+ | If there are non-printable characters before or after the location description or code they will be removed. Any non-printable characters in the description or code will be replaced with an underscore (<wrap em> | ||
+ | </ | ||
- | // Previous: [[import_and_export: | + | \\ |
+ | \\ | ||
+ | | | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||