script to export all data into and external database

[zzmystique]

Not sure if this is the right thread to put this question in, but has anyone written a script that they are willing to share that will export all the recordings data out of sage into a mysql or mssql express database?

I want to add details about the recordings ie aspect ratio, audio and video codecs to the xml files or metadata 'my' generated by Neilm's or JREKiwi's plugins.

Thanks

[JREkiwi]

Hi Anne, a couple of things.

Do you need anything other than what's displayed under Format: in the recording Detail Info screen?

Do you normally populate your database using the .my or xml files? or are you just using the database to add the information to the .my or xml files

I can add that additional info to the .my files if you want.

John

[zzmystique]

Hi John

Wow that was a quick response. Thankyou.

The info I am after is, the file format information similar to what is display in the webserver - recordings page. for example:

File Format: Quicktime[MPEG4-Video 4:3 512x384@30fps, AAC@44.1kHz Stereo und]

At the moment, the information is imported into a database from neilm's xml file, but the file format info is not there. I would also need to add the path to the mpg/mp4 file. If you could include this information in the 'my' file that would be fantastic.

This info would also be very useful for getting the aspect ratio's right when converting to mp4.

Thanks

Anne

[JREkiwi]

Do you want the whole string Quicktime[MPEG4-Video 4:3 512x384@30fps, AAC@44.1kHz Stereo und] as a single item?

You could also look at stuckless' api and SageScriptFramework and use GetMediaFileFormatDescription(MediaFile) to get the format.

John

[zzmystique]

Hi John

Do you want the whole string Quicktime[MPEG4-Video 4:3 512x384@30fps, AAC@44.1kHz Stereo und] as a single item?

Preferably seperated, but if that makes it harder or more work to write then all in a single string would be good.

I will take a look at stuckless's api and SageScriptFramework for the GetMediaFileFormatDescription(MediaFile) , but my programming skills are limited, (dos cmd line and a little vbscript). So not sure how far i will get.

Think its about time, I got stuck in and learnt it!

Thanks once again.

Anne

[JREkiwi]

Anne, I've emailed a new version of RW Metadata to you that includes these changes.

John

[zzmystique]

John

It worked a treat.

Thankyou

Anne

[VCRUser]

Originally Posted by JREkiwi

Anne, I've emailed a new version of RW Metadata to you that includes these changes.

John

1. Where can I find RW Metadata?
2. Will it (or something else out there) export something like this into plain text or other easily-importable format such as CSV, MDB, Excel, or the like:
Filename, Date recorded, show title, episode title, date originally aired, length
(optional info on codecs, bitrate, encoder)?

This would help me move files from server to transportable media while retaining info useful to decide what I want to watch when.