MTU.Community

MTU.Community (http://forum.mtu.com/index.php)
-   Hoster Help (http://forum.mtu.com/forumdisplay.php?f=71)
-   -   Whats the best way to build a data base when you have different file types (http://forum.mtu.com/showthread.php?t=12210)

Ernieaquino July 30th, 2010 09:22 PM

Whats the best way to build a data base when you have different file types
 
I have a folder that contains only KMA files from all of the cd+g cds I imported. I also have a very large folder that has only MP3+G's and I have a 3rd folder that has quite a few MP3 Zipped songs. I want to combine all songs in one database for Hoster to play. So here's the question What would be the best way to bulid a database so that I don't lose any songs because of bookid overlapping? I'm guessing start with the KMA because thier book id is already set from what i understand. So how should I go about importing the rest? what order would you recommend? I don't mind if hoster blocks out the duplicates as long as they are true duplicates and not other songs.

ddouglass July 31st, 2010 11:17 AM

Re: Whats the best way to build a data base when you have different file types
 
Quote:

Originally Posted by Ernieaquino (Post 101971)
I have a folder that contains only KMA files from all of the cd+g cds I imported. I also have a very large folder that has only MP3+G's and I have a 3rd folder that has quite a few MP3 Zipped songs. I want to combine all songs in one database for Hoster to play. So here's the question What would be the best way to bulid a database so that I don't lose any songs because of bookid overlapping? I'm guessing start with the KMA because thier book id is already set from what i understand. So how should I go about importing the rest? what order would you recommend? I don't mind if hoster blocks out the duplicates as long as they are true duplicates and not other songs.

I am not quite sure what exactly you are asking. If you already have your CDG's imported (sounds like it) then they should already be in the database. Then all you need to do is import the MP3+G and ZIP files. Hoster will not allow duplicate BookIDs. Order doesn't make any difference.Hoster will only block a duplicate if the DiskIDs are in the title of the MP3+G or ZIP and it is a duplicate of one already imported.
If you have an older version of Hoster then importing those file types will create a KMA file in the same folder with your CDG imports. If you have the latest (4.22) then Hoster will create a 256 byte KMH file in the same folder as the original MP3+G or ZIP file without changing the original. These too would be added to the database at that time.

Ernieaquino July 31st, 2010 03:40 PM

Re: Whats the best way to build a data base when you have different file types
 
Thanks Dale for your comments. yes your correct! I don't have to import the kma files and i tried importing the mpe+g's and they all import perfectly however when i imported the mp3-zipped and then i did a song seach, the songs that were from that zipped folder put the manufactures name, the disc #, trk #, lastname,firstname and then song title all in the song name section and it seemed to default all songs as if they were from the "Legends" ! but they do all play just fine. I used the "easy" method of importing. I'm guessing im gonna have to do it over again but use the "advance" method but it 's a little confusing so do you have any advice on how i should go about reinporting them base i was I found? all other songs are just fine.

ddouglass July 31st, 2010 03:55 PM

Re: Whats the best way to build a data base when you have different file types
 
Easy method does put all the information in the Title block, so yes you need to use the Advanced and set the order for the items.
Don't forget to delete the ones you did with the easy method through the Edit Tool.
Because it basically ignores what was in the filename in the Easy method, then it chose one brand. With the Advanced it should read the DiskID and determine from that the brand.


All times are GMT -4. The time now is 11:01 PM.

Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2025, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.