Page 1 of 1

Relocate Multiple Paths

Posted: Mon Jan 01, 2024 9:38 pm
by st11x
Hi,

I learnt that I could use the relocate path feature should a folder change outside of the application.

In my Catalog dialog, I have these directories all hanging off the same parent.

Image

If H:\Library was moved to D:\Library, do I have to go change each and every one of the paths? Is there a more convenient way to do this?

I opened up the DB file and saw that there is a Folders table with all the paths in it. Can I just bulk "relocate" with a SQL?

Also, what does the Delete option do? Does it remove the selected path and all assets that are tagged with categories?

thanks
Matt

Re: Relocate Multiple Paths

Posted: Mon Jan 08, 2024 7:14 am
by xnview
st11x wrote: Mon Jan 01, 2024 9:38 pm I opened up the DB file and saw that there is a Folders table with all the paths in it. Can I just bulk "relocate" with a SQL?
yes you can change paths in Folders table with SQL request

Re: Relocate Multiple Paths

Posted: Mon Jan 08, 2024 4:00 pm
by st11x
Got it. I suppose when it comes to that, we have to do it via SQL as the UI treat each directory separate even if it's a parent and child.

I selected an entry and clicked on the Delete All to test what it will do, but selected No in the dialog that pops up. It still deleted quite a number of entries (in this case, all of the "C:\*" entries except one. I couldn't figure out the pattern.

Image

My intention was to cancel but I selected "No" by mistake. I made backups so no worries.

thanks
Matt