Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 542681" data-attributes="member: 18896">This thread reminds me that I have been putting off the daunting task to filter out my large Asian movie collection and rename all their titles to the English titles that I prefer, as listed in the &quot;Alternative Title&quot; field. I'm still hoping to do this automatic via some fancy SQL Queries, but it might be a lost cause and I'll be forced to rename them manually.Since during install I selected English, I actually assumed that the scraper would pick the &quot;(Hong Kong: English title)&quot; field from the &quot;Also Known As&quot; entries on imdb.com, since that entry exist on every Asian movie title I've encountered, but I can't expect this plugin to cook me breakfast in the morning either <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite4" alt=":mad:" title="Mad&nbsp; &nbsp; :mad:" loading="lazy" data-shortname=":mad:" />The scraper does recognize the &quot;Also Known As&quot; names though, because on importing my collection, it had no trouble finding the ones that were named &quot;English Title (Asian Title).ext&quot;, but on the ones named &quot;English Title.ext&quot;, it always had the correct Asian title listed (I ended up renaming all the filenames that were only English after doing a manual lookup on imdb.com).This works a lot easier on MyMovies were you can select and use the AKA title and not have to learn another language <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />One of these days I'll find the time to rename all the entries in my database, but I hope an automatic method on this is part of the planned enhancement that fforde informed me about in another thread (regarding sorting of titles).PS: If anybody else already has created some fancy SQL Queries to do this renaming partly automatic, then please share it with the rest of us. It usually takes me hours/days before I can come up with a working query.</blockquote>

[QUOTE="RoChess, post: 542681, member: 18896"] This thread reminds me that I have been putting off the daunting task to filter out my large Asian movie collection and rename all their titles to the English titles that I prefer, as listed in the "Alternative Title" field. I'm still hoping to do this automatic via some fancy SQL Queries, but it might be a lost cause and I'll be forced to rename them manually. Since during install I selected English, I actually assumed that the scraper would pick the "(Hong Kong: English title)" field from the "Also Known As" entries on imdb.com, since that entry exist on every Asian movie title I've encountered, but I can't expect this plugin to cook me breakfast in the morning either :bitch: The scraper does recognize the "Also Known As" names though, because on importing my collection, it had no trouble finding the ones that were named "English Title (Asian Title).ext", but on the ones named "English Title.ext", it always had the correct Asian title listed (I ended up renaming all the filenames that were only English after doing a manual lookup on imdb.com). This works a lot easier on MyMovies were you can select and use the AKA title and not have to learn another language :) One of these days I'll find the time to rename all the entries in my database, but I hope an automatic method on this is part of the planned enhancement that fforde informed me about in another thread (regarding sorting of titles). PS: If anybody else already has created some fancy SQL Queries to do this renaming partly automatic, then please share it with the rest of us. It usually takes me hours/days before I can come up with a working query. [/QUOTE]

Verification