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 entries to a List 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 “Confirm”:
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 highlighting its name in the left-hand column, then clicking the “-” button at the bottom of that column.
Automatic List Pruning
You can set each list to automatically “prune” itself of entries that have reached a specified age using the Automatic List Pruning" feature. Note that items. Once each item has been in a list for the interval specified for that list, it is permanently deleted from the list.
Note that once an item has been “pruned” from a list, it cannot be recovered.
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:
- Strip leading and trailing whitespace from the query string
- Down-case all characters in the query string
- 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.
Comments
0 comments
Please sign in to leave a comment.