Blog Home

Altering test cases in Excel for the ISO8583 simulator

Posted on 9th Nov 2017 1255 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

There are some standard values that you may want to remember:
**SYSTEM** means that the simulator will use script logic to build that field. In brief, it will be populated by the system
**NOVALUE** means that the simulator will not use any value to build that field, and will not include it in the message.
**CARDFILE** means that the simulator will use the Cards Sheet any to build that field, and will look up the card set for that transaction
**TERMFILE** means that the simulator will use the Terminals Sheet any to build that field, and will look up the Terminal set for that transaction
12345 - if a value is set, that value will be loaded in the message. If the value is longer than defined, the simulator will trim it; if it is shorter, the simulator will pad it as defined.

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

Top Read Articles


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

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

Run the neaPay ISO8583 simulator 6225 views

ISO8583 payments message format, programmers guide 5877 views

ISO8583 Message Converter JSON and XML interface specification mapping 4390 views

Deploy the neaPay ISO8583 simulator - video guide 3881 views

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

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

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

Asking for defects support for the neaPay products: converter, switch, issuer, simulator 2418 views

Log Files in BASE24 classic 2195 views

Performance testing at 500, 1000 and 1500 TPS 2188 views

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

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

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

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

BASE24 documentation to read 1813 views

BASE24 classic vs BASE24-eps 1770 views

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

BASE24 classic interview questions 1695 views

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

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

BASE24 classic screens examples explained 1552 views

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

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

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

Enabling traces in the payments simulator 1452 views

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

Altering test cases in Excel for the ISO8583 simulator 1256 views

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

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

Cards and Banks Training 1162 views

BASE24 classic cards configuration tutorial with Examples 1149 views

EMV explained for programmers 1100 views

BASE24-eps interview questions 1085 views

Deploy the neaPay HSM simulator in a test environment 1002 views

Getting started with BASE24. Compiling your first TAL program 932 views

BASE24-EPS ACI DESKTOP tutorial - Getting started 910 views

BASE24 classic prefix configuration tutorial CPF with examples 852 views

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

BASE24 classic Institution configuration Tutorial with example 801 views

ACI BASE24 classic automatic extract configuration 685 views

BASE24 classic interchange configuration with examples 683 views

BASE24 classic balance file configuration PBF with example 675 views

Base24-eps how to create journals with esbldjnl 666 views

Deploy the Payments Switch Router in a test environment 601 views

Getting started with Base24 development. TAL tutorial 579 views

BASE24 classic routing in IDF 535 views

Working with Base24-eps vs BASE24 Classic 495 views

BASE24 classic External Message File configuration EMF with examples 484 views

Managing BASE24-eps implementation projects 476 views

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

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

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

First steps with BASE24 Classic 467 views

What to expect when installing Base24-eps 463 views

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

BASE24 classic host configuration tutorial HCF with examples 418 views

Ask a question, get advice and help

   
Read related articles - Iso8583

ISO8583 converter to JSON XML SQL to HTTP host - message flow - video guide - Part.2
ISO8583 converter to JSON XML SQL to HTTP host - message flow - video guide - Part.2
ISO8583 converter to JSON XML SQL to HTTP Host - host unavailable - video guide- Part.3
ISO8583 converter to JSON XML SQL to HTTP Host - host unavailable - video guide- Part.3
ISO8583 converter to JSON XML SQL to HTTP host - start& run - video guide - Part.1
ISO8583 converter to JSON XML SQL to HTTP host - start& run - video guide - Part.1


Altering test cases in Excel for the ISO8583 simulator
Altering test cases in Excel for the ISO8583 simulator
Run One, Run Scenario, Run All, Run Load in the neaPay ISO8583 Simulator - Use guide
Run One, Run Scenario, Run All, Run Load in the neaPay ISO8583 Simulator - Use guide
Deploy the neaPay ISO8583 Payments converter in a test environment
Deploy the neaPay ISO8583 Payments converter in a test environment


Are you ready to start or need help?


Ready to start your next project with us? Give us a call or send us an email and we will get back to you as soon as possible!

Get a free quote, Ask for details, Get guidance


Contact us

Download and Use the software yourself


Download software

Follow a getting started guide to deploy and use the software


Get started