database & xml

[boohiss]

I'm looking through the SQLite file and the XML file and I'm kinda confused about what data is where.

What determines if a show will appear on the "Recordings" list? Where does that data come from?

Where can I get the filename of a program from the PROGRAMME table?

Thanks,

Matt

[sub]

What determines if a show will appear on the "Recordings" list? Where does that data come from?

The recordings are in the RECORDING_SCHEDULE table.

Where can I get the filename of a program from the PROGRAMME table?

A PROGRAMME database record doesnt have filenames, but it does have the show title, which is a major part of the filename. The filename is in the RECORDING_SCHEDULE table.

[boohiss]

Thanks for your reply. However, there's a 'filename' column in that table, but it doesn't seem to correspond to the .mpg or .avi file.

[sub]

The filename only contains the show title until the recording actually begins, then it is converted into a full path. This is so that if the user changes the recording directory, the files wont be saved in the old location.