DVBLink Recordings Importer tool: import from *.ts files

General discussions over DVBLink products

DVBLink Recordings Importer tool: import from *.ts files

Postby driver140771 » Sun Jan 25, 2015 12:52 pm

Hello, i have recordings from other tv-backends like DVBViewer... (*.ts).
Can i import this files to the DVBLink Database that i can see/play this recordings with DVBLink?

Thank`s
driver140771
 
Posts: 45
Joined: Sun Dec 14, 2014 2:16 pm


Re: Import other *.ts Files in the DVBLink Database

Postby Oberon » Mon Jan 26, 2015 5:09 pm

At the moment there is no automatic mechanism to import those recordings.
Oberon
 
Posts: 11763
Joined: Thu Sep 06, 2007 5:04 am

Re: Import other *.ts Files in the DVBLink Database

Postby driver140771 » Tue Jan 27, 2015 8:27 pm

Oberon wrote:no automatic mechanism


...and manual? Is this possible?

Thank`s
driver140771
 
Posts: 45
Joined: Sun Dec 14, 2014 2:16 pm

Re: Import other *.ts Files in the DVBLink Database

Postby Oberon » Wed Jan 28, 2015 10:48 am

To do it manually you would need to patch dlrecorder.db, using one of the available sql editors.
Oberon
 
Posts: 11763
Joined: Thu Sep 06, 2007 5:04 am

Re: Import other *.ts Files in the DVBLink Database

Postby driver140771 » Fri Jan 30, 2015 4:30 pm

Hello Oberon, it works with http://sqlitebrowser.org/ :D

But on question: what ist the format of the column "start_time"?
driver140771
 
Posts: 45
Joined: Sun Dec 14, 2014 2:16 pm

Re: Import other *.ts Files in the DVBLink Database

Postby Oberon » Sat Jan 31, 2015 12:05 pm

It is a unix timestamp of the recording start time.
Oberon
 
Posts: 11763
Joined: Thu Sep 06, 2007 5:04 am

Re: Import other *.ts Files in the DVBLink Database

Postby Jake » Thu Jun 02, 2016 2:02 pm

I was also looking for a way to import my recordings. In my case they were from Argus TV.

I could have manually edited the dlrecorder.db file. But I have a lot of recordings, so it would have been both tedious and prone to errors.
So I created a small application to do it for me.

It's very simple and works with all .TS files.
You can either select to copy the .TS files to the configured DVBLink recordings path or you can move them. Moving is faster but if something happens it can't be undone. So it is recommended to copy the files and after you have checked that everything worked, you can just delete the old ones. Just make sure you have enough disk space.

Screenshot - 2016-06-02 , 14_22_13.png
Main screen importing
Screenshot - 2016-06-02 , 14_22_13.png (103.62 KiB) Viewed 10376 times


If you have recordings from Argus TV or ForTheRecord and have saved the metadata files (.arg or .4tr) along with the recordings. Then the application will also import the metadata such as title and channel name. If you don't have .arg or .4tr files, the application will still import the recordings, just without the extra metadata.

Screenshot - 2016-06-02 , 14_26_02.png
Imported with Argus TV metadata
Screenshot - 2016-06-02 , 14_26_02.png (14.83 KiB) Viewed 10376 times


Screenshot - 2016-06-02 , 14_22_41.png
Imported without Argus TV metadata
Screenshot - 2016-06-02 , 14_22_41.png (16.11 KiB) Viewed 10376 times


If you stop the importing, it will check what has been imported already and continue.


Remember to backup dlrecorder.db first!!!

Download the application and unzip it. .NET 4.6 is required.
http://releases.crudesoftware.xyz/dvblinkrecordingsimporter/dvblinkrecordingsimporter-latest.zip
And then follow the instructions in the application.

This is not an official application, but I have tested it extensively on my system and it works.

Stop the dvblink_server service before importing, or you will encounter locking issues.

Remember to backup dlrecorder.db first!!!
Jake
 
Posts: 31
Joined: Tue May 31, 2016 2:52 pm

Re: Import other *.ts Files in the DVBLink Database

Postby Jake » Thu Jun 02, 2016 6:30 pm

A new version is uploaded after fixing a bug with quotes in the description field.

http://releases.crudesoftware.xyz/dvblinkrecordingsimporter/dvblinkrecordingsimporter-latest.zip
Jake
 
Posts: 31
Joined: Tue May 31, 2016 2:52 pm

Re: Import other *.ts Files in the DVBLink Database

