database problems

[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 ?

[rpmzzz]

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

[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.