Altering test cases in Excel for the ISO8583 simulator

Posted on 9th Nov 2017 6869 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 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 163044 views

ISO8583 Response Codes for Transaction processing 65576 views

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

ISO8583 Message Types for Transaction Processing 30888 views

ISO8583 Processing Codes for Transaction Processing 30770 views

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

Run the neaPay ISO8583 simulator 20766 views

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

ISO8583 payments message format, programmers guide 18300 views

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

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

ISO8583 Message Converter JSON and XML interface specification mapping 13829 views

Cards and Banks Training 13488 views

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

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

Log Files in BASE24 classic 9682 views

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

BASE24 classic vs BASE24-eps 8643 views

BASE24 documentation to read 8515 views

BASE24 classic interview questions 8451 views

Deploy the neaPay ISO8583 simulator - video guide 8449 views

EMV explained for programmers 8078 views

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

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

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

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

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

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

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

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

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

BASE24 classic screens examples explained 6887 views

Enabling traces in the payments simulator 6885 views

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

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

Altering test cases in Excel for the ISO8583 simulator 6870 views

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

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

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

BASE24-eps interview questions 6787 views

Deploy the neaPay HSM simulator in a test environment 6687 views

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

Deploy the Payments Switch Router in a test environment 6474 views

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

Add extra custom fields to the ISO8583 simulator 6023 views

BASE24 classic cards configuration tutorial with Examples 6005 views

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

PCI compliant with neapay switch 5647 views

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

BASE24-EPS ACI DESKTOP tutorial - Getting started 5430 views

BASE24 classic prefix configuration tutorial CPF with examples 4011 views

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

ACI BASE24 classic automatic extract configuration 3607 views

BASE24 classic Institution configuration Tutorial with example 3545 views

BASE24 classic balance file configuration PBF with example 3469 views

First steps with BASE24 Classic 3320 views

POS simulator format SPDH HPDH Verifone and custom 3317 views

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

ISO8583 simulator Visa MasterCard Amex CUP configuration demo video 169 views

Contact    

Iso8583 - articles


ISO8583 Converter

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

PCI compliant with neapay switch


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

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


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

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

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

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 Simulator

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 Converter

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

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

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 ...
ISO8583 Simulator

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

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


neaPay simulator performance testing. Simulator is requiring 0.02 seconds to send 100 transactions, every second. How to enable Load /Stress test in ...

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