Bulk Map not working?

[djo5003]

I think there's still an issue with this, even after applying this patch.

When I do Bulk Map (on a fresh list ofchannels), and I select XMLTV, select my file, and map it to the proper channel, the rest of the channels do indeed automap (whereas they didn't prior to this patch).

However, the auto-mapped channel listings don't associate themselves with the correct .xml file.

I checked in the .db3 SQLite DB and noticed the tag for file was just <file></file>, when it should have been <file>R:\NextPVR\EPG\TVGUIDE.xml</file>.


As a workaround (for now), I manually ran the SQL: UPDATE "CHANNEL" SET epg_mapping = REPLACE(epg_mapping, '<file></file>', '<file>R:\NextPVR\EPG\TVGUIDE.xml</file>')

Can you outline how you accomplished this workaround? How did you connect to the DB? I was going to try to use SQLite Manager w/Firefox, but not sure how to connect.

With 400+ channels and the channel detail pages loading slowly, my patience does not cooperate with manually mapping each channel.

[2leftfeet]

Label this advice "Blind leading the blind", lol, having never done this before either ...

I just performed the very thing you are asking using SQLite Manager in Firefox. And it works!

Here's what I did...

Make a backup of the .db3 file (just in case) !!!

Connect to the database file - in SQLite manger, by clicking on database tab at top and select connect to database, navigate to the proper folder and click on the npvr.db3 file

It will open the file, then after it is opened, navigate to the CHANNELS table in left pane

In the right PANE, select the Execute SQL tab

in the "Enter SQL" window, enter the command provided by ScawnyB above ---

UPDATE "CHANNEL" SET epg_mapping = REPLACE(epg_mapping, '<file></file>', '<file>R:\NextPVR\EPG\TVGUIDE.xml</file>')

!!! but, make sure that you change the "replace to" folder location in the above command (in Scrawny's case: R:\NextPVR\EPG\TVGUIDE.xml) to match the location where your EPG file is located in your system before executing the command.

Once the desired db location is entered, press the "Run SQL" button and wait a few seconds for a status message stating no errors.

That's it. You can verify the operation by inspecting the data in the Search&Browse tab in the right Pane.

Close SQLite manger and press the Update EPG button in NPVR's settings/channels window and you should be good to go.

AGAIN, Make sure you have a backup, just in case

good luck.

[jachello]

Thanks for the "how-to" 2leftfeet. I used the SQLite GUI off sqlitebrowser.org. The navigation was just slightly different, but same process.