Reply to thread

Message

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

<blockquote data-quote="pStar" data-source="post: 25068" data-attributes="member: 14359">hi everyonei 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 &quot;movieinfo&quot;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 &quot;movieinfo&quot;-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&nbsp; from ant movie catalog). next in sqlite browser i deleted the &quot;movieinfo&quot;-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&nbsp; &nbsp; :(" loading="lazy" data-shortname=":(" /> ). then i imported my textfile into a new table, naming it &quot;movieinfo&quot;. 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 &quot;movieinfo&quot;-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 &quot;unknown&quot; (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</blockquote>

[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]