Follow

Bulk Adding or Replacing List Entries With the UI, and Deleting a List

You can easily add new entries to a List or replace the entire contents of a List in one step by importing the new items in a text file.

Adding new entries does not disturb the existing contents of the List. In case a new entry is a duplicate value of an existing entry, the timestamp of that entry is updated according to the import file.

Replacing List entries deletes all existing entries and populates the emptied List with the new entries.

Prepare a plain-text file named with the ".csv" appendage containing your new entries. If you want SuppressionList to set the item's age using the current time, your file should contain the entries only as plain text, one per line with no header line:

If you want to pre-set the age for each item, your file may have a second, comma-delimited column that contains the timestamp you wish applied to each item. Many different timestamp formats will work but the recommended one is YYYY-MM-DD HH:MM:SS Z.

 

Upload the prepared file by clicking the appropriate button near the upper-right corner of the List's information page:

select your file and click "Upload Selected File:

Once your file upload has completed, you can refresh the UI page to see the updated count of records in your List, plus some new additions: A search box where you can check if a specific value is in the stored list, and a log of the List's Recent upload jobs.

 

Deleting a List is as simple as highlighing its name in the left-hand column, then clicking the "-" button at teh bottom of that column.

A Note About MD5 Hashing

For data security all Lists store their data in MD5-hashed form. The system will do its best to do the right thing when adding values to a List. If you submit a non-hashed value, SuppressionList will automatically hash it before adding it to the List. If you submit a string that looks like an md5 hash (32 characters long using only 0-9 and a-f), SuppressionList will add that value directly to the List without re-hashing it.

Standardizing data

Upon receiving a item to add to a List or a term to query, SuppressionList will take the following steps:

  1. Strip all whitespace from the query string
  2. Downcase all characters in the query string
  3. MD5 hash the query string before performing the add or query.

Note that punctuation is not removed, only whitespace. So phone number formats, for example, are not standardized. We recommend that you standardize all data before adding it to a list as well as before querying. 

Next article:

Creating and Working with Query URLs

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

You must be logged in to comment.