I wrote a REXX program (Perl would also work) to do text processing on a QIF file, creating a new QIF file.
The Quicken QIF transaction: ^ D1/ 7'16 T75.60 CX Pdr. miller Mfjt cleaning L[fjt-tex-check]/fjt:160107 gets turned into: ^ D1/ 7'16 T75.60 CX Pdr. miller Mfjt cleaning L[fjt-tex-check] S[fjt-tex-check] Efjt cleaning $75.60 S#:fjt:160107 $0 I used it on one Quicken account (with lots of different Classes) and then imported that into Gnucash into an existing account. This is the same set of transactions as was imported a year ago with an older version of Gnucash when I first started using Gnucash. The dummy splits were added to the existing transactions. Also, the Memo field got imported to the real split. On Wed, Apr 27, 2022 at 8:42 PM David T. <sunfis...@yahoo.com> wrote: > That's an interesting idea. I can't imagine it would involve too much-- > swapping the slash with a line feed and the appropriate account strings. I > don't recall the QIF format that exactly, though, to be sure. > > David > > On April 27, 2022 9:56:29 PM EDT, Fred Tydeman <tydeman.f...@gmail.com> > wrote: >> >> Has someone written a program to transform a *.QIF file into another *.QIF >> file with >> the Quicken class data (the text after the '/' in the Cat field) into dummy >> split transactions >> with the class data as the account on dummy split? >> Since a gnucash transaction can have multiple splits, that is a way to tag >> a transaction with many tags/classes. >> And, since the tag/class data is gnucash accounts, they can be a hierarchy. >> >> On Wed, Apr 27, 2022 at 5:09 PM Fred Tydeman <tydeman.f...@gmail.com> wrote: >> >> Thank you. Comment 6 with the dummy accounts added as $0 splits seems >>> good enough for my needs. >>> >>> On Wed, Apr 27, 2022 at 2:44 PM flywire <flywi...@gmail.com> wrote: >>> >>> https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html >>>> is part of a discussion on classes. >>>> >>>> >>> ------------------------------ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> ------------------------------ >> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
