[GNC] - File Path for associated files

[John Ralls]

LibreOffice is a word processor with its own XML features. It very likely didn’t preserve GnuCash’s XML but instead substituted its own. Try again using a plain text editor like vi, vim, emacs, etc.

Regards,
John Ralls


> On Sep 12, 2018, at 4:42 AM, John Sears via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> Hi ,
> 
> My file doesn't seem to be compressed.  I managed to open it up directly in LibreOffice Word and do the replacement. and then save the file as a .xml.  ( over 9000 pages !)
> 
> I don't seem to be able to open this XML file in GNC..  I get the "No suitable backend was found for /media/john/USB DISK/trialgnucash2.gnucash."
> 
> Any ideas?
> 
> I'm sorry if these are such newbie quesions :(
> 
> Thanks John
> 
> GNC 2.6.19
> 
> 
> On 12/09/2018 11:49, Adrien Monteleone wrote:
>> Perhaps someone else who’s come across this might offer some tips, but here’s how I’d approach it:
>> 
>> Your data file (if using the default backend) is just an XML file that is compressed.
>> 
>> Uncompress it (with tar) and use either your favorite text editor or sed command to conduct a find&replace.
>> 
>> If you’re using one of the SQL backends, you can run an UPDATE command to replace the given text. (research this command well for your particular backend before proceeding)
>> 
>> You only need to replace the “G:/documents” or whatever you used part of the file path, not the actual pdf file name. If the bulk of the path is the same as before, just say mounted on /media instead of G:/ then you only need to replace “G:” with “/media” (the slash left over after “:” will continue the path)
>> 
>> In any case, I’d work on a copy of your data file and then check it out to make sure everything is fine. Then perhaps store the non-modified copy as an extra backup just in case you find a problem down the road.
>> 
>> Don’t forget to change your default path in GnuCash preferences.
>> 
>> Regards,
>> Adrien
>> 
>>> On Sep 11, 2018, at 7:00 PM, John Sears via gnucash-user <gnucash-user at gnucash.org> wrote:
>>> 
>>> When using the associate files function  for a transaction within
>>> GNUCash on Windows, I stored all of my pdfs on an  external USB/ SD
>>> card. Windows  mapped this address  with a letter, G, in this case.  ( I
>>> also store my accounts on this same card now)
>>> 
>>> So my files were all stored on G:/documents/xxx.pdf
>>> 
>>> Now that I have transferred to Linux, this path is not recognised - "
>>> GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf"
>>> 
>>> Is there a way to bulk edit the paths of all the  links so that Linux
>>> will recognise  the SD path?  I would prefer not to go  into every
>>> single transaction to do this, as I have a lot of linked files.
>>> 
>>> Or is there someway ( and this might be more of a Linux question) to map
>>> the SD card to the "file:///G" terminology.
>>> 
>>> Thanks!
>>> 
>>> 
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at 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 at 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 at 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.