Export not working - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116) +---- Forum: TinyMediaManager (https://forum.kodi.tv/forumdisplay.php?fid=204) +---- Thread: Export not working (/showthread.php?tid=330757) |
Export not working - loungebob - 2018-04-11 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? RE: Export not working - mlaggner - 2018-04-11 good catch. we changed the rating structure to multiple ratings, and obviously forgot to adopt the export templates could you try: Code: <Cell><Data ss:Type="String">${movie.ratings.imdb.rating}</Data></Cell> RE: Export not working - loungebob - 2018-04-11 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="urnchemas-microsoft-com:officepreadsheet" xmlns:o="urnchemas-microsoft-com:office:office" xmlns:x="urnchemas-microsoft-com:office:excel" xmlnss="urnchemas-microsoft-com:officepreadsheet" 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" ssefaultColumnWidth="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> RE: Export not working - mlaggner - 2018-04-11 you have 3 columns defined, but 6 cells per row - I suppose that is the problem RE: Export not working - Klojum - 2018-04-11 (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? RE: Export not working - loungebob - 2018-04-11 oh duh. I thought the default value at the beginning of the table in the export file (ssefaultColumnWidth="60") catches this and assumes that value for all non-defined variables. anyhow, this works: and yay! :-) now that this works, is there a way I can get metacritic values and rottentomatos values too? thanks so far! RE: Export not working - thwaller - 2018-07-07 (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. RE: Export not working - Klojum - 2018-07-07 (2018-07-07, 20:43)thwaller Wrote: Well, the bold red text actually says ...*yawn* |