Lightroom: Ability to edit the local path/destination for published services

  • 2
  • Idea
  • Updated 5 years ago
  • (Edited)
I have an issue with Windows whereby I replaced a USB drive with an SSD where my photos are located. The issue is windows will not boot if I change the drive letter of the SSD to match what was being used by the old USB drive. So I had to allocate a different drive letter. I can fix everything in my LR 5 catalog with the exception of hard drive published services, which seem to be permanently linked to the old drive letter.

There are way too many to set up again manually so I'm wondering if there is any way to get this changed in SQLite. If so could someone give me a step by step as I'm clueless when it comes to SQL and have never used SQLite? Or is it possible to send the catalog to Lightroom support where they could do it? I just need to change all hard drive published services to use hard drive letter P instead of V.
Photo of John Rigby

John Rigby

  • 3 Posts
  • 2 Reply Likes

Posted 5 years ago

  • 2
Photo of Rob Cole

Rob Cole

  • 4831 Posts
  • 379 Reply Likes
Dunno if there is a way without hacking the catalog, but I use SQLiteSpy for poking around in the catalog, but there are other client apps you may prefer - that's the place to start me-thinks.

Is it the drive in the Export Location - Folder you want to change? or what..
Photo of John Rigby

John Rigby

  • 3 Posts
  • 2 Reply Likes
Yes it's the drive letter in the export location.

Here's a thread explaining why I can't use the same drive letter as before:
http://www.sevenforums.com/hardware-d...

I wouldn't have a clue how to 'poke around in the catalog' as I'm just not that savvy with databases, sql etc. so I'll wait in hope of some expert help who could do it for me or give me a step by step.

Thanks for your reply.
Photo of Rob Cole

Rob Cole

  • 4831 Posts
  • 379 Reply Likes
Step by step (for poking, not for fixing).
1. Get SQLite client app.
2. Close Lightroom.
3. Make copy of catalog file (the one with .lrcat at the end) to work on.
4. Open SQLite client app.
5. Open copy of catalog file.
6. Double-click the various tables and inspect contents.

If you can find the places that need to change, I'll change 'em for ya (or post SQL scripts and instructions for you to do it yourself).

Rob
Photo of John Rigby

John Rigby

  • 3 Posts
  • 2 Reply Likes
Thanks for offering Rob but yesterday I gave up and decide to manually recreate the publish settings. It wasn't too bad in the end. Hopefully Adobe will make a change in a future release because it's pretty silly being tied to a specific drive letter. You should just be able to update the location of the publish setting like you can for a folder.
Photo of Jeffrey Tranberry

Jeffrey Tranberry, Sr. Product Manager, Digital Imaging

  • 14049 Posts
  • 1735 Reply Likes
Yeah. There isn't a good way to do this. (They had the same suggestion of recreate the publish settings)

The hack way really isn't a safe bet.

If there isn't already a topic on this site to be able to change/modify the local path to publish service, we can turn this into a feature request for the engineering team to consider.
Photo of Jim Wilde

Jim Wilde, Champion

  • 269 Posts
  • 82 Reply Likes
Agreed. I've gradually been converting my hard drive publish services to use Jeffrey Friedl's Collection Publisher, which DOES allow the destination folder to be changed.
Photo of Jeffrey Tranberry

Jeffrey Tranberry, Sr. Product Manager, Digital Imaging

  • 14049 Posts
  • 1735 Reply Likes
OK. I'll mark it as feature request. Let me know if anyone finds an existing dupe I can merge with.
Photo of Jeffrey Tranberry

Jeffrey Tranberry, Sr. Product Manager, Digital Imaging

  • 14049 Posts
  • 1735 Reply Likes
Add a vote if you want this.