Merge or Rebuild Database?

[Skybird74]

I'm a little confused. I keep reading the Manual trying to understand the difference between merging and rebuilding. As I understand it, if you rebuild and there are duplicate IDs (don't understand how that happens), then those songs are put on a list and then you have to re-import all those songs. Is that true? If so, why would you ever want to Rebuild?

I have always used my desktop to import and make changes (fix song names, etc.) to my external hard drive and then do my Show with my laptop. However, when I want to just practice at home using my desktop, the database is very different from what I get when I use my laptop after merging these files.

So, I started making all my corrections with the laptop only to be sure that these corrections show up at my Show. Am I doing something wrong?

Just bought a new Vista laptop, so I'm wondering the correct way to transfer my songs to be sure I get everything, including any previous changes I've made. If I rebuild and there are duplicate IDs, I'm worried that they will get renumbered. I don't want to start over. I don't have the hours/days needed to re-import all those disks.

Any advice will be appreciated.

[gd123]

Desktop ---> Laptop using same External Drive

Once correcting any KMA or adding Songs via the Desktop, just copy the SONGS.MDB from your Desktop to your Laptop.

Make sure that the External Drive LETTER assigned by your Desktop is THE SAME Drive LETTER assigned by your Laptop.

If they are different, then CHANGE your Laptop's DRIVE LETTER to match what your Desktop has assigned.

If you are using a Printed Song List, where a BookID is your reference to a song, do not use the MERGE Command as that would render the Current Printed Song List useless.

[Skybird74]

Thanks for the answer. I forgot about just copying the .mdb to the other computer.

No, I don't refer to the Book I.D, so that's not the problem.

But the Manual specifically says that if you "rebuild" and it finds a duplicate I.D. that those songs will be put in a list. And, it also states that those songs may need to be "re-imported". It also suggests merging, saying that "re-building" is rarely necessary.

My concern is having to re-import songs because of the rebuilding process.

[mindonstrike]

If you fix/edit a kma on one computer and then move the corrected files to another computer just make sure they go into the same folder as the ones you are replacing and windows will overwrite the old ones. Hoster will play the new corrected kma's although the database won't show the corrections until you rebuild. If you put them in a diferent folder and try to merge (or rebuild for that matter), Hoster will list them in the duplicate diskid log and then ignore them because they are duplicates.

The ONLY time Hoster will change a bookid requires using the merge command. When using merge, when Hoster encounters a kma with a duplicate bookid (same bookid as another file with a different diskid). These are generally only possible if you import using both computers (to save time for example) and then combine the files together.
If you use just one computer to import and then transfer to the other, duplicate bookids will never occur.

But the Manual specifically says that if you "rebuild" and it finds a duplicate I.D. that those songs will be put in a list. And, it also states that those songs may need to be "re-imported". It also suggests merging, saying that "re-building" is rarely necessary.

My concern is having to re-import songs because of the rebuilding process.

Again this only an issue when you are using 2 or more computers to import a bunch of disks to combine later. If you use the same diskid for 2 different disks you'll have to reimport one of them to correct the situation because you can't use the edit screen to change a diskid.
If you are importing with 2 computers and are anal about making sure they have different diskids (using the manufacturers diskid is the safest way of doing this) this will never be an issue.

If all you are doing is adding new songs then merge is all you need. If you are fixing songs on computer A and want to use merge to add them to computer B you can delete those songs on computer B (using the edit songs screen) and then you can use merge for those as well.

Sam

[Skybird74]

WOW! Thanks for the detailed answer. I do understand more than I did. I always Imported from my desktop, put them in a New Songs Folder on my external drive. I always let Hoster assign the Book ID. I couldn't care less what ID Hoster assigns the song, as I always pick songs according to the Disk ID (i.e S.C. or CB). Then I used the "merge" command on my laptop so that the database I use at my Shows is always up-to-date. That way my "new songs" are kept so that I can print out a list of new songs for my songbooks.

However, when I first got Hoster I also did my editing on the desktop, and that information did not always show up on my Show Computer, but when I do my editing on my Show computer all the information is there. Plus while I was learning I think I tried to do things differently and not sure how that has affected my database or whether Hoster ever assigned a duplicate ID to anything. I always let Hoster assign the IDs and never pay any attention those numbers.

If I understand you correctly, if I rebuild the database that duplicate songs, if any, will NOT be lost? All I want to do is now put All my kma's on my new laptop so I don't have to.
So... when Hoster builds the new database for the first time on my new laptop, and somehow finds a duplicate ID, will everything still be there?

[ddouglass]

It doesn't delete them so if you did a rebuild and it shows duplicate IDs, the files are still there but not listed in the database. Run the merge and Hoster will change the bookid for the duplicates and add them to the database. Since you only use the discid this shouldn't give you any problems.

[mindonstrike]

If I understand you correctly, if I rebuild the database that duplicate songs, if any, will NOT be lost? All I want to do is now put All my kma's on my new laptop so I don't have to.
So... when Hoster builds the new database for the first time on my new laptop, and somehow finds a duplicate ID, will everything still be there?

Well as I read and understand what you are doing I se 2 possible courses of action (both of which will reset your new song counter):

1st, this is the way I would do it (and have a time or two) but only because I don't like my KMA's spread out in different locations:
Cut and paste all the songs fromthe "new song folders" into the "old songs folder", when windows encounters the edited kma's it will ask you want to replace the file in the folder with the one you are moving, it will tell you the name of the file and the dates they were modified, typicly the ones you are moving will be newer than the ones they will replace. Tell windows to replace the old ones. when that's done open the build database screen, you will see the "old songs" folder listed as well as any and all of the new song folders, you can delete those new song folders from the list (Hoster will automaticaly add them back the next time you use merge). Click the build database button and click OK to the backup message and let it do it's thing.

Or

This will temporarily fix your problem but it only puts it off to be fixed another day. The one good thing about this method is that since no files are being moved you can copy your songs.mdb to another location and re-use it if you don't like the results.
First, open the build database screen in Hoster, in the list of song folders make sure the main folder or original folder or old song folder (whatever it's called ) is listed last, make sure the new song folders (the ones with your edited kma's) are listed first. Hoster will build the database folder by folder in the order they are listed, until it's done, by putting the edited kma's before the older ones, Hoster will add the new ones and later ignore the duplicates.
To move a folder to the last position you just need to delete it from the list and then re-add it.

Now rebuild the database, the edited kma's will get included and the older duplicates will get logged as duplicates but otherwise ignored.

Hopefully this isn't to confusing, I made several edits because I started confusing myself.LOL

Sam