How to filter records before importing

Import WP allows you to create filters on your xml or csv file before each record is imported, filters can be added via the Filter Rows section found under the Run Import tab of the edit importer screen, or if you prefer more complex filters can be added in code.

Clicking add filter button will expand the filter ui allowing you to add multiple conditions by clicking the and or or buttons.

Filter conditions

To best explain each condition, the following dataset will be used for the following examples.

1, saw
2, circular saw
3, circular saw blade
4, red circular saw
5, blue saw
6, drill
7, cordless drill
8, cordless drill bit
9, red cordless drill
10, blue drill

Text equals

The Text Equals condition allows you to skip row/records that match the input, using the previously defined dataset and skipping rows where the text equals circular saw will skip the 2nd record, and import the remaining records.

Records Imported where skipped record text equals ‘circular saw’:

1, saw
3, circular saw blade
4, red circular saw
5, blue saw
6, drill
7, cordless drill
8, cordless drill bit
9, red cordless drill
10, blue drill

Text not equals

The Text not equals condition allows you to skip row/records that do not match the input, using the previously defined dataset and skipping rows where the text does not equal circular saw will skip all records except for the 2nd record.

Records Imported where skipped record text not equals ‘circular saw’:

2, circular saw

Text contains

The Text Contains condition allows you to skip row/records that contain part of the input, using the previously defined dataset and skipping rows where the text equals circular saw will skip the 2nd – 4th records, and import the remaining.

Records Imported where skipped record text contains ‘circular saw’:

1, saw
5, blue saw
6, drill
7, cordless drill
8, cordless drill bit
9, red cordless drill
10, blue drill

Text not contains

The Text Not Contains condition allows you to skip row/records that do not contain part of the input, using the previously defined dataset and skipping rows where circular saw is not found, skipping the 1st, 5-10th.

Records Imported where skipped record text does not contain ‘circular saw’:

2, circular saw
3, circular saw blade
4, red circular saw

Text is listed in

The Text is listed in condition allows you to skip row/records where they equal an item in the list, using the previouslt defined dataset and skipping rows where the value is either circular saw or cordless drill will skip the 2nd and 7th rows.

Records Imported where skipped record text is listed in either ‘circular saw’ or ‘cordless drill’:

1, saw
3, circular saw blade
4, red circular saw
5, blue saw
6, drill
8, cordless drill bit
9, red cordless drill
10, blue drill

Text not listed in

The Text not listed in condtion allows you to skip row/records where they do not equal an item in the list, using the previously defined dataset and skipping rows where the values are not circular saw and cordless drill will skip the 1st, 3-6th and 8-10th rows.

Records Imported where skipped record text is not listed in either ‘circular saw’ or ‘cordless drill’:

2, circular saw
7, cordless drill

Contains text in list

The Contains text in list condition allows you to skip row/records where they are not found in the list, using the previously defined dataset and skipping rows where the values match circular saw or cordless drill will skip 2-4th, 7-9th rows.

Records Imported where skipped record text contains text in list ‘circular saw’ or ‘cordless drill’:

1, saw
5, blue saw
6, drill
10, blue drill

Does not contain text in list

The Does not contain text in list condition allows you to skip row/records where they are found in the list, using the previously defined dataset and skipping rows where the values do not match circular saw or cordless drill will skip the 1st, 5-6th, 10th rows.

Records Imported where skipped record text does not contains text in list ‘circular saw’ or ‘cordless drill’:

2, circular saw
3, circular saw blade
4, red circular saw
7, cordless drill
8, cordless drill bit
9, red cordless drill

How to import Attachments from Google Drive