The concept was the user could vie a list of parts in the Inventory Report Designer, export them to a file, adjust the file as necessary, and then import the file into the Delete Inventory Routine and delete the uploaded items. The feature currently supports text-files only.
When importing items from a text file there needs to be a column with “UNIQUE” in the title. Optionally, there can also be a column called “DELETE”
Requirement for the import
as stated above, column UNIQUE must be present
also, the file must be a “TEXT”.
run DESIGN INVENTORY REPORT with columns UNIQUE, CATEGORY & PARTNO
export into an Excel File or Spreadsheet
Clean up the file for unwanted lines like the TOTAL at the very bottom of the report, etc.
Highlight everything “COLUMNS & ROWS”
Set everything to TEXT, see sample below.
delete_inventory_routine.txt · Last modified: 2018/12/21 10:59 (3 years ago) by fgabiana