ginjaninja 537 Posted November 23, 2018 Share Posted November 23, 2018 I am investigating an issue with people in the database, would be useful to be able to view/export people. Link to comment Share on other sites More sharing options...
erikblues 4 Posted November 24, 2018 Share Posted November 24, 2018 What kind of data would you be looking to export? Can you give some examples? Sent from my iPhone using Tapatalk Link to comment Share on other sites More sharing options...
Luke 37096 Posted November 24, 2018 Share Posted November 24, 2018 Considering the size of this wouldn't it be easier to examine the database directly using a sqlite browser. If you try this I always prefer to make a copy rather than opening the original file using another tool. Link to comment Share on other sites More sharing options...
Happy2Play 8296 Posted November 24, 2018 Share Posted November 24, 2018 Very true as I just used the API and pulled the information for 132,181 people. Link to comment Share on other sites More sharing options...
ginjaninja 537 Posted November 24, 2018 Author Share Posted November 24, 2018 (edited) for my purpose, i just need [name], i tried sql lite browser but its not obvious...itempeople table doesnt seem to contain actor names.i rightclicked this table and exported to csv... maybe there is some funky sql i need to know to join to another table? edit i found what i needed under mediaitems table thanks anyway Edited November 24, 2018 by ginjaninja 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