2019-06-04, 13:46
Hi @mlaggner
I have tried audioChannels and it worked perfect, so thank you very much for all your help since finally, I have movies template as I wanted, exporting all the fields that could be useful either for the movie information as per the video / audio resolution.
As I said, find attached my complete template. I hope it can help other people since I have been looking for something similar for quite a long time with no success.
Now... I will work in a similar template for series..., but in this case into another thread.
I have tried audioChannels and it worked perfect, so thank you very much for all your help since finally, I have movies template as I wanted, exporting all the fields that could be useful either for the movie information as per the video / audio resolution.
As I said, find attached my complete template. I hope it can help other people since I have been looking for something similar for quite a long time with no success.
Code:
<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s22">
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="s23">
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="Short Date"/>
</Style>
</Styles>
<Worksheet ss:Name="movielist">
<Table x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="60">
<Column ss:Width="200.00"/>
<Column ss:Width="33.00" ss:StyleID="s22"/>
<Column ss:Width="200.00"/>
<Column ss:Width="200.00"/>
<Column ss:Width="200.00"/>
<Column ss:Width="200.00"/>
<Column ss:Width="100.00"/>
<Column ss:Width="100.00" ss:StyleID="s23" />
<Column ss:Width="60.00" ss:StyleID="s22" />
<Column ss:Width="60.00" ss:StyleID="s22" />
<Column ss:Width="120.00"/>
<Column ss:Width="70.00" ss:StyleID="s22" />
<Column ss:Width="50.00" ss:StyleID="s22" />
<Column ss:Width="50.00" ss:StyleID="s22" />
<Column ss:Width="200.00"/>
<Column ss:Width="260.00"/>
<Column ss:Width="300.00"/>
<Column ss:Width="70.00"/>
<Column ss:Width="70.00" ss:StyleID="s23" />
<Column ss:Width="100.00"/>
<Column ss:Width="40.00"/>
<Column ss:Width="40.00"/>
<Column ss:Width="40.00"/>
<Column ss:Width="70.00" ss:StyleID="s22" />
<Column ss:Width="50.00" ss:StyleID="s22" />
<Column ss:Width="50.00"/>
<Column ss:Width="50.00"/>
<Column ss:Width="50.00"/>
<Column ss:Width="70.00"/>
<Column ss:Width="33.00" ss:StyleID="s22" />
<Column ss:Width="33.00" ss:StyleID="s22" />
<Column ss:Width="33.00" ss:StyleID="s22" />
<Column ss:Width="33.00" ss:StyleID="s22" />
<Column ss:Width="33.00" ss:StyleID="s22" />
<Column ss:Width="300.00"/>
<Column ss:Width="100.00"/>
<Column ss:Width="100.00"/>
<Column ss:Width="100.00"/>
<Row>
<Cell><Data ss:Type="String">Titulo</Data></Cell>
<Cell><Data ss:Type="String">Year</Data></Cell>
<Cell><Data ss:Type="String">Coleccion</Data></Cell>
<Cell><Data ss:Type="String">Argumento</Data></Cell>
<Cell><Data ss:Type="String">Titulo Original</Data></Cell>
<Cell><Data ss:Type="String">Generos</Data></Cell>
<Cell><Data ss:Type="String">Etiquetas</Data></Cell>
<Cell><Data ss:Type="String">Fecha Estreno</Data></Cell>
<Cell><Data ss:Type="String">ID Imdb</Data></Cell>
<Cell><Data ss:Type="String">ID TMDB</Data></Cell>
<Cell><Data ss:Type="String">Idiomas Hablados</Data></Cell>
<Cell><Data ss:Type="String">Certificacion</Data></Cell>
<Cell><Data ss:Type="String">Duracion Archivo</Data></Cell>
<Cell><Data ss:Type="String">Duracion Pelicula</Data></Cell>
<Cell><Data ss:Type="String">Pais</Data></Cell>
<Cell><Data ss:Type="String">Ruta</Data></Cell>
<Cell><Data ss:Type="String">Nombre de Archivo</Data></Cell>
<Cell><Data ss:Type="String">Bytes</Data></Cell>
<Cell><Data ss:Type="String">Fecha de Inclusion</Data></Cell>
<Cell><Data ss:Type="String">Extension</Data></Cell>
<Cell><Data ss:Type="String">Categoria</Data></Cell>
<Cell><Data ss:Type="String">Codec Video</Data></Cell>
<Cell><Data ss:Type="String">Formato</Data></Cell>
<Cell><Data ss:Type="String">Resolucion</Data></Cell>
<Cell><Data ss:Type="String">Video Bitrate</Data></Cell>
<Cell><Data ss:Type="String">Aspect Ratio</Data></Cell>
<Cell><Data ss:Type="String">Frame Rate</Data></Cell>
<Cell><Data ss:Type="String">HDR</Data></Cell>
<Cell><Data ss:Type="String">Codecs Audio</Data></Cell>
<Cell><Data ss:Type="String">Canales Audio</Data></Cell>
<Cell><Data ss:Type="String">Audio Bitrate</Data></Cell>
<Cell><Data ss:Type="String">Subtitulos</Data></Cell>
<Cell><Data ss:Type="String">Metadata</Data></Cell>
<Cell><Data ss:Type="String">Duplicado</Data></Cell>
<Cell><Data ss:Type="String">Imagenes</Data></Cell>
<Cell><Data ss:Type="String">NFO</Data></Cell>
<Cell><Data ss:Type="String">Trailer</Data></Cell>
<Cell><Data ss:Type="String">Actores</Data></Cell>
</Row>
${foreach movies movie}
<Row>
<Cell><Data ss:Type="String">${movie.title}</Data></Cell>
<Cell><Data ss:Type="Number">${movie.year}</Data></Cell>
<Cell><Data ss:Type="String">${movie.movieSet}</Data></Cell>
<Cell><Data ss:Type="String">${movie.plot}</Data></Cell>
<Cell><Data ss:Type="String">${movie.originalTitle}</Data></Cell>
<Cell><Data ss:Type="String">${movie.genresAsString}</Data></Cell>
<Cell><Data ss:Type="String">${movie.tagsAsString}</Data></Cell>
<Cell><Data ss:Type="String">${movie.releaseDateAsString}</Data></Cell>
<Cell><Data ss:Type="String">${movie.imdbId}</Data></Cell>
<Cell><Data ss:Type="String">${movie.tmdbId}</Data></Cell>
<Cell><Data ss:Type="String">${movie.spokenLanguages}</Data></Cell>
<Cell><Data ss:Type="String">${movie.certification}</Data></Cell>
<Cell><Data ss:Type="String">${movie.runtimeFromMediaFiles}</Data></Cell>
<Cell><Data ss:Type="String">${movie.runtime}</Data></Cell>
<Cell><Data ss:Type="String">${movie.country}</Data></Cell>
<Cell><Data ss:Type="String">${movie.path}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.filename}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.filesize}</Data></Cell>
<Cell><Data ss:Type="DateTime">${movie.dateAdded;date(yyyy-MM-dd)}T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.extension}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.videoDefinitionCategory}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mediaInfoVideoCodec}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mediaInfoVideoFormat}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mediaInfoVideoResolution}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mediaInfoVideoBitrate}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.aspectRatio}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.frameRate}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.HDR}</Data></Cell>
<Cell><Data ss:Type="String">${foreach movie.mediaFiles mediafiles}${foreach mediafiles.audioStreams audio}${audio.codec}, ${end}${end}</Data></Cell>
<Cell><Data ss:Type="String">${foreach movie.mediaFiles mediafiles}${foreach mediafiles.audioStreams audio}${audio.audioChannels}, ${end}${end}</Data></Cell>
<Cell><Data ss:Type="String">${foreach movie.mediaFiles mediafiles}${foreach mediafiles.audioStreams audio}${audio.bitrateInKbps}, ${end}${end}</Data></Cell>
<Cell><Data ss:Type="String">${movie.mainVideoFile.subtitlesAsString}</Data></Cell>
<Cell><Data ss:Type="String">${movie.hasMetadata}</Data></Cell>
<Cell><Data ss:Type="String">${movie.duplicate}</Data></Cell>
<Cell><Data ss:Type="String">${movie.hasImages}</Data></Cell>
<Cell><Data ss:Type="String">${movie.hasNfoFile}</Data></Cell>
<Cell><Data ss:Type="String">${movie.hasTrailer}</Data></Cell>
<Cell><Data ss:Type="String">${foreach movie.actors actor}${actor.name}, ${end}</Data></Cell>
</Row>
${end}
</Table>
</Worksheet>
</Workbook>
Now... I will work in a similar template for series..., but in this case into another thread.