Differences

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

Link to this comparison view

Both sides previous revision Previous revision
import_and_export:importing_locations [2025/08/09 11:05] – [17.07. Importing locations] Mark Gloverimport_and_export:importing_locations [2025/08/09 11:15] (current) – [17.07. Importing locations] Mark Glover
Line 13: Line 13:
  
 ^ Column ^ Field  ^ Description ^ ^ Column ^ Field  ^ Description ^
-| 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. "A01or "A01.03.C". |+| 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. ''A01'' or ''A01.03.C''. |
 | 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...// | | 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...// |
-| C | Location description | For your reference only, a longer description of the location e.g. "Aisle A, shelf 1, position C". |+| C | Location description | For your reference only, a longer description of the location e.g. ''Aisle A, shelf 1, position C''. |
 | D | Volume               | The total storage volume of the location in m<sup>3</sup> (cubic metres). | | D | Volume               | The total storage volume of the location in m<sup>3</sup> (cubic metres). |
 | 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. | | 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. |
-| 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. | +| 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.  <WRAP center round important 60%> 
-| 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). | +As of August 2025, the summary location field exists in mSupply, but it has no functionality. 
-| 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. |+</WRAP>  
 +| G | Location type        | The location type for this location.  <WRAP center round important 60%> 
 +This text must be an exact match for an existing location type in mSupply, otherwise the location will be created with no location type. 
 +</WRAP> |  
 +| 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.  Make sure that the parent location is imported first! <WRAP center round important 60%> 
 +As of August 2025, the parent / child location feature does not function. 
 +</WRAP> |
  
 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|}}
  • Last modified: 2025/08/09 11:15
  • by Mark Glover