I’ll check it out. Thanks. > On Jan 7, 2023, at 17:54, Jean L <[email protected]> wrote: > > Also, this > > https://github.com/jrwrigh/csv2cash <https://github.com/jrwrigh/csv2cash> > Could be the answer to what you're trying to do? > > Jean > > On 1/7/2023 12:51 PM, Tim Rohrer wrote: >> >> >>> On Jan 7, 2023, at 2:32 PM, Jean L <[email protected]> >>> <mailto:[email protected]> 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! >> >> Tim >> >>> Jean >>> >>> On 1/7/2023 10:59 AM, Tim Rohrer wrote: >>>> Correct. And the errors and warnings I pasted earlier are logged. >>>> >>>> Linux GnuCash 4.11 >>>> Build ID: 4.11+(2022-06-25) >>>> >>>>> On Jan 7, 2023, at 12:53 PM, Jean L <[email protected]> >>>>> <mailto:[email protected]> 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:OFXSGML <> >>>>>> ENCODING: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 <[email protected]> >>>>>>> <mailto:[email protected]> wrote: >>>>>>> >>>>>>> >>>>>>> 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 >>>>>>>> <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 >>>>>>>> [email protected] <mailto:[email protected]> >>>>>>>> To update your subscription preferences or to unsubscribe: >>>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>>>>> <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 >>>>>>> [email protected] <mailto:[email protected]> >>>>>>> To update your subscription preferences or to unsubscribe: >>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>>>> <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 [email protected] 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.
