String studio = reader.ToString() Ĭatalog.SetVideoFileExtendedProperty(video_id, "studio", studio) Once we have the video created we get the id of the newly created video and can use that to set the extended properties.Ĭatalog.SetVideoFileExtendedProperty(video_id, "year", year) Int video_id = catalog.AddVideo(path, name, 0, description, 0, 0, url, null, 0, null, null)
Then we read each line of the movie table in the database to create video entries.
Var catalog = scripting.GetVideoCatalogService() Ĭatalog.SetPropertyMeta("video_property", "year", "edit") Ĭatalog.SetPropertyMeta("video_property", "studio", "edit") Ĭatalog.SetPropertyMeta("video_property", "trailer", "edit") Ĭatalog.SetPropertyMeta("video_property", "length", "edit") Ĭatalog.SetPropertyMeta("video_property", "comments", "edit") But, since you can add your own properties in Fast video cataloger we will also do that for these properties. Some of the properties in All my movies are not in the list of default video properties. Next we create some new extended properties for the catalog. OleDbCommand command = new OleDbCommand("SELECT * from movies", connection) OleDbConnection connection = new Source=" + dlg.FileName + Id=admin Password = ") We then open the database file and runs a simple SQL query to get everything from the movies table in the database. dlg = new () ĭlg.FileName = "access" // Default file nameĭlg.DefaultExt = ".mdb" // Default file extensionĭlg.Filter = "mdb file (.mdb)|*.mdb|AllMyMovies file (.amm)|*.amm|All files (.*)|*.*" // Filter files by extension If you want to expand on this script you should split it up into a number of functions and you should add error handling.įirst we show a dialog to let the user pick the All my movies database file to read from: To make it easy to follow I have put it all in the entry function. The script to import videos is pretty straight forward.
Since Fast video cataloger is a 64 bit program make sure you install the 64 bit version of the database engine. To be able to read the Access database in a program you need to install the Access database engine.
mdb you can load it straight into Access and have a closer look at the data. Database formatĪll my movies uses an Access database with the extension set as. The full script is included at the end, simply load the script into the script window in Fast video cataloger and run it.
This sample script shows how to use the scripting support in Fast video cataloger to import data from an All my movies database. If you compare to Fast video cataloger the focus of All my movies is toward collecting movies while Fast video cataloger is geared toward organizing any type of video clips you have on your computer or in your organisation. It also let you track and rate movies you have watched. It downloads movie data from the imdb database and many other services ( ). Import videos from All My Movies by BoildeSoftīy fredrik lonn | | Scripts All my moviesĪll My Movies by Boildesoft ( ) is a software that lets you manage your collection of bought movies.