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.
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.