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 [2016/07/06 14:51] – Gary Willetts | import_and_export:importing_locations [2023/08/14 23:26] (current) – [17.07. Importing locations] Mark Glover | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Importing locations ====== | + | {{indexmenu_n> |
- | {{entry> | + | ====== |
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 | ||
+ | </ | ||
- | <WRAP important> | ||
^ Column number | ^ Column number | ||
- | | 1 | A | Location code | The code of the location. This is used to identify and select the location throughout mSupply and is the label you apply to the location in your warehouse e.g. " | + | | 1 | A | Location code | The code of the location. This is used to identify and select the location throughout mSupply and is the label you apply to the location in your warehouse e.g. " |
- | | 2 | B | Store code or name | The code or name of the store the location is to be created in. You can see the list of store names and their codes currently in your copy of mSupply by going to //Special > Show stores...// | + | | 2 | B | Store code or name | The code or name of the store the location is to be created in. You can see the list of store names and their codes currently in your copy of mSupply by going to //Special > Show stores...// | |
- | | 3 | C | Location description | For your reference only, a longer description of the location e.g. "Aisle A, shelf 1, position C". This field is optional. | | + | | 3 | C | Location description | For your reference only, a longer description of the location e.g. "Aisle A, shelf 1, position C". | |
- | | 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 | . | | + | | 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 | . | | + | | 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 the location will be imported without the parent. Please make sure that the parent location are imported first. | |
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: {{: | ||
- | When you have created the import text file go to **File** > **Import** > **Import | + | When you have created the import text file go to **File** > **Import** > **Import |
- | {{ :issuing_goods:customer_budgets_import.png?600 |}} | + | {{ :import_and_export:import_locations.png?350 |}} |
Now choose the import settings to match your file: | Now choose the import settings to match your file: | ||
Line 29: | Line 33: | ||
And select how duplicates are to be handled (a duplicate is a row which matches another line in the file or a budget already in mSupply): | And select how duplicates are to be handled (a duplicate is a row which matches another line in the file or a budget already in mSupply): | ||
+ | * **Import and continue:** The duplicate record is created and import continues normally | ||
+ | * **Ask each time:** You will be asked what you want to do with a duplicate each time one is detected; ignore it, create it or stop the import | ||
* **Skip the duplicate without asking:** The duplicate record is ignored completely | * **Skip the duplicate without asking:** The duplicate record is ignored completely | ||
- | * **Stop the import:** mSupply will stop importing | + | * **Stop the import:** mSupply will stop importing |
- | * **Update customer budget:** The budget already in mSupply will be updated with the new details found in the file and the import will continue. | + | |
- | + | ||
- | You can also click the //Next// and // | + | |
- | 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 lines were imported, how many budgets | + | 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 |
+ | <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 | ||
---- | ---- | ||