Re-Reading the recorded tv programms from directory (1 Viewer)

[rue]

Hello again!

Currently I'm testing MediaPortal for a implementation of my own mediaserver solution.

When reinstalling MediaPortal all existing tv-records are getting lost.

It would be very helpful, if there would be a mechanism to re-read existing recordings into MediaPortal

Thanks for your help in advance

RUE

 

[rekenaar]

The TV Server does have an import functionality.
See this page in the manual (Database Import).

 

[rue]

Ooops!!

Sorry ... I've not seen it till now!

Thanks for your reply!!

RUE

 

[iancalderban]

The TV Server does have an import functionality.
See this page in the manual (Database Import).

does this function actually work for you? I have recorded tv files (.ts + .xml) sitting there from previous installation, that do not appear in the "database import tab". the right directory is configured in the tv card recording path.

also, I just cut a file using video edit plugin (saves to same filename), now its vanished from my recorded tv list
Ian

 

[Cybertex]

The TV Server does have an import functionality.
See this page in the manual (Database Import).

does this function actually work for you? I have recorded tv files (.ts + .xml) sitting there from previous installation, that do not appear in the "database import tab". the right directory is configured in the tv card recording path.

also, I just cut a file using video edit plugin (saves to same filename), now its vanished from my recorded tv list
Ian

It could depend on the way the TVServer DB works. When you record a program, a row is inserted in the "recordings" table, matched with the ID of the channel.

If you delete and rescan the channels, those ID were changed. The import utility still find recordings in the db, so doesn't prompt you to re-import; but you cannot see them in "Recorded TV" because the channel ID stored within the record row doesn't match anymore the channel ID in channels table.

You could verify if this is the situation simply opening (in Management Studio) Channels table, and Recordings table. Look for a channel, get its ID, look for a registration done on this channel, and give a look at the channel id recorded.. You can edit the recording table data to re-match (manually) the IDs. Registrations will appear again in "Recorded TV".

Same for Schedules, open the table, edit the IDs...

Sorry for any typo.. I'm at work, a meeting is going to begin, not so much time

 

[iancalderban]

It could depend on the way the TVServer DB works. When you record a program, a row is inserted in the "recordings" table, matched with the ID of the channel.

If you delete and rescan the channels, those ID were changed. The import utility still find recordings in the db, so doesn't prompt you to re-import; but you cannot see them in "Recorded TV" because the channel ID stored within the record row doesn't match anymore the channel ID in channels table.

You could verify if this is the situation simply opening (in Management Studio) Channels table, and Recordings table. Look for a channel, get its ID, look for a registration done on this channel, and give a look at the channel id recorded.. You can edit the recording table data to re-match (manually) the IDs. Registrations will appear again in "Recorded TV".

Same for Schedules, open the table, edit the IDs...

Sorry for any typo.. I'm at work, a meeting is going to begin, not so much time

thanks. however, I don't delete and rescan channels. I did a lot of work once to get my tv server channels configuration "nice" (in an order I like, deleting junk channels etc). so now I always backup and restore tv server configuration using backupsettings plugin if I am doing any kind of reinstall.

what do you mean by Management Studio? is this something in MP or another app?
is there a way to "really force" import of a recording?
Ian

 

[Cybertex]

what do you mean by Management Studio? is this something in MP or another app?
Ian

Oh, yes. Management Studio is the graphical management interface of SQL Server Express.. I supposed you're using SQL Server Express and not MySQL.

Don't remember if Management Studio is installed within SQL Server Express engine or a separate download (from microsoft.com) and install is needed.

You can find it in "start"->"programs"->"SQL Server 2005" (if installed).

I don't know any "real" way to import.. I use the way I described or, if recording are not found by importer, and not present in DB, I insert them by hand. Not so difficult, but a few of SQLServer knowledge is required..

 

[iancalderban]

found a way!

I found a way to get MP tv server to re-read it all. by luck whilst doing something else

1) I have a number of files that are in recorded tv directory that are not present in recorded tv database, but I'd like them to be.
2) I have moved some (different) files out of my recorded tv directory into another directory (by hand in windows). These are films or series, that I am going to load into My Videos / My TV series instead. So these files are now present in the recorded tv database but are NOT present in the record tv directory.
3) I go to the TV server database import tab and click the button (can't remember exact name) for delete recordings that no longer exist. this prompts me to delete , one-by-one, all the recorded tv entries in category 2) - of course it can't delete the files as they are no longer there. Then (automatically) it seems to rescan the directory and asks me about the files in category 1), do I wish to import them? (yes!).
4) I then fire up MP, go to recorded to TV - and all the files that I want are there, and the files that I don't want, aren't!

so the answer for me at least - set something up for deletion, that then appears to trigger a reimport as well.

Ian

 

[rtv]

I found a way to get MP tv server to re-read it all. by luck whilst doing something else

1) I have a number of files that are in recorded tv directory that are not present in recorded tv database, but I'd like them to be.
2) I have moved some (different) files out of my recorded tv directory into another directory (by hand in windows). These are films or series, that I am going to load into My Videos / My TV series instead. So these files are now present in the recorded tv database but are NOT present in the record tv directory.
3) I go to the TV server database import tab and click the button (can't remember exact name) for delete recordings that no longer exist. this prompts me to delete , one-by-one, all the recorded tv entries in category 2) - of course it can't delete the files as they are no longer there. Then (automatically) it seems to rescan the directory and asks me about the files in category 1), do I wish to import them? (yes!).
4) I then fire up MP, go to recorded to TV - and all the files that I want are there, and the files that I don't want, aren't!

so the answer for me at least - set something up for deletion, that then appears to trigger a reimport as well.

Ian

This button has been designed to remove all invalid database entries. It won't delete the recorded movie files