[GNC] Fwd: Relative paths in transaction associations

[D]

Justin,

Probably, your best bet is to dig in to the data file directly and change the entries there. 

NOTE: editing your data file directly can be risky. Always work on a backup copy!!!

How you go about this depends on the way you have your data stored (XML, database). 

XML is straight text, although by default it's compressed (change the setting in preferences to store it without compression), so a find and replace in a text editor would suffice.

The db backend will require digging around for the table in question, and developing an appropriate SQL command.

Oh. Did I mention that you should do this on a backup? You should.

David

On February 16, 2019, at 12:44 AM, Justin Haynes <justin at justinhaynes.com> wrote:

OK everything worked as expected, and I can switch between disparate
machines and still have access to associations!

So I only have one remaining question:Where should I look in the data file
or in the code or documentation to discover how to programmatically or
using a text editor change all the absolute paths in my current
associations to relative ones?

Thanks!,

Justin



On Feb 13, 2019, at 11:18 AM, Justin Haynes <justin at justinhaynes.com> wrote:

OK, so I can see that with a populated "Path head for Transaction
Association Files", that linking transactions to files after this is
populated, results in the "Relative" field being checked next to the
corresponding entry in the "All Transaction Associations" window, and an
absolute path in the window.  When I have my other laptop, I can experiment
to see if changing the Path head configured in GNUCash on that laptop will
result in GNUCash on that machine finding the files associated when I click
on Open Associated File/Location from the corresponding Transaction.

Second Question: if my experiment works, and GNUCash behaves the way I
would like, how can I go back and change the links to all previously
created transaction associations to be relative links to the same files?

Thanks,

Justin

On Wed, Feb 13, 2019 at 10:46 AM Justin Haynes <justin at justinhaynes.com>
wrote:

> Found it.
>
> Edit -> Preferences -> General -> Path head for Transaction Association
> Files.
>
> Now i just need to experiment with it to see how it behaves.
>
> On Wed, Feb 13, 2019 at 10:43 AM Justin Haynes <justin at justinhaynes.com>
> wrote:
>
>> What provision is there for relative paths in transaction associations?
>> I often associate transactions with files where the files are almost always
>> receipts.  This results in a URL to an absolute path which appears in the
>> Tools -> Transaction Associations dialog.  Also from a transaction I can
>> access the file I linked to with Transaction -> Open Associated
>> File/Location.  The file opens in whatever program is associated for that
>> file type.
>>
>> I would rather have relative paths which resolve with relation to an
>> absolute base path I can figure.  This would allow me to move from system
>> to system and only change the absolute path on the target system's GNUCash
>> instance.  I then only use one instance at a time on the same files of
>> course.  These files exist on local machines but sync with a cloud service
>> so that the file is available wherever I'd like it to be.
>>
>> Tools -> Transaction Associations brings up the "All Transaction
>> Associations" window, where I see columns for the Date, Description,
>> Association (URL link to the resource, either local (file:// with link to
>> absolute path) or remote).  There is then an "Available?" column populated
>> with "Unknown" in each row, and a column called "Relative" with no data.
>>
>> Since there is  "Relative" field, I assumed there must be some proviision
>> for this.
>>
>> Thanks,
>>
>> Justin
>>
>>
>>
>
_______________________________________________
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.