BuddyPress.org

Thanks for the answers.

Taking it a bit further… I played around with the wpDataTables plugin which allows me to enter SQL queries into an interface and display database info into a table with options to export as PDF or CSV. The problem arises if I use BuddyPress XProfile Data plugin. Serialized array and SQL.

I also looked at Gravity Forms (with the User Registration Add-On). This handshakes with BuddyPress. GravityView, an additional plugin, allows me to access, extract, and display serialized data from the database, and then generate the desired PDF and CSV Membership Directory. A bit clunky, but then as luck would have it, there are conflicts with my theme (TwentyThirteen). When initially visiting the site, a manual refresh of the page needs to be done in order for GravityView’s search page to display correctly. And then the desired output (PDF + CSV) is garbled. TwentyThirteen is the only theme it will do it on. I’ve tried a CSS reset in the core css files to no avail. I’m running a TwentyThirteen child theme with a separate BP stack.

So this brings me to a PHP solution for which I’m sketchy. I could either do some sort of cron job periodically and unserialize the xprofile data and insert it into a new table. That would let me access it via SQL Query and the original wpDataTables plugin. This would peridocially update any new additions to my BuddyPress Membership into an unserialized table.

The better solution is to do it all with PHP. I now have the FPDF class up and running. I’m generating sample PDF output. So from my PHP script, I’m “requiring” fpdf.php and also an “include” for another php file to open a connection to MySQL.

Now I’m to the point where I need info and help as to construct the code and read serialized data into my newly created file to generate the PDF (i.e. “sql2pdf.php).

Thanks in advance.