ginjaninja 605 Posted November 23, 2018 Posted November 23, 2018 I am investigating an issue with people in the database, would be useful to be able to view/export people.
erikblues 4 Posted November 24, 2018 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
Luke 42079 Posted November 24, 2018 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.
Happy2Play 9780 Posted November 24, 2018 Posted November 24, 2018 Very true as I just used the API and pulled the information for 132,181 people.
ginjaninja 605 Posted November 24, 2018 Author 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
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