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
Watch / Listen Media
watch/edit Videos
Movie Database - Import My Own Data?
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="ckcomm" data-source="post: 176015" data-attributes="member: 54553"><p>I have a bunch of home movies I'd like to catalog and watch using My Videos. I have data about them in Excel (and I've also ported it to Access). I'm hoping to import this data into the "VideoDatabasev5.db3" database.</p><p></p><p>I have slavishly conformed to the table structure of this database with my data (after browsing the data that MediaPortal itself adds when doing an IMDB scan).</p><p></p><p>I then import my data using a third party solution, the SQLite Data Wizard from SQL Maestro (which seems to have a problem with Excel data sources, so I have to convert my Excel data to an Access database first).</p><p></p><p>I do the import into a blank database (which I create using the "Reset Database" command from MediaPortal Setup). When I browse the tables with the SQLite Database Browser, the new data is there, and looks good.</p><p></p><p>But when I run MediaPortal, none of these entries appear when I choose to View "by Title". When I view "by Share", the files appear - but as far as I can tell, "by Title" populates its list based on the database contents and "by Share" populates its list based on the contents of a directory.</p><p></p><p>So it seems that something is preventing MediaPortal from considering these additions to be valid records, but I can't for the life of me figure out what it is. When I add records manually using the SQLite Database Browser, they seem to be recognized by MediaPortal (even though they look identical to the ones that are imported) - so I'm stumped.</p><p></p><p>Does anyone have any experience with this? Any suggestions would be greatly appreciated.</p></blockquote><p></p>
[QUOTE="ckcomm, post: 176015, member: 54553"] I have a bunch of home movies I'd like to catalog and watch using My Videos. I have data about them in Excel (and I've also ported it to Access). I'm hoping to import this data into the "VideoDatabasev5.db3" database. I have slavishly conformed to the table structure of this database with my data (after browsing the data that MediaPortal itself adds when doing an IMDB scan). I then import my data using a third party solution, the SQLite Data Wizard from SQL Maestro (which seems to have a problem with Excel data sources, so I have to convert my Excel data to an Access database first). I do the import into a blank database (which I create using the "Reset Database" command from MediaPortal Setup). When I browse the tables with the SQLite Database Browser, the new data is there, and looks good. But when I run MediaPortal, none of these entries appear when I choose to View "by Title". When I view "by Share", the files appear - but as far as I can tell, "by Title" populates its list based on the database contents and "by Share" populates its list based on the contents of a directory. So it seems that something is preventing MediaPortal from considering these additions to be valid records, but I can't for the life of me figure out what it is. When I add records manually using the SQLite Database Browser, they seem to be recognized by MediaPortal (even though they look identical to the ones that are imported) - so I'm stumped. Does anyone have any experience with this? Any suggestions would be greatly appreciated. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Watch / Listen Media
watch/edit Videos
Movie Database - Import My Own Data?
Contact us
RSS
Top
Bottom