Delete Inventory Routine - Import from File
Print
Modified on: Thu, 8 Jul, 2021 at 12:04 PM
Delete Inventory Routine - Import from File
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”.
Steps
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.
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.
