home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My Films
Extreme Movie Manager XML Exporter
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="tomtotom2" data-source="post: 398041" data-attributes="member: 16555"><p><strong>Sure!</strong></p><p></p><p>Open Access and in Access you open your EMM.MDB-File.</p><p></p><p>Next you Go to "Querys" ( hoping you`ve got an Access Version below 2007 - I got near to no Idea how anything works with the new Design)</p><p></p><p>Here you Create a New Query, close the " Insert Table" Window ( I'M guessing the Window-Names , I only know the German Version)</p><p> Under "View" ther should be the Option to switch to "SQL"</p><p></p><p>Now you should have a clean Window.</p><p></p><p>Next you Copy this text:</p><p>SELECT [tvseriesmain]![title] & " " & [season] & " x " & Format$([number],"00") & " -" & [episodes]![title] AS OriginalTitle, [tvseriesmain]![title] & "\Season" & [season] & "\" & Format$([number],"00") AS TranslatedTitle, Episodes.Rating, Episodes.Director, Episodes.Plot AS description, Episodes.Trivia, Episodes.Codec AS videoformat, Episodes.Resolution, Episodes.Bitrate AS videobitrate, Episodes.AudioCodec AS audioformat, Episodes.MovieFile1 AS Source, "Here belongs the Path to your EMM Picture Directory" & [episodes]![cover] AS Picture</p><p>FROM Episodes INNER JOIN TVSeriesMain ON Episodes.SerieID = TVSeriesMain.SerieID;</p><p></p><p>And Paste it into your empty Window.</p><p></p><p>Now you save and open it ...voila (?) you should the all you`re Fields including Hirachie etc.</p><p></p><p>You never have to go ther again....</p><p></p><p>Next step:</p><p></p><p>Open Ant</p><p>Create an empty xml</p><p>import from Access</p><p>select you mdb and the query you have just created</p><p>if necessery check your field-names (Picture and source is a miss although I dont know why)</p><p>And there you go.</p><p></p><p>Hope it helps</p></blockquote><p></p>
[QUOTE="tomtotom2, post: 398041, member: 16555"] [b]Sure![/b] Open Access and in Access you open your EMM.MDB-File. Next you Go to "Querys" ( hoping you`ve got an Access Version below 2007 - I got near to no Idea how anything works with the new Design) Here you Create a New Query, close the " Insert Table" Window ( I'M guessing the Window-Names , I only know the German Version) Under "View" ther should be the Option to switch to "SQL" Now you should have a clean Window. Next you Copy this text: SELECT [tvseriesmain]![title] & " " & [season] & " x " & Format$([number],"00") & " -" & [episodes]![title] AS OriginalTitle, [tvseriesmain]![title] & "\Season" & [season] & "\" & Format$([number],"00") AS TranslatedTitle, Episodes.Rating, Episodes.Director, Episodes.Plot AS description, Episodes.Trivia, Episodes.Codec AS videoformat, Episodes.Resolution, Episodes.Bitrate AS videobitrate, Episodes.AudioCodec AS audioformat, Episodes.MovieFile1 AS Source, "Here belongs the Path to your EMM Picture Directory" & [episodes]![cover] AS Picture FROM Episodes INNER JOIN TVSeriesMain ON Episodes.SerieID = TVSeriesMain.SerieID; And Paste it into your empty Window. Now you save and open it ...voila (?) you should the all you`re Fields including Hirachie etc. You never have to go ther again.... Next step: Open Ant Create an empty xml import from Access select you mdb and the query you have just created if necessery check your field-names (Picture and source is a miss although I dont know why) And there you go. Hope it helps [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My Films
Extreme Movie Manager XML Exporter
Contact us
RSS
Top
Bottom