adjusting channel blast numbers

[pBS]

i setup new version [working great btw] but when i imported channels for my hdpvr, it just gave them all incremental numbers..
instead of 206 for espn i got 40...so i went and changed the db so channel table has correct channel for 'number' slot..
but it still didn't blast right!! all numbers show up correctly....
but then i noticed it uses the channel_mapping table's 'tuning' xml in <channel> to get number to blast with!! not the one you see..
apparently it's not picking up my channel numbers in the mapping process?

also, how do i alter which channel <display_name>206 ESPN</display_name> from xml it uses?
[my channels show up displaying as '206 ESPN' and i'd like to get rid of numbers and keep just name, maybe why it's not picking them up?]

my question is, is there a sql update that can copy from channel table's number field to channel_mapping's channel_source_number?
i tried with a join statement to the channel table but failed...

UPDATE CHANNEL_MAPPING AS M INNER JOIN CHANNEL AS C on M.CHANNEL_OID = C.OID SET M.CHANNEL_SOURCE_NUMBER = C.NUMBER;
is what i had tried without luck...

trying to make a sql statement so i can redo later...
any help appreciated..

[sub]

If you can zip and attach the xmltv file, I can check why it didnt get the correct channel number.

[pBS]

it's probably cuz the channel display_name..
my xml maybe too big to attach..trying now..

are there any option of which display_name is used like there used to be? [name, name + number, number alone]

thanx alot as there's no way i could fix manually within hours..

[sub]

From memory, it always uses the first display-name in an xmltv file for the channel name. If there is any alternative display-name which is only a number, then it use it as the channel number otherwise it just allocates the next number.

[pBS]

another thing, i noticed the data type for 'tuning' field is varchar(50)....yet there's wayyy more than 50 chars in there..??
does it mean 50 per line? probably why my editor is cutting off the data when trying to edit...[being literal]

[pBS]

my channels look like: [from mc2xml]

<channel id="I206.28455954.microsoft.com">
<display-name>206 ESPN</display-name>
<display-name>ESPN</display-name>
<display-name>206</display-name>
<display-name>Sports Satellite</display-name>

or with a -F switch i can get this instead if that would be better:

<channel id="I206.28455954.microsoft.com">
<display-name>ESPN</display-name>
<display-name>206 ESPN</display-name>
<display-name>206</display-name>
<display-name>Sports Satellite</display-name>

[sub]

SQLite only uses the size in it's varchar definition for SQL compatility. It ignores this though, and the varchar fields can be as long as you want, regardless of what it's defined as.

[sub]

or with a -F switch i can get this instead if that would be better:

It doesnt bother me what you use. The app should cope with eithr. First display name will be used for the channel name. A number only display name will be used for the channel number.

I'll test your file in the morning.

[pBS]

it has a number only alternate, but doesn't seem to be using it..
previous version dealt with it fine so must be something new..
will try playing with xml to see if i can get any to stick..

may want to up the varchar limit for that field just for correctness cuz it seems some tools take it literally..i had to up it to 255 to squeeze everything in..
[to head off possible future user issues]

[pBS]

ever get to check why that file won't import channels?
i found that any more than 2 display-name entries seems to stuff it up..