Skip to main content

Importing components from a CSV file

File format​

Your CSV should have the following columns:

  • component: component unique identifier
  • op_number: operation sequence number
  • machine: machine name

To add extra information, you can include these columns:

  • description: component description
  • op_description: operation description
  • cycle_time: cycle time (in seconds)
  • setup_time: setup time (in seconds)
  • route_version: route version number (defaults to 1)
  • issue: component issue / revision (max 10 characters)

How to import​

  1. Go to Manage → Components, click the ⋮ in the top right, then Start CSV Import
  2. Choose options:
    • Split duplicates: creates separate routes for duplicate components
    • Overwrite old routes: replaces existing routes instead of versioning
  3. Select your CSV file
  4. Click Review to validate the data
  5. Confirm the import if the preview looks correct

Routes​

New routes are created through the CSV import process with two configurable options. Split duplicates creates separate routes when the same component name appears multiple times, allowing for multiple manufacturing paths for the same part.

Overwrite old routes determines how the system handles existing components. When enabled, it deletes all current routes for an existing component before creating new ones; when disabled, it creates a new route version while preserving existing routes. This lets you either maintain multiple concurrent manufacturing methods or replace outdated routes entirely.

warning

If you choose to overwrite old routes, the old job information (including clocked jobs) is deleted.

Issues​

Add an issue column to set the component issue (revision) on import. If a component appears across several rows with different issue values, each distinct issue is created for that component; issues that already exist on the component are matched case-insensitively and are not duplicated.

If you omit the issue column, components are imported with your organisation's default issue.

Example​

Download example CSV

component,description,op_number,op_description,cycle_time,setup_time,machine,issue,route_version
155332,Engine block housing,10,Face Off Block,145,399,VMC2,A,1
155332,Engine block housing,20,Semi-Finish Block,145,399,VMC2,A,1
155333,Block head,10,Rough,120,600,VMC2,B,1
155333,Block head,20,Drill and tap,120,600,VMC2,B,1