Editing .MDB entries for path changes

[Guest]

I have a dedicated MP3 server with three 250GB drives, and about to add a fourth. Some of my folders will be shifting across drives - the extremely vague information about moving files from within MM doesn't give me warm fuzzies that I'm going to be able to do this cleanly and safely.

I would prefer to have a "view" that is sorted by path (all of my database entries are stored as UNC paths instead of mapped drive letters - this makes it apparently impossible to use the MM way anyway) where I can select a range of database records, right click, select an option to "change location", and a popup entry window appears. I would then type in the beginning portion of the UNC path that the moved folders are now located at, and then MM would change the same length information in each marked database record. I've done this same thing in applications I've written, and it works fine.

This feature is extremely important to me, as I've marked a LOT of entries with my ratings, and don't want to go through that time consuming process again.

Thank you,
Scott
sdaughtry@yahoo.com

[Peke]

Try this
1. Move some of files manualy so that file timestamp and date are the same.
2. Select manualy Moved songs and Use 'file/locate moved ...' to find them.

I think it will work that way, and you'll be sure that they are in right place. BTW one sugestion if you wanna be sure 100% do not move lots of files at time (I tested with around 1000 MP3s at time).

[b0b0b0b]

Here's a possible way.

a) add a new row to the medias table describing the new drive
b) write sql to update the idmedia in the mdb tables for the songs you are moving. Tables appear to be: songs and playlists
c) actually move those files

sql I suppose would look like:

UPDATE SONGS s SET s.IDMedia=## WHERE SongPath LIKE ':\Somedirectory\Somesubdirectory\%'