Export option for Projects list

[Santhosh]

It will be good to have export option for "Projects" list. We have export option for "Issues".

Export options for projects with all project fields will be really helpful.

Please consider this request

[Sergey]

Hi Santhosh,

This was actually logged in the past and was closed as 'won't do' unfortunately.

However, the good news is - if you're comfortable running SQL queries -- you can very easily export all your projects into a .csv file

For example

select * from project;

Depending on the tool you use, you should be able to directly export the results into a .csv file.

You can also do it in the actual SQL code, but it'll be a bit more complicated and will depend on the actual database you're running.

A good article on how to export data to csv from various db:

https://support.spatialkey.com/export-data-from-database-to-csv-file/

Hope this helps,

Regards,

Sergey

[Sergey]

Sorry, forgot to mention the feature request URL:

https://jira.atlassian.com/browse/JRASERVER-32859

[RentalHost]

So there is no way to just get the list of names of projects out quickly?  We don't more than just the names.

[elyons]

I selected/copied it from the browser, dumped it to terminal and cleaned it up with vim. Took about 5 minutes. Could use any graphical text editor. Way quicker than sorting out the DB query access/permissions, which most folks don't have at their fingertips.