Export All Issues Data to a table or excel

Added by Meltem Sert almost 7 years ago

Hello all,

I am totally new for redmine and a noob for coding so please keep your answers simple :)
I need a script or plugin to export all the data of our companys redmine to a table with the columns in the attachmenent.

Is it possible to do that and if yes how?

All help will be highly appreciated.

Thanks in advance.

T&R,
Meltem

Replies (6)

RE: Export All Issues Data to a table or excel - Added by Kush Suryavanshi over 6 years ago

I guess this has already been sorted for you now. If not, you can just export the data to csv and then open it in excel. Other alternative is generate the report directly through database.

RE: Export All Issues Data to a table or excel - Added by Thierno diallo over 4 years ago

Je suis nouveau sur redmine, je voudrais savoir comment faire pour exporter la base de données de notre entreprise cad les tables, les colonnes et les relations entre les tables.
Si vous pouvez menvoyer un code ou un plugins pr ca svp ?

I'm new to Redmine, I would like to know how to export the database of our company CAD the tables, columns and relations between the tables.
If you can menvoyer a code or plugins ?

Thanks in advance.

Thier

RE: Export All Issues Data to a table or excel - Added by Martin Denizet (redmine.org team member) over 4 years ago

Hello,
Pourquoi ne pas utiliser directment mysqldump ou pg_dump (en fonction du système de base de donnée utilisé)?
Vous trouverez des instructions précises dans la doc et sur internet.
NB: les fichiers ne sont pas contenus dans une sauvegarde de la base de donnée!

Why no use directly mysqldump or pg_dump (according to the RDBMS you installed)?
Please check out the documentation and internet for instructions.
Please note: files attachments are not embedded in DB dumps!
Cheers,

RE: Export All Issues Data to a table or excel - Added by Thierno diallo over 4 years ago

Martin Denizet
Merci pour votre réponse

Mai comme je suis trop nouveau méme en info
est c k vous pouvez m'expliquer mysqldump en quelque ligne
et comment sa fonctionne et est ce qu'on peut l'utliser sous windows

Bc,

RE: Export All Issues Data to a table or excel - Added by Martin Denizet (redmine.org team member) over 4 years ago

Please have a look on YouTube for detailed tutorials.
If the DBs you want to backup are on your local Windows machine, you may try using a GUI tool like MySQL Workbench (mysql-workbench-community-6.3.10-winx64.msi the link at the very bottom). With Workbench, your backup is mere clicks away :)
Cheers,

(1-6/6)