Comment:
Published by Scroll Versions from space ENWORK and version Documentation
Page properties
hidden
true
id
Info
Info
Export all information saved in the application as a CSV file.
Page properties
hidden
true
id
FAQ
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
SpaceWithExcerpt
EN
MultiExcerptName
Platform-Kurz
PageWithExcerpt
Wording
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
"Period" selection field
"Select all" selection field
"Operation data" selection field
"Status data" selection field
"Card data" selection field
"Account data" selection field
"Wallet data" selection field
"Factoring data" selection field
"Personal data" selection field
"Address and credit check" selection field
"IP data" selection field
"Information about your shopping cart" selection field
"Execute action" button
Drop-down "Select action" menu
Drop-down "Separator" menu
Info
title
Information on export data
Please keep in mind that the data available depend on the payment and the parameter that are sent to
Multiexcerpt include
SpaceWithExcerpt
EN
MultiExcerptName
Platform-Name
PageWithExcerpt
Wording
, 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
SpaceWithExcerpt
EN
MultiExcerptName
Selection Field "Period"
PageWithExcerpt
Content for reuse
Activating the "Operation data" selection field
Operation data are general information about an operation.
Expand
title
Operation data table
Selection criterion
Description
Parameter in
Multiexcerpt include
SpaceWithExcerpt
EN
MultiExcerptName
Platform-Kurz
PageWithExcerpt
Wording
Merchant
MerchantID assigned by
Multiexcerpt include
SpaceWithExcerpt
EN
MultiExcerptName
Partner-Name
PageWithExcerpt
Wording
MID
Payment ID
PaymentID automatically assigned and unique for each payment process
PayID
Merchant reference number
Merchant’s transaction number
TransID
Former merchant reference number
depricated
depricated
Reference number
The merchant reference number is a merchant code assigned by you to identify an operation
RefNr
Former reference number
depricated
depricated
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 EUR
Amount
User data
You may put some information to your own purpose
UserData
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 process
TransactionID
Source
Activating the "Status data" selection field
Status data are information about the creation data and the current status of an operation.
Expand
title
Status data table
Selection criterion
Description
Parameter in
Multiexcerpt include
SpaceWithExcerpt
EN
MultiExcerptName
Platform-Kurz
PageWithExcerpt
Wording
Creation date
Date / time for creation of payment process
n/a
Time of capture
Date / time for capture of payment process
n/a
Time of credit
Date / time for credit/refund of payment process
n/a
Time of EPA creation
Date / time of EPA (credit card settlement), optional
IP data are all the information about the device used by a person and that was used to pay the transaction.
Expand
title
IP data table
Selection Criterion
Description
Parameter in
Multiexcerpt include
SpaceWithExcerpt
EN
MultiExcerptName
Platform-Kurz
PageWithExcerpt
Wording
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
title
Information about your shopping cart table
Selection criterion
Description
Parameter in
Multiexcerpt include
SpaceWithExcerpt
EN
MultiExcerptName
Platform-Kurz
PageWithExcerpt
Wording
OrderDesc
Shopping cart information
OrderDesc
Shopping cart information
OrderDesc2
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.
Drop-down "Select separator" menu
Drop-down "Select action" menu
"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
title
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.