Maintenance Work Notice!

We will carry out maintenance work on this documentation on Thursday, 28.10.2021 between 1:30 pm and 2:30 pm CEST. During this time, this documentation will not be available to you. Thank you for your understanding.

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ENWORK and version Documentation
Page properties
hiddentrue
idInfo
InfoExport all information saved in the application as a CSV file.
Page properties
hiddentrue
idFAQ
Info
Excerpt

How to export all stored information of a payment process in tab "View operations → Data export"?

What do the selection fields in "View operations → Data export" mean?

What are the

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording
references to the selection fields?

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
Info
titleInformation on export data

Please keep in mind that the data available depend on the payment and the parameter that are sent to

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Name
PageWithExcerptWording
, too.

Activating or deactivating all selection fields

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

Info
title"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.

Multiexcerpt include
SpaceWithExcerptEN
MultiExcerptNameSelection Field "Period"
PageWithExcerptContent for reuse

Activating the "Operation data" selection field

Operation data are general information about an operation.


Expand
titleOperation data table


Selection criterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

Merchant

MerchantID assigned by

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePartner-Name
PageWithExcerptWording

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.


Expand
titleStatus data table
Selection criterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.



Expand
titleCard data table
Selection criterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.


Expand
titleAccount data table
Selection CriterionDesription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Name
PageWithExcerptWording

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.


Expand
titleWallet data table
Selection CriterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.


Expand
titleFactoring data table
Selection CriterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.


Expand
titlePersonal data table
Selection criterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.


Expand
titleAddress and credit check table
Selection CriterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.


Expand
titleIP data table
Selection CriterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.


Expand
titleInformation about your shopping cart table
Selection criterionDescription

Parameter in

Multiexcerpt include
SpaceWithExcerptENWORK
MultiExcerptNamePlatform-Kurz
PageWithExcerptWording

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.


Info
titleSeparator 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.


Multiexcerpt include
SpaceWithExcerptEN
MultiExcerptNameApplication Button
DisableCachingtrue
PageWithExcerptContent for reuse

Linchpin Teaser
titleComputop Analytics
type2
newTabtrue
urlhttps://paygate.computop.de/analytics/dataexport.aspx

On this page

Table of Contents
exclude(On this page|In this section).*

In this section

Content by Label
showLabelsfalse
showSpacefalse
sorttitle
cqllabel = "en" and label = "analytics" and label = "view-operations" and space = currentSpace()