Ask Your Question

How to export data using PHP to LO

asked 2014-01-05 00:01:30 +0200

Pathy gravatar image

updated 2015-08-27 12:57:29 +0200

Alex Kemp gravatar image

I speak spanish, sorry for my bad english (im using google translate).

I want to export data from preguntas y respuestas (possible spam link removed) using PHP to a document compatible with LO

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2014-01-05 01:25:01 +0200

bencomp gravatar image

The basic way of doing this is, as you mention, reusing or creating a PHP script that exports data (presumingly from the database that the given site runs on) to a file or a set of files that can be opened with LibreOffice. LibreOffice can handle many kinds of file formats — which is the best for you depends on your goal.

You could create a table-like document in CSV (Comma separated values) or TSV (Tab separated values) format and import them in Calc. Or you could save each page as HTML or some XML-based file format like DocBook and open them in Writer. If you have access to the database that is behind the website (for example MySQL or PostgreSQL) from the computer you are using LibreOffice on, you could even use Base to connect to the database and create labels.

Examples of how to use PHP to create documents of any of the above types is, in my opinion, beyond the scope of this Q&A website. You could try to find answers to specific questions about programming with PHP on StackOverflow.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2014-01-05 00:01:30 +0200

Seen: 1,705 times

Last updated: Aug 27 '15