Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
import_and_export:importing_items [2022/02/10 14:53] – Gary Willetts | import_and_export:importing_items [2023/08/16 00:20] (current) – [Import new item codes] Mark Glover | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{indexmenu_n> | {{indexmenu_n> | ||
====== 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 center round important 80%> | <WRAP center round important 80%> | ||
* This command only imports (creates) items. | * This command only imports (creates) items. | ||
- | * <wrap em>This process does not introduce stock.</ | + | * <wrap em>This process does not introduce stock.</ |
- | * If you would like to import stock, see the [[import_and_export: | + | |
</ | </ | ||
Line 31: | Line 30: | ||
**Handling duplicate items:** During the import process, mSupply compares the item code in the import file (1st column - see below) against the codes of items already in its database to determine whether an entry is a duplicate item or not. If a duplicate item is found in the import file mSupply will handle it according to your radio button selection in the //If duplicate codes are selected// section: | **Handling duplicate items:** During the import process, mSupply compares the item code in the import file (1st column - see below) against the codes of items already in its database to determine whether an entry is a duplicate item or not. If a duplicate item is found in the import file mSupply will handle it according to your radio button selection in the //If duplicate codes are selected// section: | ||
- | * **Create new duplicate items and continue** and **Ask each time** | + | * **Create new duplicate items and continue** and **Ask each time** |
<WRAP center round important 60%> | <WRAP center round important 60%> | ||
- | As of v5 (or earlier) | + | 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. |
</ | </ | ||
+ | |||
* **Skip the duplicate without asking:** the duplicate is ignored and not imported. | * **Skip the duplicate without asking:** the duplicate is ignored and not imported. | ||
* **Stop the import:** if a duplicate is detected mSupply will stop and cancel the whole import i.e. the database will be exactly that same as it was before you started the import. | * **Stop the import:** if a duplicate is detected mSupply will stop and cancel the whole import i.e. the database will be exactly that same as it was before you started the import. | ||
Line 90: | Line 91: | ||
| 4 | D | reference pack size | integer | | 4 | D | reference pack size | integer | ||
| The above fields are mandatory, while the following fields are optional and may or may not be included\\ | | The above fields are mandatory, while the following fields are optional and may or may not be included\\ | ||
- | | 5 | E | shelf location | + | | 5 | E | Default |
| 6 | F | user field 1 | 30 alphanumeric characters | | 6 | F | user field 1 | 30 alphanumeric characters | ||
| 7 | G | user field 2 | 30 alphanumeric characters | | 7 | G | user field 2 | 30 alphanumeric characters | ||
Line 109: | Line 110: | ||
| 22 | V | Category 3 | 60 alphanumeric characters | | 22 | V | Category 3 | 60 alphanumeric characters | ||
| 23 | W | VEN category | | 23 | W | VEN category | ||
- | | 23 | X | Weight | + | | 23 | X | Weight |
| 24 | Y | Critical stock | " | | 24 | Y | Critical stock | " | ||
| 25 | Z | Normal stock | " | | 25 | Z | Normal stock | " | ||
Line 115: | Line 116: | ||
| 27 | AB | User field 6 | 30 alphanumeric characters | | 27 | AB | User field 6 | 30 alphanumeric characters | ||
| 28 | AC | User field 7 | " | | 28 | AC | User field 7 | " | ||
+ | | 29 | AD | Default volume per pack | The volume of a single pack of the default pack size in m< | ||
+ | | 30 | AE | Default outer pack size | The number of default packs that fit in a carton. Filled in by default when receiving goods but can be simply overridden. | | ||
+ | | 31 | AF | Default outer pack volume | ||
- | All these are in this handy template: {{ : | + | All these are in this handy 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 138: | 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. | + | If you need to change the item codes for a selection of items, |
The relevant details are: | The relevant details are: |