Exporting Page Titles and their Content for eBook
Permalink
I set up a Concrete5 website for my wife for her curriculum. She is almost finished adding all her pages.
Now people want an eBook as well. I need to export all the content in a comprehensive way so I can edit in Word. Does anyone have a SQL statement for joining and exporting the page content and their respective titles? Please include any statements that would grab only approved content, since this would be the pages that currently show on the website.
Also, if you don't know the SQL statement to use, do you know which tables I can grab the data from, and which ID's I need to reference the content and page titles with?
Thanks in advance...
Now people want an eBook as well. I need to export all the content in a comprehensive way so I can edit in Word. Does anyone have a SQL statement for joining and exporting the page content and their respective titles? Please include any statements that would grab only approved content, since this would be the pages that currently show on the website.
Also, if you don't know the SQL statement to use, do you know which tables I can grab the data from, and which ID's I need to reference the content and page titles with?
Thanks in advance...
It's not exactly what you're asking for but it might be a more manageable solution.
There's an add-on that allows to save an area to pdf (http://www.concrete5.org/marketplace/addons/save-area-to-pdf/)
I'm telling you about this for 2 reasons. First looking through the code can show you how to get content from a page through the C5 api. Second, developing something that gets info directly from the database might get you in trouble later on if updating C5 and the structure of the db changed.
Anyway, hope it helps.