Ignored Columns
Option for users to drop columns for 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.
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.
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.
- 2.
- 3.
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.
1
[
2
{
3
"import_id": 79418895,
4
"sheet_id": 55,
5
"sheet_name": "Products",
6
"row_number": 1,
7
"row_data": {
8
"Name": "TP-Link TL-WN822N Wireless N300 High Gain USB Adapter",
9
"SKU": "AS-100221",
10
"Price": "33.00",
11
"Quantity": "3"
12
},
13
"custom_fields": {
14
"user_id": "1002"
15
},
16
"ignored_columns": ["qualification", "experience"]
17
},
18
{
19
"import_id": 79418895,
20
"sheet_id": 55,
21
"sheet_name": "Products",
22
"row_number": 2,
23
"row_data":{
24
"Name": "EPower Technology EP-600PM Power Supply 600W ATX12V 2.3 Single 120mm Cooling Fan Bare",
25
"SKU": "AS-103824",
26
"Price": "95.35",
27
"Quantity": "8",
28
"_ignored_data":{
29
"qualification": "MA",
30
"experience": "6"
31
}
32
},
33
"custom_fields": {
34
"user_id": "1002"
35
},
36
"ignored_columns": ["qualification", "experience"]
37
}
38
]
Last modified 3mo ago