Help Centre

Cardholder Data Import

Modified on: Tue, 6 Sep 2022 at 4:33 pm

Cardholder Data Import

We are happy to import your sensitive customer data from any other payment processor. To initiate the process, you will need to request a data export from your current provider and ask them to transfer the data to us via a secure connection.

Data Transfer Process

Our preferred data transfer process:

  • We will get in touch with your old provider and provide them with a public encryption Key(link to PGP Key).
  • We will ask your old provider to provide an encryption Key, so we can send them the SFTP credentials for upload.
  • Your old provider will encrypt the data with our encryption Key and load the data to the TILL SFTP server.
  • We will perform the data import.

Once the import is complete, we will provide you with a newline-delimited JSON, with each line containing the old and the new reference ID of one card.

Sample:

{ “newReferenceId”: ”abcdefghijklmnopqr”, ”oldReferenceId”: “388333B”, customerId: “AT-2938938” }
{ “newReferenceId”: ”8291edi3ndidn393un”, ”oldReferenceId”: “7837373”, customerId: “DE-3838832” }

Data Format

The data shall be provided in CSV or JSON with UTF-8 encoding. The provided data must follow the following conventions. Data provided in a different format may cause importing delays.
Note: The encrypted file may not exceed the file size of 25 Megabytes. Please split the file into several chunks if it exceeds the file size limit.

CSVJSON
Text qualifier or encapsulation: none or "
Delimiter or field separator: , (comma) or ;(semicolon)
A header column which identifies each field must be included.
Newline-delimited JSON (one valid JSON per line) http://jsonlines.org The key of each field shall match the field names of the tables below, we don’t support nested JSON, data must be provided as String types only.

The following data fields can be imported during the data transfer processes. Please include the field name in the data migration file:

Required Fields

Field nameDescriptionExample
creditcard.numberThe primary account number (PAN) of the card4111111111111111
creditcard.expiration_monthThe credit card's expiration month in the format: M or MM

1 (M)

01 (MM)

creditcard.expiration_yearThe credit card's expiration year (YYYY)

2020

reference_idID or token representing this card to the merchant in the former processor's system83389B

Optional Fields

Field nameDescriptionExample
creditcard.cardholder_nameThe cardholder name of the card (technically this is optional, but usually you will want to know the cardholder name)John Smith
customer.identificationAny identification representing the user of customer in your shop or ERP systemAT-2938938
customer.first_nameFirst name of the customerJohn
customer.last_nameLast name of the customerSmith
customer.billing_address1Street address line 1Shortroad 33
customer.billing_address2Street address line 2Unit A
customer.billing_cityCitySydney
customer.billing_postcodePostal Code/Zip code2000
customer.billing_stateStateNSW
customer.billing_country2-letter country codeAU
customer.billing_phonePhone number+61401006732
customer.companyThe company associated with the billing addressExample Inc.
customer.emailEmail address of the customerjohn.smith@example.org
customer.ip_addressIP address of the customer1.2.3.4
customer.national_idThe national ID (e.g. social insurance number) of the customerAT39398881
customer.genderEither M for male or F for femaleM

Was this article helpful?

1 out of 1 found this helpful