[GNC] OFX Requirements

[Tim Rohrer]

On Jan 7, 2023, at 2:32 PM, Jean L <ripngo at gmail.com> wrote:OK so I found that GC fais to import this ofx
        because the account name is too long. This is probably a bug,
        but I'm not sure what the specs are for account names in the OFX
        specifications.Nice find! Thank you. So yeah, `csv2ofx` generates those randomly. Why the author made them so long is a little unclear; maybe the same code as the autogenerated FITD?About the rest of your questions:You're right that you can't specify the "other"
        account (like expense:dining) in the OFX file. That's
        specifically a GC thing. When you import your OFX, you have to
        specify the "other" account for each transaction, but GC learns
        to automatically assign it after a little while so you no longer
        have to assign it manually.In your case it's not super helpful if you save
        *all* your migrated transactions into a single OFX then try to
        import that in one shot you'll have to specify the other account
        for each transaction, which would be super tedious.Instead, you could import only the first N
        transactions, the re-import and deals with the N next ones, etc.
        Each time you import, GC learns the association between
        transactions and splits. But that too could be tedious.Perhaps you can make it work better with the CSV
        idea. Even better would be to write a script that takes the CSV
        export, and generates the complete xml file that GC uses to
        represent your account tree. I.e., a tool to automatically
        create a GC account file from a csv export. Perhaps somebody's
        written that already?This last idea is exactly what I was starting to think about. I don't know C/C++, but I can figure out XML. And I've not done a lot of Internet searching yet for others who've worked this migration (other than in our mailing list). Again, thank you!TimJeanOn 1/7/2023 10:59 AM, Tim Rohrer wrote: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 <ripngo at 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 <ripngo at 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 at 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 at 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.