Current Position:Home > How can I delete ALL of the offline files in the catalog?

How can I delete ALL of the offline files in the catalog?

Update:10-11Source: network consolidation
Advertisement
I have Photoshop Elements 10, and a catalog with over 60,000 items in it.
About 10,000 of those items were on an external drive ("E: Drive"). The E drive crashed, and all of those files are now on a different external drive, the F drive.
On the E drive, they were in a very disorganized folder structure with hundreds of sub-folders. I think the easiest thing to do will be do just dump all the catalog entries related to the E drive and re-catalog them from the F drive, with a better structure.
However, the only way I can see to do this is to manually delete EACH of the hundreds of subfolders.
Any ideas for me?
Thanks!
Mary Miller

The Best Answer

Advertisement
If you're willing to directly modify the database, this procedure can be used to change all instances of your E: drive to your F: drive.  The images will show in Organizer as "disconnected", but at least you can use "Reconnect all missing files" and point the reconnection process to the root folder of your F: drive.  Or, you can use the Thumbnail View to select all the "disconnected" files and delete them from the catalog (but not from disk).
The fastest way is to directly change the values in the catalog.pse10db database. The database is a SQL Lite database, so if you know (or know someone who knows) how to run SQL queries against a database, you're in luck because Adobe did an excellent job of designing a highly normalized database schema.
I highly recommend first trying this on a copy of your database. In general, the procedure goes like this:
Run a SQL query against the volume_table table to see a listing of all the rows.
Note the values of the "id" column for your "E:" volume and the "F:" volume.
Run a SQL query against the media_table table to update the value of the volume_id column, replacing all instances of the "E:" id number with the id number of your "F:" drive. The SQL query will look something like this:
Update media_table
set volume_id = "<your new value>"
where volume_id = "<your old value>"
I use the free Database.Net SQL tool:
http://www.fishcodelib.com/Database.htm
which is simple to install -- just extract the executable file.
Good luck!
Ken
  • How can I delete ALL of the offline files in the catalog? Update:10-11

    I have Photoshop Elements 10, and a catalog with over 60,000 items in it. About 10,000 of those items were on an external drive ("E: Drive"). The E drive crashed, and all of those files are now on a different external drive, the F drive. On the

  • How to delete all offline file references in a catalog? Update:11-30

    I backed up and restored my entire photo archive to a new computer.  I've never used offline files, but somehow I now have hundreds (if not thousands) of offline file icons, right next to the exact same file date and time, except the images are now n

  • Recover Deleted Offline File in Window's 7 Update:10-11

    Documents that were suppose to sync with the server had not synced in months. The filess I am sure were being saved to the offline file cache. The offline file cache was deleted by using microsoft hotfix 50561 (kb230738), reinitalizing the cache and

  • Possible to delete Offline Files content for a specific user from the Client Side Cache (CSC) ?. Update:10-11

    Hello Everyone, We would like to implement a script to delete the offline files in the Client Side Cache (CSC) for a nominated user (on Windows 7 x64 enterprise). I am aware that; 1. We can use a registry value to flush the entire CNC cache (for all

  • Privacy settings data - is it safe to delete saved passwords and offline website data? Update:11-30

    As above. Privacy > settings > data - is it safe to delete saved passwords and offline website data? Or can this permanently delete my passwords and I won't be able to access the websites again?By deleting passwords, you permanently remove them. But

  • How do I delete the synced offline files from my iPhone? Update:11-30

    Hey people! I just unchecked "offline" for all my playlists on my iPhone to free up some memory. However the usage of the Spotify-App is still shown with 1GB. Is there any way to get rid of the cached songs besides reinstalling the app? Regards,

  • Keep Reading List Item - Delete Offline Files Update:11-30

    Is there a way to delete your offline files from your reading list, without having to remove the item from the list itself? In case you want to look something back up at a later time, like when you're trying to remember something you know that you re

  • Offline Files sync gives Access Denied on Windows 8.1 Enterprise Update:10-11

    A small number of our staff have now been issued with Windows 8.1 Enterprise hybrid tablet computers, however there is a problem with using Offline Files on them - when synchronising, it responds "Access Denied". The tablets have Windows 8.1 Ent

  • How to Move Offline Files Cache in Windows 7? Update:10-11

    I'm using the offline files feature in Win7 (much better implementation, btw - kudos!) and I've run into a problem:  the CSC is using up all the drive space on C:\.  I'd like to move the CSC to D:\, however I've been unable to do so. I've seen this p

  • Offline Files (Background) Sync makes File Explorer and other programs responding slow Update:10-11

    Hi TechNet, I have a problem with Offline Files and especially with VPN users. For VPN users, the slow-link policy is activated with a background sync interval of one hour. But, when Offline Files is syncing, their File Explorer is hanging (not respo