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 December 20th, 2010, 09:08 AM
gd123 gd123 is offline
Registered User
 
Join Date: May 2006
Posts: 155
Latest Video Hoster Version

Can this version update the KMA Header from an edited Songs.MDB?

Something similar to what hoster 2.12 used to be able to do as listed in the "UPGRADE NOTIFICATION" section as:
Quote:
Added Update KMA File Headers Command - This Tools menu command takes the Songs Database Songs and Artists fields and writes them to the .kma file associated to each record. Once this is done, running the Build Songs Database Command will display the corrected names.
Reply With Quote
  #2  
Old December 20th, 2010, 12:09 PM
ddouglass ddouglass is offline
Super Moderator
 
Join Date: Nov 2004
Location: Ace, TX (5 miles past Nowhere)
Posts: 9,395
Re: Latest Video Hoster Version

I am not quite sure what you are asking about since that version was before I started working with Hoster.
It is not recommended for you to edit the Songs.mdb except through Hoster's Edit Songs utility. This does edit both the database and the KMA file if you make a change to Singers, Artist or any other field.
__________________
Dale Douglass
2nd Generation Karaoke
I am not a member of the MTU Staff.
Reply With Quote
  #3  
Old December 20th, 2010, 02:22 PM
gd123 gd123 is offline
Registered User
 
Join Date: May 2006
Posts: 155
Re: Latest Video Hoster Version

I want to make mass edits...not one at a time.

Editing the the Songs.MDB, whether recommended or not, is the way to do this with ease and en mase. Once the Songs.MDB is edited, Hoster should have the ability to update the KMA header based on what is listed in the Songs.MDB.

This is what a prior version of Hoster was able to do.

This is what I am asking if the Lastest version of Video Hoster has the ability to do.
Reply With Quote
  #4  
Old December 20th, 2010, 03:31 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,392
Re: Latest Video Hoster Version

If you edit the Songs .mdb outside of Hoster you will lose all your editing as soon as you rebuild the database. You can do mass editing from the edit dialog, first select multiple highlight the field you need to edit, example select Artist enter Elvis Presley list all Elvis Presley and change to Presley, Elvis then Apply changes. This can be done on most fields in the multiple tabs except for DiscID. book id & No S-E.
__________________
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 December 20th, 2010, 03:58 PM
gd123 gd123 is offline
Registered User
 
Join Date: May 2006
Posts: 155
Re: Latest Video Hoster Version

So, you are suggesting I update, one at a time...4000 missing artists? The Artist fields are named with Genre...i.e. POP, BALLAD, etc. We are not talking about a simple edit like transposing a Proper Name...as in your example. I have a Artist/Title list that I can copy into an AccessDB in a microsecond. I just need a way to update the KMAs based on that update.

If I have to edit one at a time, I may as well fix the file before importing. It would take the same amount of time.

I got it to work...but, the resulting file got updated as a CDCDG verses a HDBIN, which caused the KMAs not to PLAY. I went into the Songs.mdb and renamed from CDCDG to HDBIN and they played OK.

Not wanting to have to rename the column after a DB rebuild, I tried using Songverter to take the resulting KMAs back to BIN, which, when converted back, maintains the Artist and Title info, and then, simply re-import as a BIN completing the cycle to a clean and backward convertible KMA.

But, Songverter could not convert back to BIN or MP3+G. It only converted back to WMA+G. Upon viewing the CDG with EDITCDG, the CDG file was corrupt. Trying to use a WMA to MP3 converter stated that the WMA was a protected audio file. So, Songverter didn't help. Obviously, the older version of Hoster is doing more than just updating ARTIST and TITLE info.

I'll keep testing with this old version. I've got a few more ideas to try.

Thanks
Reply With Quote
  #6  
Old December 20th, 2010, 07:27 PM
ddouglass ddouglass is offline
Super Moderator
 
Join Date: Nov 2004
Location: Ace, TX (5 miles past Nowhere)
Posts: 9,395
Re: Latest Video Hoster Version

Quote:
Originally Posted by gd123 View Post
Not wanting to have to rename the column after a DB rebuild, I tried using Songverter to take the resulting KMAs back to BIN, which, when converted back, maintains the Artist and Title info, and then, simply re-import as a BIN completing the cycle to a clean and backward convertible KMA.

But, Songverter could not convert back to BIN or MP3+G. It only converted back to WMA+G. Upon viewing the CDG with EDITCDG, the CDG file was corrupt. Trying to use a WMA to MP3 converter stated that the WMA was a protected audio file. So, Songverter didn't help. Obviously, the older version of Hoster is doing more than just updating ARTIST and TITLE info.

Thanks
What version of Songverter are you using? Songverter for several versions now has been able to convert KMA files to BIN, MP3+G, and many more formats.

Also, whether the song is listed as CDCDG or HDBIN should have no effect since when either of those are imported they are converted to compressed WMA+G in a KMA file.
__________________
Dale Douglass
2nd Generation Karaoke
I am not a member of the MTU Staff.
Reply With Quote
  #7  
Old December 20th, 2010, 05:29 PM
admin admin is offline
Administrator
 
Join Date: Oct 2000
Location: Raleigh, NC, USA
Posts: 10,515
Re: Latest Video Hoster Version

Quote:
Originally Posted by gd123 View Post
Can this version update the KMA Header from an edited Songs.MDB?

Something similar to what hoster 2.12 used to be able to do as listed in the "UPGRADE NOTIFICATION" section as:
No Norm, we didn't bring that function forward for our reasons.

The Edit Songs dialog Multiple View does allow modifying more than one song at a time, if you modify one field at a time, and select only the songs to update this field in their header. Try the demo.

What made you want to upgrade?
__________________
Making Karaoke the best it can be!
http://www.mtu.com/
Reply With Quote
  #8  
Old December 20th, 2010, 05:34 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,392
Re: Latest Video Hoster Version

The .MDB Database is built from the headers not the other way round. You can't change the header information by editing in Access.

Which version of Hoster do you currently have ?

If these are hard drive files you may find it quicker to reimport them choosing the correct field order this would be the best option.
If they are CD's then it will be a slow process but probably better in the end.
__________________
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
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 08:13 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.