Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Parser for American Express transaction reconciliation files
Ruby
tree: 68f8bc30f6

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
config
lib
spec
.gitignore
Gemfile
Gemfile.lock
MIT-LICENSE
README.md
Rakefile
paxmex.gemspec

README.md

Paxmex

This gem parses your Amex data files into human readable data.

Installation

From RubyGems.org

% gem install paxmex

Available Methods

  • parse_eptrn(file_path)
  • parse_epraw(file_path)

Both methods return a readable hash in the following format:

{
  "DATA_FILE_TRAILER_RECORD" => {
    "DF_TRL_RECORD_TYPE" => "DFTRL",
    "DF_TRL_DATE" => "03082013",
    "DF_TRL_TIME" => "0435",
    "DF_TRL_FILE_ID" => "000000",
    "DF_TRL_FILE_NAME" => "LUMOS LABS INC      ",
    "DF_TRL_RECIPIENT_KEY" => "00000000002754170029          0000000000",
    "DF_TRL_RECORD_COUNT" => "0000004"
  },
  "DATA_FILE_HEADER_RECORD" => {
    "DF_HDR_RECORD_TYPE" => "DFHDR",
    "DF_HDR_DATE" => "03082013",
    "DF_HDR_TIME" => "0435",
    "DF_HDR_FILE_ID" => "000000",
    "DF_HDR_FILE_NAME" => "LUMOS LABS INC"
  },
  ...
}

Example

require 'paxmex'
Paxmex.parse_eptrn('/path/to/amex/eptrn/raw/file')
Paxmex.parse_epraw('/path/to/amex/epraw/raw/file')

The input files for either methods is a data report file provided by American Express. These files are in either EPRAW or EPTRN format so use the relevant method to parse them. We have provided dummy EPRAW and EPTRN files in spec/support. Output and key-value pairs vary depending on whether you choose to parse an EPTRN or EPRAW file.

Contributing

Fork and submit a pull request and make sure you add a test for any feature you add.

License

LICENSE: (The MIT License)

Something went wrong with that request. Please try again.