GolfSpy STUDque Posted March 5, 2019 Share Posted March 5, 2019 Hey Guys, Hope someone is able to help. I searched the community and was unable to find exactly what I'm seeking so I'm going a new thread will get us there. We'd like to query the database to return Excel spreadsheets based on certain values we'll assign in the query. Would like these queries to look in specific Topics as well as in polls. I have limited technical expertise but one of the staffers has a background in programming...just not specific to IPB. Is there a step by step tutorial available for this? Link to comment Share on other sites More sharing options...
Clover13 Posted March 5, 2019 Share Posted March 5, 2019 I don't know of any technical documentation from Invision Community that shows the table structure DDL, RI, etc for IPS. Your resource will need to learn the IPS DB table structures and relationships by looking through your MySQL DB via PHPMyAdmin or something similar. To export, your resource will need to write queries to export to CSV, which can then be imported or opened directly with Excel. See the following StackOverflow post on the approach: https://stackoverflow.com/questions/10295228/exporting-results-of-a-mysql-query-to-excel Link to comment Share on other sites More sharing options...
bfarber Posted March 5, 2019 Share Posted March 5, 2019 Topic data is stored in "(table-prefix)forums_topics" and poll data is mostly stored in "(table-prefix)core_polls". Your technical contact can use phpmyadmin to export the contents of these tables to CSV for manipulation in Excel, etc. Link to comment Share on other sites More sharing options...
GolfSpy STUDque Posted March 13, 2019 Author Share Posted March 13, 2019 Thanks for the help guys. I forwarded your responses along and will come back if we have additional questions. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.