Can you post a small OFX file that's generated that way? I'll take a
quick look.
Jean
On 1/7/2023 10:18 AM, Tim Rohrer wrote:
I'm continuing my experimentation to migrate my Quicken for Mac data. I believe
I'm on track for the investments, so I've switched back to regular accounts.
Originally, I was going to use the Quicken Mac 2007 Transfer File (QMTF aka
QIF) but I started seeing some issues with how GnuCash handles splits, plus I'd
lose tags and much of my notes.
Now I'm trying to usehttps://github.com/reubano/csv2ofx
<https://github.com/reubano/csv2ofx> to generate OFX files from exported csv.
A dummy csv transaction:
Date,Payee/Security,Category,Amount,Account
1/1/2022,Tim,Income:Salary,500,Family Checking
Using csv2ox with a custom mapper, I get an ofx with guts of the transaction
like this:
<STMTTRNRS>
<TRNUID></TRNUID>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<STMTRS>
<CURDEF>USD</CURDEF>
<BANKACCTFROM>
<BANKID>b9fc6ca936ba09958d5076dd5ebfac69</BANKID>
<ACCTID>384d7d0b77b259606be9c29de2e05b45</ACCTID>
<ACCTTYPE>CHECKING</ACCTTYPE>
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>19700101</DTSTART>
<DTEND>20230107</DTEND>
<STMTTRN>
<TRNTYPE>CREDIT</TRNTYPE>
<DTPOSTED>20220101000000</DTPOSTED>
<TRNAMT>500.00</TRNAMT>
<FITID>743df964dc21309d6d8a7c0ca5eaa657</FITID>
<NAME>Tim</NAME>
</STMTTRN>
</BANKTRANLIST>
</STMTRS>
</STMTTRNRS>
But nothing appears to import.
In my logs:
LibOFX INFO: libofx_proc_file(): File format not specified, autodetecting...
(Above message occurred on Line 40, Column 1)
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open Financial
eXchange (OFX or QFX))
(Above message occurred on Line 40, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate
SIGNONMSGSRSV1
(Above message occurred on Line 2, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SONRS
(Above message occurred on Line 3, Column 3)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate
BANKMSGSRSV1
(Above message occurred on Line 12, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate STMTTRNRS
(Above message occurred on Line 13, Column 3)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date part, but unable
to parse time part of string 19700101. It is not in proper
YYYYMMDDHHMMSS.XXX[gmt offset:tz name] format!
(Above message occurred on Line 27, Column 23)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date part, but unable
to parse time part of string 20230107. It is not in proper
YYYYMMDDHHMMSS.XXX[gmt offset:tz name] format!
(Above message occurred on Line 28, Column 21)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpEkcf1m:37:11:E: end tag for "STMTRS" which is not finished
I do notice there is no category which could be a problem with my customer
mapper, so I'll keep experimenting.
But, does anyone see what could be causing the error? Are the warnings of
concern?
Tim
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
