Template to export ALL avaible fields into Excel
mlaggner
Donor
Posts: 3,027
#16
2019-08-26, 13:12
sorry, completely forgot about that..

I will include your template in 3.0.4 or 3.0.5 (depends on my spare time)

this snippet should show you the way to include the url from our database:
Code:
<!-- <td><div class="poster"><img src="${movie.artworkUrls.POSTER(../nopicture.gif)}" width="180px"/></div></td> -->
tinyMediaManager - THE media manager of your choice - available for Windows, macOS and Linux
Help us translate tinyMediaManager at Weblate | Translations at 66%
Found a bug or want to submit a feature request? Contact us at GitLab
Find
jhoyos
Senior Member
Posts: 157
#17
2019-09-01, 12:51
Hi, I finally resolved how to include poster url into the template, including this line:

    <Cell><Data ss:Type="String">${movie.artworkUrls.POSTER(../nopicture.gif)}</Data></Cell>

This is the hole template:

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"/>
   <Column ss:Width="300.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>
     <Cell><Data ss:Type="String">Poster</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>
    <Cell><Data ss:Type="String">${movie.artworkUrls.POSTER(../nopicture.gif)}</Data></Cell>

   </Row>
${end}

  </Table>
 </Worksheet>
</Workbook>
Find
z3us
Member
Posts: 85
#18
2020-05-04, 07:45
hI
I want to import this xml file into a google spreedshet. Does anyone know if it is possible?
Thx
Find
jhoyos
Senior Member
Posts: 157
#19
2020-05-04, 10:36
(2020-05-04, 07:45)z3us Wrote: hI
I want to import this xml file into a google spreedshet. Does anyone know if it is possible?
Thx

You can always open it in Excel, save it as an xls file, and import it into google spreadsheet...
Find

Home
Search
Help
Logout Mark Read Team Forum Stats Members Help
Template to export ALL avaible fields into Excel1