| Both sides previous revision Previous revision Next revision | Previous revision |
| import_and_export:import_items_and_stock [2023/01/19 11:17] – [Import file format] Gary Willetts | import_and_export:import_items_and_stock [2026/02/16 12:23] (current) – [17.02. Importing stock] Gary Willetts |
|---|
| If you spot any problems, click on the **Cancel** button, fix them and try again. If all is well, click on the Import button and mSupply will carry out the import. A progress bar will show you how far through the whole process mSupply is. When it gets to the end you will be shown a message telling you how many lines were imported successfully and how many were skipped (because the item could not be identified - because the item code was missing or did not match an item in your datafile). | If you spot any problems, click on the **Cancel** button, fix them and try again. If all is well, click on the Import button and mSupply will carry out the import. A progress bar will show you how far through the whole process mSupply is. When it gets to the end you will be shown a message telling you how many lines were imported successfully and how many were skipped (because the item could not be identified - because the item code was missing or did not match an item in your datafile). |
| |
| | <WRAP center round important 60%> |
| | Any lines in the import file that belong to items that are **invisible** in the current store will be ignored and not imported. An alert message at the end of the import will inform you of any lines that were not imported because of this. For information on item visiobility in stores, see the [[other_stuff:virtual_stores#master_lists_tab_and_visibility_tab_controlling_item_visibility|26.07. Virtual stores]] page. |
| | </WRAP> |
| ==== Import file format ==== | ==== Import file format ==== |
| The import file must be a tab delimited text file. The first row can contain the column titles but all other rows in the file should contain data to be imported. These are the fields you should have (and the order they must be in) in each row of the file: | * The import file must be a tab delimited text file. |
| | * The first row can contain the column titles but all other rows in the file should contain data to be imported. |
| | * The table below details the fields you should have (and the order they must be in) in each row of the file. |
| |
| ^ Column ^ Field ^ Description ^ | ^ Column ^ Field ^ Description ^ |
| | 10 (J) | Description | **Optional**. Text, Up to 32,000 characters. The full description of the item. Be careful not to have any carriage return characters in the text though, or the import file will not be valid! | | | 10 (J) | Description | **Optional**. Text, Up to 32,000 characters. The full description of the item. Be careful not to have any carriage return characters in the text though, or the import file will not be valid! | |
| | 11 (K) | [[items:department_management|Item Department]] | **Optional**, Text, up to 30 characters. If you import a department name that doesn't exist, the department will be created. | | | 11 (K) | [[items:department_management|Item Department]] | **Optional**, Text, up to 30 characters. If you import a department name that doesn't exist, the department will be created. | |
| | 12 (L) | [[items:item_locations|Shelf Location]] | **Optional**, Text, Up to 60 characters. The code for the shelf location of this stock line. | | | 12 (L) | [[items:item_locations|Shelf Location]] | **Optional**, Text, Up to 60 characters. The code for the shelf location of this stock line.\\ If the location does not exist, the location will be created as the stock is loaded. You can then edit the location details after the import.| |
| | 13 (M) | Donor | **Optional**, Text, Up to 60 characters. The name of the donor of this stock line. If the donor doesn't exist, it will be created. | | | 13 (M) | Donor | **Optional**, Text, Up to 60 characters. The name of the donor of this stock line. If the donor doesn't exist, it will be created. | |
| | | 14 (N) | [[receiving_goods:custom_stock_fields#custom_stock_fields|Custom stock field 5]] | **Optional**, Text. The value to be entered in custom stock field 5 for this batch. If the value doesn't already exist as an option for custom stock field 5 then it will be added. See the [[receiving_goods:custom_stock_fields]] page for details of custom stock fields. | |
| | | 15 (O) | Outer pack size | **Optional**, Integer. The number of packs that fit in a carton (NOT the number of units in a carton!). | |
| | | 16 (P) | Volume per pack | **Optional**, Decimal number. The volume that a single pack of this batch occupies on the shelf in m<sup>3</sup>. | |
| | | 17 (Q) | Weight per pack | **Optional**, Decimal number. The weight of a single pack of this batch in kg. | |
| | | 18 (R) | Manufacturer | **Optional**, Text. The code of the manufacturer of this batch. If a manufacturer with this code doesn't exist in the datafile then it is created with the Code, Name and Charge to values all set to the contents of this cell. | |
| |
| <WRAP important center round 90%> | <WRAP important center round 90%> |
| **Please note:** It is not part of the import file but, if an item's default Volume per pack is set (see the **Volume per pack** fied on the [[items:item_basics:tab_storage]] page for details) then this will be applied to the stock line's volume per pack. The value will be proportionately increased or decreased if the stock line's pack size differs from the item's default pack size (**Preferred pack size** field on the [[items:item_basics:tab_storage]] page). | **Please note:** It is not part of the import file but, if an item's default Volume per pack is set (see the **Volume per pack** field on the [[items:item_basics:tab_storage]] page for details) then this will be applied to the stock line's volume per pack. The value will be proportionately increased or decreased if the stock line's pack size differs from the item's default pack size (**Preferred pack size** field on the [[items:item_basics:tab_storage]] page). |
| </WRAP> | </WRAP> |
| |