MTU.Community


Go Back   MTU.Community > Hoster Software > Hoster Help

Hoster Help Post Hoster questions, tips and suggestions here.

Reply
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2016, 12:41 PM
bendrew bendrew is offline
Registered User
 
Join Date: Jan 2003
Posts: 99
Rebuilding database with new bookid

My bood id on my song database is on a five digit number now and I would like to bring it back to lower digits so that it's easy to search by bood id. Is there a way to rebuild the song database getting a lower book id. (from xxxxx to xx) automatically. Thanks..
Reply With Quote
  #2  
Old September 23rd, 2016, 05:13 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,391
Re: Rebuilding database with new bookid

There's no automatic way to do that to the best of my knowledge.

Are you referring to Importing tracks from CD or individual downloads ?

Depending which version you are running you can tag new songs onto an existing Disc Id in the import Hard drive files dialog up to a total of 99 tracks per Disc ID.
But you can't do that with CD importing.

I ask which version you are using because older versions would overwrite the existing tracks unless you rename the files with a track # higher than the last track already allocated to the disc Id.
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
Reply With Quote
  #3  
Old September 23rd, 2016, 05:34 PM
bendrew bendrew is offline
Registered User
 
Join Date: Jan 2003
Posts: 99
Re: Rebuilding database with new bookid

I'm using v5.41.04 and my real intention is to let hoster rebuild the songs database assigning new available lower nos. I don't know if this is a good idea to uninstall and re-install hoster,then rebuild the database when hoster open. Just a suggestion if it will do it. I can use songverter to convert the song to a zip file and then start all over with hoster but this will be a painstaking job for 120,000 songs..
Reply With Quote
  #4  
Old September 23rd, 2016, 06:19 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,391
Re: Rebuilding database with new bookid

Uninstalling and re Installing doesn't change anything because the data is in the kma and kmh headers.
Rebuilding the database doesn't renumber discs unless it finds duplicated Book or Disc Id's.

What format are they imported as KMA or KMH ?

With KMA the book and Disc Id is held in the KMA envelope, you can't change that without deleting it and re Importing it and that will only be possible if you have the original source or you convert them to zip as you suggested.

If they are KMH types you would have to delete all the KMH files along with the small text file that is in each folder with the source files but keep the source files.
Then re import them all.

I've no idea if that would re build them for you with the lower book id you desire. A lot of it depends if you import them with their original Disc ids or ignore that.

With imported CDs they normally have only 10 to 20 tracks per Disc and Book Id so that uses up a lot of Book Id's.
If you just import them direct from Hard drive but ignore Disc ID data then you can get 99 tracks per Book Id.
In theory that way you would be able to get 98,000 tracks using only a 3 figure route book id.

I think it would involve a lot of work.
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
Reply With Quote
  #5  
Old September 23rd, 2016, 06:43 PM
bendrew bendrew is offline
Registered User
 
Join Date: Jan 2003
Posts: 99
Re: Rebuilding database with new bookid

I have kma's for cdg and kmh for vcd...Anyway, thanks for your help Roy.I just leave it the way it was. I thought it would be possible and easy...
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On


All times are GMT -4. The time now is 10:09 AM.


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.