Altering test cases in Excel for the ISO8583 simulator

Posted on 9th Nov 2017 6932 views

When you need to customize your own test case, you need to follow some simple steps all the time.

In order to obtain this, you need to alter test data in Excel, save your new test data, export for the simulator, restart simulator with new test cases.

Changing test cases with the neaPay ISO8583 simulator is really easy because you just need to work with Excel.
1. Go to the deployment folder, for example  C:/neaPaySimulator

2. Go inside the Acquirer instance(for example neapay_ACQ_client)

3. Go inside folder test_data (E.g. C:/neaPaySimulator/neapay_ACQ_client).

4. Open spreadsheet ISO8583_TestCases_v3.1.xlsm.  

Warning: It is advised to NEVER edit the CSV files. 

5. Go to sheet ISO8583_Acquirer to edit Acquirer test cases (These are messages that the simulator builds)

We will refer to this as the Acquirer Sheet from now on.

6. Update the columns to the corresponding fields. For example, Amount in Filed 4 (DE04) on column R.

7. The simulator can populate the fields with values, if values are inserted

8. The simulator can use some keywords to trigger a specific javascript behaviour

Below are some standard values that you may want to remember. They are checked in the following script:

script_acquirer.js:function buildField(name, field, caseField, isoMessageAcqRq) {

**SYSTEM** means that the simulator will use script logic to build that field. It is used to retrueve system time and date, generate random values, perform complex operations, or perform cryptography, or make external calls; So the value will be populated by the system. Script reference:

script_acquirer.js:function buildSystemField(name, field, caseField) {

**NOVALUE** means that the simulator will not use that field, and will not include it in the message. The Bitmap will NOT be activated for this field.

**CARDFILE** means that the simulator will use the Cards Sheet any to build that field, and will look up the card key selected set for that transaction;

script_acquirer.js:function buildCardField(name, field, currentCard) {

**TERMFILE** means that the simulator will use the Terminals Sheet to build that field, and will look up the Terminal set for that transaction; You can also use Excel's sheet reference information to retrieve information from another sheet, whoch may prove easier

12345 - if a text value is set, that value will be loaded in the message exactly from the spreadsheet. If the value is longer than defined, the simulator will trim it; if it is shorter, the simulator will pad it as defined. If you use binary data, paste the hex representation of the binary data and the simulator will convert it automatically when loaded in a binary field.

9. Edit column AW (DE 35) and change it from **SYSTEM** to a value of "12345678910"

10. Press the "Save Test Data CSV" button inside the sheet, next to the neaPay logo. It will ask you about saving the excel file and exporting a .csv. Answer Yes.

Warning: It is advised to NEVER edit the CSV files.  This button will generate the CSV files

11. Close the Excel file (optional).

12. Close the Acquirer simulator. The server can keep running.

13. Open and Start again the Acquirer simulator, check that it has connected.

14. When the Transactions List window opens, check that your new transaction is available in the list.

15. Select your configured transaction and click the Send button.

16. Check the Acquirer Console for the text Test case: and check that after that, the field 35 has the value you wrote above.

Congratulations! You have successfully configured your own test case!

 


LinkedIn

Docs Home ISO8583 Simulator Simulator Tutorials ISO8583 Converter Cards Issuer BASE24 Base24-eps Reference Guide ISO8583 Switch HSM Simulator POS Simulator Products


Top Read Articles


BIN List & Range for MasterCard, Visa, Amex, Diners, Discover, JCB, CUP 165061 views

ISO8583 Response Codes for Transaction processing 66768 views

Read smart card chip data with APDU commands ISO 7816 63701 views

ISO8583 Message Types for Transaction Processing 31272 views

ISO8583 Processing Codes for Transaction Processing 31261 views

Deploy, run and generate with neaPay Card Data Generator 21399 views

MCC Codes - Merchant Category Codes to use in ISO8583 Field 18 20901 views

Run the neaPay ISO8583 simulator 20882 views

ISO8583 payments message format, programmers guide 18400 views

ISO8583 message: The list of ISO 4217 currency codes for data elements 49 and 52 17533 views

ISO8583 ATM POS Crypto API integration with exchanges like Coinbase or Binance 17047 views

ISO8583 Message Converter JSON and XML interface specification mapping 13967 views

Cards and Banks Training 13603 views

Java version for neapay products Simulator Converter Switch Authorization Cards Issuer 10624 views

Support for the neaPay products: Authorization, Switch, Converter, Simulator, Issuer 10102 views

Log Files in BASE24 classic 9795 views

Create a new test case in the neaPay ISO8583 simulator Video guide 9080 views

BASE24 classic vs BASE24-eps 8757 views

BASE24 documentation to read 8604 views

BASE24 classic interview questions 8537 views

Deploy the neaPay ISO8583 simulator - video guide 8491 views

EMV explained for programmers 8180 views

ISO8583 Simulator neapay- Performance testing at 500, 1000 and 1500 Transactions per second 8101 views

ISO8583 converter to JSON XML SQL to HTTP host - message flow - video guide - Part.2 7752 views

ISO8583 converter to JSON XML SQL to HTTP Host - host unavailable - video guide- Part.3 7268 views

Adding your own card to the Payments simulator to test your system 7133 views

ISO8583 converter to JSON XML SQL to HTTP host - start& run - video guide - Part.1 7107 views

Card readers supported by neaPay payments simulator, CHIP and NFC 7054 views

Changing fields definitions in the ISO8583 simulator and message converter 7034 views

Connect the neaPay ISO8583 Acquirer simulator to your own host or Issuer 7024 views

Run the neaPay ISO8583 converter to JSON, XML, SQL, in a test environment 6998 views

BASE24 classic screens examples explained 6994 views

Load Test enabling and performance testing at 1TPS and 100TPS 6961 views

Run One, Run Scenario, Run All, Run Load in the neaPay ISO8583 Simulator - Use guide 6958 views

Enabling traces in the payments simulator 6952 views

Sample Recommended design for an Acquirer test cases suite, Scenarios and Regression 6946 views

How the fingerprint reader works in the ISO8583 payments simulator 6936 views

Altering test cases in Excel for the ISO8583 simulator 6933 views

Deploy the neaPay ISO8583 Payments converter in a test environment 6923 views

BASE24-eps interview questions 6860 views

Deploy the neaPay HSM simulator in a test environment 6785 views

Regression Testing in 1 click with instant Analytics and CSV report 6645 views

Deploy the Payments Switch Router in a test environment 6528 views

BASE24 classic ATM configuration Tutorial in ATD and XPNET with examples 6229 views

Add extra custom fields to the ISO8583 simulator 6126 views

BASE24 classic cards configuration tutorial with Examples 6113 views

Trace configuration in neaPay Simulator, Converter, Switch, Authorization and Cards Issuer 6087 views

PCI compliant with neapay switch 5717 views

ISO8583 Message Converter to XML SQL CSV interface specification mapping 5662 views

BASE24-EPS ACI DESKTOP tutorial - Getting started 5510 views

BASE24 classic prefix configuration tutorial CPF with examples 4080 views

BASE24 classic tracing of transactions. Audits, configuration, enabling and opening 3943 views

ACI BASE24 classic automatic extract configuration 3638 views

BASE24 classic Institution configuration Tutorial with example 3598 views

BASE24 classic balance file configuration PBF with example 3509 views

POS simulator format SPDH HPDH Verifone and custom 3432 views

First steps with BASE24 Classic 3351 views

Getting started with using Prognosis for BASE24 and BASE24-eps 3073 views

ISO8583 simulator Visa MasterCard Amex CUP configuration demo video 302 views

Swift Message Structure ISO 15022 and ISO 20022 56 views

SWIFT Common Message Type List with examples 56 views

SWIFT Message types complete list reference 56 views

POS Transaction types explained 47 views

Contact    

Iso8583 - articles


ISO8583 Converter   5662 views

ISO8583 Message Converter to XML SQL CSV interface specification mapping


ISO8583 Converter creating an XML,  SQL and CSV object from an incoming TCP/IP ISO8583 binary message, and then sending it to a HTTP host as ...
ISO8583 Switch   5717 views

PCI compliant with neapay switch


PCI compliant with neapay switch Steps and procedure: Configuration parameters to acheive service PCI DSS compliance   ...
Products   6087 views

Trace configuration in neaPay Simulator, Converter, Switch, Authorization and Cards Issuer


Trace configuration in neaPay Simulator, Converter, Switch, Authorization and Cards Issuer ...
ISO8583 Simulator   6126 views

Add extra custom fields to the ISO8583 simulator


Adding extra, custom fields to the ISO8583 simulator in 3 simple steps is as easy as running the tests: Edit the spreadsheet and save it; Edit th ...
ISO8583 Switch   6528 views

Deploy the Payments Switch Router in a test environment


Deploy then neaPay Payments switch router to easily route transactions based on BIN/prefix, amount, merchant, originating or destination insytitution, ...
ISO8583 Simulator   6645 views

Regression Testing in 1 click with instant Analytics and CSV report


The neaPay Payments simulator is designed from the start to follow the life of a project, and therefore, after all testing has been completed, we need ...
ISO8583 Converter   6923 views

Deploy the neaPay ISO8583 Payments converter in a test environment


When you receive a delivery from neaPay for an iso8583 convertor, you will get 1 zip file.  This step by step guide will guide you through ...
ISO8583 Simulator   6933 views

Altering test cases in Excel for the ISO8583 simulator


When you need to customize your own test case, you need to follow some simple steps all the time.In order to obtain this, you need to alter test data ...
ISO8583 Simulator   6936 views

How the fingerprint reader works in the ISO8583 payments simulator


Step by step guide to enable and disable fingerprint reading, enrollment and verification with the neapay Simulator is pretty straight forward and ass ...
ISO8583 Simulator   6946 views

Sample Recommended design for an Acquirer test cases suite, Scenarios and Regression


A test suit is composed of different scenarios which follow in a functional (or another) way in order to cover the full, or as much as possible, of th ...
ISO8583 Simulator   6952 views

Enabling traces in the payments simulator


Enabling traces in the ISO8583 Payments Simulator, just like the ISO8583 message converter and the ISO8583 Host, is a call to the system core to write ...
ISO8583 Simulator   6958 views

Run One, Run Scenario, Run All, Run Load in the neaPay ISO8583 Simulator - Use guide


neapay ISO8583 simualtor is designed to Support your project in all stages and has 4 modes are available: RunOne - runs only the selected Test Case; R ...

Choose the product you need



ISO8583 Converter

Convert ISO8583 to JSON XML SQL


ISO8583 Interface

ISO8583 Interface Handler


ISO20022 Converter

Convert ISO20022 to ISO8583 ...


ISO8583 Builder

Build ISO8583 from scratch


ISO8583 Switch

ISO8583 Router by criteria


ISO8583 Authorization

Authorize cards and ledger


Payments Acquirer

Acquiring host from devices


Cards Issuing

Generate and issue cards


ISO8583 Simulator

ISO8583 HISO98 HISO87 simulator


ISO20022 Simulator

ISO20022 & SWIFT simulator


POS Simulator

POS protocols simulator


Web Api Simulator

Web API tester Performance

 

Get a free quote, Ask for details
Get help

Contact us

Try the software yourself
Download

Download software

Read Documentation and Start guides

Documentation

Online Tools Overview

Online Tools