Merging Media Manager Databases

Tim Stannard wrote on 1/21/2008, 2:12 PM
Is it possible?

I'm frequently deleting whole tags in my MM databases. I have one where I add the acid 8 packs every week (I never use them, but collect & catalog them just in case).
When I add them I get a new tag (eg "Scan" + date & time. Having tagged these properly, I'll highlight the "Scan" tag and delete it. Now SOMETIMES the highlight seems to jump to another tag - I've no idea why -and unless I'm watching very carefully I'll end up deleting the wrong tag (there's not even an "Are you sure?" check.). Once done there's no way back.

Is it just me or is MM flakey? Had this same problem in 2.2 and 2.3.

Anyway, in a nutshell, I'm often deleting whole tags in error, and I've just discovered my entitre "Electric Bass Guitar" catalog has gone. I take frequent backups so can go back then scan everything since, but it would be so much easier if I could merge the current database with the last backup.

Comments

kairosmatt wrote on 1/21/2008, 2:29 PM
When you get the MM database the way you want it, highlight everything and right click, then click "save tags and properties to file(s)"

Now when you add these to another MM database, these tags come with them and set themselves up automatically.

I just did a test run on that workflow, and it comes in fine. However, if there is already a category of tags called "Video" and you had some saved "video" tags and sub-tags, they come under a new heading "Video (2)". So it doesn't exactly merge the two, but you get all your tags back.
Tim Stannard wrote on 1/22/2008, 11:40 PM
Thanks for that. WIll play....
kairosmatt wrote on 1/23/2008, 5:12 AM
Also you can copy and paste tags between databases. It would be awfully tedious (copy tag, open new database, paste tag, back to old database) though. Unless you had two instances of Vegas opened, each with a different database open.

kairosmatt
Tim Stannard wrote on 1/23/2008, 7:40 AM
Thanks for your suggestions, but unless I'm doing something wrong, it's not helping.

I did as you suggested, opened my "backup" database which has loads of entries under the tag "Electric Bass Guitar" (itself grouped under "Bass" and highlighted all 7000 odd names (in the middle section of MM) right clicked and selected Save Tags and Properties to file(s). Now this happened extremely quickly (a quick "saving" flashed up less than a second) which suggests to me that something might not be quite right here.

Then
Method 1
Opened my "current" database which has "Bass" but not "Electric Bass Guitar"
Dragged a folder containing some files tagged as "Electric Bass Guitar" into the current database.
It imported them but no imported "Electric Bass Guitar" tag. Presumably because the files have already been catalogued in the database.
(I tested this with another test database with only a few entries and confirmed that this is what happens)

Method 2
Yes, you can copy the tags, but it doesn't result in the files being tagged (ie it has the same effect as simply re-adding the tag)

I'm sure there must be some way of merging databases and I'm missing something
kairosmatt wrote on 1/23/2008, 12:51 PM
Tim,
When I select Save Tags and Properties to Files, it usually takes quite a while-and I only have about 1500 files-not 7000! But maybe its because I've tagged a bunch of HD-as opposed to audio files? I wouldn't think that would make any difference as you're just saving tag info, but...

I just tested it again, and when I import files, it brings in the tags with it.

I guess the problem is the media is already in the database. When you open the "Add files to Media Library", in the advanced box under "When adding files, update media library information for" try click on "all files". Then have it scan your folder where the "Electric Bass Guitar" files are. I'm not sure, but maybe this will force the library to update those files...good luck!
Tim Stannard wrote on 1/23/2008, 2:22 PM
I really thought you'd hit the nail on the head with the "update all files" option and was severely chastising myself having got it to work exactly as you said.
Once.
On a sample of a dozen samples.
Then tried it with the whole lot. No go. Not even the tag duplicated.
Then again with another dozen.
Still no go.

Think I'm going to uninstall, delete all the media files and start from scratch. But I'm not sure I can bring myself to trust MM anymore. Which is a shame as I know how much some of you swear by it (whereas I seem to just swear AT it)

I spent hours (over a number of days) tagging all these samples only six months ago. Am rather upset.
kairosmatt wrote on 1/23/2008, 7:03 PM
Tim,
I'm sorry I can't come up with anything else. Its weird that idea worked once, but then never again.
There is a guy who does the VASST MM training video (I used it and liked) named John Rofrano, so I sent him in an email to see if he had any ideas.
Its too bad you (and others in this forum) are having such problems with MM, because when it works, its really cool.
kairosmatt
JohnnyRoy wrote on 1/24/2008, 4:12 AM
> There is a guy who does the VASST MM training video (I used it and liked) named John Rofrano, so I sent him in an email to see if he had any ideas.

Matt, Thanks for sending the email. I saw your answer to the original post and it was exactly what I would have said so I passed on the thread thinking things were well under control. ;-)

> Now this happened extremely quickly (a quick "saving" flashed up less than a second) which suggests to me that something might not be quite right here.

Tim, Matt is correct that this should take a while. What might be happening is that when you copy loops off of a read-only CD the read-only bit stays ON while on your hard drive. This would prevent the Media Manager from saving the tags with the media.

Here is something to try. Open a command prompt at the root of your ACID loop libraries on your hard drive. Then issue the following DOS command:

ATTRIB -R *.* /S

This will run the attribute program (ATTRIB.EXE) and remove the read-only bit (-R) from all files (*.*) in all subdirectories (/S). If this is the problem, this will clear it up.

> It imported them but no imported "Electric Bass Guitar" tag. Presumably because the files have already been catalogued in the database.

I think you're on to something there. My recommendation would be to start a 3rd database and merge the two into it. This way you can be sure that the media is only added and tagged once. So the steps would be:

1) Open the first database
2) Select all files and Save tags with media
3) Open the second database
4) Select all files and Save tags with media
5) Create a NEW database and import all of the media

