Reply to thread

Message

<blockquote data-quote="bamboocha" data-source="post: 294118" data-attributes="member: 81645">Hallo zusammen,da ich per TVSeries schon eine Zuordnung der Serien gemacht habe, suche ich nun ein Programm, was alle Serien umbenennt und eine Ordnerstruktur anlegt. ( Serienname -&gt; Staffel X -&gt; Serienname S0#E0# Folgenname.avi )Gibt es ein Tool was mit dem Plugin TVSeries zusammenarbeitet?&nbsp;Gruß bamboochaedit:Ok, ich hab mir selbst was geschrieben.Vielleicht kann es jemand gebrauchen.Falls es jemand als ausführbares Programm braucht, dann schreibt einfach und ich baue ein paar Parameter ein.[CODE]&nbsp; &nbsp; &nbsp; &nbsp; String zielpfad = &quot;C:\\Serien\\&quot;;&nbsp; &nbsp; &nbsp; &nbsp; Connection conn = null;&nbsp; &nbsp; &nbsp; &nbsp; SQLite.Database db = null;&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Class.forName(&quot;SQLite.JDBCDriver&quot;).newInstance();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; conn = DriverManager.getConnection(&quot;jdbc:sqlite:/C:/TVSeriesDatabase4.db3&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; java.lang.reflect.Method m = conn.getClass().getMethod(&quot;getSQLiteDatabase&quot;, null);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db = (SQLite.Database) m.invoke(conn, null);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PrintWriter pw = new PrintWriter(new FileWriter(&quot;Serienumbenennen.csv&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String sql = &quot;SELECT episodefilename, os.pretty_name, &quot; + &quot;&nbsp; oe.seasonindex, oe.episodeindex, oe.episodename &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + &quot; FROM local_episodes le, online_episodes oe, online_series os &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + &quot; WHERE le.compositeid = oe.compositeid &quot; + &quot; AND oe.seriesid = os.ID&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PreparedStatement ps = conn.prepareStatement(sql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ResultSet rs = ps.executeQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (rs.next()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String Serie = rs.getString(2).replace('/', ' ');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String Episode = rs.getString(4).replace('/', ' ');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String Staffel = rs.getString(3);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String Episodenname = rs.getString(5).replace('/', ' ');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Staffel.length() == 1) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Staffel = &quot;0&quot; + Staffel;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Episode.length() == 1) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Episode = &quot;0&quot; + Episode;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String back = &quot;\\&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String fileformat = rs.getString(1).substring(rs.getString(1).lastIndexOf(&quot;.&quot;), rs.getString(1).length());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String quellename = rs.getString(1);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String zielname = zielpfad + Serie + &quot;\\Staffel &quot; + Staffel + back + Serie + &quot; - S&quot; + Staffel + &quot;E&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + Episode + &quot; - &quot; + Episodenname + fileformat;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (new File(zielpfad + Serie)).mkdir();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (new File(zielpfad + Serie + &quot;\\Staffel &quot; + Staffel)).mkdir();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pw.println(quellename + &quot; ---&gt; &quot; + zielname);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!quellename.equals(zielname)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; File quelle = new File(quellename);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; File ziel = new File(zielname);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int i = 1; i &lt; 10 &amp;&amp; ziel.exists(); i++) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; zielname = zielpfad + Serie + &quot;\\Staffel &quot; + Staffel + back + Serie + &quot; - S&quot; + Staffel + &quot;E&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + Episode + &quot; - &quot; + Episodenname + &quot;(&quot; + i + &quot;)&quot; + fileformat;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ziel = new File(zielname);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; boolean bla = quelle.renameTo(ziel);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!bla) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.err.println(&quot;Das war wohl nix!&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.out.println(quellename + &quot; ---&gt; &quot; + zielname);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pw.flush();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pw.close();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]</blockquote>

[QUOTE="bamboocha, post: 294118, member: 81645"] Hallo zusammen, da ich per TVSeries schon eine Zuordnung der Serien gemacht habe, suche ich nun ein Programm, was alle Serien umbenennt und eine Ordnerstruktur anlegt. ( Serienname -> Staffel X -> Serienname S0#E0# Folgenname.avi ) Gibt es ein Tool was mit dem Plugin TVSeries zusammenarbeitet? Gruß bamboocha edit: Ok, ich hab mir selbst was geschrieben. Vielleicht kann es jemand gebrauchen. Falls es jemand als ausführbares Programm braucht, dann schreibt einfach und ich baue ein paar Parameter ein. [CODE] String zielpfad = "C:\\Serien\\"; Connection conn = null; SQLite.Database db = null; try { Class.forName("SQLite.JDBCDriver").newInstance(); conn = DriverManager.getConnection("jdbc:sqlite:/C:/TVSeriesDatabase4.db3"); java.lang.reflect.Method m = conn.getClass().getMethod("getSQLiteDatabase", null); db = (SQLite.Database) m.invoke(conn, null); PrintWriter pw = new PrintWriter(new FileWriter("Serienumbenennen.csv")); String sql = "SELECT episodefilename, os.pretty_name, " + " oe.seasonindex, oe.episodeindex, oe.episodename " + " FROM local_episodes le, online_episodes oe, online_series os " + " WHERE le.compositeid = oe.compositeid " + " AND oe.seriesid = os.ID"; PreparedStatement ps = conn.prepareStatement(sql); ResultSet rs = ps.executeQuery(); while (rs.next()) { String Serie = rs.getString(2).replace('/', ' '); String Episode = rs.getString(4).replace('/', ' '); String Staffel = rs.getString(3); String Episodenname = rs.getString(5).replace('/', ' '); if (Staffel.length() == 1) { Staffel = "0" + Staffel; } if (Episode.length() == 1) { Episode = "0" + Episode; } String back = "\\"; String fileformat = rs.getString(1).substring(rs.getString(1).lastIndexOf("."), rs.getString(1).length()); String quellename = rs.getString(1); String zielname = zielpfad + Serie + "\\Staffel " + Staffel + back + Serie + " - S" + Staffel + "E" + Episode + " - " + Episodenname + fileformat; (new File(zielpfad + Serie)).mkdir(); (new File(zielpfad + Serie + "\\Staffel " + Staffel)).mkdir(); pw.println(quellename + " ---> " + zielname); if (!quellename.equals(zielname)) { File quelle = new File(quellename); File ziel = new File(zielname); for (int i = 1; i < 10 && ziel.exists(); i++) { zielname = zielpfad + Serie + "\\Staffel " + Staffel + back + Serie + " - S" + Staffel + "E" + Episode + " - " + Episodenname + "(" + i + ")" + fileformat; ziel = new File(zielname); } boolean bla = quelle.renameTo(ziel); if (!bla) { System.err.println("Das war wohl nix!"); System.out.println(quellename + " ---> " + zielname); } } } pw.flush(); pw.close(); } catch (Exception e) { e.printStackTrace(); } [/CODE] [/QUOTE]

Verification