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 use https://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.
