| Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision |
| import_and_export:import_items_and_stock [2023/04/04 14:20] – [Import file format] Gary Willetts | import_and_export:import_items_and_stock [2023/04/21 02:53] – [Import file format] Mark Glover |
|---|
| |
| ==== 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 ^ |
| | 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. | |
| | 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) | Outer pack size | **Optional**, Integer. The number of packs that fit in a carton (NOT the number of units in a carton!). | | | 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) | Volume per pack | **Optional**, Decimal number. The volume that a single pack of this batch occupies on the shelf in m<sup>3</sup>. | | | 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) | Weight per pack | **Optional**, Decimal number. The weight of a single pack of this batch in kg. | | | 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) | [[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. | | | 17 (Q) | Weight per pack | **Optional**, Decimal number. The weight of a single pack of this batch in kg. | |
| |
| <WRAP important center round 90%> | <WRAP important center round 90%> |