•  
     
    story #12345 export results to csv
Summary
Empty
export results to csv

I can do my own computation and stuff

Functional overview

Export is done with a click on a button near the result table.

On Click of the export button, a csv file is generated and proposed to be downloaded. The export can be long and generate large files.

What is exported

  • The data set corresponds to the ALL the artifacts that match the query (no pagination of results)
  • Fields that are covered
    • Always there fields
      • project label
      • tracker label
      • last update date
      • last update by
      • submission date
      • submitted by
      • artifact id
    • Semantics
      • Status
      • Title
      • Description
    • Fields "by duck typing" that are present in at least two selected trackers
      • String
      • Text
      • Integer
      • Float
      • Dates (with or without time)

What is "export by duck typing" ?

As data will be exported from several projects, the content might not be consistent. In order to get a result that "mean" something, for "general fields" (not always there fields or semantics) the export will consider that 2 fields are the same if

  • They have the same name (label might be different)
  • They have the same type (int, float, etc).

All other fields will be ignored (that is to say, if one field is present in only one tracker it won't be exported).

WARNING: it's likely that big query with large number of results and/or large number of computed fields might not be able to generate the file is a "human acceptable" time. This story doesn't cover this use case and this should be treated in a dedicated story once we collect enough information how it behaves on "real" data sets.

Technical overview

Export is done with a dedicated CSV endpoint which is paginated.

How to build the result

  • 1 query for Always There Fields + Sementics
  • + N queries per "extra" field
  • + M queries per artifact and per computed field

Will be done in later stories

  • Exporting Single value list (eg. select box and radio button): see story #12523: Export single-value list fields to CSV
  • Exporting Computed fields (not by default, it's an option that user must activate like a checkbox)
Empty
Empty
Status
Done
Development
Empty
Empty
Details
#12345
Manuel Vacelet (vaceletm)
2018-11-15 16:52
2018-10-02 11:27
3659

References

List of items referenced by or referencing this item.

Follow-ups

  • User avatar
    Updated AC to reflect what has been implemented

    • Acceptance criteria
  • User avatar
    • Acceptance criteria
    • Status changed from On going to Done
  • User avatar
    gerrit #13055 integrated into Tuleap 10.6.99.146
  • User avatar
    gerrit #13048 integrated into Tuleap 10.6.99.140
  • User avatar
    gerrit #13042 integrated into 10.6.99.135
  • User avatar
    gerrit #13015 integrated into Tuleap 10.6.99.124
  • User avatar
    gerrit #12996 integrated into Tuleap 10.6.99.95
  • User avatar
    gerrit #12992 integrated into Tuleap 10.6.99.93
  • User avatar
    gerrit #12991 integrated into Tuleap 10.6.99.90
  • User avatar
    gerrit #12983 integrated into Tuleap 10.6.99.84
  • User avatar
    gerrit #12980 integrated into Tuleap 10.6.99.82
  • User avatar
    gerrit #12963 integrated into Tuleap 10.6.99.70
  • User avatar
    gerrit #12960 integrated into Tuleap 10.6.99.62
  • User avatar
    gerrit #12946 integrated into Tuleap 10.6.99.61
  • User avatar
    gerrit #12920 integrated into Tuleap 10.6.99.60
  • User avatar
    gerrit #12939 integrated into Tuleap 10.6.99.52
  • User avatar
    gerrit #12942 integrated into Tuleap 10.6.99.51
  • User avatar
    gerrit #12934 integrated into Tuleap 10.6.99.45
  • User avatar
    gerrit #12921 integrated into Tuleap 10.6.99.42
  • User avatar

    gerrit #12915 integrated in Tuleap 10.6.99.31

  • User avatar
    gerrit #12913 integrated into Tuleap 10.6.99.29
  • User avatar
    gerrit #12908 integrated into Tuleap 10.6.99.25

    • Status changed from To be done to On going
  • User avatar
    gerrit #12907 integrated into Tuleap 10.6.99.23
  • User avatar
    • Acceptance criteria
  • User avatar
    • So that
    • Acceptance criteria