Billing and Invoicing Integration Guide
Information Batch Import File Format
The Card Numbers Batch Import File is a properly formatted CSV or XML batch file of card numbers and/or Recurring IDs to generate tokens that is uploaded through the Information Batch Import (
The format of a CSV batch file is as follows:
- First line of the file.
- Contains all the field names.
- Each field name is enclosed within double quotes and followed by a comma.
- Transaction Data
- Starts after the header line.
- Each transaction data is placed on a single line.
- Each transaction data is enclosed within double quotes and followed by a comma.
- The transaction data is placed in the same order of the field names.
You can download a template csv for batch imports.
"ssl_card_number","ssl_exp_date","ssl_transaction_type","ssl_verify","ssl_avs_address","ssl_avs_zip";"ssl_add_token","ssl_first_name","ssl_last_name", "0000000000000000","1212","ccgettoken","Y","123 Main","31307""N","","", "0000000000000000","1213","ccgettoken","N","","","Y","John","Doe",
The format of an XML batch file is as follows:
- The file contains a single
<txnimport>element and multiple
<txn>(transaction) nested elements.
- Every transaction is a set of XML tags.
- The number of
<txn>corresponds to the number of transactions in the file.
- All elements must be closed in the order that these were opened.
<txnimport> <txn> <ssl_card_number>0000000000000000</ssl_card_number> <ssl_exp_date>1212</ssl_exp_date> <ssl_transaction_type>ccgettoken</ssl_transaction_type> <ssl_verify>Y</ssl_verify> <ssl_avs_address>123 Main</ssl_avs_address> <ssl_avs_zip>31307</ssl_avs_zip> </txn> <txn> <ssl_card_number>0000000000000000</ssl_card_number> <ssl_exp_date>1213</ssl_exp_date> <ssl_transaction_type>ccgettoken</ssl_transaction_type> <ssl_verify>N</ssl_verify> <ssl_add_token>Y</ssl_add_token> <ssl_first_name>John</ssl_first_name> <ssl_last_name>Doe</ssl_last_name> </txn> </txnimport>
CVV2/CVC/CID values and Track data should never be stored, and therefore cannot be passed to Converge on the file.
18 | numeric | conditional
Card Number as it appears on the credit card.
4 | numeric | conditional
Card's Expiry Date
Date when the card becomes invalid.
Important: Required if
50 | alphanumeric | conditional
Unique identifier of the recurring payment record.
20 | alphanumeric | required
1 | alphanumeric | optional
Account Verification Indicator
Indicates whether the Converge needs to verify the account before generating a token.
30 | alphanumeric | optional
Address Line 1
Commonly the house number and street name on the cardholder's / customer's account or billing address.
Address Verification Service (AVS) data compared with the address on the card issuer's file.
9 | alphanumeric | optional
Postal or ZIP Code
ZIP code on the cardholder's account or billing address.
Address Verification Service (AVS) data compared with the postal or ZIP code on the card issuer's file.
1 | alphanumeric | optional
Add to Card Manager Indicator
Indicates whether to generate and store the token in Card Manager.
20 | alphanumeric | conditional
First name on the cardholder's / customer's account or billing address.
30 | alphanumeric | conditional
Last name on the cardholder's / customer's account or billing address.