OFX (Open Financial Exchange) - Is there an easy way to handle in Make?

Questions & Answers
1

Is there an easy way to handle OFX (Open Financial Exchange) files using Make?

2

Is there an api? Is it a text file? Lots of questions you could post and we could answer. But don’t force us to parse a link. Ask useful questions please about what you need in make. Thanks!

3

Okay,
So, according to Design: Bank statement OFX format (exactsoftware.com)

There are 2 types (SGML / XML) of OFX files;

1) OFXSGML format from OFX version 1.x

Header:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

Body:

<OFX>
  <SIGNONMSGSRSV1>
    …
  </SIGNONMSGSRSV1>
  <BANKMSGSRSV1>
    …
          <STMTTRN>
            <TRNTYPE>PAYMENT
            <DTPOSTED>20050824080000
            <TRNAMT>-80.32
            <FITID>219378
            <CHECKNUM>1044
            <NAME>FrogKick Scuba Gear
          </STMTTRN>
    …
  </BANKMSGSRSV1>
</OFX>

The file header is specific to OFX file format.
The starting tag does not end with ending tag.

2) XML format from OFX version 2.x

Header:

<?xml version="1.0" encoding="ASCII"?>
<?OFX OFXHEADER="200" VERSION="211" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?>

Body:

<OFX>
 <SIGNONMSGSRSV1>
    …
 </SIGNONMSGSRSV1>
 <BANKMSGSRSV1>
    …
          <STMTTRN>
            <TRNTYPE>POS</TRNTYPE>
            <DTPOSTED>20050824080000</DTPOSTED>
            <TRNAMT>-80</TRNAMT>
            <FITID>219378</FITID>
            <NAME>FrogKick Scuba Gear</NAME>
          </STMTTRN>
    …
 </BANKMSGSRSV1>
 <CREDITCARDMSGSRSV1>
    …
 </CREDITCARDMSGSRSV1>
</OFX>
4

Terrific use the xml parser.

Text parser if necessary for headers.

1 Like