Run data imports

Data imports let you load many records into Bulk from a CSV or Excel file instead of creating them one by one. You pick an import type (for example Customers, Parts, or Production Jobs), upload the file, map its columns to Bulk fields, validate the rows, and run the import into the site you currently have selected.

Use imports when you are onboarding a site, migrating master data from another system, or bringing in a large list of production jobs, projects, or tasks. Day-to-day single-record work still happens on the normal master-data and production screens; this page is for batch loading.

Before you startCopy Anchor Link

1. Open Settings, expand the Data group, and select Imports. The list page address ends in /settings/data/imports.
2. Select the site (entity) you want the records to land in. Import history and new imports are always scoped to the selected site. If no site is selected, Bulk asks you to select one before you can continue.
3. Prepare a CSV, XLSX, or XLS file. One file at a time; maximum size 50 MB. Put column headers in the first row so Bulk can suggest mappings.
4. Confirm the import type you need is enabled for your organization. Admins can turn types on or off under Settings → Organization → Settings, on the Imports tab.

You need these permissions:

• imports.view: open the Imports page, browse history, and open a job’s detail view.
• imports.manage: start a new import (the New Import button and the wizard). Built-in roles that grant this include Super user, Entity admin, and Master data.
• The create permission for the target data (for example customers.create for Customers, parts.create for Parts, production_jobs.create for Production Jobs). Without that permission, creating a job for that type is rejected even if you can manage imports.

If New Import is missing, you likely have view-only access. If a type does not appear in the wizard, it may be disabled for the organization, or you may lack the matching create permission once you try to upload.

What the Imports page showsCopy Anchor Link

The page title is Data Imports. With a site selected, the description names that site. Users who can manage imports see a New Import button in the header.

When there are past jobs, a table lists recent imports for the site. Its columns are File, Status, Definition, Results, Created by, and Completed. Each row shows:

• The file name and a status badge (for example Completed, Importing, Failed).
• The import type label (for example Customers) and total row count when known.
• Who started the import and roughly when.
• On completed jobs: how many records were imported and how many rows had errors. The detail view provides create and update counts when available.

Select a row to open the job detail page. If the site has never imported, you see No imports yet with an optional Create Your First Import action when you have manage permission.

Available import typesCopy Anchor Link

Only types enabled for your organization appear in the wizard. Labels and required fields come from Bulk’s built-in catalogue. Common types include:

For Customers, optional targets also include contact fields (email, phone, notes, currency_unit_id) and structured address fields (street, city, state, zipcode, country, address_kinds, address_label, is_primary). To attach multiple addresses to one customer, repeat the same code on extra rows and fill the address columns on each row; scalars such as name and currency only need to appear on the first row of the group. address_kinds accepts semicolon-separated values business, invoice, and delivery. Free-text address is no longer imported; map structured address columns instead.

Reference fields (for example customer code, part number, or process code) must already exist in the selected site when the import looks them up. Tasks is the only type that can update an existing record when the same task name and project already match; other types create new records and apply their target data’s uniqueness rules. Customers rejects a code that already exists in the selected site’s legal entity, so use new codes when preparing another customer import.

Run a new importCopy Anchor Link

1. Select New Import. The New Import page opens at /settings/data/imports/new with the six-step wizard.
2. Work through the steps below. Use Continue (or Validate on the mapping step) to move forward, Back to return, and Cancel if you need to abandon the job.

Step 1: Select TypeCopy Anchor Link

Choose the type of data to import. Search the grouped list and select one type. Each row shows its label and required and optional field counts. The selected type’s description and counts appear below the list. The catalogue table above lists required field names; the mapping step shows the available targets. Select Continue.

If no types appear (No Import Types Available), an administrator must enable import types for the organization (organization Import Settings), or contact Bulk support if the catalogue was never seeded for the tenant.

Step 2: UploadCopy Anchor Link

Upload a CSV, XLSX, or XLS file for the selected site: drag and drop onto the drop zone, or select browse. Progress shows preparing, uploading, then processing. When the file is accepted, Bulk creates an import job and moves you toward the preview once parsing finishes.

Step 3: PreviewCopy Anchor Link

File Preview shows sample rows (up to 20) from the total row count, column headers, and automatically detected data types. Confirm the file looks right, then Continue.

Step 4: Map ColumnsCopy Anchor Link

Column Mapping links each source column to a target field. Bulk suggests matches from header names. Required targets are marked; you cannot continue until every required field is mapped. Unneeded source columns can stay unmapped (they are skipped). When mapping is complete, select Validate: Bulk saves the mapping and starts validation.

