KCSL have enhanced the Stock Import Tool to allow for the
removal of child list information.
The stock import tool will be enhanced to include an
additional flag column for child lists to indicate the removal of child list
information.
Example is LinkedDocument, a new flag will be added called
DeleteExisting (Column header in import file will be LinkedDocument:DeleteExisting).
The expected values are 0 (Default) and -1.
When the value is 0 or omitted from the system the import
will act exactly as it currently does.
When the value is -1 the system will clear out the
pre-existing information for the child list and then import the data.
CAVEAT
- Owing to the order of operations the LinkedDocument:DeleteExisting
flag MUST be the first LinkedDocument column in the import file. If it is not
then the data in the import file may only be partially imported or not imported
at all.
An updated application will be provided with this
functionality.
The following fields can now be added to the TSV format
import file.
| Field Name. | Description. | Options. |
| Barcode:DeleteExisting | To delete all barcodes against the specified stock item. | 0 = Do not delete the stock item’s barcodes. -1 = Delete the stock item’s barcodes. |
| Image:DeleteExisting | To delete all images against the specified stock item. | 0 = Do not delete the stock item’s images. -1 = Delete the stock item’s images. |
| LinkedDocument:DeleteExisting | To delete all linked documents against the specified stock
item. | 0 = Do not delete the stock item’s linked documents. -1 = Delete the stock item’s linked documents. |
| Supplier:DeleteExisting | To delete all suppliers against the specified stock item. | 0 = Do not delete the stock item’s suppliers. -1 = Delete the stock item’s suppliers. |
| LINKED_STOCK_CODE:DeleteExisting | To delete all linked stock codes against the specified
stock item. | 0 = Do not delete the stock item’s linked stock codes. -1 = Delete the stock item’s linked stock codes. |
After applying the above
Configuration, typical steps for usage would include:
4.1
Using the [ Stock | Import
Stock items ] menu option.
The import will delete any
of the child list entries with a setting of -1 within the import file.
