csvbox.io
  • Help Center
  • Getting Started
    • 1. Add Template
    • 2. Install Code
    • 3. Receive Data
  • Dashboard Settings
    • Column Options
    • Bulk Add Columns
    • Validations
    • Sheet Options
    • Styling
    • AI Bulk Transforms
  • Advanced Installation
    • Dynamic Columns
    • Virtual Columns
    • Unmapped Columns
    • Ignored Columns
    • Import Links
    • Validation Functions
    • Server Side Validation
    • Data Transforms
    • REST File API
    • Environment Variables
  • Data Destinations
    • Bubble.io
    • Zapier
    • Notion
    • Webflow
    • Private Mode
  • Account
    • Teams
  • Contact Us
  • App
  • Website
  • Login
  • Change Log
  • Suggestions
  • Legal
    • Privacy Policy
    • Terms of Use
    • Cookie Policy
    • User Data Policy
    • GDPR
      • Data Processing Addendum
    • SOC 2 Type 2
Powered by GitBook
On this page
  • Enabling Ignored Columns
  • Data from Ignored Columns

Was this helpful?

  1. Advanced Installation

Ignored Columns

Option for users to drop columns from the import process.

PreviousUnmapped ColumnsNextImport Links

Last updated 1 year ago

Was this helpful?

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.

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:

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"]
  }
]

Zapier
Ignored Column Selection
Ignored Column
Client Side
API/Webhook