MiGS VPC Batch Loader R2.0
Contents
1. LT MasterCan Worldwide Loader AMA Configuration File e ebatchLoaderNbatchinNsampleStandardO1l csv Open v Validate Only Thread 1 READY Thread 2 E READY Thread 3 READY Thread 4 READY Thread 5 READY View Results Validated Pre Auth Purchase Transactions 18 Total Pre Auth Purchase Value 20 50 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 Total Capture Value 0 00 0 00 approx 0 00 Unknown Transactions 0 Figure 10 Validate Only Cycle Validation Finished The View All Results button will display the validation status of all transactions contained in the input batch file This includes all validated and error results file csv test all csv The Validated button will display the validation status of all validated transactions file csv test app csv The Error button will display the error transactions exactly as it appears in the input batch file file csv test err csv Please refer to Appendix B and C for detailed information on result codes and result information 20038 MasterCard Int 13 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 The following is an example of the all csv that is displayed when the View Results button is pressed MiGS PCBatchLoader batchout sampleSt2. eq 11 55922 slay 1 J9 3 AGODSSADIV sdpodA ne wod puedua sew 561 54114 18 13 9 1 75 91 sdp odA ne uo 2 pJ4e J4eiseu 566 54114 1 1139 1 59 SUOL IeESURIA u23eq eui seurjep SLUL TUN 15 y 34104 JUaL D JUaWAed 993 uo 591 JeDuo F Tun 139 1 2 45 sss ss uu HH Ppp ww AAAA p uUs 93 7 1 5 5 5 Jepuedde 433aN3ddVSDIW Jepuedde Appendix This section contains detailed information on RESULTCODEs displayed by the CommWeb Batch Loader application ERR BATCHLOADER BatchLoader Configuration Errors ERR BATCHLOADER error messages typically depict configuration errors of the application With the exception of LOOO and 1001 these errors will prevent the application from processing the batch file INFO DESCRIPTION RESOLUTION 000 Could not find the Payment Client Please check the lax class path setting in the Load lax file or check your CLASSPATH environment variable 8001 BATCHLOADER properties configuration problem B002 A lock file indicates that the applica
3. y 31 514 16 ey seueus Lj UO LAdNI 5 pae eui 64 92U91SLX9 2942 LM eui JUL BY 9002 e Q0 J 591 1 92 pJE2J8eJSE A 2002 Jepueddve 1 Lea Cp60 5 4 p60 Jepueddve osuo eu ede 6420 33aNaddvs5IW Jepuedde 4 AYNTIVA 9 19901 OL GVA1 lt SV 5 3S3Hl LON OG 8 19901 ZENIM NOILVIIdWOD 3Q0VOl1HO2l1V873 THHHHHHHHHEHHHBHHEHHHHHHHHBHHHBHHHHHBHHHBHHHHBHBHHBHBHHHBHHHBHHHBHHHBHHHHBHEHHBHHHBHHHHHHHBHHHHHHHHHES SDONILLAS 50 THHHHHHHHHEHHHBHHEHHHHHHHHBHHHHBHHHHHHHHBHHHPBBHHHBHHHHHHBHHHBHHHBHHHHBBHHHBHHHBHHHHHHHHHHHHHHHHES 0 ZY NOISYSA H83QVOlHD1V8 J9peo1 SOLW 3WVN YAGVOTIHDLVE THHHHHHHHHEHHHBHHEHHHHHHHBHHHHBHHHHHBHHHBHHHHBBHHHBHHHHHHBHHHHBHHHBHHHBBHHHHHHBHHHHHHHHHHBHHHHBHHES Q35NVHD 39 LON LSNW 501414 1 1104 THHHHHIHHHHE
4. aseo enit te three 9 2 Opening a Batch File ode ee oe Ree RERO RR TR E tele 10 3 Ensuring that Validate Only is Checked 14 4 Starting the Validate Only Cycle 12 5 Checking the Results from the Validate Only Cycle 13 6 Amending the Input Batch File 14 The AMA Configuration 08 15 The Processing Cycle 16 7 Ensuring that Validate Only is Cleared 16 8 Starting the Processing 17 9 Waiting for the Processing Cycle to Finish 18 10 Checking the Results from the Processing Cycle 20 Business Processes for Declined and Error Transactions 21 Refunding Transactions cc rn m Ur NAR sie ue ce FRE RR needa 21 Advance et er 22 Automating Batch Loader c at M exe ARD E Pn bun kx pd sid 22 Operating In the Background entente a af E 23 Custom input c i apr Abe pr nere E ER ER M apr keen 23 Payments Du 23 Pepe rre ne 24 properties oomen erue ia dene P C R
5. ee SL pue use s eq e qnop Aq lt 1 SMOPULM 40322841p 5 941 01 195 eq 5 1004 9 LJ UL 359 3 LL LM 9240 sour SOUL 5 1395 LON 59411 SOUL S3usuuo2 4 ey 59817 9114 5914 SAL Jsedoud 2007 14 6 4 402 ERE 1 y 104 Bunsi ue si v xipueddy 9002 e Q0 LH 591 1 SC PIEDISISEW 2002 rr M M 9 X
6. MasterCard Worldwide VPC Batch Loader R2 0 User Manual Version 1 0 Disclaimer We may make improvements and or changes to the products and services described in this Manual at any time To the fullest extent permitted by any applicable law We give no warranties of any kind whatsoever in relation to this Manual including without limitation in respect of quality correctness reliability currency accuracy or freedom from error of this Manual or the products it describes All terms conditions warranties undertakings inducements or representations whether expressed implied statutory or otherwise relating in any way to this Manual are expressly excluded Without limiting the generality of the previous sentence neither us nor our affiliates employees directors officers or third party agents will be liable to you for any direct or indirect loss or damage including without limitation consequential punitive or special loss or damage however arising in respect of this Manual or any failure or omission by us even if we are advised of the likelihood of such damages occurring If we have to accept any liability our total aggregate liability to you including any liability of our affiliates employees directors officers and third party agents collectively and regardless of whether such liability is based on breach of contract tort strict liability breach of warranties failure of essential purpose or otherwise
7. 4 Using the Batch Loader This section contains information on the operation of the Batch Loader application The Validate Only Cycle Once the Batch Loader has been successfully started the main Loader screen will be displayed MIGS Batch Loader R2 0 ni xi Program Help MasterCard Worldwide Loader AMA Configuration File Open v Validate Only Status Please open a batch file Thread 1 i READY Thread 2 READY Thread 3 READY Thread 4 READY Thread 5 READY Pre Auth Purchase Transactions 0 0 0 Total Pre Auth Purchase Value 0 00 0 00 approx 0 00 Refund Transactions 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 30 00 Unknown Transactions 0 Figure 5 Batch Loader Main Loader Screen The main Loader screen is the interface through which the user will carry out the batch processing task Notice that the Batch File field is currently blank and that the Load button is disabled 1 BatchFile Input Directory Batch files should be placed in the following directory lt BATCHHOME gt batchin This will allow the application to easily locate the batch files to be processed Although it is not mandatory for batch files to be placed in this directory it is highly recommended so that the user can keep track of all their files 20038 MasterCard Int 9 MiGS VPC MiGS Batc
8. QHVONV LSaNITHOLV8 99 Jo ejduexe ue si yeg eui periddns s ejduies v qu vaNVIS3NITHO1Vg
9. The BATCHLOADER properties Configuration File By default the Batch Loader installation application is installed in the following directory c Dialect BatchLoader If the Batch Loader has been installed to a different directory the following error message will appear when attempting to run the Batch Loader application 151 MIGS YPC Batch Loader ERR BATCHLOADER BOOL error has occured while starting the application ERR BATCHLOADER B001 Bad BATCHLOADER_ROOT specified in the configuration file BATCHLOADER properties Please ensure that it points to the BATCHLOADER installation directory EXIT Figure 4 ERR BATCHLOADER B001 Bad BATCHLOADER_ROOT If the message above appears the following configuration file will need to be modified otherwise skip this section on The BATCHLOADER properties Configuration File lt BATCHHOME gt classes BATCHLOADER properties The default BATCHLOADER_ROOT setting points to the Batch Loader installation directory BATCHLOADER_ROOT MiGS BatchLoader The setting will need to be changed to reflect the correct installation directory NOTE directory separators require double backslashes and there is no at the end of the setting For detailed information on the settings configurable in the BATCHLOADER properties configuration file please refer to Appendix A 20038 MasterCard Int 8 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008
10. 0 00 Unknown Transactions 0 Figure 8 Validate Only Cycle Starting Validation The progress will be displayed while validation is taking place amp MIGS Batch Loader R2 0 Program Help Loader AMA Configuration File C MMIGSNVPCBatchLoaderNbatchi nsampleStandardO1 csv Open v Validate Only Status PROCESSING send File Stop Thread 1 7 pone LINE 6 VALIDATED Validation passed Thread 2 LINE 7 VALIDATED Validation passed Thread 3 7777 pone LINE 8 VALIDATED Validation passed Thread 4 7 pone LINE 9 VALIDATED Validation passed Thread 5 7777 pone LINE 10 VALIDATED Validation passed View All Results validated Declined Error Pre Auth Purchase Transactions 0 0 0 Total Pre Auth Purchase Value 0 00 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 0 00 Unknown Transactions 0 Figure 9 Validate Only Cycle Validating 20038 MasterCard Int 12 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Checking the Results from the Validate Only Cycle Please wait while the application performs validation Once it is complete the application will display FINISHED in the Status field Several results buttons will also be enabled
11. Results Validated Error Pre Auth Purchase Transactions 18 0 0 Total Pre Auth Purchase Value 20 50 0 00 approx 30 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 30 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 30 00 Unknown Transactions Figure 13 Processing Cycle Clearing the Validate Only Checkbox NOTE by clearing the Validate Only checkbox transactions will be sent to the server when the Load button is pressed 20038 MasterCard Int 16 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 8 Starting the Processing Cycle The processing can be started via the Send File button 5 MIGS Batch Loader R2 0 Program Help MasterCard Worldwide Loader AMA Configuration File C MIGS VPCBatchLoader batchin samp eStandard01 csv Status FINISHED Thread 1 READY Thread 2 READY Thread 3 READY Thread 4 READY Thread 5 READY View All Results Validated Declined Error Pre Auth Purchase Transactions 18 0 Total Pre Auth Purchase Value 20 50 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 0 00 Unknown Transactions 0 Figure 14 Processing Cycle Begin Processing A confirmation popup for the
12. Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 0 00 Unknown Transactions 0 Figure 16 Processing Cycle Processing The processing be stopped via the Stop button the File gt Exit menu item or the X at the top right corner of the application If the processing needs to be stopped please wait patiently while the application finishes off transactions that have already been sent to the server NOTE the application cannot be closed while a batch file is being processed If the File gt Exit menu item or the X is pressed while a batch is being processed this will be equivalent to pressing the Stop button To close the application press the File gt Exit menu item or the X while batch processing has finished or has stopped 20038 MasterCard Int 18 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Program Help i x Loader Configuration Open Validate Only Send File Stop pl 1 Thread 2 PROCESSING LINE 22 Thread 3 PROCESSING 231 4 PROCESSING LNE 24 Thread 5 PROCESSING 20 View Results Approved Declined Error Pre Auth Purchase Transactions 0 0 0 Total Pre Auth Purchase Value 0 00 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 3000 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00
13. approx 0 00 Unknown Transactions 0 Figure 17 Processing Cycle Interrupting the Process MIGS Batch Loader R2 0 x Program Help E Loader AMA Configuration File C MMIGSNVPCBatchLoader NbatchinssampleStandardOl csv Open Validate Only Stats Processing was interrupted via Stop button or Exit Send File Stop Thread 1 Thread 2 READY Thread 3 READY Thread 4 READY ThreadS READY View Results Approved Declined Error Pre Auth Purchase Transactions 24 0 0 Total Pre Auth Purchase Value 24 00 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 0 00 Unknown Transactions 0 Figure 18 Processing Cycle Interrupted 20038 MasterCard Int 19 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 10 Checking the Results from the Processing Cycle Once the Processing cycle is complete the application will display FINISHED in the Status field Several results buttons will also be enabled loxi Program Help MasterCard Worldwide Loader AMA Configuration File MMIGSNVPCBatchLoaderNbatchi nNsampl eStandardO1 csv Open 0 Status FINISHED Thread 1 READY Thread 2 READY Thread 3 READY Thread 4 READ
14. is limited to US500 00 While we have no reason to believe that the information contained in this Manual is inaccurate we accept no responsibility for the accuracy currency or completeness of the information in this Manual We do not warrant or represent that we have checked any part of this Manual that is a copy of information we have received from a third party We are merely passing that information on to you License Agreement The software described in this Manual is supplied under a license agreement and may only be used in accordance with the terms of that agreement Copyright MasterCard owns the intellectual property in this Manual exclusively You acknowledge that you must not perform any act which infringes the copyright or any other intellectual property rights of MasterCard and cannot make any copies of this Manual unless in accordance with these terms and conditions Without our express written consent you must not distribute any information contained in this Manual to the public media or quote or use such information in the public media or allow access to the information in this Manual to any company firm partnership association individual group of individuals or other legal entity other than your officers directors and employees who require the information for purposes directly related to your business 20038 MasterCard Int ii MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Summary of
15. The declined file csv dec csv and error file csv err csv files contain transactions copied from the input batch file The exact reason for the decline error should be cross checked with the results file file csv all csv and a business decision be made whether to correct and re process these transactions DO NOT MODIFY THESE FILES DIRECTLY these files can be copied back into the input directory as a new batch file Please rename it to a unique batch filename Refunding Transactions The approved results file file csv app csv contains the necessary information for processing refunds DO NOT MODIFY THIS FILE DIRECTLY this file can be copied back into the input directory as a new batch file Please rename it to a unique batch filename The field can be changed from a charge to a refund while the TRANSACTIONNO be used All other irrelevant fields should be removed to conform to the refunds format see Appendix C 20038 MasterCard Int 21 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 5 Advance Functions This section contains information on the advanced functions and settings of the Batch Loader application Before users attempt to utilise these advance function they should have a good understanding of how the Batch Loader functions and the input output formats Automating Batch Loader starting the Batch Loader with Load Auto exe the Batch Loader will search
16. e2u9gJ9jJoJ enbiun OV N JJ3HNXLHOSMHSIN 9L 2 OLON JO 94 ISN JdALNXL SMVHO SYVHD NIN jeuuo 5 QquvaNv LS3NI1HO1V8 1VWOJOG 30VO1H21V8 eq 0 y 15 esn 1 99 payloads si jeuuo eu L 5 uojeg Aq 1ndu y uo uoneuuojui uomoes 5 41 3 xipueddy 9002 e Q0 J 591 1 PIEDJI ISEW 2002 61 11 141 urejuoo Aew BY jues jou jeu suonoesueu pied peziubooeM 1die oM JdALQHVO 6L ON Duiddous 3die2esj ONNOILOVSNVUL 8L Jequinw 1die es ONHOLVd 4 019293 GISZIMOHLNV 9L JeJinboy 1dieoesJ 3dO9dS3HOOV SL JequunN 1die283 1019094 ONLdI3O
17. start of the Processing cycle will appear Click Yes to proceed or No to cancel processing CONFIRMATION _ The Processing Cycle will begin and transactions will be sentto the server Please ensure that you are satisfied with the results during the Validate Only Cycle If the batch contains refunds please also ensure that you have configured the AMA username and password in the Configuration screen Are you sure you wantto proceed Figure 15 Processing Cycle Confirmation 20038 MasterCard Int 17 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 9 Waiting for the Processing Cycle to Finish Please wait while the application performs processing The total time is dependent on the size of the batch file the speed of the computer the speed of the internet connection and the authorisation time taken for each transaction MasterCard Worldwide Loader Configuration File C MMIGSNVPCBatchLoader batchi nNsampl eStandardO1l csv m Status PROCESSING Stop Thread 1 PROCESSING 11 Thread 2 PROCESSING 12 Thread 3 PROCESSING 13 Thread 4 PROCESSING 9 Thread 5 DONE LINE 10 APPROVED 0 Transaction Successful Pre Auth Purchase Transactions 0 0 0 Total Pre Auth Purchase Value 0 00 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00
18. 3M tL pezuouiny 30192934 L 50 1die es 2S3d3aO09dS3MlsO Z4 esuodseay 50 119294 21009989350 LL jndui se owes OJNINH3QHO OL jndui se ewes LINNOWY 6 OSOQHVO 8 jndui se 1 pexseuu eq Aew se owes 2 9 jndui se J3MNXLHOMSSIN S jndui se QILLNVHOMWZIN v jndui se AdALNXL SjjnseJ SU jo 170538 c 99 10 AGOOLINSSAY L SLNAWINOD qii LAdLNO yewo GYVGNVLSANITHOLVA 9002 e 0 4 SOIN PIEDJI ISEW 2002 61 11 141 urejuoo Aew BY 0 1 95 JOU jeu suonoesueu yuejq MNV1d 6L ON eloueut4 3019294 ONNOILOVSNVHI 8L Jaquinn 1die es ONHOLVd Zl 019293 GISZIMOHLNV 9L JeJuinboy 1die2e jgoodsaHOOVv SL Jequinw 1die283 1019094 ONLIdI3O3M tL XNV1I8 L uonduoseq 50 1die eN OSAGHGOOdSAUISO Z4 esuodsed 50 101929 3agood
19. C 04 VALIDATED Validation passed C TESTTESAUDALUCYF AUTH DEC 05 512345 346 1305 151 AUTH DEC 05 VALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH ERR 01 512345 346 1305 100 AUTH ERR O Validation passed C TESTTESAUDALUCYF AUTH ERR 02 512345 346 1305 100 AUTH ERR 02 VALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH ERR 03 512345 346 1305 100 AUTH ERR 0 WALIDATED Validation passed C TESTTESAUDALUCYF AUTH ERR 04 512345 346 1305 100 AUTH ERR 04 END FILE Figure 11 Validate Only Cycle View Results 6 Amending the Input Batch File The user should take note of any error transactions and make any modifications necessary Because this is the Validate Only cycle the user may make modifications to the original input batch file The user is encouraged to validate the input batch file until the batch file is deemed fit for the Processing cycle To repeat the Validate Only cycle after making modifications the user should ensure that the Validate Only option is selected and click on the Load button to re validate NOTE the most common source of validation errors are fields that are too long too short or fields that contain invalid information for example a card number failing MOD10 check 20038 MasterCard Int 14 MiGS VPC MiGS Batch VPC Loader R1 0
20. Changes Batch Loader R1 5 0 User Manual December 2003 Date Description By 01 Dec 03 Document created Thomson 14 Feb 06 Revised for R1 4 John T 03 Jan 08 Revised for VPC R2 0 John T 20038 MasterCard Int MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Table of Contents Using this Me 1 n 1 i E 1 Related pq e Rea Em E 1 Other Software 2 2 Essential Knowledge esee enne nenne nnne nnne 3 det eo 3 Functional Overview bn p PRIN 3 Pre requisites 4 Two Step Manual Processing 5 Automatic Processing teri ed eerie eH ULP dead da 5 Input and Output File 6 Input and Output File 0 etaient oa f e ntur en dta oed 6 Validate Only 6 PROCESSING ccm 7 ASONTIGUPAON EE 8 The BATCHLOADER properties Configuration File 8 4 Using the Bater eed 9 The Validate Only Cycle 9 1 Batch File Input
21. HHHBHHEHHHHHHHBHHHHBHHHHBHHHBHHHBHBHHBHBHHHHHHBHHHBHHHBHHHHBBHHHBHHHHHHHHHHHHHBHHHHHHES qJesn u3S SINVHOHJW VWV SINVHOM3ALS3 1 GOI SI1NVHOH3W 3QVO HD1V8 4950 3350 plNVHOHJ3W 1 VLINVHOHJWIS31 QI pLNVHDYAW 5 ELNVHOHJW YACVOTHDLVE 1 1531 01 1 VIV 2495 4350 CINVHOW3W 33QvO H21V8 21 1531 01 ZINVHOH3W VIV 33QVO H21V8 cIpJowssed ssvd 33Q0vO 1H21V8 T4esn udst LINVHOS3W VIV 33QVO H21V8 4 531 01 TLNVHDYAW 4950 335 TLNVHDYAW VIV 33Q0VvO1HD1V8 1531 01 TLINVHOH3W 1 s duex3 spunjou pue queupJeu y 195944 UOLJeUNHLJUOD pue viv 9002 e Q0 J 591 1 PIEDJI ISEW 2002 4048 4 400255422 6409 400255422 L 1621404 uorieJisrurupv JZUeYDIIEW
22. Results of APPROVED txns approved txns only dec csv DECLINED txns copied from input file csv err csv ERROR txns copied from input file csv state Keeps track of which txns from file csv is processed Figure 3 Input and Output File Format Processing Cycle In the Processing Cycle the state file is used to keep track of which lines in the input has been processed Should the process be interrupted processed transactions will not be sent again The program will resume at the first unprocessed transaction NOTE the application keeps track of results and processed transactions via the unique filename Once the Processing Cycle has been initiated the user MUST NOT CHANGE DELETE the filenames or contents of the files illustrated above The declined dec csv and error err csv files contain declined and error transactions exactly as they appear in the input file The user can make a copy of these files make any corrections necessary and re process these failed transactions NOTE it is recommended that the user does not change the declined and error output files but rather make a different copy for reprocessing The user can copy these files to the input directory and make modifications there 20038 MasterCard Int 7 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 3 This section contains information on the general configuration of the Batch Loader
23. SVWDD 31 1 5 3NON 53 p 3se 993 pue 9 15413 y UO 9 2521 eui pue 9 15 14 uo moys 59 3161 p 2521 eui A uo moys 70 3161 Sew 11 9 LJ 531 59 627100 992 ur pued 3161 9T 404 9 5 TWOLSQO3NIIHOLVS8 1VWHOJOG YACVOTHDLVE QuVONV IS3NITIHOIV8 1VW3HOHOQG 33Q0VO THO21V8 a ILLIS GUVONVLSANI 1HDLVE LVWeOAOd TWOLSNDANI IHD LVE LVWeOAOd 33Q0VOT1H2 1V8 s Ita ELLE IC AL EILEEN 5 404 OL LJ Indul eui 01 195 eq ISN 1 0404 P Se SS eS oi1nv N3llVd LAdNI i e LLm L epow ony UL SL ay LM NN3llVd
24. User Manual Jan 2008 The AMA Configuration Screen If the input batch file contains transactions requiring Advanced Merchant Administration usernames and passwords they can be configured in the AMA Configuration screen MIGS PC Batch Loader R2 0 1 MasterCard Worldwide Merchant ID AMA Username Password Confirm 1 TESTMERCHANT1 2 TESTMERCHANT2 2 3 TESTMERCHANT3 user3 4 TESTMERCHANT4 user4 5 TESTMERCHANTS users Figure 12 AMA Configuration Screen Up to five 5 AMA usernames passwords can be configured 20038 MasterCard Int 15 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 The Processing Cycle Once the user has validated the batch file they may begin the Processing cycle 7 Ensuring that Validate Only is Cleared To start the Processing cycle ensure that the Validate Only checkbox is cleared as illustrated below MIGS Batch Loader R2 0 Program Help Loader AMA Configuration File C MMIGSNVPCBatchLoader batchi nsampleStandardOi csv Open L Validate Only Status FINISHED Send File Thread 1 READY Thread 2 READY Thread 3 READY Thread 4 READY Thread 5 READY View
25. Y Thread 5 READY 1 ES View Results Approved Declined Error Pre Auth Purchase Transactions 24 0 Total Pre Auth Purchase Value 24 00 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 0 00 Unknown Transactions 0 Figure 19 Processing Cycle Processing Finished The View Results button will display the results of all transactions This includes all approved declined and error results file csv all csv The Approved button will display the results of all approved transactions file csv app csv The Declined button will display the declined transactions exactly as it appears in the input batch file file csv dec csv The Error button will display the error transactions exactly as it appears in the input batch file file csv err csv An extra state file file csv state contains the information on which lines of the input batch file has been processed This file is for the internal use of the application only PLEASE DO NOT EDIT OR REMOVE THIS FILE this is especially important if the processing was stopped before it was finished as this file allows the application to resume processing at the last unprocessed transaction 20038 MasterCard Int 20 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Business Processes for Declined Error Transactions
26. andard01 csy test all csy File WALIDATED Validation passed C TESTTESAUDALUCYF AUTH APP 01 512345 346 1305 100 AUTH APP 01 VALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH APP 02 512345 346 1305 100 AUTH APP 02 WALIDATED Validation passed C TESTTESAUDALUCYF AUTH APP 03 512345 346 1305 100 AUTH APP 03 WALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH APP 04 512345 346 1305 100 AUTH APP 04 WALIDATED Validation passed C TESTTESAUDALUCYF AUTH APP 05 512345 346 1305 100 AUTH APP 05 WALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH APP 06 512345 346 1305 100 AUTH APP 06 IVALIDATED Validation passed C TESTTESAUDALUCYF AUTH APP 07 512345 346 1305 100 AUTH APP D7 WALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH APP 08 512345 346 1305 100 AUTH APP 08 VALIDATED Validation passed C TESTTESAUDALUCYF AUTH APP 09 512345 346 1305 100 AUTH APP 09 WALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH APP 10 512345 346 1305 100 AUTH APP 10 VALIDATED Validation passed C TESTTESAUDALUCYF AUTH DEC 01 512345 346 1305 105 AUTH DEC 01 VALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH DEC 02 512345 346 1305 110 AUTH DEC 02 WALIDATED Validation passed C TESTTESAUDALUCYF AUTH DEC 03 512345 346 1305 133 AUTH DEC 03 WALIDATED Validation passed PRCH TESTTESAUDALUCYF AUTH DEC 04 512345 346 1305 151 AUTH DE
27. d 2 READY Thread 3 READY Thread 4 _ READY Thread 5 READY View Result Declined Error Pre Auth Purchase Transactions 0 0 0 Total Pre Auth Purchase Value 0 00 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx 0 00 Unknown Transactions Figure 7 Validate Only Cycle Validate Only Option Notice that the Batch File field will display the filename of the selected batch file Once a batch file has been selected the Load button is enabled as illustrated above 20038 MasterCard Int 11 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 4 Starting the Validate Only Cycle The validation can be started via the Send File button 5 MIGS Batch Loader R2 0 lolx Program Help x Loader AMA Configuration File C MMIGSNVPCBatchLoader batchin NsampleStandardO1 csv Validate Only Status Press LOAD to begin Stop Thread 1 READY Thread 2 READY Thread 3 READY Thread 4 READY Thread 5 READY EIU Results Approved Declined E Pre Auth Purchase Transactions 0 0 0 Total Pre Auth Purchase Value 0 00 0 00 approx 0 00 Refund Transactions 0 0 0 Total Refund Value 0 00 0 00 approx 0 00 Capture Transactions 0 0 0 Total Capture Value 0 00 0 00 approx
28. dministration username and password Two Step Manual Processing Cycle VITAL INFORMATION Merchants operating the Batch Loader application manually must process transactions in a two step process 1 Validate Only Cycle this process pre screens the input file for commonly known errors and outputs information on which transactions are correctly formatted and which transactions will definitely fail In the Validate Only Cycle no transactions will be sent to the Payment Server This allows the merchant to correct formatting errors Once the user is happy with a validated input file they may proceed to the next step NOTE the application defaults with the validate only option enabled however the user may manually skip this step Validation is highly recommended to reduce rework on failed transactions 2 Processing Cycle this process will send transactions to the Payment Server Any transactions that had failed validation but had not been corrected will not be sent to the server NOTE in depth information on using the application will be detailed in the section Using the Batch Loader Automatic Processing Cycle Automatic Processing will be covered in the Advanced Section of this manual 20038 MasterCard Int 5 MiGS VPC 5 Batch VPC Loader R1 0 User Manual Jan 2008 Input Output File Format The Batch Loader application processes transaction commands from comma separated value CSV input
29. e ca sex Feo e PER P auda 24 PROD SIAC B dcos spesa saa en Eh 28 ERR BATCHLOADER BatchLoader Configuration Errors 28 ERR RECORD Batch File Record 5 29 APPROVED DECLINED mi cinta perte epe te Y red et de ue 29 ote Sei tef E du a AEN Dor 30 30 20038 MasterCard Int iv MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 BATCHLINESTANDARD Charge Input 30 BATCHLINESTANDARD Charge 31 BATCHLINESTANDARD Refund Input 32 BATCHLINESTANDARD Refund Output 32 BATCHLINESTANDARD Example sse 33 20038 MasterCard Int V MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 1 Using this Manual This section contains information that helps you understand and use the information contained in this manual Purpose The MiGS VPC Batch Loader is an application facilitating the batched processing of credit card transactions This MiGS VPC Batch Loader R2 0 User Manual helps end users to understand the installation and op
30. erational requirements of the Batch Loader application Audience MiGS provides this manual for merchants and their authorized agents Specifically the following personnel should find this manual useful e Business owners responsible for delivery of the application e Technical support personnel Endusers of the application Related Documents This document is intended to be used with reference to various other documents detailing systems that this application depends upon The reader is advised to consult the following documents to gain an in depth understanding of the application Document Name Provider Merchant Administration User Manual MiGS 9 20038 MasterCard Int 1 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Other Software Dependencies The Batch Loader depends upon the following 3 party software Software Version URL Java Runtime Environment SUN JRE 1 5 0 http java sun com j2se 1 5 0 OR OR Java Development Kit SUN J2SE 1 5 0 SDK Furthermore the application requires connectivity to the internet in order to send transactions to the Payment Server 20038 MasterCard Int 2 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 2 Essential Knowledge This section contains background information that the reader is expected to understand prior to installing and operating the application Distribution The Batch Loader installa
31. files Likewise it outputs results to CSV output files Input and Output File Locations The Batch Loader application picks up input files from the following subdirectory lt BATCHHOME gt batchin by default and generates output files in lt BATCHHOME gt batchout Cenforced where is the directory in which the application has been installed The user may select input files from other directories however the output files will always be generated in the batchout directory Validate Only Cycle INPUT FILE batchin OUTPUT FILES batchout test all csv Results of ALL txns validated and error Validate test app csv Results of VALIDATED txns validated txns only test err csv ERROR txns copied from input file csv Figure 2 Input and Output File Format Validate Only In the Validate Only Cycle users can validate the file make any adjustments necessary and validate the file again There is no limit on the number of times a file can be validated NOTE the output filenames are prefixed with the input filename This is to allow easy identification of results 20038 MasterCard Int 6 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Processing Cycle INPUT FILE batchin OUTPUT FILES batchout all csv Results of ALL txns approved declined error Process Cycle app csv
32. fine your own input directory in BatchLoader classes BA TCHLOADER properties by removing the infront of the line INPUT_DIRECTORY C MiGS BatchLoader MERCHANT_DEFINED Recurring Payments User may send an empty expiry date field if optional expiry date is activated For example a purchase transaction line will be C MERCHANTID MERCHREF 5123456789012346 123 500 ORDERINF To activate the optional expiry date users will have to open the BATCHLOADER properties file in the classes folder And uncomment the line take away the RECURPAY_CARDEXP Optional During validation if no Exp Date is specified or it is all spaces it will pass validation If the exp date has anything other than spaces validation will still check for its formating as per non recurring payments NOTE The merchant account has to be setup by their bank to send Recurring Transaction Subtype as default before they can utilise recurring payments Please consult your bank 20038 MasterCard Int 23 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 9002 e 0 LH 591 1 vc pJE2J8e SE A 2002 SL indui peurjed 4esn AWHOLO3HIQ 1 Jopeo1u2iesaNNS5LIANN LOOX 33Q0VO 1HD1V8 s
33. h VPC Loader R1 0 User Manual Jan 2008 NOTE batch files must have a unique filename As detailed the section Input and Output File Locations the application keeps results and status information according to the input filename 2 Opening a Batch File To select a batch file click on the Open button from the Main Loader screen An example batch file is included in the installation package Select the batch file and click the Open button m D Auto sampleStandard01 csv D sample No ExpDate csv D sampleCustom01 csv D sampleStandard01 csv D sampleStandard02 csv D sampleStandard5200 csv File Name Files of Type Batch files csv Figure 6 Validate Only Cycle Opening Batch File 20038 MasterCard Int 10 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 3 Ensuring that Validate Only is Checked By default the Validate Only checkbox is ticked when a batch file is selected Because this option is selected no transactions will be sent to the server transactions in the batch file will be checked for common formatting errors MIGS Batch Loader R2 0 x Program Help MasterCard Loader AMA Configuration File iz Validate Only Status Please open a batch file Se TOT Thread 1 READY Threa
34. heck that the files in batchout are not write protected and that you have read write access to the batchout directory 1000 No AMA username specified for this merchant ID This is returned in the RESULTCODE and RESULTINFO field during validation or processing Please configure the appropriate MerchantlD username password in the AMA Configuration screen L001 Invalid BATCHLOADER DOFORMAT specified in the configuration file BATCHLOADER properties This is returned in the RESULTCODE and RESULTINFO field during validation or processing Please ensure that a correct value has been configured and close and restart the application 2003 MasterCard 28 MiGS Batch VPC Loader R1 0 User Manual February 2006 ERR RECORD Batch File Record Errors ERR RECORD error messages indicate formatting errors in a particular transaction line in the input batch file During the Validate Only cycle validated transactions will be marked as VALIDATED otherwise the suitable ERR RECORD will be recorded During the Processing cycle all transactions marked with ERR RECORD will be stopped by the application and will not be sent to the server INFO DESCRIPTION RESOLUTION R000 Blank line indicates a blank line in the batch file R010 Input TXNTYPE is invalid Check the error message for details R011 Input MERCHANTID is invalid Check the error message fo
35. r details R012 Input MERCHTXNREF is invalid Check the error message for details R013 Input CARDNUM is invalid Check the error message for details R014 Input CARDEXP is invalid Check the error message for details R015 Input CARDCSC is invalid Check the error message for details R016 Input AMOUNT is invalid Check the error message for details R017 Input ORDERINFO is invalid Check the error message for details R018 Input TRANSACTIONNO is invalid Check the error message for details APPROVED DECLINED Transactions that have successfully reached the authorisation process will have a RESULTCODE of APPROVED or DECLINED RESULTCODE DESCRIPTION APPROVED Transaction has gone through authorisation and has been approved DECLINED Transaction has gone through authorisation and has been declined 2003 MasterCard MiGS Batch VPC Loader R1 0 User Manual February 2006 29 06 9002 e Q0 J 591 1 pJE2J8e SE A 2002 L 8 0 gt jou Isni 001 1 SLND Ul 0L L INNOWY 4 CANOICONO Ajunoes pied 9 ZL gt 0 SI WIN ININAA 18 04 499U9 0LGON jequinu 61 INONGMVO Y
36. saMIsO LL yuelq MNV1d OL yuejq MNVY I8 6 xueiq MNV I8 8 indui se INnONWV 1 indui se owes ONNOLLOVSNVMH L 9 jndui se owes 9 jndui QILLNVHOM3IN v indui se AdALNXL 6 SjjnseJ SU jo 1711544 c uonoesueJ 3y JO AGOOLINSSY L SLNAWINODS LAdLNO yewo jnd3no punjes qu vaNvIS3NITHOIVS8 0 gt eq 100 18001 001 1 SLNAO UI ve INnONV 6 6 01 9 4 ON Buiddous 6L ONNOILOVSNVMH L v enbiun Ov N J3HNXLHOMSMSIN GI 1 9 4 suonoesueJ punjeJ 10 eq ISNIN AdALNXL L SHVHO SYVHD SIN3WAOO NIN LAdNI 3ndu 5 9002 e Q0 J 591 1 ce PIEDJI ISEW 2002 0 OANTYAGHO 001 EZT 7050 9VEZTOG8Z9SVECTS 0 3334NXLHOW3W SADNIVGNVSALLSAL SD 20 04 3040 00 VEZT 7050 10000000005 55007 Z0 SSYNXLHIYAN SADNIVGNVSSALLS3L D TO OANTYAGHO 001 221 7050 9VEZTOB6SZ9SHEZTS TO SSUNXLHDYAW 4 1 00 531153192 jndul
37. through the batchin and process all files that starts with certain pattern default is Auto This pattern can be changed defined in BatchLoader classes BATCHLOADER properties in the line INPUT_PATTERN Auto Next is to add running Load Auto exe as a windows scheduled task please navigate to Start gt All Programs gt Accessory gt System Tools gt Scheduled Tasks Click on Add Scheduled Task Click on Next Click on Browse Browse to the Batch Loader folder and select Load_Auto exe Select desired frequency and time In the log directory there will be a log file called autotask log which will have details on the automated tasks For example wed Mar 15 17 40 45 EST 2006 ROOTDIR C MiGS BatchLoader INPUT_DIRECTORY C MiGS BatchLoader batchin OUTPUT_DIRECTORY C MiGS BatchLoader batchout INPUT_PATTERN Auto VALIDATE_ONLY false Ready to process 1 input files Auto Processing C MiGS BatchLoader batchin Auto_sampleStandard01 csv done 0 Finished auto processing 20038 MasterCard Int 22 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Operating in the Background The Batch Loader can be ran hidden automatically e Right click on Load Auto exe Select Properties e Inthe Target field delete the word show at the end Next time the Batch Loader is ran from Load Auto exe it will start processing without showing its window Custom input directory You can de
38. tion is already running Only one instance of the Batch Loader can run at any one time The lock file may have been left behind by a previous crash If you are 10096 sure no other instances of the Batch Loader is running you may remove the BATCHLOADER lIock file from the log directory and restart the application 8003 Unable to create state file Please check that files in batchout are not write protected and that you have read write access to the batchout directory 8004 There is problem with the selected batch Please check that exists and that you have read access to the file and that it is a supported batch file type 8005 There is problem with the selected batch Please check that exists and that you have read access to the file and that it is a supported batch file type 8006 Unable to create all csv Please check that the files batchout are not write protected and that you have read write access to the batchout directory B007 Unable to create app csv file Please check that the files batchout are not write protected and that you have read write access to the batchout directory 008 Unable to create dec csv file Please check that files in batchout not write protected and that you have read write access to the batchout directory B009 Unable to create err csv file Please c
39. tion package is distributed to merchants who have signed onto the MiGS service and have a specific requirement for the batched processing of transactions NOTE the Batch Loader installation package must NOT be redistributed without the prior consent of MiGS Functional Overview The following diagram depicts the communication between the Batch Loader and various components of the MiGS service Merchant 2 Transaction Server requests Batch Loader Payment Server 3 Transaction responses 4 File Outputs 1 File Input Figure 1 Communication between the Batch Loader and the Server As the Batch Loader communicates with the server via the Virtual Payment Client the Batch Loader must only use Merchant IDs linked to the Access Code in the configuration file 9 20038 MasterCard Int 3 MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Pre requisites SUN JRE JDK must be installed prior to the installation of the Batch Loader Please refer to the Related Documents and 20038 MasterCard Int MiGS VPC MiGS Batch VPC Loader R1 0 User Manual Jan 2008 Other Software Dependencies for further information on obtaining and installing this software Furthermore a valid Merchant ID must be active on the MiGS service with the following Global Permissions enabled MayUse Virtual Payment Client MOTO Refunds processing requires an Advanced Merchant A
Download Pdf Manuals
Related Search