Postby Jake » Fri Jun 03, 2016 10:13 am

Jake
 
Posts: 31
Joined: Tue May 31, 2016 2:52 pm

Re: DVBLink Recordings Importer tool: import from *.ts files

Postby beeswax » Sat Jun 04, 2016 10:59 am

Nice work Jake, thanks for taking the time and for sharing :)
beeswax
 
Posts: 75
Joined: Sun Jul 14, 2013 5:06 pm

Re: DVBLink Recordings Importer tool: import from *.ts files

Postby Atreyu » Thu Jun 30, 2016 7:36 pm

Very nice, thanks a lot!
I am sure i will be needing this sometime in the future..!
Atreyu
 
Posts: 27
Joined: Tue Nov 24, 2015 10:37 pm

Re: DVBLink Recordings Importer tool: import from *.ts files

Postby aggeren » Tue Jul 05, 2016 8:47 pm

Great great great tool!

DVBLink installation on Synology NAS, newly installed version6 of DVBLink and have a folder with old recordings.

I've tried to execute your program on Windows 10, entering the following:
Database path: \\NAS\DVBLink\database\dlrecorder.db
DVBLink Recording path: Z:\
Recordings path to import: Z:\archive (where i have stored my old recordings)
where Z: is mapped to \\NAS\DVBLink

I've stopped the DVBLink service on the Synology box and if I try to execute the above, the tool breaks and give me an error message that "DVBLinkRecordingsImporter has stopped working". I've also tried to run the tool as administrator.

Is my setup an edge case or should it work fine, when patching an external server/ressource with this program?
Attachments
1.PNG
1.PNG (9.08 KiB) Viewed 9929 times
aggeren
 
Posts: 8
Joined: Thu Oct 24, 2013 10:58 pm

Re: DVBLink Recordings Importer tool: import from *.ts files

Postby Jake » Tue Jul 05, 2016 9:19 pm

I haven't tried running it against a UNC (possibly a permissions error). I can do some tests on this, but in the meantime you can try to copy over the dlrecorder.db file to your computer and point the importer to that location instead. If that works, you can then copy the dlrecorder.db file back to your NAS.

Keep in mind that the importer will use the path that you enter in the 'DVBLink Recordings Path' field and place that in the DB file for each recording. It has to be within the set path in DVBLink (see screenshot below).
I'm not sure how DVBLink handles recordings on a NAS. I assume it uses UNC paths. If it does then you have to use a UNC path in the 'DVBLink Recordings Path' field. If you want I can take a look at your dlrecorder.db file.

Screenshot - 2016-07-05 , 22_09_37.png
Screenshot - 2016-07-05 , 22_09_37.png (15.77 KiB) Viewed 9927 times
Jake
 
Posts: 31
Joined: Tue May 31, 2016 2:52 pm

Re: DVBLink Recordings Importer tool: import from *.ts files

Postby aggeren » Tue Jul 05, 2016 10:02 pm

i have taken a look at your suggestion, and there might be a problem with the paths on a linux-synology filesystem and the one i can enter on a windows machine.
In DVBLink on Synology, the path is this: /volume1/DVBLink/RecordedTV/
On windows, i can only use \folder1\folder2 format

I've attached the new dlrecorder.db file, if you want to have a go at it. This is a clean dlrecorder.db (18k). I also found a backup-dlrecorder.db which i think the upgrade of DVBLink 5.x->6.0 has produced and put into databases/backup i guess. I guess that one should hold the data, but i can't seem to get DVBLink to use it :/
Attachments
1.PNG
1.PNG (21.48 KiB) Viewed 9925 times
dlrecorder.zip
(1.56 KiB) Downloaded 246 times
aggeren
 
Posts: 8
Joined: Thu Oct 24, 2013 10:58 pm

Re: DVBLink Recordings Importer tool: import from *.ts files

Postby aggeren » Tue Jul 05, 2016 10:41 pm

Well, i actually got it to accept a path like: volume1/DVBLink/RecordedTV (by creating a folderstructure inside the folder, where DVBLinkRecordingsImporter.exe exists) and imported a single .ts file into the database. Checked with the sqlitebrowser and it seems ok. I might have to push a "/" in before the path, so i looks like the linux/Synology path.
Now i need to copy it to synology and start the service and then test if its reachable from my mediacenter or DLNA devices.
aggeren
 
Posts: 8
Joined: Thu Oct 24, 2013 10:58 pm

Next

Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

cron