import_and_export:importing_locations

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
import_and_export:importing_locations [2017/07/03 21:06] rozannaimport_and_export:importing_locations [2023/08/14 23:26] (current) – [17.07. Importing locations] Mark Glover
Line 1: Line 1:
-====== Importing locations ====== +{{indexmenu_n>70}} 
- +====== 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 ^
Line 13: Line 17:
 | 3 | C | Location description | For your reference only, a longer description of the location e.g. "Aisle A, shelf 1, position C". | | 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               | The total storage volume of the location in m<sup>3</sup> (cubic metres). | | 4 | D | Volume               | The total storage volume of the location in m<sup>3</sup> (cubic metres). |
-| 5 | E | Priority             | A whole number from 0 upwards. This is used when printing a picking slip. Setting a priority for a location will override the default alphabetical ordering of shelf locations in a picking list. A location with a lower priority number will be printed before a location with a higher priority number. All locations with 0 priority are counted as having no priority and will be printed, in alphabetical order, after all locations with a priority. | +| 5 | E | Priority             | A whole number from 0 upwards. This is used when printing a picking slip. Setting a priority for a location will override the default //alphabetical// ordering of shelf locations in a picking list. A location with a lower priority number will be printed before a location with a higher priority number. All locations with 0 priority are counted as having no priority and will be printed, in alphabetical order, //after// all locations with a priority. | 
-| 6 | F | Is summary location  | Whether the location is a summary location that cannot hold stock. "y""yes""tor "trueis interpreted as true, anything else (including nothing) is interpreted as false. |+| 6 | F | Is summary location  | Whether the location is a summary location that cannot hold stock. ''y''''yes''''t'' or ''true'' is interpreted as true, anything else (including nothing) is interpreted as false. |
 | 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 it will be created so make sure your typing is accurate! |+| 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: {{:import_and_export:location_import_template.xlsx|}} An empty Excel spreadsheet containing these columns for you to use as a template is here: {{:import_and_export:location_import_template.xlsx|}}
Line 36: 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:the_log|The log]]). 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:the_log|The log]]).
  
 +<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>_</wrap>).
 +</WRAP>
  
-// Previous: [[import_and_export:importing_customer_budgets|Importing customer budgets]]     Next: [[import_and_export:export_invoice|Exporting invoices]]//+\\ 
 +\\ 
 +|  //  Previous:  **[[import_and_export:importing_customer_budgets]]** | | Next: **[[import_and_export:importing_a_supplier_invoice]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2017/07/03 21:06
  • by rozanna