Uploaded image for project: 'Xporter for Jira'
  1. Xporter for Jira
  2. XPORTER-873

Trouble with SLA custom fields in excel export

    XporterXMLWordPrintable

Details

    • R5.1.0 Sprint 3, R5.6.0 Sprint 1
    • OK

    Description

      Hi Xpand-team

      I'm having some trouble with integrating SLA Custom Fields into a template.
      If you reference a SLA Custom Field in an excel export you receive something like this:

      _SLAValue{completeSLAData=[CompleteSLAData

      {calendarName=Schedule 4/5 9-17 Mo-Fr, succeeded=true, goalTime=86400000, elapsedTime=3515590, startTime=2016-10-11T11:40:29.341Z, stopTime=2016-10-11T12:39:04.931Z}

      ], timeline=Timeline{events=[TimelineEvent

      {date=2016-10-11T11:40:29.341Z, types=[START]}

      , TimelineEvent

      {date=2016-10-11T12:39:04.931Z, types=[STOP]}

      ]}, ongoingSLAData=null, metricId=8, definitionChangeDate=2016-02-16T13:47:58.000Z, definitionChangeMsEpoch=1455630478290, goalsChangeDate=null, goalsChangeMsEpoch=null, goalTimeUpdatedDate=null, goalTimeUpdatedMsEpoch=null, metricCreatedDate=0}_

      The field contains all relevant information but in a not very user friendly way. Would there be a way to render these fields like JIRA does? I tried to work with some excel functions but this did not work properly.

      Thank you for your help!

      Attachments

        1. XPTST-30.docx
          12 kB
          Pedro Rodrigues
        2. XPTST-30.xlsx
          9 kB
          Pedro Rodrigues

        Activity

          People

            tfsi Tiago Silva [X] (Inactive)
            c.brause Carola Brause
            Votes:
            2 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 2 days
                2d
                Remaining:
                Time Spent - 1 day, 5 hours, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                2h 30m
                Logged:
                Time Spent - 1 day, 5 hours, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                1d 5h 30m