database problems

[rpmzzz]

I have a dell laptop and external drive. However, I only use hoster for 464 songs because of importing problems and these are multiplex which hoster can handle and the other programs can't. Also if someone comes in with a cdg I use hoster to import that. Here is the problem. I use the c drive of my laptop for hoster songs and database. The other 52000 songs are on my external. I had 462 of these files in the songs folder in the kma format. I deleted two songs out of my songs folder because of a problem with the import, big surprise. Because of this I did a database rebuild. I deleted the songs file and songs backup file from the database folder and then rebooted the hoster program which should automatically do the rebuild. I think I have this correct so far. When I went to the dropdown to check what was there it said only 99, however all the files are in the songs folder of the c drive where everything points to, unless I missed something. Can anyone help with this. Also is there any way to get around the import of only 99 files at a time as I have 444 of them and the range from THM2005-01 to THM2005-444. thanks for your help

[mindonstrike]

This is a bit confusing.

Are you saying that when you rebuild your database only 99 of your 464 kma's are in the database?

Or are you saying you can only import 99 tracks to diskid THM2005 ?

Or are these two separate questions comingleded in one thread?

BTW you can only get 99 tracks per rootid/diskid

Sam

[rpmzzz]

I'm saying that I have 464 files in my songs folder of the hoster folder on drive c of which 444 are THM2005 -01 to THM 2005 -444. These are in my songs folder. When I get in the program and try and search for them they are there until a rebuild. I imported them 99 at time but used the same id THM2005, and they all show up and work until I rebuild database then all but 99 of the 444 don't show up.... but are still in the songs folder. I tried deleting the songs and songs backup in the database folder and restarting to rebuild and the paths are correctly showing the right folder on c drive. This will be the third time I have had to reimport. Thanks and happy 4th

[bobcox- with the Lord]

go to tools and rebuild songs database.

[rpmzzz]

bobcox, I'm sure that you are trying to help and thanks, but rebuilding my database is what is causing the problem, it is fine until I do that. Last night I deleted the kma's and reimported. It will now be fine until I rebuild the database and then even though the kma's are there it will only show 99 in my search, or if I go to the dropdown

[mindonstrike]

Hard to say without seeing exactly what you are doing .

But one real possibility is an excessively long artist name or song title. For some reason the input fields 3.310 were shortened by a few characters and can cause the rebuild to stop prematurely.
Theoreticly it shouldn't let you import them in the first place, but you never know.

Sam

[rpmzzz]

This is step by step what I did. I took a folder of 444 mp3 +g and put it into five folders of 99 mp3+g each. I then went to import hard drive file and imported them one folder at a time. I set the brand drop down for each one as Top Hit's Monthly, and the disc ID drop down as THM2005 for all five folders. It would not let me change the disc ID to say THM2005a it would just switch back to THM2005, however they all imported and I had 444 kma's in my hoster songs folder. Actually, only 442 because two would not import. I then load hoster and they are all there, and remain there unless I use the rebuild database option. When I do this, and then I do a search using hoster or go to the dropdowns, they say there is only 00 to 99. When I look in the hoster song folder, all of the kma's are still there. if I try and play one from the songs file it plays fine. I don't understand how if my path is correct and it points to the hoster songs file that has 442 files in it when I check it, yet the dropdown and search only produce 99 files. I don't think that I can make it any clearer than that. Thanks for your help

[ddouglass]

If all of them are importing as "THM2005" then you will only see the first 99. Instead of trying to add a letter after it try THM2005-1, THM2005-2, etc.

What is an example of your MP3+G file names? This may be the problem if you don't select the right format then they won't import and create the header right either.

[rpmzzz]

I don't understand though, does that mean I have to change the id on each one of the individual files to read THM2005-1, or -2. Is the database rebuild and merge kma functions just for the songbook

[ddouglass]

Under each DiskID there is a limitation of 99 songs, as you have done by placing only 99 files in each folder. So when you import the files you need to import the first folder as THM2005-1, the second folder as THM2005-2, etc. Thus what you are creating is a series of DiskIDs like the Chartbuster Essentials.

And no the database rebuild and merge are for the database used by Hoster when you add songs to the playlist not for the songbook.

[mindonstrike]

Originally Posted by rpmzzz

