What is ItemID in the metadata, and how do I create one?

Legacy 2nd gen Apple TV
1

In the “com.firecore.media.meta.db” file, in the "meta_movie "table each has a unique “ItemID” which looks like an MD5 of something. What is it an MD5 of? I would like to create my own table entries to more quickly insert and sync metadata into this file. But I need to know what ItemID I should be using and how to create my own when I add files to a share.

Thanks

2

Ping.

I would really like to know because it is much faster using the exported tvdb database to fill the media player metadata and maintain synchronicity.

3

No reply yet, but I figured it out. For anyone else that wonders in the future it is the MD5 of the string of the file with proper capitalization as it exists on disk, and replace any spaces with “%20”. The “Path” column is all lowercase so using that string won’t be correct.

example: smb://192.168.1.1/Mount/File.mp4
md5: 9f2d03047d533a8431b6c9a53e240d97

You can then open the .db file in perl and quickly import lots of descriptions and thumbnails from thetvdb or other database dump. ( forums.thetvdb.com/viewtopic.php?f=3&t=7550 )

my $dbh = DBI->connect(“dbi:SQLite:dbname=com.firecore.media.meta.db”,
undef, undef, {RaiseError=>1}) or die $DBI::errstr;
my $sth = $dbh->prepare(“SELECT * FROM meta_movie” );
etc.

If the folder only has 1 file in it the hash is currently of the folder name which is probably incorrect since the file could change, but I posted about this bug in the Bugs forum.