This is the cleanest way. Now one problem might be that the database you have now has already tagged data incorrectly from the original one. For this reason, I would do one of two things: Either remove all of the data from the database that is tagged incorrectly before you save tags with the media, OR save the tags from the bad database first, then save the tags from the old (good) database that you like. This way the last tags saved are the "good" tags!

Good Luck,

~jr
Tim Stannard wrote on 1/24/2008, 2:14 PM
Guys, I'm really appreciative of your help. Without it I'd have abandoned MM by now.
I've been experimenting for a couple of hours this evening and making some (albeit little) progress.
I did exactly as you suggested Johnny - I though the "read only" flag was a very good suggestion (and another classic oversight by me). Unfortunately none of the files I examined had that set but I ran the attrib command anyway.
Still no joy though. Funny thing is it works for some files, not for others.
So I took one specific media file and watched it through the system. Very carefully did everything. No go. Tried again to be sure. Nada.
Tried it on another file, one that had worked. Removed it, added it again, added to a new database. All worked fine every time.

The difference? When saving the tags and properties to the file, on the "good" one the %bar goes very quickly from 0 to 100 and the dialog closes. On the "bad" file, it goes quickly from 0% to, well, 0%

So, we can conclude for now that the problem is definitely with the saving of the tags. For the life of me I can't see anything different in the files. Will investigate further over the weekend with copies of files, different folders etc (I'm out tomorrow night - at my video club) and report back.

Thanks for encouraging me to keep on the case.
kairosmatt wrote on 1/25/2008, 3:48 AM
Tim,
I just noticed something: some of my files are DVCProHD. The ones that are converted to Raylight AVI can save the tags, the ones not converted (I use the Raylight plugin to edit natively) cannot save the tags.
Maybe there are certain file types that MM is just unable to save the tags too? Is there any difference between the files that do work, and the ones that don't? Or to put another way: are they the same type of wav (or other) file?
kairosmatt
Tim Stannard wrote on 1/27/2008, 3:57 AM
I've discovered what I think is the cause. The "bad" files - those I can't save the tags with, appear to have tags (in the properties) which don't exist in the tag tree
I have no idea how this situation has occurred - clearly the database has become corrupt somehow.

I've tried creating a tag in the tree with the same name, adding that file to the tag (the tag appears twice in the file's properties) and deleting it, but no go.

Unless anyone has any suggestions for clearing up this corruption, I guess I'm back to square one.