Export not working
#1
After IMDBNator quit, I needed a new tool to go through massive amount of video files and index them properly, then export the data for further processing. I think I might be falling in love with TMM v3 but for now all I really need is a structured file list export that contains mainly the movie name, imdb rating and imdb votes count.

I cant get it to work though. Which is almost certainly my being not very good at this.

I copied the ExcelXml template, named the copy ExcelXmlVotes, changed the template.conf to “name=EXCEL list Votestype=movielist=list.jmteextension=xmldescription=Since CSV is sub-optimal for Excel, use this XML version.“ and added 2 lines (movie.rating & movie.votes) to list.jmte;

${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="DateTime">${movie.dateAdded;date(yyyy-MM-dd)}T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">${movie.rating}</Data></Cell>
    <Cell><Data ss:Type="int">${movie.votes}</Data></Cell>
    <Cell><Data ss:Type="String">${movie.path}</Data></Cell>
   </Row>
${end}

And now it wont export at all. It just runs for a second and the nada. Nothing in the output folder.

All I could find in the log is this:

2018-04-11 00:33:26,295 DEBUG [main] o.tinymediamanager.ui.actions.TmmAction:34 - action fired: MovieExportAction
2018-04-11 00:33:33,158 INFO  [main] o.t.core.movie.MovieExporter:72 - preparing movie export; using EXCEL list Votes
2018-04-11 00:33:33,158 INFO  [main] o.t.core.movie.MovieExporter:105 - generating movie list
2018-04-11 00:33:33,162 ERROR [main] o.t.u.movies.dialogs.MovieExporterDialog:191 - Error exporting movies:
com.floreysoft.jmte.message.ParseException: Error while parsing 'movie.votes' at location (41:33): Property 'votes' on object 'Movie[sortTitle=The Disaster Artist,...

Sooo, what am I doing wrong?
Reply
#2
good catch.
we changed the rating structure to multiple ratings, and obviously forgot to adopt the export templates Wink

could you try:
Code:
<Cell><Data ss:Type="String">${movie.ratings.imdb.rating}</Data></Cell> 
<Cell><Data ss:Type="int">${movie.ratings.imdb.votes}</Data></Cell>
tinyMediaManager - THE media manager of your choice - available for Windows, Mac OSX and Linux
Help us translate tinyMediaManager Weblate
[Image: 1qbFVy]
Reply
#3
now TMM generates an xml output file but Excel doesnt like it:


XML ERROR in Table
REASON: Bad Value
FILE: G:\images\movielist.xml
GROUP: Cell
TAG: Data
ATTRIB: Type
VALUE: int

dont know how to attach files in here so:
 <?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urnConfusedchemas-microsoft-com:officeConfusedpreadsheet"
 xmlns:o="urnConfusedchemas-microsoft-com:office:office"
 xmlns:x="urnConfusedchemas-microsoft-com:office:excel"
 xmlnsConfuseds="urnConfusedchemas-microsoft-com:officeConfusedpreadsheet"
 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" ssBig GrinefaultColumnWidth="60">   <Column ss:Width="200.00"/>
   <Column ss:Width="33.00" ss:StyleID="s22" />
   <Column ss:Width="70.00" ss:StyleID="s23" />
   <Column ss:Width="300.00"/>
   <Row>
    <Cell><Data ss:Type="String">Absolutely Anything</Data></Cell>
    <Cell><Data ss:Type="Number">2015</Data></Cell>
    <Cell><Data ss:Type="DateTime">2015-12-02T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.0</Data></Cell>
    <Cell><Data ss:Type="int">30765</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Absolutely.Anything.2015.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">The Disaster Artist</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2018-02-28T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">7.6</Data></Cell>
    <Cell><Data ss:Type="int">70843</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.Disaster.Artist.2017.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">El Camino Christmas</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-12-08T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">5.6</Data></Cell>
    <Cell><Data ss:Type="int">4541</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__El.Camino.Christmas.2017.1080p.NF.WEBRip.DD5.1.x264-SB</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Going in Style</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-07-11T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.6</Data></Cell>
    <Cell><Data ss:Type="int">54641</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__Going.In.Style.2017.1080p.WEB-DL.DD5.1.H264-FGT</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Hail, Caesar!</Data></Cell>
    <Cell><Data ss:Type="Number">2016</Data></Cell>
    <Cell><Data ss:Type="DateTime">2016-05-25T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.3</Data></Cell>
    <Cell><Data ss:Type="int">101248</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Hail.Caesar.2016.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">The House</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-09-26T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">5.6</Data></Cell>
    <Cell><Data ss:Type="int">23117</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.House.2017.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">I, Tonya</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2018-02-28T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">7.6</Data></Cell>
    <Cell><Data ss:Type="int">78413</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\I.Tonya.2017.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Keanu</Data></Cell>
    <Cell><Data ss:Type="Number">2016</Data></Cell>
    <Cell><Data ss:Type="DateTime">2016-07-22T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.3</Data></Cell>
    <Cell><Data ss:Type="int">37285</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Keanu.2016.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Lady Bird</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2018-02-23T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">7.6</Data></Cell>
    <Cell><Data ss:Type="int">110013</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Lady.Bird.2017.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Masterminds</Data></Cell>
    <Cell><Data ss:Type="Number">2016</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-01-06T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">5.8</Data></Cell>
    <Cell><Data ss:Type="int">38838</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Masterminds.2016.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Mayhem</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-11-10T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.3</Data></Cell>
    <Cell><Data ss:Type="int">8004</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__Mayhem.2017.1080p.WEB-DL.DD5.1.H264-FGT</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">The Meyerowitz Stories (New and Selected)</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-10-14T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">7.0</Data></Cell>
    <Cell><Data ss:Type="int">22329</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__The.Meyerowitz.Stories.New.and.Selected.2017.1080p.WEBRip.x264-STRiFE</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Mindhorn</Data></Cell>
    <Cell><Data ss:Type="Number">2016</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-05-14T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.3</Data></Cell>
    <Cell><Data ss:Type="int">7692</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__Mindhorn.2017.1080p.WEBRip.DD5.1.x264-FGT</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Our Brand Is Crisis</Data></Cell>
    <Cell><Data ss:Type="Number">2015</Data></Cell>
    <Cell><Data ss:Type="DateTime">2016-01-20T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.1</Data></Cell>
    <Cell><Data ss:Type="int">17257</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Our.Brand.Is.Crisis.2015.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Paddington 2</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2018-03-08T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">8.0</Data></Cell>
    <Cell><Data ss:Type="int">24191</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Paddington.2.2017.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">The Party</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2017-11-30T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.7</Data></Cell>
    <Cell><Data ss:Type="int">8461</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.Party.2017.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">Pitch Perfect 3</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2018-03-07T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">6.0</Data></Cell>
    <Cell><Data ss:Type="int">24254</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Pitch.Perfect.3.2017.BluRay.1080p.BluRay.x264-RARBG</Data></Cell>
   </Row>   <Row>
    <Cell><Data ss:Type="String">The Square</Data></Cell>
    <Cell><Data ss:Type="Number">2017</Data></Cell>
    <Cell><Data ss:Type="DateTime">2018-02-23T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">7.4</Data></Cell>
    <Cell><Data ss:Type="int">28991</Data></Cell>
    <Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.Square.2017.BluRay.1080p.x264-RARBG</Data></Cell>
   </Row>
  </Table>
 </Worksheet>
</Workbook>
Reply
#4
you have 3 columns defined, but 6 cells per row - I suppose that is the problem
tinyMediaManager - THE media manager of your choice - available for Windows, Mac OSX and Linux
Help us translate tinyMediaManager Weblate
[Image: 1qbFVy]
Reply
#5
(2018-04-11, 08:38)loungebob Wrote: dont know how to attach files in here so:
Which part of bold red text "When posting text snippets or log files, use a text upload website like https: //paste.ubuntu.com/", right above the Post Reply button, is then unclear to you?
Useful pages: Debug log (wiki) || First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
#6
oh duh. I thought the default value at the beginning of the table in the export file (ssBig GrinefaultColumnWidth="60") catches this and assumes that value for all non-defined variables.

anyhow, this works:

<Worksheet ss:Name="movielist">
  <Table x:FullColumns="1" x:FullRows="1" ssBig GrinefaultColumnWidth="60">

   <Column ss:Width="200.00"/>
   <Column ss:Width="33.00" ss:StyleID="s22" />
   <Column ss:Width="70.00" ss:StyleID="s23" />
   <Column ss:Width="100.00"/>
   <Column ss:Width="100.00"/>
   <Column ss:Width="300.00"/>

${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="DateTime">${movie.dateAdded;date(yyyy-MM-dd)}T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="Number">${movie.ratings.imdb.rating}</Data></Cell>
    <Cell><Data ss:Type="Number">${movie.ratings.imdb.votes}</Data></Cell>
    <Cell><Data ss:Type="String">${movie.path}</Data></Cell>
   </Row>
${end}
and yay! :-)

now that this works, is there a way I can get metacritic values and rottentomatos values too? thanks so far!
Reply
#7
(2018-04-11, 08:55)Klojum Wrote: Which part of bold red text "When posting text snippets or log files, use a text upload website like https: //paste.ubuntu.com/", right above the Post Reply button, is then unclear to you?

Well, the bold red text actually says ... "Do not post logs in the forum. Use https://paste.ubuntu.com/ or similar". Which part of that is unclear to you? There was no log posted here, so your post is completely irrelevant and disrespectful, not to mention incorrectly quoting information.
Reply
#8
(2018-07-07, 20:43)thwaller Wrote: Well, the bold red text actually says ...
*yawn*
Useful pages: Debug log (wiki) || First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
Export not working00