database problems

[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

It probably would not accept the "A" because the disk id in the file name was contradictory. I think if you set the drop down to "ignore" instead of "disk id" it would accept it

[rpmzzz]

It is a superCDG and has to be converted back to mp3+g first you cannot import direct from the disk.

[rpmzzz]

I guess, but I don't want it to ignore the disc ID because I like the option of searching just by disc ID for THM2005, for one because it is printed in a different book that I made after I got the original disc and it goes by a number that came with the DVD, if that is the only option.

[MTUSUPPORT]

Ok,
From what it sounds like you have created 5 folders with 99 files in each. From what I can tell, since you are importing the files all under the Same Brand and Disc ID is that you have Imported 444 files as 4 sets of 99. I am guessing that you now have 5 sets of 99 files with the same BookId's. So this is why you are only seeing 99 files.

If you had imported these files with different DiscId's you would now have run into this.

To fix what you have done, take one set of the 99 files in .kma format and copy these to a folder such as \songs.

Then take the other files and copy them to another folder named something such as Songs\New.

Now go into Hoster and build the Songs Database for the \songs folder ONLY.

Once you have done this, go to the Tools Menu\Merge KMA Files. Now set the Song Source Folder on this dialog, at the top, to your \Songs\New folder to merge those other .kma files into the database. Now click the Merge into Songs Database button. This should now re-assign the BookId's for these songs to ones that are not used.

Now once this is finished, see if you can see all your files in Hoster.

[ddouglass]

Originally Posted by rpmzzz

THM2005-0001 - Pat Green - Don't break my heart again.cdg.

They revert back to THM2005 because it is part of the name. So yes you will have to rename them. Additionally the track numbers can't be any more than 2 digits, hence the 99 limit. Are all of your files converted from SCDGs?

Originally Posted by rpmzzz

And then there is a matching mp3 file. These are from my THM SuperCDG that I converted to MP3+G files.

Someone else may need to verify this but I believe that those need to be zipped in order to import correctly. Otherwise you may get music with no lyrics.

Originally Posted by rpmzzz

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.

The reason they are out of order is because of windows sort priority. When they are importing the leading zeros get dropped.

Originally Posted by rpmzzz

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.

The 99 "rule" as you call it happens to be the way the database was set up to allow for 2 digits/spaces in the database record for the track number. Remember that SCDGs with 1000+ songs can't be imported directly. CDs can't store more than 99 songs, so MTU set it up to only use 2 digits.

Originally Posted by rpmzzz

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.

The program doesn't read from the folder and since the rebuild drops to the 99 limit, then all you will be able to see and use in Hoster will be those 99.

To over come those limitations you will need to rename those files to make them import in groups of 99. I know this is a pain but for now that is the only way I can see it working.

[rpmzzz]

Did what you said bryan and it just shows the last kma's that I merged and that is it. Once again they are there in both the song folder and the program search, and they work until I merge or build database. Once I do that I have to clear databases and reimport to get them to show and work. Does anyone know of a program out there that will find and replace in a folder like the word processor function so that I could rename each file as THM2005-1 for the first 99 and then THM2005-2 for the second set etc, then it should work I guess. Too bad you couldn't go to a three digit instead of two to allow these types of discs as a lot of people have them. Kind of discouraging as I put in all the work to change the names so they didn't have things like T.N.T in the title or feat. in the title therefore and would then import.

[ddouglass]

I think it has been suggested in New Requests, but not implimented yet. Maybe MTU will hear our cry. I too have a couple SCDGs that I am going to convert, so I can get some of the songs off of them that we haven't been able to find in CDG.

[rpmzzz]

Well for those of you that care. I eventually broke down after no other way and individually changed the names of the files from THM2005-0001 to THM2005-01-0001 changing the middle number for each batch of 99. Alot of work for 442 files, couldn't find a program that would do a search and replace so did it one at a time. Thanks for trying to help.

[MTUSUPPORT]

There are some batch converting programs out there. Here is one that I have used in the past, found it under Google:http://www.publicspace.net/windows/BetterFileRename/

Here is the Search from Google: http://www.google.com/search?sourcei...+file+renaming

[rpmzzz]

I will give that a try when I purchase the THM for 2006, and convert it.