Hi,

Does anyone have the column heading format for the download_history file please?

Example line extracted below;

b04v5q11|Bing|59. Potato|tv|1436427585|flashvhigh1|C:\Users\Me\Desktop\iPlayer Recordings\Bing_-_59._Potato_b04v5q11_default.mp4|audiodescribed,default|300|Bing and Sula find a potato in Amma's vegetable patch with a comical face.|CBeebies|Learning,Children's,Pre-School,Entertainment & Comedy,Animation|http://ichef.bbci.co.uk/images/ic/150x84/p02dd9fn.jpg||http://www.bbc.co.uk/programmes/b046ts1d|59|1|

I'd like to read this into Excel and does some working on the download history contents but not sure what all the column headings would be...

Many thanks

Paul

(15-01-2016, 03:00 PM)Hi,

Does anyone have the column heading format for the download_history file please?

Example line extracted below;

b04v5q11|Bing|59. Potato|tv|1436427585|flashvhigh1|C:\Users\Me\Desktop\iPlayer Recordings\Bing_-_59._Potato_b04v5q11_default.mp4|audiodescribed,default|300|Bing and Sula find a potato in Amma's vegetable patch with a comical face.|CBeebies|Learning,Children's,Pre-School,Entertainment & Comedy,Animation|http://ichef.bbci.co.uk/images/ic/150x84/p02dd9fn.jpg||http://www.bbc.co.uk/programmes/b046ts1d|59|1|

I'd like to read this into Excel and does some working on the download history contents but not sure what all the column headings would be...

Many thanks

Paul

At a rough guess:

pid |programme | episode | type | timestamp (unix??) | mode | output file | (can't remember what this is called) | duration (secs?) | long description | Channel | type | thumbnail source | dunno | dunno | dunno | dunno |

Mable

Cheers for the input Mable - appreciated ;-)

Anyone else confirm the blanks?

Paul

I've added to it in bold.

pid |programme | episode | type | timestamp (unix) | mode | output file | version | duration (secs?) | long description | Channel | type category| thumbnail source | dunno | programme page | episode no | series no |

Ooohhh - so close to a full list (thanks to tvfan).... Any more helpers for the final one?

The missing one between thumbnail and programme page is Parental Guidance (very rarely used) can contain something like Adult

Excellent, many thanks errfmt :-)