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

Posted on 29th Sep 2018 7078 views

 

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

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 163019 views

ISO8583 Response Codes for Transaction processing 65570 views

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

ISO8583 Message Types for Transaction Processing 30879 views

ISO8583 Processing Codes for Transaction Processing 30769 views

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

Run the neaPay ISO8583 simulator 20765 views

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

ISO8583 payments message format, programmers guide 18300 views

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

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

ISO8583 Message Converter JSON and XML interface specification mapping 13828 views

Cards and Banks Training 13488 views

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

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

Log Files in BASE24 classic 9681 views

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

BASE24 classic vs BASE24-eps 8640 views

BASE24 documentation to read 8513 views

BASE24 classic interview questions 8450 views

Deploy the neaPay ISO8583 simulator - video guide 8449 views

EMV explained for programmers 8077 views

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

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

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

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

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

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

Changing fields definitions in the ISO8583 simulator and message converter 6947 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 6884 views

Enabling traces in the payments simulator 6882 views

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

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

Altering test cases in Excel for the ISO8583 simulator 6869 views

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

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

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

BASE24-eps interview questions 6784 views

Deploy the neaPay HSM simulator in a test environment 6685 views

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

Deploy the Payments Switch Router in a test environment 6474 views

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

Add extra custom fields to the ISO8583 simulator 6020 views

BASE24 classic cards configuration tutorial with Examples 6004 views

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

PCI compliant with neapay switch 5645 views

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

BASE24-EPS ACI DESKTOP tutorial - Getting started 5428 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 3606 views

BASE24 classic Institution configuration Tutorial with example 3543 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 3316 views

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

ISO8583 simulator Visa MasterCard Amex CUP configuration demo video 166 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 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 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

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