My source is cable TV coming from Comcast which I understand is digital (except I don't have the digital cable box connected, which probably doesn't matter)
OK, so the lineup you're using on SD should be correct then.
Am I correct in assuming that once you did a channel scan, & before you ran SD with rename option enabled, that you ended up with very few (if any) named channels?
The analog ones should have just been populated as channel numbers, & possibly the digital ones included a channel name, in addition to the number, depending on your cable company.
Renaming the digital channels in TVServer to match the name on SD should work to get SD to associate your remaining channels with no guide data. In the example you used earlier, you said SD listed WCCO-DT correct?
If so, then rename that channel in TVServer to be WCCO-DT. It has to match the SD naming exactly. Do not change the channel number, if it doesn't match SD, as it has to stay as whatever the scan detected it as.
The next time SD runs, it should create a match once it sees a station matching exactly by name to on in your lineup.
Add a second lineup on SD for antenna. Edit that lineup to only have the HD channels you're interested in active (usually just the .1 channels) . Rename the HD channels in the TVserver to exactly match the names of the ones in this lineup (eg. WCCO-DT).
Next SD scan should match them up. The SD plugin will search all lineups everytime, looking for matches. If there's a channel that doesn't show up for your zipcode, then you can add another lineup under a different zip that does have that channel, & disable all other channels in that lineup.
It took a bit of fiddling for me, trying different zipcodes, but I eventually found two zipcodes, which when used together, gave me all the channels I can receive. I just selected the channels I wanted from each zip, and left any unwanted or redundant ones unselected.
For me it helped to set the SD plugin option to force download on next start in the SD plugin.
This grabs the SD data when you restart TV server.
Note that the option is reset after each restart.
So you will need to check it each time you want to force a SD grab.
Then open the TVserver.log and you can see what it is doing.
Refresh the log as it is constantly being updated.
I agree with the other posters. The mapping of the SD channel to the MP channel is done via the channel name in MP. MP must match SD e.g. "72 KQED".
You can change the SD plugin to use only the number or call sign or both. I use both.
I tried forcing rename of channels but that just made a mess and I don't recommend it.
As stated by another poster you should disable the channels that you aren't using in the SD lineup.
If you are still having problems I would focus on enabling only 1 SD channel and then look in the logs to see what it says.
I also use Comcast basic package with SD.
I got a quick input on my thoughts here if anyone doesn't mind, and who knows, I may be wrong in this thinking. But, if you have analog channels matching up with SD and then you do a QAM scan and you get all those Unknown 9823928-31 channels, wouldn't it be easier to rename all the channels to their respective channel number and callsign and then using the TV Channels -> Combination option in TV Server to combine it with the analog version of the channel? As close as I can tell that will allow MP to pick which card based on priority for recording and match up the Schedules Direct channels to what your system already knows. Just my .02.
Here's what I did for adding digital cable channels
1) scan to find digital channels, and manually identify what channel is what
2) edit my Schedules Direct lineup to add the digital channels.
3) Set the SD options to automatically add channels, set the option to download guide on next start, and restart TV Server to force an update.
Now, I have guide data from SD that doesn't tune a channel, and I have working digital channels from the scan with no guide data. Right?
4) Open the channels table in SQL Server. Copy the value for "external id" (i think that's the column name; values look like xxxx.xxxx.schedulesdirect.org) FROM the schedules direct channel TO the scanned channel.
5) In config you can now delete the schedules direct added channels.
May not be the easiest way, but it's what worked for me. Guide updates work, and digital channels work.