Ignored Columns

Option for users to drop columns from the import process.

There can be a situation where users want to skip a column during data submission. This is especially useful when using the importer to update existing data. To avoid overwriting existing columns, the users can mark those columns as Ignored and the importer will skip them.

With CSVbox you can give the option to the users to mark certain columns as Ignored.

Enabling Ignored Columns

The first step is to activate the Ignore Columns option via your CSVbox dashboard.

1. Login to your account.

2. Edit the sheet of your choice.

3. Go to the 'Options' Tab.

4. Select 'Yes' for the 'Allow Columns to be Ignored' field.

5. Click 'Save'.

The importer will then show the option to mark the columns as Ignored on the Column Mapping screen.

Ignored Column Selection

Ignored Column

The columns that are marked as Ignored will not be visible on the Verify Data screen.

For columns that are marked as "Required", the Ignore Column option will not be available for selection.

Default Selection

When the Default Selection option is configured to 'Yes', all the unmapped columns will default to Ignore Column.

Data from Ignored Columns

The Ignored Columns will not be pushed to any destination. Only the metadata (List of Ignored Columns) will be pushed to the following destinations:

1. API/Webhook

2. Zapier

3. Client Side

Ignored Column List

In the API response JSON object, the list of Ignored Columns will be displayed inside the ignored_columns object as shown below. The ignored_columns object will be visible only if the Ignored Columns are activated. In the example below check lines 16 and 36.

[
  {
    "import_id": 79418895,
    "sheet_id": 55,
    "sheet_name": "Products",
    "row_number": 1,
    "row_data": {
          "Name": "TP-Link TL-WN822N Wireless N300 High Gain USB Adapter",
          "SKU": "AS-100221",
          "Price": "33.00",
          "Quantity": "3"        
    },
    "custom_fields": {
      "user_id": "1002"
    },
    "ignored_columns": ["qualification", "experience"]
  },
  {
    "import_id": 79418895,
    "sheet_id": 55,
    "sheet_name": "Products",
    "row_number": 2,
    "row_data":{
          "Name": "EPower Technology EP-600PM Power Supply 600W ATX12V 2.3 Single 120mm Cooling Fan Bare",
          "SKU": "AS-103824",
          "Price": "95.35",
          "Quantity": "8",
           "_ignored_data":{
		"qualification": "MA",
		"experience": "6"
           }
        },
    "custom_fields": {
      "user_id": "1002"
    },
    "ignored_columns": ["qualification", "experience"]
  }
]