Basic concepts

Migrate payment data from another provider

To import data about tokens from another provider, you need to complete the following steps:

  • Contact us
  • Format the data
  • Encrypt the file
  • Send us the file

Contact us

Before you import your data from another provider, email our Gateway Team with the following information:

  • Current processing gateway
  • Current processor
  • Token direction (Import or Export)
  • Approximate number of tokens
  • Primary contact details:
    • Name
    • Email
    • Phone
  • Merchant DBA
  • Merchant MID
  • Merchant GWID

After you contact our Gateway Team, we send you a global unique identifier (GUID) that you use when you name the file to allow us identify your import file. We also provide you with information about how to format the file.

Format the data

We accept only CSV files for importing sensitive data. The name of the CSV file must include the GUID that we sent you and your terminal number that we assigned to you, for example, <GUID>_<terminal_number>.csv.

In the CSV file you must separate values with semicolons (;) and use the headers in the following table:

Important: All headers must be in the specified order and you must include all optional columns even if there is no value.

Field nameMax lengthExplanationMandatory or Optional
cardNumber128Unencrypted card number with without spaces.Mandatory
cardHolderName50Cardholder name.Optional
cardExpiry4Card expiry in MMYY format.Mandatory
email128Cardholder’s email address.Optional
countryCode2Two-letter country code, for example, US, UK, or DE.Optional
region128Customer data.Optional
address128Customer data.Optional
city128Customer data.Optional
postCode128Customer data.Optional
cof1Credentials on file. Include a value of Y or N.Mandatory
merchantref200Actual secure token.Mandatory
transactionReference128Reference for the original transaction used to create this token.Optional

Example

The following example shows the layout of the CSV file with the headers.

CSV Layout

Encrypt the data

Note: If you’re unfamiliar with Pretty Good Privacy (PGP), see GnuPG and start by importing a public key.

We use PGP to share and receive sensitive data. To encrypt your data with PGP software, use the following information:

