[GNC] - File Path for associated files

[John Sears]

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.