Auto Generate PayloadXML for Tv Channels

[jitterjames]

It would be great if James could add the option to build the file automatically reading the data from TVServer's database file 

Maybe if you send me your tv server database I can whip something up. 

[jitterjames]

I'm thinking of buying one of the following mics:

http://www.amazon.com/gp/product/B001TGTDFM/ref=ox_sc_act_title_2?ie=UTF8&m=ATVPDKIKX0DER
http://www.amazon.com/CAD-U7-Desktop-Condenser-Recording/dp/B001AIQGTK/ref=pd_sim_MI_17

My favorite is the first one but, including shipping and taxes, it costs 100€ ($128) so I'm not sure to spend so much money in something that I don't know how well will it works.

If you look in the microphone section of this forum, I think at least one user posted a review of a desktop conference microphone that was on amazon.com

I don't know about those mics but I think it would make more sense to look for something local.  I'm sure Kalle knows of some mail order places in Europe that sell microphones.  I don't know if that would be cheaper or not...

[Kalle]

If you look in the microphone section of this forum, I think at least one user posted a review of a desktop conference microphone that was on amazon.com

I don't know about those mics but I think it would make more sense to look for something local.  I'm sure Kalle knows of some mail order places in Europe that sell microphones.  I don't know if that would be cheaper or not...

I have to disappoint you, unfortunately, not available in Europe. 

[alexdepalma]

Maybe if you send me your tv server database I can whip something up.  

I send you mine  

By the way, I've been trying different channels combinations and althout the system recognized the channel calls properly, nothing happens. I've tried with wifiremote ver 0.6.0 and your modified wifi file (based on vers 0.5.0 as shown in dll version).
As you can see in my setting, I've different channel groups and also different tv cards so may be the problem of is related to that.

I send you a copy of my data base and also an xml file exported channels list, groups... form tv server

Im using mediaportal 1.2.2 and StreamMP skin. I also use eventghost to control Onkyo AMP and domotics.

Thaks again
Alex

[jitterjames]

the database file appears to be empty  ,

... and the xml file is not attached.

[bodiroga]

I have to disappoint you, unfortunately, not available in Europe. 

Yeah, Kalle is right, it's very difficult to buy this kind of mics here in Europe (and in Spain is even worst, I can't find anything in amazon.es or ebay.es )

I suppose that at the end I will buy the MXL AC404 and see how it works, let's hope that I don't get disappointed.

James, MP TVServer uses a MySQL database to store the recordings, channels, schedulings,... so I don't know which files you need for this. In my folder "C:\ProgramData\MySQL\MySQL Server 5.1\data\mptvdb" I have lots of files with .frm, .MYD and .MYI, for example: channel.*, channelgroup.*, history.*, program.*, recording.*, schedule.*,... Do you have any experience with this complex databases? For now I can't send you more details, but in a couple of weeks and can offer you a TeamViewer session ;-) It would be soooo could to do searches in EPG, set recordings, play recordings... with VoxCommando!

Many thanks for all your work (seriously, the support that you offer is AWESOME) and best regards,

Aitor

PS: Sorry Alex, the truth is that my configuration for channel changes is not tested because I'm away from home for the exams   I will see if it works for me next week, although I'm sure that you will be able to solve it faster. What level of confidences do you get with you mic?

[jitterjames]

I haven't tested it myself but I would not be surprised if this was just as good:  http://www.logitech.com/webcam-communications/microphones/devices/221

although probably not good for too long a distance.  Get a usb extension cable and mount it on the ceiling over your recliner 

[alexdepalma]

the database file appears to be empty  ,

... and the xml file is not attached.

Problems transfering the files to VC server.. they are now...
XML export file is how online

As bodiroga has mentioned a lot of files are there...

[jitterjames]

perfect.  from this xml I can create a payloadXML file with all the channel names mapped to the correct channel number.

I don't think there is anything else I can do with it though.

Is this something that changes often?  If I understand correctly you need to export this by hand first.  I hope it's not too difficult.  I am able to read sqlite files no problem but don't know about mysql

[jitterjames]

Many thanks for all your work (seriously, the support that you offer is AWESOME) and best regards,
 

Thanks, I do my best.  It is wonderful to be appreciated. 

[Kalle]

Yeah, Kalle is right, it's very difficult to buy this kind of mics here in Europe (and in Spain is even worst, I can't find anything in amazon.es or ebay.es )

