Re: Hoster 5.02.7 Songs Not Showing up in Search
 

Searching through the database you sent I see one file that seems to be confusing Hoster because of the format for the name.
It is in C:\Karaoke Music\2010\November. Filename is SBI-23252 - Glee Cast - Don't Rain on my Parade.zip
Hoster is taking this as DiskID= SBI and Track= 23252 of disk number 1896. From that point it is using 1896232 and above as the disk number part of the BookID incrementing from that point. This seems to be the reason why you suddenly have such large BookIDs. If you change this filename to SBI23252 (no dash) then add a -01 after that then your BookIDs will not jump up to such a large number.
If you found one duplicate BookID I am sure there are more. You say you don't have any kind of error log file in C:\MTU\Hoster and I don't know why it wouldn't be there if you have duplicates. The only way I could see duplicates even coming up is if when you started over importing that you did not delete all the old KMH files in all the folders.
You did say there is another program on this computer you can use. I would have them use it for now and wait until the next time you can get the computer back to work on this.
There is a big difference in the way Version 5 handles the importing/indexing of files as opposed to how version 4 handled them, but that doesn't mean it is a software bug.
Using 20/20 hindsight since all of these files had been imported in a previous version, then all you needed to do was to Rebuild the database after adding the main folder using the Add Folder/Sub-Folder button. Since the kmh files and database are in the state they are in right now then that won't be possible, because of the duplicate BookIDs and the messed up numbers. We will figure this out and get it working right for you so don't give up on Hoster yet.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

Something I didn't notice: The Mel05 files all had the same track number except for one. Mel05-01 - XXX - XXXXX.zip.

Additionally, there were some files that didn't have any artist or track because they were the vocal tracks and when imported didn't get an artist or track.

What I see has happened is Hoster is getting confused and creating these wild book IDs after trying to import the same file more than once, then certain files are either ignored or imported in this high range of book IDs.

Some of them show in the data base, some don't.

I've relabeled the Mel05's and am reimporting the WHOLE data base from scratch.

When I fixed and tried rebuilding, I got a realistic number, but the database didn't reflect what Hoster was saying. Hoster said it found 25721 tracks and that is closer to the 25737 that are there, but like I said, when I looked at the songs database, it was less than 25000.

When I'm done I'll have some notes for installing hoster in replacement of other software, some quirks I notice to save people from getting frustrated.

Thanks again for your help, I'll report back what happens after this import, in 3 hours or so.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

Thanks, got it before hoster did. Relabeled that one too.

It's funny that hoster would do this wild jumping, and yes, no duplicates listed in any error. Strangely, the duplicates have a index.txt file saying they were imported... weird.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

This may be where the problem is coming into this and Hoster may need some corrections/filters to stop this kind of wild numbering. I will be talking to Admin on Tuesday as he is unavailable this weekend. I really hope you don't drop this as I think we can work through it and stop this stuff from happening again for someone else.
Do you have a computer that you could set up Hoster 5.02 on and copy all his files over to it so we can continue working on this during the week? You should be able to use the second copy of his license to do this if it hasn't been used.
I am almost to the point of making a trip up to where you are as we are not that far apart. I am about 75 miles north of Houston. :g:e

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

The bar has a main PC and a laptop that they use as a backup in case one system goes down (happened once). I've installed Hoster on the main PC and I think I installed it on the laptop, but I could get the laptop when I drop off the PC today and remove the license.

I was planning on making a copy of the music to fix here then copy it back to the HDD of the PC and the Backup Laptop, that way all the files are the same.

I don't know if they are willing to pay me to fix the files, but there are a lot that need fixing just for the Artist/Title switch.

I'm still importing and will report back.

A couple of other things that I noticed, Hoster will kick out files that have a tilde over a letter, like Buble vs Bublẽ. The later will get kicked out.

Also, if you have an extra space before the dash as in SC8000-01 - Artist - Title, after the 01 are two spaces, this gets kicked out

Also, if you are copying files and accidentally copy a zip folder into another zip file, this file will get kicked out (found several of those).

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

It will get skipped if the import file screen isn't set up exactly for this format. If your other files are setup without the two spaces & your import screen is setup for those, then anything else that you are trying to import is not going to be imported - this sounds like the entire issue that you are encountering. You would not get a bad import report for these files because they were not being imported.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

Sounds like you are heading in the right direction. My guess is this has gone on for a while and files they thought were imported were just not there. It is going to take a while to do all of that but should be well worth it to them.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

