Data export to Excel


#1

Hi! Is there any possibility to export user profile data to excel sheet including custom fields?


#2

Not built-in. You could use the conduit user.search API to pull this information and convert it to CSV for import to Excel.


#3

oh thanks. Could I expect such feature to be built-in in the future then?


#4

Seems pretty unlikely to me, but I can’t speak for Phacility.


#5

Probably part of Facts will have some sort of export for queries and charts you make there. No plans on when though.


#6

Is there any way to export data directly from database?


#7

The database is just MySQL (or MySQL-compatible), so exporting data should actually be fairly trivial as long as you have database read access; I actually generate a number of reports at work that span both our old bugtracker (FogBugz) and our new one (Maniphest within Phabricator) partially using this, in edge cases where the conduit API doesn’t get me to the info I want easily or honestly sometimes when I’m just a bit too lazy to look up how to do something via Conduit (since I’m quite comfortable in MySQL).

IIRC the MySQL commandline client even spits out results in tab-separated form, so just piping the output of a query against the phabricator_user table to a .tsv file and you’ve already got a spreadsheet :slight_smile: (Excel will open TSV files just fine, as will LibreOffice and Google Sheets and such.) And of course, many MySQL/MariaDB GUI clients will export results as spreadsheets of various formats too :slight_smile: