Skip to content

Tools / CSV Error Translator

Multiple selections are split, repeated, or missing

Check the separator and the complete intended set. Routing locations have their own whitespace requirements.

A selection is repeated

Message may mention: name/parent.

What it means

A list selection may be repeated.

Import context: General imports.

Check this first

Check multi-select IDs.

Show the steps

Check multiple selections and hierarchy

  1. Identify whether the value represents a parent/child path, several selections, or an ordinary text value.
  2. Check the separator selected for this import.
  3. Make sure that separator does not split part of a real identifier.
  4. Check for a repeated selection within one cell.
  5. When updating the complete set, retain existing selections that must remain.

Hierarchy and multi-select separators serve different purposes. Oracle describes colon-separated hierarchy paths and a configurable single-character separator for multiple selections. Follow the record-specific requirements where they differ.

Hierarchy and multi-select guidance

For manufacturing routings, check the routing-specific separator and whitespace requirements. Do not silently trim all record values or apply one whitespace rule across every import.

Read Oracle's guidance

Documentation checked September 16, 2026.

A separator splits an identifier

Message may mention: Multiple values.

What it means

The configured multi-select separator may appear inside an identifier.

Import context: Inventory items.

Check this first

Choose an import separator absent from those values. Oracle also notes that a literal NULL setting can behave as a space.

Show the steps

Check multiple selections and hierarchy

  1. Identify whether the value represents a parent/child path, several selections, or an ordinary text value.
  2. Check the separator selected for this import.
  3. Make sure that separator does not split part of a real identifier.
  4. Check for a repeated selection within one cell.
  5. When updating the complete set, retain existing selections that must remain.

Hierarchy and multi-select separators serve different purposes. Oracle describes colon-separated hierarchy paths and a configurable single-character separator for multiple selections. Follow the record-specific requirements where they differ.

Hierarchy and multi-select guidance

For manufacturing routings, check the routing-specific separator and whitespace requirements. Do not silently trim all record values or apply one whitespace rule across every import.

Read Oracle's guidance

Documentation checked September 16, 2026.

An item update would remove a subsidiary already in use

Message may mention: remove subsidiary, used on a transaction.

What it means

The imported subsidiary list may replace the existing selections and leave out a subsidiary needed by earlier transactions.

Import context: Item records.

Check this first

Prepare the complete intended set in one multi-select cell, including subsidiaries that must remain. Check the separator and mapping. Do not solve this by changing the historical transactions.

Show the steps

Check multiple selections and hierarchy

  1. Identify whether the value represents a parent/child path, several selections, or an ordinary text value.
  2. Check the separator selected for this import.
  3. Make sure that separator does not split part of a real identifier.
  4. Check for a repeated selection within one cell.
  5. When updating the complete set, retain existing selections that must remain.

Hierarchy and multi-select separators serve different purposes. Oracle describes colon-separated hierarchy paths and a configurable single-character separator for multiple selections. Follow the record-specific requirements where they differ.

Hierarchy and multi-select guidance

For manufacturing routings, check the routing-specific separator and whitespace requirements. Do not silently trim all record values or apply one whitespace rule across every import.

Read Oracle's guidance

Documentation checked September 16, 2026.

Routing locations need a separator or subsidiary check

Message may mention: location.

What it means

Check the location, its subsidiary, and multi-select syntax.

Import context: Manufacturing routings.

Check this first

This routing guide specifically warns about spaces around the separator.

Show the steps

Check multiple selections and hierarchy

  1. Identify whether the value represents a parent/child path, several selections, or an ordinary text value.
  2. Check the separator selected for this import.
  3. Make sure that separator does not split part of a real identifier.
  4. Check for a repeated selection within one cell.
  5. When updating the complete set, retain existing selections that must remain.

Hierarchy and multi-select separators serve different purposes. Oracle describes colon-separated hierarchy paths and a configurable single-character separator for multiple selections. Follow the record-specific requirements where they differ.

Hierarchy and multi-select guidance

For manufacturing routings, check the routing-specific separator and whitespace requirements. Do not silently trim all record values or apply one whitespace rule across every import.

If that looks right

The routing-specific documentation warns about spaces around the multi-select separator. Check the accepted format for this routing import. Keep actual identifiers intact.

Read Oracle's guidance

Documentation checked September 16, 2026.

Browse all errors

Still stuck?

We can help you work through the file, the mapping, and the NetSuite setup behind the error.

Talk to MySuite

Last updated:

NetSuite Implementation Advisory & Administration