I suppose that at the end I will buy the MXL AC404 and see how it works, let's hope that I don't get disappointed.

James, MP TVServer uses a MySQL database to store the recordings, channels, schedulings,... so I don't know which files you need for this. In my folder "C:\ProgramData\MySQL\MySQL Server 5.1\data\mptvdb" I have lots of files with .frm, .MYD and .MYI, for example: channel.*, channelgroup.*, history.*, program.*, recording.*, schedule.*,... Do you have any experience with this complex databases? For now I can't send you more details, but in a couple of weeks and can offer you a TeamViewer session ;-) It would be soooo could to do searches in EPG, set recordings, play recordings... with VoxCommando!

Many thanks for all your work (seriously, the support that you offer is AWESOME) and best regards,

Aitor

PS: Sorry Alex, the truth is that my configuration for channel changes is not tested because I'm away from home for the exams   I will see if it works for me next week, although I'm sure that you will be able to solve it faster. What level of confidences do you get with you mic?

by the way, I think a "boundary" mic works fine in a quite environment. If you have backround noises (like music or movie playing) it pick this all up and you get fail to talk with VC, but I hope the MXL works fine for you, let us know.
I have make some tests with other mic, and the best results is: 1.Place -> amulet-remote, ASUS Wireless Headset HS1000W and RF Audiobox (all the same very good results) 2.Place: iPhone4/iPad2 with Mobilia software or Skype 3.Place: Samson GoMic "open Air" good results in a quiet environment. 4. Place: JabraHalo2 Bluetooth (does not always work satisfactorily)

Kalle

[alexdepalma]

perfect.  from this xml I can create a payloadXML file with all the channel names mapped to the correct channel number.

I don't think there is anything else I can do with it though.

Is this something that changes often?  If I understand correctly you need to export this by hand first.  I hope it's not too difficult.  I am able to read sqlite files no problem but don't know about mysql

Yes, obtain this file is easy.
In TVServer config, you have to acces the Import/Export option. And click Export button and give a name...

[bodiroga]

I haven't tested it myself but I would not be surprised if this was just as good:  http://www.logitech.com/webcam-communications/microphones/devices/221

As good as the MXL AC404 or as Alex's webcam?

I have seen that I can buy the Logitech mic for 12€ (shipping included) in ebay, so perhaps it's a better idea to try it first and see what results I get.

For the boundary mics problems, my idea is to use the VC.Prefix.Start event to lower the system and receiver volume when I'm away from my remote (listening to music with TV off, for example) and also configure a button in my harmony remote to mute the system volumen and switch VC to green mode when I'm in from of my TV. It shouldn't work so bad, right?

[Kalle]

As good as the MXL AC404 or as Alex's webcam?

I have seen that I can buy the Logitech mic for 12€ (shipping included) in ebay, so perhaps it's a better idea to try it first and see what results I get.

For the boundary mics problems, my idea is to use the VC.Prefix.Start event to lower the system and receiver volume when I'm away from my remote (listening to music with TV off, for example) and also configure a button in my harmony remote to mute the system volumen and switch VC to green mode when I'm in from of my TV. It shouldn't work so bad, right?

the problem is -> in a loud environment, VC do not understand the prefix or you cry it very loud 

[jitterjames]

As good as the MXL AC404 or as Alex's webcam?

I have seen that I can buy the Logitech mic for 12€ (shipping included) in ebay, so perhaps it's a better idea to try it first and see what results I get.

For the boundary mics problems, my idea is to use the VC.Prefix.Start event to lower the system and receiver volume when I'm away from my remote (listening to music with TV off, for example) and also configure a button in my harmony remote to mute the system volumen and switch VC to green mode when I'm in from of my TV. It shouldn't work so bad, right?

I don't own any of these mics so I'm just guessing, but the reviews on this logitech mic are very good on Newegg.com and it is pretty inexpensive.  Keep in mind that most of  these people are not reviewing it in the context of speech recognition.  And as I said, the range is probably not as good as with a boundary mic, on the other hand, it is probably less likely to pick up background noise.  The boundary  / conference microphones are designed to pick up sound from greater distances, and also from every direction, which is basically the opposite of noise cancellation.  I would not be surprised, with the correct positioning, if the logitech performed much better than a boundary mic.  But if you want to be able to speak from anywhere in the room, the logitech will probably not work well.  This is all based on my research, and my experience with microphones in general, not on any experience with these specific models.  I do not even own a boundary mic, but I have done lots of reading.