GnuCash import difficulty and interim solution

Jack ostroffjh at users.sourceforge.net
Sat Jan 6 23:36:16 GMT 2024


Can you open the file in a text editor and confirm that it meets the  
criteria Thomas listed, specifically that the string "<gnc-v" followed  
by one or more digits" occurs within the first 70 bytes of the file?

On 2024.01.06 17:29, Jonathan Kimmitt via KMyMoney-devel wrote:
> I see no dialogue box. My gnucash XML file is uncompressed. My file  
> is chosen from a pop up window so it must exist. I can try the Linux  
> version another time to see if there are terminal messages. However  
> my GnuCash is v5.4 and the documentation says that the importer was  
> designed for v2.x
> 
> Sent from my iPhone
> 
> > On 6 Jan 2024, at 21:40, Thomas Baumgart via KMyMoney-devel  
> <kmymoney-devel at kde.org> wrote:
> >
> > On Samstag, 6. Januar 2024 18:24:47 CET Jack via KMyMoney-devel  
> wrote:
> >
> >>> On 1/6/24 12:17, Jonathan Kimmitt wrote:
> >>> Yes, it is present and has version GNC Importer Version  
> 5.1.3-33a66be8a. Under OSX it’s in KMyMoney preferences instead of  
> Setting
> >>>
> >>> It’s probably something stupid like an account or payee name with  
> an & in is represented unadorned in the XML whereas KMyMoney requires  
> &
> >> That is certainly possible, but I'll have to look into the code to  
> see
> >> what exactly triggers that particular error message.  If you are  
> right,
> >> then we would want to find a utility that checks XML files for  
> proper
> >> encoding/markup (I can't think of the exact term right now.)
> >
> > Encoding and structure are the two important things. xmllint would  
> be the tool to use.
> >
> > I scanned the GNC plugin's open() call real quick. Here is what it  
> checks:
> >
> > - file is not a database (e.g. SQL, SQLite, ...)
> > - file is on local drive (url starts with file://)
> > - file is readable
> > - if file is gzip compressed (first two bytes are "\037\213") it  
> re-opens it
> >  for decompression
> > - first bytes in file are not "SQ"
> > - the first 70 bytes of the file must contain the regex  
> "<gnc-v(\\d+)"
> >
> > In case all that is true, a dialog is shown. This contains a switch
> > to turn on debug messages which are printed to the console (in case
> > KMyMoney was started via terminal) while the file is parsed. Now I  
> have
> > two questions: Does the dialog is shown? Do these debug messages  
> provide
> > any hint or details why the import fails?
> >
> > Thomas
> >
> >
> >
> >
> >>>> On 6 Jan 2024, at 17:10, Jack via KMyMoney-devel  
> <kmymoney-devel at kde.org> wrote:
> >>>>
> >>>> On 1/6/24 11:40, Jonathan Kimmitt via KMyMoney-devel wrote:
> >>>>> Hi Jack,
> >>>>>   I am using Apple M1 macOS 14.2.1 (23C71), with GnuCash  
> Version: 5.4 Build ID: 5.4+(2023-09-23) and KMyMoney Version  
> 5.1.3-33a66be8a
> >>>>>
> >>>>> The converter was written with OCaml 5.0.0 but I would not  
> expect any lack of portability for the XML handling.
> >>>>>
> >>>>> The error when trying to open the GnuCash XML  in the GUI was:
> >>>>> Could not read your data source. Please check the KMyMoney  
> settings that the necessary plugin is enabled.
> >>>>>
> >>>>> Based on what Mark was saying, it sounds like the failure is  
> something quite trivial, however I lack the knowledge to debug it.
> >>>>>
> >>>>> Regards,
> >>>>> Jonathan
> >>>> I'll have to do some digging, but the first step would be to  
> assure the file can be read.  If it is on a local drive and you can  
> look at it in a text editor, then that's OK.  The next step would be  
> to assure that the guncash importer is present and enabled.  Go to  
> Setting/Configure KMyMoney... select Plugins on the left side, and  
> see if GNC Importer is present on the right.  If it's there, then we  
> do have an interesting problem.  If it is NOT present, then we need  
> to figure out why not.  I just confirmed it IS present in the  
> Appimage versions, but I don't know about the macOS version.
> >>
> >>
> >
> > --
> >
> > Regards
> >
> > Thomas Baumgart
> >
> > -------------------------------------------------------------
> > Ilde servers are the devil's work -- robbyoconnor on #irc
> > -------------------------------------------------------------
> 



More information about the KMyMoney-devel mailing list