Jump to content

Database Query Help

Recommended Posts

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

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:


Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...