Blog Home

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

Posted on 29th Sep 2018 2393 views

simulator add card

 

Follow these easy steps to add a card. Repeat the steps or use some Excel skills to add multiple cards.

Edit the spreadsheet of cards

Open the test cases sheet ISO8583_TestCases_vx.x.xlsm, located in the test_data folder.

Open the sheet named ISO8583_card.

You will notice several rows of dummy cards with all card details.

 

Edit the card data

For simplicity, Copy any row and paste on the first empty row to make a duplicate of an existing card.

Modify/ Edit the rows CardID, PAN, sequence number and all the relevant columns for you.

Make sure the Card ID is unique (first column), otherwise the search for cards will always get the first occurrence.

Set a description that is relevant for the future understanding of the cards usage (e.g: RealCard, MasterCard for test, Visa for regression).

Repeat the steps above as many times as you need to add all the records.

 

Save the new cards

IMPORTANT! SAVE your cards by pressing the "Save Test Data CSV" button next to the neaPay logo inside the spreadsheet! See Image below!

Click YES to overwrite the CSV files on the disk!

These csv files will have the new information.

For Cards, the csv file is called ISO8583_Card.csv

It is reccomended, for maintenance purposes, to NOT edit the CSV files directly. They are generated by the spreadsheet.

Check the csv files on the disk that they have changed and the date is new.

 

Load the new cards

The simulator will automatically look for cards in file ISO8583_Card.csv

The ISO8583 simulator requires this file to populate transaction data.

 

simulator save card

 

 

Importing data from test environments is just as easy! We assume you cannot simply connect Excel to the SQL database, but you need to work this manually.

  1. Export the data from your environment in an SQL-like form; INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
  2. Use a text editor to format the data and remove the column definitions. Keep just the values:value1, value2, value3, ...
  3.  Rearrange the columns to match the spreadsheet layout : Card ID,Description,PAN,App_PAN,Sequence number,PIN,PIN Block Format,Expiry Date,Discretionary Data Format,Service Code ,PVKI,PVV,PVV2,PIN Offset,PIN Offset 2,CVV,iCVV,CVV2,dCVV,Name/Location,Effective Date,L Code,Billing currency,Account,CDG,Track2,Track3,Offset,EMVStandard,**END**;
  4. Import this data into the spreadsheet via the Excel menu Data -> Get External Data -> Import from Text;
  5. IMPORTANT! SAVE your cards by pressing the Save button next to the neaPay logo inside the spreadsheet! See Image above!
  6. Click YES to overwrite the CSV files on the disk! These csv files will have the new information.
  7. Optional: Check the csv files on the disk that they have changed and the date is new.

Thank you for following this article! Please leave us a note below if something is wrong or unclear, we will review and change it asap!


LinkedIn

Top Read Articles


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

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

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

Run the neaPay ISO8583 simulator 9546 views

ISO8583 payments message format, programmers guide 9019 views

ISO8583 Message Converter JSON and XML interface specification mapping 6573 views

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

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

ISO8583 Response Codes for Transaction processing 5772 views

Deploy the neaPay ISO8583 simulator - video guide 4975 views

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

ISO8583 Message Types for Transaction Processing 4244 views

ISO8583 Processing Codes for Transaction Processing 3956 views

Log Files in BASE24 classic 3831 views

Performance testing at 500, 1000 and 1500 TPS 3421 views

BASE24 classic interview questions 3409 views

BASE24 documentation to read 3374 views

BASE24 classic vs BASE24-eps 3334 views

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

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

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

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

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

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

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

BASE24 classic screens examples explained 2606 views

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

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

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

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

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

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

Enabling traces in the payments simulator 2307 views

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

Altering test cases in Excel for the ISO8583 simulator 2305 views

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

EMV explained for programmers 2305 views

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

BASE24-eps interview questions 2255 views

Deploy the neaPay HSM simulator in a test environment 2181 views

Cards and Banks Training 2085 views

BASE24 classic cards configuration tutorial with Examples 1995 views

Deploy the Payments Switch Router in a test environment 1846 views

BASE24-EPS ACI DESKTOP tutorial - Getting started 1727 views

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

BASE24 classic prefix configuration tutorial CPF with examples 1673 views

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

BASE24 classic Institution configuration Tutorial with example 1461 views

BASE24 classic interchange configuration with examples 1429 views

BASE24 classic balance file configuration PBF with example 1413 views

ACI BASE24 classic automatic extract configuration 1388 views

Working with Base24-eps vs BASE24 Classic 1298 views

Add extra custom fields to the ISO8583 simulator 1240 views

Base24-eps how to create journals with esbldjnl 1213 views

BASE24 classic routing in IDF 1139 views

Getting started with Base24 development. TAL tutorial 1133 views

BASE24 classic External Message File configuration EMF with examples 1067 views

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

First steps with BASE24 Classic 966 views

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

What to expect when installing Base24-eps 935 views

BASE24 classic host configuration tutorial HCF with examples 919 views

Managing BASE24-eps implementation projects 867 views

Ask a question, get advice and help

   

Read related articles - Iso8583


EMV explained for programmers


EMV explained for programmers

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