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 [2019/08/28 06:23] louimport_and_export:importing_locations [2023/08/14 23:26] (current) – [17.07. Importing locations] Mark Glover
Line 1: Line 1:
 {{indexmenu_n>70}} {{indexmenu_n>70}}
-====== 11.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 ^
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: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: 2019/08/28 06:23
  • by lou