Correct. And the errors and warnings I pasted earlier are logged.Linux GnuCash
4.11Build ID: 4.11+(2022-06-25)On Jan 7, 2023, at 12:53 PM, Jean L
<rip...@gmail.com> wrote:And you're saying that when you import this into a
blank account, nothing shows up?On 1/7/2023 10:52 AM, Tim Rohrer
wrote:Thanks, Jean.Here is the entire file (attached and pasted). For testing,
I was simply trying to get one transaction to work
first.DATA:OFXSGMLENCODING:UTF-8<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS><DTSERVER>20230107105800</DTSERVER><LANGUAGE>ENG</LANGUAGE></SONRS></SIGNONMSGSRSV1><BANKMSGSRSV1><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></BANKMSGSRSV1></OFX>On
Jan 7, 2023, at 12:41 PM, Jean L <rip...@gmail.com> wrote:Can you post a small OFX file that's generated that
way? I'll take a quick look.JeanOn 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,Account1/1/2022,Tim,Income:Salary,500,Family
CheckingUsing 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 finishedI 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
listgnucash-user@gnucash.orgTo 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
listgnucash-user@gnucash.orgTo 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.
