import_and_export:importing_items

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_items [2023/04/04 14:45] – [Import file format] Gary Willettsimport_and_export:importing_items [2023/08/16 00:20] (current) – [Import new item codes] Mark Glover
Line 1: Line 1:
 {{indexmenu_n>10}} {{indexmenu_n>10}}
 ====== 17.01. Importing items ====== ====== 17.01. Importing items ======
-You can import a tab-delimited text file of items by choosing **File > Import > Import items...**.+You can import a <wrap em>tab-delimited text file</wrap> of items by choosing **File > Import > Import items...**.
  
 <WRAP center round important 80%> <WRAP center round important 80%>
Line 33: Line 33:
  
 <WRAP center round important 60%> <WRAP center round important 60%>
-As of v5 (or earlier) it should not be possible to create an item with the same code as another item. Hence, item with duplicate Item code will be ignored.+As of v5 it should not be possible to create an item with the same code as another item. Hence, item with duplicate Item code will be ignored.
 </WRAP> </WRAP>
  
Line 120: Line 120:
 | 31             | AF             | Default outer pack volume            | The volume of an outer pack in m<sup>3</sup>, filled in by default when receiving goods but can be simply overridden. | | 31             | AF             | Default outer pack volume            | The volume of an outer pack in m<sup>3</sup>, filled in by default when receiving goods but can be simply overridden. |
  
-All these are in this handy template: {{ :import_and_export:msupply_item_import_template_1_.xlsx |mSupply Item Import template}}+All these are in this handy template: {{ :import_and_export:msupply_item_import_template.xlsx |mSupply Item Import template}}
  
 The chances are that you already have a set of codes that you use internally. In this case open up Excel or a similar spreadsheet program, fill in the item description in the order shown above. For a quick solution, you only need to fill in the first four columns, the rest can be ignored. The chances are that you already have a set of codes that you use internally. In this case open up Excel or a similar spreadsheet program, fill in the item description in the order shown above. For a quick solution, you only need to fill in the first four columns, the rest can be ignored.
Line 142: Line 142:
 ==== Import new item codes ==== ==== Import new item codes ====
  
-If you need to change the item codes for a selection of items in bulk, custom code has been developed for this purpose.  It is a technically challenging process that is easy to get wrong.  Please contact Sustainable Solutions on support@msupply.org.nz to discuss this.  Include a link to this heading [[https://docs.msupply.org.nz/import_and_export:importing_items#import_new_item_codes|Import new item codes]] :-).+If you need to change the item codes for a selection of items, it is a technically challenging process that is easy to get wrong if done manually, especially if you intend to re-use existing codes (not recommended!).  Custom code has been developed to do this in bulk.  Please contact Sustainable Solutions on support@msupply.org.nz to discuss this.  Include a link to this heading [[https://docs.msupply.org.nz/import_and_export:importing_items#import_new_item_codes|Import new item codes]] :-).
  
 The relevant details are: The relevant details are:
  • Last modified: 2023/04/04 14:45
  • by Gary Willetts