Database Query Help

[GolfSpy STUDque]

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? 

[Clover13]

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

[bfarber]

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.

[GolfSpy STUDque]

Thanks for the help guys. I forwarded your responses along and will come back if we have additional questions.