So far, all the IDs are in a proper range. I've seen some files importing tracks that weren't there. For example, they only imported one track off a CD, however, on the importHDD it shows multiple tracks being imported. I'll have to verify this after the import.

I will say though that I think you are right about adding some filtration ability in hoster, even my personal files are not 100%, but hoster should catch the occasional error and either kick it out or notify you of the error.

Going smoothly, about another hour and I'll have a final count.

And to Lonman, I already dealt with those files, they weren't the issue, just part of a problem.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

Here's the update:

Hoster reported "NEW" songs imported as 255704, which is off a little, but I was willing to accept that as an issue with a few files maybe not viable.

When I open the database in access I see that Hoster has imported 24,960 which, so far, is the most that it has imported.

I'm currently making a copy of the files onto a external HDD for further dissection to see if there is anything more I can do to correct the files (assuming they are in error despite being shown as imported while I watched for 3 hours).

I'll get the Laptop Computer and work on the files on the Laptop since it is supposed to be the backup anyway. I'll be interested to know how many files it reports when I do the scan of the KMH files first, then a separate import.

I'm going to try and get this "running" in the show today, and indicate that some files (over 700) may not be available and have them make a list, this will help me look at specific files.

I know already that "teenage dream" shows 6 copies in the other software, but in hoster, only 4, one now being the Glee version which was missing because of the duplicate file number.

Thanks for dealing with my frustration, I'm disabled because of that and when things go well I'm unaffected, but when things go bad, it gets downright debilitating.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

Forgot to mention, once Hoster was done with the first scan of the 24,000 some odd songs (before I have to add the &this for the Chartbuster Tracks), it only indicated having imported 16 songs.

I deleted the songs database and the backup, also I started with NO kmh or txt files in the folders.

Later when it finished indexing the Chartbuster CBxxx-xx-01 type files, it indicated 19 tracks were added to the database, even though it went through about 1,000 tracks.

Hope this helps.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

I think I found the missing 759 files.

Under the MTU folder there is a file called: buildsongdblog.txt this log has lots of "duplicates" listed that it didn't import. Upon searching the database, I see for example there are two QH0329 folders with songs in them.

I also think that that one file without a dash segmenting the disk id from the track, was throwing things off.

I think hoster is due some better filters, and better error logs, that hoster claims only to import 19 songs, when it says 24,000 is a big scare. Hopefully this will be worked out.

Thanks Doug and Roy for your assistance. I think we can chalk this one up as resolved 80% database fault 20% software I feel in the end. Those filters will surely help in the future.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

I think I did a dumb thing, I got the laptop home and we agreed to upgrade from Vista to Windows 7, but I forgot to uninstall hoster (our second copy) off this PC, will it give the same information because the components are the same so they can reset it? Probably should ask this in a different post.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

Not sure as I have never done an upgrade from Vista to Windows 7. You may need to get the reg number from the other machine. I do know that the computer ID will not be the same because every install of Windows OS gives the computer a new ID. This means MTU won't recognize the laptop as the same computer.

Re: Hoster 5.02.7 Songs Not Showing up in Search
 

I have not read pages 2 & 3 of this thread, but I thought I would pass along something that stumped me. I would import, say, 13 MP3G pieces, and only 9 would show up in a search, yet they existed in the database. I fixed it by doing this:

I downloaded a free MP3 Tag editor called Mp3Tag. I unzipped any MP3-CDG zip files, and opened the MP3s. I found that on the problem files, Hoster would use the Title tag in building its KMH cross reference, and that would also show up in the resulting database. Because the title is what Hoster searches for, it never found these files. Typically this happened when there was SOMETHING in the mp3 tag title like this: TRACK 5 or like this: tSinger.

With an MP3 tag editor, you can type in the real name and artist, and it will then show up in searches after you rebuild your database. (Pretty easy for 100 files, but obviously this will get tedious if you have to fix 3000 of them. Whatcha gonna do, hey?) I suggest you kill the associated kmh files, just to be sure Hoster doesn't ignore it, thinking it was already correct.

This did not seem to occur when the files had no mp3 tag Title at all. So you may be having the same problem. I was surprised to see that about 20 percent of my existing library had problems like this.

It's easy to check if you get an mp3 tag editor, or simply turn on the "Title" field in Windows explorer. I strongly suspect you will see discrepancies in the mp3 title field. I also suspect this is the result of files having a "questionable history" of legality. I purchase most new music from apparently legitimate websites, but many of the files I get have this peculiar problem.