Merge question

[TTowntenor]

I have a dilemma. I recently bought a bunch of new discs & ripped them at home to copy to my show computer. When I got them to the show computer I rebuilt the database & it came up with several duplicate book id numbers. Since the book id is worthless to me, I merged the database...to my understanding this will change the book id's that are duplicates....correct? Well I did the merge, when I tried to bring up the new discs by song name, the song name came up in my search, but when I added it to the playlist, an entirely different song came up. So I started checking other titles that I recently added, same thing, the right song title comes up in the search, but the wrong title comes up in the playlist. So I note the book id of the song I want to play & the song that came up & they are the same? I thought it was supposed to change the id to a new number?

[mindonstrike]

Merge will change duplicate book id (when diskids are different), but it will not merge duplicate diskids.

Sam

[TTowntenor]

Guess i'm not understanding that. It will change a duplicate book id but not merge into the database?
What i'm saying is it didn't change the book id number, but merged it into the database with the same book id number as one that was already there. So I now have say 2 songs that I can actively search with 1 book id, they will both come up as each title but if I click the ones that I want, it will bring up the original.

Example in the attachment...well actually the problem of one of the discs I am talking about. The KAR006 disc is the new one. It comes up in the search, but had the same book id as the Star Disc. Now when I rebuilt the database, it didn't add the new disc to the database, but gave me the duplicate book id message & logged it. So I did the merge command as it is supposed to change that book id to a useable number, instead it just added the disc to the database with the same book id number instead of changing it.
It did this with several other discs I just got as well. I know it's my bad for using a separate computer to import with, but I figured it would work out anyway if the duplicate book id would be renumbered instead of just adding it to the database & not being able to use it anyway.

[mindonstrike]

Now I see what you are saying, and it's definately not doing what it should.

What version of Hoster are you running? I think this was an issue when "merge" first came out, but not since, and that was a long time ago.

If you've got 3.321 you can add KMA's to the playlist via the mp3g tab at the top of the playlist. It might be interesting to see if they work properly when added this way.

If you've got Access from Microsoft you can change the book id's, it's a little complicated but it can be done.

Sam

[TTowntenor]

I have 3.316 on my show computer & 3.321 on my home computer. This also happened here at home as well when I tried to merge so it isn't an older version issue.
I tried adding via the mp3g tab & I could add it this way & it played. But this isn't how I would prefer. So does the merge not work properly or is it really supposed to change the book id into a useable number if it is a duplicate of a already used number?

[mindonstrike]

It is supposed to change the bookid in your situation. As to why it's not working properly I don't know. I'll try and recreate it on my computer and see if it's a problem for me as well.

[mindonstrike]

Using 3.317 which is what i've got on my laptop. I created a kma with an existing bookid with different brand and diskid and merged it into the database. Hoster renumbered it to the next available bookid as it is supposed to.
Still not sure why it's not working for you

Sam

[TTowntenor]

Yeah I just tried again. Rebuilt the database, then merged the duplicates. When I rebuilt it took all duplicates out, then I merged & it brought them all back in again with the same numbers as before.

[gd123]

Uhh...maybe he doesn't REALLY have duplicate BookID.

[admin]

Ttowntenor, you are understanding how Merge is supposed to work.

"While merging, if a BookID is found that already exists in the Songs Database, the BookID stored in the KMA file being merged is renumbered to the lowest free BookID available."

I've not heard this problem before. Thus, my first inclination is to suggest your reinstall Hoster from scratch by doing a REMOVE then Installing again. I would use 3.321 as it is the latest release.

I'm interested to hear what you find after installing. If the problem persists, we would need to get 4 files from you; 2 pairs of duplicate BookID's to dissect and see what the Headers contain. That is the source of what we use in the Merge.

[ddouglass]

TTowntenor, check the properties of those with duplicate IDs and make sure they are not set to "Read Only". If you copied these files from another computer on to this one Windows may have set them to Read Only which would prevent Hoster from changing the header info.

[TTowntenor]

Originally Posted by admin

Ttowntenor, you are understanding how Merge is supposed to work.

"While merging, if a BookID is found that already exists in the Songs Database, the BookID stored in the KMA file being merged is renumbered to the lowest free BookID available."

I've not heard this problem before. Thus, my first inclination is to suggest your reinstall Hoster from scratch by doing a REMOVE then Installing again. I would use 3.321 as it is the latest release.

I'm interested to hear what you find after installing. If the problem persists, we would need to get 4 files from you; 2 pairs of duplicate BookID's to dissect and see what the Headers contain. That is the source of what we use in the Merge.

Well like I said I do have 3.321 on my home computer & it was a fresh install, removed when updated. I will try again.

[TTowntenor]

Originally Posted by ddouglass

TTowntenor, check the properties of those with duplicate IDs and make sure they are not set to "Read Only". If you copied these files from another computer on to this one Windows may have set them to Read Only which would prevent Hoster from changing the header info.

None of the duplicates are marked read only.

[Lonman]

I ran into this problem today as well. You need me to send 2 sets of the duplicate BookID to you?

[swany]

I merge files a lot, and don't run into this problem. I do make up a sub file and merge from that so all the pc has to deal with is subfiles with say 50 songs in it. I make up the sub file with kma's in it, place the sub file in the songs folder. Go to tools, open the sub file and merge from there. When I have just a couple of tracks I copy them as bin files to my USB drive, copy to a temp file on the hard drive and import from there. Delete the temp after.

[Lonman]

Maybe that was my problem, I just moved all the files into one folder & merged from there, do they need to be individual sub folders?

[mindonstrike]

Originally Posted by Lonman

Maybe that was my problem, I just moved all the files into one folder & merged from there, do they need to be individual sub folders?

They merge faster if they are in there own folder, but if you've got to many merge folders floating around they can start to get unmanageable. Generally I put them all in one merge folder where they get merged over and over every month, and then once a year or so I dump them all in the main folder and rebuild.
The short answere to your question is; no, they don't have to be in subfolders.

Sam

[Lonman]

Yeah I don't know I upgraded my sholw computer to the latest update & tried to do a merge & none of the same bookid's came up. I had a huge log of the same bookid's so I guess I will be doing alot of reimporting to make things right again.

[swany]

Make up new slips without a line for numbers. Ask for title and artist only. No numbers less problems. I've been numberless on my books for a while. Don't even pay attention to em anymore.

Then if you have dupes you can find them in edit, and make em go bye bye. another one is a virtual book and just read it over while in edit.

[mindonstrike]

Originally Posted by Lonman

Yeah I don't know I upgraded my sholw computer to the latest update & tried to do a merge & none of the same bookid's came up. I had a huge log of the same bookid's so I guess I will be doing alot of reimporting to make things right again.

Change the bookids in Access and then bring up the new numbers in the Hoster edit screen, click apply and they will now be permanant (won't change back when you rebuild).

Sam