Skip navigation
sea-monkey
Currently Being Moderated

Reconnect with changed off-line media path

May 17, 2012 3:37 AM

Hi.  I've had my catalogued images on a network drive for several years.  Recently had a major failure and re-built the drive, re-loaded from backup etc. 

 

Unfortunately, since the overall requirements for the drive had changed over the years, when re-building I didn't re-create exactly the same folder tree as before.  While all my images are there (30,000+) and in the same relative tree as when they were catalogued, they are one level higher in the overall tree.  As a result, the catalog (PSE7) doesn't marry up with the path to the folders and Organizer displays a red 'off-line' media icon for every single image.  (None of the images is marked as needing to be re-connected since Organizer thinks the problem is the media being off-line rather than it being on-line but with a different path.)

 

With this many images, re-cataloguing the images isn't a realistic option.  What can I do to get Organizer to recognise the drive is not off-line media and that the images are all there but on a different path ?

 

Thanks for any help.

 
Replies
  • Currently Being Moderated
    May 17, 2012 8:52 AM   in reply to sea-monkey

    What did you do to "re-build" the drive?

     

    Ken

     
    |
    Mark as:
  • Currently Being Moderated
    May 17, 2012 1:49 PM   in reply to sea-monkey

    Oh boy, that could be a tough one.  Offhand, all I can think of is to directly modify the database with a 3rd party SQL query tool.  See if this discussion seems to apply to your situation:

    http://forums.adobe.com/message/3649698#3649698

     

    As always, should you or any of your Impossible Mission data become damaged, the Secretary will disavow any knowlege of your actions.  Good luck!

     

    Ken

     
    |
    Mark as:
  • Currently Being Moderated
    May 17, 2012 3:41 PM   in reply to sea-monkey

    The PSE Organizer (at least version 8 and earlier) doesn't properly handle reconnecting files on network drives.  But there is a trick to force it to reconnect; see method 4 of the following FAQ:

     

    http://www.johnrellis.com/psedbtool/photoshop-elements-faq.htm#_Quickl y_reconnecting_large

     

    But before using that method, I highly recommend that you restore the original file paths of your photos on the new NAS.  After you've successfully reconnected, you can then safely reorganize your folder tree using the Organizer commands.

     

    While you can edit the catalog database file directly using database tools such as "sqlite3" (and some programmers will find that straightforward), I definitely don't recommend it.  Such methods often end up taking much more time than you think.

     

    The "psedbtool" utility will give you an overview of what's currently going on with your catalog:

     

    http://www.johnrellis.com/psedbtool/

     

    But it won't make any changes to your catalog.

     
    |
    Mark as:
  • Currently Being Moderated
    May 17, 2012 5:16 PM   in reply to sea-monkey

    sea-monkey wrote:

     

    (1) that my catalog is PSE7 rather than PSE9.  Would you expect this procedure to work similarly for PSE7 as for PSE9 ?

    I honestly don't know for sure -- I've only examined the tables and done this with a PSE9(10) database.  However, I expect that it's likely to also work with PSE7.  You'll have to first make a copy of your catalog database file (using Windows Explorer) and test it on the copy.

     

     

    sea-monkey wrote:

     

    Is the path stored as a column of simple string data per image in the db ?

    Not exactly.  It is stored as a string in different formats in two columns in the media_table table.  This is a sample of the three columns in that table that describe the fully qualified path of an image:

    /Pics/Misc/cabin_done.psd     /pics/misc/     cabin_done.psd

     

    I wouldn't recommend altering those values, although it is tempting, because it would be very tedious (and prone to typo errors).  If the original SQL query in my link works for you, count your blessings and let the Organizer do all the reconnection work.

     

    Ken

     
    |
    Mark as:
  • Currently Being Moderated
    May 18, 2012 7:16 AM   in reply to sea-monkey

    sea-monkey wrote:

     

    I was getting stack overflows causing psedbtool to crash at first.  Appeared to get rid of them by dismounting drives from my PC - is there a limit on the number of connected drives it will support ?

    I hadn't received any previous reports about too many connected drives, and I don't have ideas what might be going wrong there.  Unfortunately, I don't support "psedbtool" any more, having moved to Adobe Lightroom two years ago.  LR isn't perfect, but its Library does seem to be actively supported by Adobe, unlike the Organizer.

     
    |
    Mark as:
  • Currently Being Moderated
    May 18, 2012 10:26 AM   in reply to sea-monkey

    The "junk" will accumulate primarily because files have been removed from the catalog (using the Organizer, of course) -- when an application tells SQLite to "delete" an entry from the database, that entry is not removed, only marked by the database as "not available".  So, over time, a lot of dead wood accumulates.  What the "Optimize" function in PSE's Catalog Manager does is physically delete those entries from the database file, resulting in not only a smaller file but also less stuff to wade through when the database is searching for an entry (when you use Organizer to search for a tag, e.g.).

     

    That dead wood doesn't accumulate in "enterprise-class" databases like MS SQL Server, because the database engine periodically purges the database as part of its automatic maintenance processes.  That's one reason I have this fond dream that at some time in the future PSE (and Lightroom) will switch to MS SQL Server Express, which uses the same database engine as the "big" SQL Server.

     

    Ken

     
    |
    Mark as:
  • Currently Being Moderated
    May 19, 2012 3:59 PM   in reply to sea-monkey

    Glad to hear you're up and running.

     

    I think the advantage of running a SQL query would be that all media files will have their volume info updated instantly.  Then, the Organizer can be started on reconnecting all files.  Just a thought for future reference....

     

    Ken

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points