{"id":423,"date":"2016-04-07T14:29:16","date_gmt":"2016-04-07T18:29:16","guid":{"rendered":"http:\/\/www.e-registernow.com\/support\/?p=423"},"modified":"2018-07-09T13:44:46","modified_gmt":"2018-07-09T17:44:46","slug":"batch-file-format","status":"publish","type":"post","link":"https:\/\/e-registernow.com\/support\/batch-file-format\/","title":{"rendered":"Batch File Format"},"content":{"rendered":"

File Format For Credit Card Transaction Submission<\/h3>\n\n\n\n\n
Expiry Date<\/td>\nAmount<\/td>\nCard Number<\/td>\nCardholder’s Name<\/td>\nCompany Name (Optional)<\/td>\n<\/tr>\n
mmyy<\/td>\n0.00<\/td>\ndddd dddd dddd dddd<\/td>\nJimmy Breer<\/td>\nInterware.Net Inc.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

    \n
  • Each line of the file should appear as follows as shown in the example.<\/li>\n
  • Each column is separated by tabs.<\/li>\n
  • An unlimited number of lines\/transactions are allowed.<\/li>\n
  • The batch file must be in .txt format.<\/li>\n
  • The fifth column can be omitted<\/li>\n<\/ul>\n

    Example of the Batch File format: (tab delimited)<\/p>\n

    1209\u00a0\u00a0\u00a0\u00a010.00\u00a0\u00a0\u00a0\u00a04500 5400 2300 1200\u00a0\u00a0\u00a0\u00a0John Doe\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Interware.Net Inc.
    \n1115\u00a0\u00a0\u00a0\u00a015.00\u00a0\u00a0\u00a0\u00a05500 5400 4400 1265\u00a0\u00a0\u00a0\u00a0Peter Jones\u00a0\u00a0\u00a0\u00a0ABC company<\/p>\n

    Notes about Excel<\/h3>\n

    If the card information is stored in excel,<\/p>\n

      \n
    1. Ensure the batch file is in the correct format:\n
        \n
      • the first column contains the expiry month and year,<\/li>\n
      • the second column contains the amount to be charged (no negative amounts are allowed)<\/li>\n
      • the third column contains the credit card number (must be 15 or 16 digits long)<\/li>\n
      • the fourth column contains the card holder’s name<\/li>\n
      • the fifth column contains the card holder’s company. (optional column)<\/li>\n<\/ul>\n<\/li>\n
      • Save the excel sheet to a new file of type *.txt, e.g. c:\\cards.txt (Save as…, Text (Tab delimited) (*.txt)<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        File Format For Credit Card Transaction Submission Expiry Date Amount Card Number Cardholder’s Name Company Name (Optional) mmyy 0.00 dddd dddd dddd dddd Jimmy Breer Interware.Net Inc.   Each line of the file should appear as follows as shown in the example. Each column is separated by tabs. An unlimited number of lines\/transactions are allowed. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[88],"tags":[220,301],"class_list":{"0":"post-423","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-batch_processor","7":"tag-batch","8":"tag-file-formatting","9":"entry"},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7kUZg-6P","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts\/423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/comments?post=423"}],"version-history":[{"count":2,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts\/423\/revisions"}],"predecessor-version":[{"id":425,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts\/423\/revisions\/425"}],"wp:attachment":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/media?parent=423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/categories?post=423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/tags?post=423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}