You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 159 Next »

The "View operations → Data export" tab allows you to export all information saved in the application as a CSV file. Furthermore, you can save the settings that were activate for the data export. Depending on the syntax used by the application, different separators are preferred for further processing of the CSV data sets. This is why you have the option to select the separator prior to export.

Overview of the selection fields for data export

  1. "Period" selection field
  2. "Select all" selection field
  3. "Operation data" selection field
  4. "Status data" selection field
  5. "Card data" selection field
  6. "Account data" selection field
  7. "Wallet data" selection field
  8. "Factoring data" selection field
  9. "Personal data" selection field
  10. "Address and credit check" selection field
  11. "IP data" selection field
  12. "Information about your shopping cart" selection field
  13. "Execute action" button
  14. Drop-down "Select action" menu
  15. Drop-down "Separator" menu

Information on export data

Please keep in mind that the data available depend on the payment and the parameter that are sent to Computop Paygate, too.

Activating or deactivating all selection fields

The "Select all" selection criterion allows you to activate or deactivate all selection fields for data export.

"Select all" selection field

Any selection fields for data export that have already been selected will be lost when you activate or deactivate the "Select all" selection criterion.

Activating the "Period" selection field

When you click in the input fields for the date, a calendar opens in which you can select a date. When you click in the input fields for the time, you can define a time for the search.

Activating the "Operation data" selection field

Operation data are general information about an operation.



Selection criterionDescription

Parameter in Paygate

Merchant

MerchantID assigned by Computop

MID

Payment ID

PaymentID automatically assigned and unique for each payment processPayID

Merchant reference number

Merchant’s transaction numberTransID

Former merchant reference number

depricateddepricated

Reference number

The merchant reference number is a merchant code assigned by you to identify an operationRefNr

Former reference number

depricateddepricated

Merchant ID

MerchantID at your credit card acquirer (also known as "AcceptorId" or "VU-Nummer")---

Payment method

Payment method used for payment process, e.g. "Card - Visa" or "eWallet - Bluecode"

Currency

Currency (ISO, Alpha-3) used for payment process, e.g. "EUR", "GBP", "USD"Currency

Amount

Amount in smallest currency, e.g. 123 for 1,23 EURAmount

User data

You may put some information to your own purposeUserData

Requested service



Provider token

Unique transaction token of the external service provider.
Normally used with credit cards for recurring payments.
TokenExt

Provider ID

Unique transaction ID of the external service provider to identify a payment processTransactionID

Source



Activating the "Status data" selection field

Status data are information about the creation data and the current status of an operation.


Selection criterionDescription

Parameter in Paygate

Creation dateDate / time for creation of payment processn/a

Time of capture

Date / time for capture of payment processn/a

Time of credit

Date / time for credit/refund of payment processn/a

Time of EPA creation

Date / time of EPA (credit card settlement), optionaln/a
Current statusCurrent status of payment process: ERROR or OK
Current codeDetailed response code, see: A4 Error codes

Activating the "Card data" selection field

Card data are information about an operation that was paid using a credit card.



Selection criterionDescription

Parameter in Paygate

Card brandCard brand for a credit card payment, e.g. Visa, MasterCardCCBrand

Card number

Masked card number; due to PCI DSS regulation the card number is shown with 6 digits, "X", and 4 digitsMaskedPan

Pseudo card number

Pseudo card number generated by ; this number can be handled and stored by the merchant without specific PCI DSS requirements.

PCNr

Card holder

Name of card holder - if presentCreditCardHolder

Country of origin

Country of credit card issuer bank - if presentIssuerCountry

Approval code

Approval code of credit card acquirer - if presentApprovalCode

Type of capture

Type of capture (MANUAL, AUTO) - if present

Capture

Card holder information 1

Value shown on card holder accounting statement - depending on paymethodTextfeld1

Card holder information 2

Value shown on card holder accounting statement - depending on paymethodTextfeld2

3-D secure



Authentication number

3-D Secure authentication valueCAVV

ECI value

Electronic commerce indicator returned by acquirer / schemeECI / ECI3D
StatusStatus of 3-D secure authentication

