Does anybody around here have experience with manipulating OFX files for import into AP?
I wrote a script which converts our bank's .CSV into an OFX for AP ERP 5.3b. We upgraded to 5.5 and it no longer works. One of my theories is that AP 5.5 reads only OFX 2+ whereas 5.3b would only read files that were older than OFX 2.
I'd be happy to make those changes to the script but, other hand, it doesn't seem very likely that they would drop support for any open banking standard. The header of the file declares the OFX version -- so it wouldn't be difficult to determine what parsing is required.
Anybody been down this, or any similar, path?
I wrote a script which converts our bank's .CSV into an OFX for AP ERP 5.3b. We upgraded to 5.5 and it no longer works. One of my theories is that AP 5.5 reads only OFX 2+ whereas 5.3b would only read files that were older than OFX 2.
I'd be happy to make those changes to the script but, other hand, it doesn't seem very likely that they would drop support for any open banking standard. The header of the file declares the OFX version -- so it wouldn't be difficult to determine what parsing is required.
Anybody been down this, or any similar, path?