paddy75 14 Posted July 21, 2019 Share Posted July 21, 2019 Hello all, i wanna connect to the emby database with odbc in windows. My intension is to build my own frontend in Microsoft Access to print out movie lists. Is there any documentation about the tables? I could connect to it but i could not see very helpful information in it to get movie names, years ect. Regards, Patrick Link to comment Share on other sites More sharing options...
Luke 37051 Posted July 21, 2019 Share Posted July 21, 2019 There isn't, sorry. I would suggest using the API instead. Link to comment Share on other sites More sharing options...
Happy2Play 8279 Posted July 21, 2019 Share Posted July 21, 2019 You can export your library to excel or csv with the Reports plugin. Then just eliminate the column you don't needed. Link to comment Share on other sites More sharing options...
paddy75 14 Posted July 21, 2019 Author Share Posted July 21, 2019 I know that it is possible to export in excel, but it's not what I looking for. Here I can't get the path for the covers or anything else. I think to use the API I must be a developer to use and understand it and to connect by ODBC it's much easier. Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted July 21, 2019 Share Posted July 21, 2019 To get what you probably want with either the APi or ODBC will require you to understand the db structure to extract what you want download "DB Browser for Sqlite" and you can open the Library.db file (with Emby server off) and view the db structure and data within If you go the API route - check out "swagger" which is built into the Emby server - from the dashboard page - click the "API" link at the bottom of the page and have a read of the API WIKI https://github.com/MediaBrowser/Emby/wiki Link to comment Share on other sites More sharing options...
paddy75 14 Posted July 21, 2019 Author Share Posted July 21, 2019 (edited) I watched the structure with a db browser. But it was not possible for me to see real movie names or similar. Only GUIDS, id's are visible. Don't know or see where the movies are listed. Must corrct myself now. When I order the column "Name" i can see what i want to. So trying now to go ahead. Edited July 21, 2019 by paddy75 Link to comment Share on other sites More sharing options...
ebr 14910 Posted July 21, 2019 Share Posted July 21, 2019 Just keep in mind that anything you create like this could break at any time. Using the API will keep that from happening. Link to comment Share on other sites More sharing options...
gnollo 16 Posted June 12, 2020 Share Posted June 12, 2020 On 7/21/2019 at 10:30 AM, PenkethBoy said: To get what you probably want with either the APi or ODBC will require you to understand the db structure to extract what you want download "DB Browser for Sqlite" and you can open the Library.db file (with Emby server off) and view the db structure and data within If you go the API route - check out "swagger" which is built into the Emby server - from the dashboard page - click the "API" link at the bottom of the page and have a read of the API WIKI https://github.com/MediaBrowser/Emby/wiki I have an emby docker, which I stopped, and tried to access Appdata\Embyserver\Data\library.db with DB Browser for Sqlite, but it says "could not open database file: reason unable to open database file". Any ideas on how I can access it? I am looking to interrogate the database to extract a list of actors with no pictures. Link to comment Share on other sites More sharing options...
ebr 14910 Posted June 12, 2020 Share Posted June 12, 2020 If the server is running it probably has it locked. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now