2018-04-11, 01:17
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?
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?