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
Support
General Support
fill databases with existing content
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="pStar" data-source="post: 25068" data-attributes="member: 14359"><p>hi everyone</p><p>i had some time to test a few things and want to share my experiences. sorry for my bad english, but i hope to find a solution to the movie database problem...</p><p>first of all i had a look at the sqlite database browser and checked out the different tables and found that the "movieinfo"table could be the one i was looking for. then i exported a plain text file from my ant movie database (where i gathered imdb and informations and covers), holding all the informations the database needs in the "movieinfo"-table separated with semicolons. then i setup mediaportal to use the folders witch contain my movies (i named them 0001_moviename, 0002_moviename,0003_moviename ... i used the numbers from ant movie catalog). next in sqlite browser i deleted the "movieinfo"-table after writing down the datatypes used in the table ('cause the sqlite browser seems to be unable of importing data into an existing table <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown :(" loading="lazy" data-shortname=":(" /> ). then i imported my textfile into a new table, naming it "movieinfo". the field names an types i changed to the original ones (i prepended the fieldnames from database in my textfile, so i haven't to change the tablefieldnames in sqllite browser by hand). finally i had a table, looking just like the original "movieinfo"-table but filled with nice informations from ant movie catalog. i was happy...till</p><p>...i opened mediaportal navigated to a movie and pressed F3.</p><p>almost every information i inserted into the database was gone and replaced with "unknown" (i checked it in the sqlite browser).</p><p>i'm really not into xml,html,sql and this stuff, so i don't know whats going on. perhaps someone has a few tips for me? i read about a ODBC driver in the forums in conjunction with excel or access, perhaps i try this one time, 'cause handling the database within sqlite browser or mediaportal setup is really tricky.</p><p>regards</p></blockquote><p></p>
[QUOTE="pStar, post: 25068, member: 14359"] hi everyone i had some time to test a few things and want to share my experiences. sorry for my bad english, but i hope to find a solution to the movie database problem... first of all i had a look at the sqlite database browser and checked out the different tables and found that the "movieinfo"table could be the one i was looking for. then i exported a plain text file from my ant movie database (where i gathered imdb and informations and covers), holding all the informations the database needs in the "movieinfo"-table separated with semicolons. then i setup mediaportal to use the folders witch contain my movies (i named them 0001_moviename, 0002_moviename,0003_moviename ... i used the numbers from ant movie catalog). next in sqlite browser i deleted the "movieinfo"-table after writing down the datatypes used in the table ('cause the sqlite browser seems to be unable of importing data into an existing table :( ). then i imported my textfile into a new table, naming it "movieinfo". the field names an types i changed to the original ones (i prepended the fieldnames from database in my textfile, so i haven't to change the tablefieldnames in sqllite browser by hand). finally i had a table, looking just like the original "movieinfo"-table but filled with nice informations from ant movie catalog. i was happy...till ...i opened mediaportal navigated to a movie and pressed F3. almost every information i inserted into the database was gone and replaced with "unknown" (i checked it in the sqlite browser). i'm really not into xml,html,sql and this stuff, so i don't know whats going on. perhaps someone has a few tips for me? i read about a ODBC driver in the forums in conjunction with excel or access, perhaps i try this one time, 'cause handling the database within sqlite browser or mediaportal setup is really tricky. regards [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
fill databases with existing content
Contact us
RSS
Top
Bottom