Key ID: 484BE277C74555DA
Key type: RSA
Key size: 4096 bits
Fingerprint: CA0E 6F0F B819 0CFB DC71 8188 484B E277 C745 55DA
User ID: Payroc Import Key (PCI) <[email protected]>

    -----BEGIN PGP PUBLIC KEY BLOCK-----
    mQINBGkLfQ8BEADKKjMzH97I5/sqBvfAWJfF9sAfAZ69lJo63eilUK313bg+Kl0d
    +qijb41tv+WgOt8wWgUG4TdK4wJ/KP1cRkcm++q1qleSeHmrQ2Wo2/HtwibXBVTi
    KVNTK584qrWwQRquhIVNJQZ8oqXTi2pu2xX1gu14BaS8kSkJz+WPeBNbq9mNP1B5
    Kz5/EXpNWaqAsaqg+wPU3dTX7HE4FYUbLzbqoqV7/jPb12aPer6RkcZs5/zDbOhb
    vowZlLiSejFlqZYWK5aSrkZ3ISDG+S4yzP2LKLcKurydorrpLN9FZH0gcbkdEeva
    0kAwzed8eYkbyj4vskZrN4e36+JFqFvcQmJd9a10wv9EswZsVr5Cgp4yhnV6FvlK
    x1WL2tXxsu/BnT436HI+3UP8I043tJn/3bPyBu8/HzGUsOAkKLVpKtP2/FbNvMFj
    aZxCZ9knR0WmUdBRyUMKZiKRcGuPEYSFXp0KfwnZXo5SV0LKEXrNbOjT8gdBAlMo
    HWoRPZJt9y7KOGoTRZSBUhFytRGdbDbPo4I5/5neLLIxrtKiTCZnr+iyq8PBrimz
    j+W+2UOyavZnwa+r42Nm7mQShE3LV0QzwjMrZBqgyEi+2l1jJS+clZIi6pBp1SrS
    oXUh8oR3YdyvBKxcgyRgVJaoUiS9RaUHOasUXg4L+AJkDAk3JLg+Zp6XfwARAQAB
    tDdQYXlyb2MgSW1wb3J0IEtleSAoUENJKSA8cGF5cm9jX2dhdGV3YXlfcGdwQHBh
    eXJvYy5jb20+iQJOBBMBCgA4FiEEyg5vD7gZDPvccYGISEvid8dFVdoFAmkLfQ8C
    GwMFCwkIBwIGFQoJCAsCBBYCAwECHgECF4AACgkQSEvid8dFVdpXoA/+MopX/8WA
    YsEJgcpCx8XSR1aYqZYJaLIw+RfA68BOgwZhHPCRr41gdNkACNHwk3aLQu0Etyls
    bcDUNpeZopzdeNC6wthYaIVYL5zq98n6yiva8gYz7V636m/CEgJWAdZr+oZpI+OD
    Eqc0i/4FSt2lu/0P+Xnm0IldvZ8yMjf9fcb6LGUSGKlVyYVuB/s5vAfeDGferB/5
    5rVFc4cMuhoZ5NPnEelh25oEvZ+z16sJrKn5HDw2Z7nK3qnkILJxQx56m6ad8+KO
    ivDkC38NOeI1GJZf+pDiqUyEmR7/qCxYhmadsbaEMDbB1iExaCeqd2fs2yyNWKDi
    ksb6ZJp4KLJdh/lIxrj0ibjRs0bQCb0AWbddF4XHKmBKeCfVdOJ6gc6+eEVrOP+5
    BtqemkAemR2cuvf8OsAJs91OIesWP/AQJcyHl/QOrINjsjyicWt3AVPRM2T+CBiH
    aGqVI2V7RsknmCxWuN+zORQMrQapj/hs/p9a1TS205L9DUmS1KhM3L1tgb4+5TEu
    KQBgzzmSPsgRuAI/TGMvz8bt0r4g3cXw2RTG77sPfTh4+8+EzF4Hi2bzTKLWjfSR
    FHwemt2XACPdwdwlgKiBJ5bWUc6zYv8XFcvDkh7Zmh2KGeIDQB1UblY3zU1E30ZB
    9sfwnFFk0PpBw7+/010ksShitLDom3Z8fV65Ag0EaQt9DwEQAMu47rC6Lvkn4FnM
    6eNogEemNXgaP4uFJzWxL30JoXw2Cr/oKy0fpKNEdiDV4yghSOZmCCAzasZRSlon
    leJV0NcASSaLOre4ajgtNXQS5UMLFcI/0vHgwguJ0h7vO3zUNXeipsk+Y3iWYc29
    1nZVY9/s18mkMj8m+OEkZmTtZ0U69wSyKFnVBcpcIOhDYXUkPfhIf5nO23FqzQmv
    Qm5SKaJkRVzW6eWDtRkGFUxAbQrMZX1zSVRv2YTe3yU6ZjZnpxA/ma55VqnQzS22
    W5YijbBWiGBx+8pBb1SOcECaXJFX+KkXmJ7fOl/eJ3kJzejdGpffSiaumh4HV2TR
    26lKyL5KR91NiM4kQ7rIOX6NZ03YFJR2vGS6Hr92RoDDusQGtx9JYf7qIlU+/+u0
    xHIV7xEjLO0T7A9nkGNSOrnAOE/RQ4Lwa9AcNuCKfJ/KTaUjcFWkaOPGPdd0dNQH
    E5EA5xaJRutTJQeik6Lo7bWNPIwdH+ffJearctvs8PJQ6SkL77OIywM8wkvnZZjM
    KQnfvgJ2ozMLFweWfcZGKGrUadGEqi1QDjYbE0y4/4+cqRGN3BivFqbo/FuSLO/q
    GXOL2/yaP4PbDFCC0lzpml2/jIKgm55y7FJFhrgQQGGNhIXcGJbyO8LG5f0LpDWc
    NMJDqxCRWOVh+I87qAmobysYryCDABEBAAGJAjYEGAEKACAWIQTKDm8PuBkM+9xx
    gYhIS+J3x0VV2gUCaQt9DwIbDAAKCRBIS+J3x0VV2rtwD/9/HyDEAUAJpZxG3fLH
    0yiNce9GU3OlanunK8wZW+Ek3bg++O8dLzbRVOs+s1RPHTO+MYS5S0ijCqHt/Urc
    NAYR0R8/0LpakYs+yBKAL/r25S9bwb3fGZFHrO5RFFxKx5BsCGKLG7N9VY5D30l3
    QVLu4+l3Ny8ymLRAhY7mx9E2TPOIqvnto/EZA6qQUPfivraf+d8w8u9rU8lY7F1T
    sWGp4KdV/kVidJRyTiyMLfggPxIeh6UQ8EmejuAzeM7xv6/b69w4+JtNkPPb0LIP
    sUc/WslLYLoYpXXvxCUhnGpgCMy0B7ie0Z1ufC1GHqq8U5bRhgiOYAAWKeJ/BQW1
    qIeG830MewXxNMunZhktvo8S9tncuKBmPJru3EQ5+qtWa8q6E7uD1J2OyP1LcPJg
    QZTrcH2aJcoHTkI6Sn6fu6qKh83i2hNjZsoIeAtXJlx54kaC63IvoLa1SXkitC5d
    T5WAJ3Xj4qtaQjnS1CHVjgAVWcRkpHy73jNqykJwfhzYTI7MztydCEf0o8wthp5S
    p6i4ewsue11Sj6hD9RepKcB/oF5hZfdpOGxdDF9rZuu5nnaFru1+vggKaR9ivjDY
    NOJ6/GJUo5G2uyIGCcjNJEAvrTtTMtwo1v4fsSsvozldGyB1K10OeehCX0gLzvb7
    ia/FRV1EaYdDV+Xt/1bef5lG3Q==
    =Pqe1
    -----END PGP PUBLIC KEY BLOCK-----

Send us the file

Upload the PGP-encrypted file to a dedicated folder on your SFTP server, and then email the SFTP credentials to [email protected].

After we receive your file, it takes approximately 30 business days to import the data.