This is step by step what I did. I took a folder of 444 mp3 +g and put it into five folders of 99 mp3+g each. I then went to import hard drive file and imported them one folder at a time. I set the brand drop down for each one as Top Hit's Monthly, and the disc ID drop down as THM2005 for all five folders. It would not let me change the disc ID to say THM2005a it would just switch back to THM2005, however they all imported and I had 444 kma's in my hoster songs folder. Actually, only 442 because two would not import. I then load hoster and they are all there, and remain there unless I use the rebuild database option. When I do this, and then I do a search using hoster or go to the dropdowns, they say there is only 00 to 99. When I look in the hoster song folder, all of the kma's are still there. if I try and play one from the songs file it plays fine. I don't understand how if my path is correct and it points to the hoster songs file that has 442 files in it when I check it, yet the dropdown and search only produce 99 files. I don't think that I can make it any clearer than that. Thanks for your help

I don't understand why all 444 songs are there untill the database is rebuilt since theoreticly the second set of 99 songs would overwrite the first set...etc. So that when you were done all that would be left is the last set of 99 songs you imported.

[rpmzzz]

Yeah, but just because the folder is named THM2005-1 etc, doesn't mean the files inside are named thus and will still have the id of THM2005, right. I don't get it, why the 99, what difference does it make if there is 500 with the same id. It doesn't in any other program.

[ddouglass]

When you import, the files get rewritten as KMA files and the header within the file is created. This header contains the brand name, diskid, bookid, etc. So, if when you import the group/folder of 99 files from a folder and you tell Hoster that the brand name is BLAH and the DiskID is THM2005-1, then that is recorded to each file. Then you import the next group/folder of99 with Brand name BLAH and DiskID THM2005-2.

[rpmzzz]

Man, This program is the most expensive program I have and also the most user unfriendly. I am not trying to step on any toes but I am so frustated with this program it is beyond belief. I named my folders THM2005-1 to THM2005-5. When I imported the first folder and I put my Brand as Top hits monthly and I put the disc ID as THM2005-1 it imports them but the disc ID stays as THM2005 once it starts importing, even though I changed it. If this means that I have to go in and change the name of each file to represent THM2005-01-name of file, you got to be kidding me. This is just one more in a long list of importing problems. Can Brian read this post and give me a definitive answer so I don't have to delete my database and reimport once again to try something that doesn't work. Thanks, I do appreciate everyone's answers I am just so frustrated. If I do have to change the name of each file to reflect THM2005-01-0001-name of file from THM2005-0001-name of file, is there an easy way to do this vs manually changing each file individually.

[rpmzzz]

Also, after it is imported the dropdown for track # goes from 01-09 then 100-109 then 11 then 110 to 119 then 12 etc instead of 01-444. And by user unfriendly I only mean as far as importing is concerned, I don't think anyone would deny that..... the rest of the program rocks.

[ddouglass]

Try deleting your song.mdb and the backup, then open Hoster and import again. That should clear out the DiskID. Since you don't have anything else in it should be no problem, right?

[rpmzzz]

Already did that about four or five times now to try reimporting the different ways suggested

[ddouglass]

Guess Admin and MTUSupport are going to have to jump in on this one then because I can't think of anything else to try.

How about posting one of the file names here, so we can see how it is setup?

[rpmzzz]

THM2005-0001 - Pat Green - Don't break my heart again.cdg. And then there is a matching mp3 file. These are from my THM SuperCDG that I converted to MP3+G files. As I said I get them to import they are converted succefully to kma's and show up in my songs file. If I start Hoster and look they are there they show up under the Top Hits Monthly 2005 SuperCDG that I entered, and the Disk ID of THM2005. On the track number drop down they are listed wierd but there and I can play them. They list like 01-10 the next number is 100 to 109 then 11 then 110 to 119 then 12 then 120 to 129 13, etc... As far as I know it stays like that unless I rebuild my database. Then the track drop down goes from 00 to 99 and a search of THM2005 only shows up to 99. Do I have to individually name each file as THM2005-01-0001 and file name, if so, that sucks. I still don't understand the 99 rule, I mean the why of it. Do I need to seperate them into five different folders inside my kma folder? And thanks again to everyone for trying to help. I guess what I don't get is how the kma files can be in the folder, but the program can't see them because of some id issue, they are there even when I can't see them when in the program.

[Eric Whitehouse]

I may be a little bit thick here, but would it not be simpler and quicker to re import the original discs using Hosters extensive database. Why convert files from the hard drive if you have the original discs just re import ?