How to compile a CSV file for import into fraud prevention

CSV stands for "Comma Separated Values". A CSV file is a text field that contains values that are separated by using commas. The simplest method of creating a CSV file is to use a spreadsheet program such as "Microsoft Excel". You can blacklist several card or account data, exempt them from velocity checks, or authorise several credit card ranges in the application by using a CSV file. To do so, collect data such as the credit card number or account number in a CSV file, which you can then upload to the application.

You can upload a CSV file to the following tabs in the application:

  • "Fraud prevention → Black list"

  • "Fraud prevention → White list"

  • "Fraud prevention → White List SecurePay"

Blacklisting card or account data

This section describes the format of a CSV file for the tab "Fraud prevention" → "Black list".

The example below shows you how you need to format a CSV file so that the application can process it.

Example of blacklisting card or account data

General structure:

EDD,IBAN
CC,CardNumber

  • no Header, no Footer

Sample:

EDD,DE11770500000123456789
CC,4444333322221111
CC,4111111111111111


Exempting card or account data from the velocity checks

This section describes the format of a CSV file for the tab "Fraud prevention" → "White List SecurePay".

The example below shows you how you need to format a CSV file so that the application can process it.

Example of exempting card or account data from velocity checks

General structure:

EDD,IBAN
CC,CardNumber

  • no Header, no Footer

Sample:

EDD,DE11770500000123456789
CC,4444333322221111
CC,4111111111111111


Authorising credit card ranges

This section describes the format of a CSV file for the tab "Fraud prevention" → "White List".

The example below shows you how you need to format a CSV file so that the application can process it.

Example of authorising credit card ranges

General structure:

[MID],[ACTION] //header
[StartBIN_1]-[EndBIN_1] //both StartBIN and EndBIN should have 8 digits
[StartBIN_2]-[EndBIN_2]
[StartBIN_3]-[EndBIN_3]
[StartBIN_4]-[EndBIN_4]


Sample:

TESTMID,INSERT
55748300-55748399
54514000-54514099
52294800-52294899
52564100-52564199