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 [2021/05/10 13:57] – [16.07. Importing locations] Gary Willetts | import_and_export:importing_locations [2023/08/14 23:26] (current) – [17.07. Importing locations] Mark Glover |
---|
{{indexmenu_n>70}} | {{indexmenu_n>70}} |
====== 16.07. Importing locations ====== | ====== 17.07. Importing locations ====== |
Locations are the labelled places in your warehouse where you store stock. Locations can be created individually (see [[items:item_locations|here]]) or can be created automatically when you import stock (see [[import_and_export:import_items_and_stock|here]]). The functionality to import locations described here will save you a lot of time if you need to put a lot of locations into mSupply separately from importing stock. | Locations are the labelled places in your warehouse where you store stock. Locations can be created individually (see [[items:item_locations|here]]) or can be created automatically when you import stock (see [[import_and_export:import_items_and_stock|here]]). The functionality to import locations described here will save you a lot of time if you need to put a lot of locations into mSupply separately from importing stock. |
| |
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> (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: |
| |
<WRAP center round important 60%>All columns must be present in the import file but only the first 2 (Location code and Store code or name) are mandatory. If either of these fields do not have values entered then the location will be ignored.</WRAP> | <WRAP center round important 60%>All columns must be present in the import file but only the first 2 (Location code and Store code or name) are mandatory. If either of these fields do not have values entered then the location will be ignored.</WRAP> |
| |
| <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> |
| |
| |
^ Column number ^ Column letter ^ Field ^ Description ^ | ^ Column number ^ Column letter ^ Field ^ Description ^ |