Hello!
I would like to export the flexicontent articles in an easy way. For this, we can use the component "SQL 2 EXCEL" (
joomla-r-us.com
).
I would need an SQL query that make the content readable:
- title
- description
- fields
Everything we see on the website frontend.
On the same sheet, fields in columns and rows.
As I am not an SQL export (faaar from that), I don't know how to sort this, what SQL query to use.
Now, I use the "jos_flexicontent_items_ext" table, as the whole article is printed, but the result is not optimal, as all the content is in the same cell.
Thank you very much!
The request I use to display the table:
SELECT type_id,language,search_index
FROM `jos_flexicontent_items_ext`
WHERE `language` = 'fr-FR'
ORDER BY `jos_flexicontent_items_ext`.`type_id` ASC