Import 250+ Programs via Plugin/WebServer automated?

[Fastrack]

Hi all,

I've finished my evaluation of Sage (I was able to squeeze more days) As I reinstalled WinXp fresh (this was my old gaming rig). But now that I have a fresh copy of windows, I'll be ordering Sage in the coming days.

Anyway 4 years ago I wrote my own PVR app using Visual Basic, Access and WinTVCap. However with multiple tuners and the HDHomeRun/HD I figured it was time to upgrade.

I have over 250 shows recorded using a PVR-250 that I would like to keep. My MS Access database has all the start/stop times, title,sub title,rating,category etc.. All from the XMLTV xml files. I do not have the Episode ID from the xml files though

Is there an easy way to write a script/program or such, as making the videos load from Imported Videos is no good. I found the feature in the webserver, but manually adding the information for 250 shows would be crazy. It's great don't get me wrong, but only for a few shows.

Thanks in advance,

Ben

[GKusnick]

If you can code in VB, you should be able to write a front end that connects to the webserver and uploads the data from your DB.

Or if you can code in Java, you should be able to modify the webserver source to read the DB directly.

[Fastrack]

Originally Posted by GKusnick

If you can code in VB, you should be able to write a front end that connects to the webserver and uploads the data from your DB.

Or if you can code in Java, you should be able to modify the webserver source to read the DB directly.

I can and have coded in Java, c++ etc... I'll take a look at the webserver code...

[dvd_maniac]

a faster way may be to use existing programs.
TV.com .my file creation utility is an easy to use program to create .my files with lots of info about the TV series.
Then using THIS custom import you could import that information into the Sage Database or just have Sage use the .my file to display the information.
And for movies I use THIS import to search from IMDB.com and then save that into Sage's DB.

[JREkiwi]

Or, if you're coding, you could write the data out to per-show .properties files and have Sage parse the data into the database.

John`

[Fastrack]

Originally Posted by JREkiwi

Or, if you're coding, you could write the data out to per-show .properties files and have Sage parse the data into the database.

John`

I can easily write a simple output routine, from all the data I already have in my Database. Where can I find the format of the properties file? Or is that your plugin ?

[JREkiwi]

The tags for .properties file are here.

Each tag is on a single line however the Sage parser will parse the text \n as a newline

Title=My Greatest Movie
Description=This is over two lines\nand this is the second one
Actor=Bill Smith, Bob Jones
Lead\ Actor=Harry Harrison


The file needs to be named the same as the video with an additional .properties extension
myvideo.avi
myvideo.avi.properties

John

[nielm]

I am also writing a batch XML importer for the webserver. This will import the shows from my SageXML format and put them as Sage Recordings... Hopefully

With luck, it may be ready early next week...

[Fastrack]

Wow quite a few options. I'm going to give the my/property files a try.

But I'd be more then willing to test out your batch XML importer!

[Fastrack]

Originally Posted by nielm

I am also writing a batch XML importer for the webserver. This will import the shows from my SageXML format and put them as Sage Recordings... Hopefully

With luck, it may be ready early next week...

I'm still trying out the .my/.properties files.. But let me know when you have your XML importer ready!

[nielm]

implemented in webserver 2.15 see here