Step 5: ValidateCopy Anchor Link

While status is Validating, progress shows rows processed. When status is Validated, Validation Results summarize Valid Rows, Invalid Rows, and warnings. If there are invalid rows, open Error Summary (by error type and by field) or Error Details (row-level messages). Fix the file and start a new import if needed, or continue and skip invalid rows on the next step. Select Continue when validation has finished.

Step 6: ImportCopy Anchor Link

Confirm Import shows total, valid, and invalid row counts and Rows to import. If invalid rows exist, Bulk shows Skip invalid rows and import only valid data. Leave it checked (the default) so only valid rows load; if you clear it, import stops when it hits invalid data. Select Start Import (N rows).

While status is Importing, progress shows processed rows, successes, creates/updates when available, and errors. On success you see Import Completed (or Import Completed with Errors / Import Failed if rows failed). Select Done to return to the Imports list.

Review a completed importCopy Anchor Link

Open any history row to go to /settings/data/imports/<job id>. The detail page shows:

• Breadcrumbs: Settings → Data → Imports → file name.
• File name as the title, import type and creator in the description, and a status badge.
• Live progress while status is Validating or Importing.
• Stat cards: Total Rows, Processed, Created / Updated (or Successful), and Errors.
• Details tab: file name and size, import type, creator, created/started/completed times, duration, column mapping (source → target, or skipped), and any job-level error message.
• Errors tab (when the job has errors): paginated row errors with field messages.

Status labels you may see across the flow: Pending, Parsing, Parsed, Validating, Validated, Importing, Completed, Failed, Cancelled.

Example: customer list at Wayne AerospaceCopy Anchor Link

Bruce Wayne is preparing customer master data for Wayne Aerospace. His burnley-customers.csv file has columns code, name, and notes, with the new customer Burnley Tooling. For customers that need more than one address, he can add rows that repeat the same customer code and fill structured address columns.

Bruce selects Wayne Aerospace, opens Settings → Data → Imports, and selects New Import. He chooses Customers, uploads the CSV, checks the preview, and confirms the code, name, and optional notes mappings. He validates, checks the valid-row count, and starts the import. When the job reaches Completed, its history row shows the file under Customers with the imported count. The customer belongs to the site’s legal entity, so sites sharing that legal entity use the same customer record.

Expected resultCopy Anchor Link

After a successful import:

• The job status is Completed (sometimes with a non-zero error count if invalid rows were skipped).
• New records exist in the selected site for the import type (or existing Tasks were updated when name and project matched).
• The job appears at the top of Import History for that site, and its detail page shows mapping, counts, and any row errors.

Feature state and limitsCopy Anchor Link

Data imports are generally available. Keep these limits in mind:

• Import jobs and history are per site. Target records keep their own scope; for example, Customers belongs to the selected site’s legal entity and is shared by sites using that legal entity.
• File formats are CSV, XLSX, and XLS only, one file at a time, max 50 MB.
• Organization-level toggles can hide types from the wizard even when the product supports them.
• Creating a job also requires the target create permission for that type, not only imports.manage.
• Only Tasks updates existing rows on match; other types insert new rows and apply their own uniqueness rules. Customers rejects an existing active code in its legal entity.
• Cancel is only available while a job is still Pending, Parsing, or Validating: not once import has started.

TroubleshootingCopy Anchor Link

• "Select a site to view imports" / "Select a site before importing": choose a site in the site switcher, then reopen Imports.
• New Import is missing: you need imports.manage (for example Entity admin, Master data, or Super user).
• No Import Types Available: enable types under organization Import Settings, or ask an admin to enable them.
• "Import type not enabled for your organization": the type is off for the tenant; turn it on in organization Import Settings.
• Missing required field mappings: on Map Columns, map every required field shown for the type (for example code and name for Customers).
• Many invalid rows on Validate: open Error Details, fix values (enums, lengths, missing references such as part numbers or customer codes that must already exist), re-export the file, and run a new import.
• Import stops on invalid data: enable Skip invalid rows and import only valid data on Confirm Import, or clean the file first.
• Permission error when creating the job: you need the create permission for that data type (for example parts.create) in addition to imports.manage.
• Import not found on the detail page: wrong site selected, or you lack imports.view for that job.

RelatedCopy Anchor Link

• Configure exports: pull data out of Bulk for reporting or migration the other way.
• Configure reports: saved and scheduled reporting.
• Manage processes: process master data that production-job imports can reference by code.
• Manage customers: maintain customer records after bulk load.
• Manage parts: maintain part numbers after bulk load.
• Manage roles and permissions: grant imports.view, imports.manage, and target create permissions.