Activating the "Account data" selection field

Account data are information about an operation that was paid on account.


Selection CriterionDesription

Parameter in Paygate

Account numberAccount number or IBAN - depending on paymethodBankAccount

Bank code

Bank code or BIC - depending on paymethodBankCode

Account holder

Account holderAccOwner

IBAN

IBAN - depending on paymethodIBAN

Pseudo account number (PBAN)

Pseudo bank account number generated by Computop Paygate

PBAN

BIC

depending on paymethodBIC

Mandate ID

SEPA Mandate IDMandateID

Date of signature

Date of signature of SEPA mandateDtOfSgntr

Bank

Bank nameAccBankName / AccBank

Card sequence number



Country

Country of bank

City of residence



Date of execution



Transaction ID



Activating the "Wallet data" selection field

Wallet data are information about an operation that was paid using an electronic wallet.


Selection CriterionDescription

Parameter in Paygate

Customer number

Customer name



Device



Reference number



Agreement number



Channel



Fee



Activating the "Factoring data" selection field

Factoring data are information about an operation that was paid using the "Factoring" financing method.


Selection CriterionDescription

Parameter in Paygate

Transaction ID

Reference number



Payment target



Customer number



Activating the "Personal data" selection field

Personal data are all the information about the person who is paying for the transaction.


Selection criterionDescription

Parameter in Paygate

Billing address

Title


bdSalutation

First name


bdFirstName

Last name


bdLastName

Name



Company



Street


bdStreet

Address addendum



Zip code


bdZip

City


bdCity

Region



Country



Country code


bdCountryCode

Shipping address



Title


sdSalutation

First name


sdFirstName

Last name


sdLastName

Name



Company



Street


sdStreet

Address addendum



Address part 1



Address part 2



Address part 3



Zip code


sdZip

City


sdCity

Region



Country



Country code


sdCountryCode

Status



Other data



Title



First name



Last name



Email address



Phone number



Country



Additional information



Business segment



Status of security



Gender


Gender

Date of birth


DateOfBirth

Age



Person ID



Customer number



Activating the "Address and credit check" selection field

Address and credit check data are all the information about the address and credit check of a person for an operation.


Selection CriterionDescription

Parameter in Paygate

Result

Address result



Name result



Person result



Email result



New customer result



Score value



Requested address components/corrected address details



Title



First name



Last name



Company



Initials



Street



House number



Zip code



City



Country code



Email address/customer number



Activating the "IP data" selection field

IP data are all the information about the device used by a person and that was used to pay the transaction.


Selection CriterionDescription

Parameter in Paygate

IP address

Country



Country code (ISO 3166 ALPHA2)



Country code (ISO 3166 numerical)



City



State



Longitude



Latitude

Activating the "Information about your shopping cart" selection field

Information about your shopping cart is all the information about the products that were paid for with the transaction.


Selection criterionDescription

Parameter in Paygate

OrderDescShopping cart informationOrderDesc
Shopping cart informationOrderDesc2

Starting data export or saving settings

You have the option of exporting all information activated in the selection fields for the selected period as a CSV file. Furthermore, you can save the information activated in the selection fields for the next data export.

  1. Drop-down "Select separator" menu
  2. Drop-down "Select action" menu
  3. "Execute action" button

Proceed as follows to start data export or to save the settings:

1. Select the required period.

2. Activate the required information in the selection fields.


Separator for data export

Depending on the application and the country, a different separator will be required for the export and import of a CSV file. This is why you have the option of selecting a separator for the CSV file from the drop-down menu.


3. Select the separator from the drop-down "Select separator" menu.

→ The separator selected is shown in the drop-down "Select separator" menu.



4. Select the action from the drop-down "Select action" menu.

→ The action selected is shown in the drop-down "Select action" menu".

5. Click on the "Execute action" button.

→ The required action is carried out. → The settings are saved to the application, or the data export is issued as a CSV file ready to download.


Application Button

The button at the bottom allows you to jump to the corresponding page within the application. You must be logged in to jump to the corresponding page within the application.


On this page

In this section

  • No labels