Differences

This shows you the differences between two versions of the page.

--- gl_-_bank_reconciliation [2015/06/10 14:59 (9 years ago)] – [OFX file Format] cliff
+++ gl_-_bank_reconciliation [2019/08/26 13:41 (5 years ago)] – [OFX file Format] craig
@@ Line 71: / Line 71: @@
 <code>
 <STMTTRN><TRNTYPE>SRVCHG<DTPOSTED>20150529172447.000[-5:EST]<TRNAMT>-1.82<FITID>15149153052514253474570000<MEMO>OVERDRAFT INTEREST CHARGE;Branch Transaction</STMTTRN>
 </code>
+=== OFX files missing line breaks ===
+Some exports are missing the line breaks at the end of each tag. It looks like
+''<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>OK</STATUS>''
+instead of
+''  <OFX>
+    <SIGNONMSGSRSV1>
+    <SONRS>
+    <STATUS>
+    <CODE>0
+    <SEVERITY>INFO
+    <MESSAGE>OK
+    </STATUS>''
+Here is how they can fix the file format. They can use the qfx for ofx file format.
+  * Download notepad++ from https://notepad-plus-plus.org/   They must use notepad++ as most other search and replace editors do not have the regular expression option.
+  * Open the file in netpad++
+  * Select Search, Replace.
+  * Find <
+  * Replace with \n<
+  * Search mode = Extended
+  * Replace All,
+  * Save with a new file name and then import into System Five.