Where does NEWA read the Show name from in the NEWA Web App?

[jksmurf]

I ask as I recently went into the npvr.db3 database and removed some "TM" labels off the kids Harry Potter Shows.

Some of them kept the TM in the file name, so I thought maybe NEWA read it off these, but there are some shows WITHOUT TM in the "name " or "filename" in npvr.db3 and NEWA STILL shows TM in the name?

ta

k.

[jksmurf]

OK I think I found it; I can fix these manually, but it would be nice to have a tool where you could adjust it as a search replace, and all in on ego for each column in that table.

[pBS]

cant you use sqlite's replace function?

Code:

sqlite3.exe npvr.db3 "UPDATE scheduled_recording SET event_details = REPLACE(event_details, 'text', 'replacement text');"

or something like that...
[remember to test before using for real]

[jksmurf]

cant you use sqlite's replace function?

Code:

sqlite3.exe npvr.db3 "UPDATE scheduled_recording SET event_details = REPLACE(event_details, 'text', 'replacement text');"

or something like that...
[remember to test before using for real]

cheers pBS
Cool, didn't know there was such an animal.