Include tags in the export file

Brian Koehler's Avatar

Brian Koehler

12 Jul, 2010 03:10 PM

I read in the past discussions that you werre going to add tags to the export file. That was July 2009! Are you really going to implement it or did you just want to close the ticket so your open ticket count goes down?

Since you do not allow custom fields, it is very difficult to export the tickets and see which ones are associated to specific tags. I realize I could sort for each one, but that doesn't help me, I need to count the open tickets for combination of tags. I think each taggs should be separated by commas so we can leverage excel sorting easier.

  1. 1 Posted by Nicole on 20 Jul, 2010 01:48 AM

    Nicole's Avatar

    Brian -

    Tags are part of the export file (http://itrgroup.lighthouseapp.com/export), but it appears somehow they were overlooked on the project level CSV file. Thanks for pointing that out to us and we'll update for the next deploy.

    Thanks,
    Nicole

  2. 2 Posted by Brian Koehler on 23 Sep, 2010 03:26 PM

    Brian Koehler's Avatar

    Nicole,

    Do you know when this will be fixed?

  3. 3 Posted by Nicole on 23 Sep, 2010 05:03 PM

    Nicole's Avatar

    Brian -

    I'll see what the ETA is and get back to you today.

    Thanks,
    Nicole

  4. 4 Posted by Nicole on 27 Sep, 2010 05:04 PM

    Nicole's Avatar

    Brian -

    Tags as part of the CSV export has been deployed. Thanks for your patience!

    Nicole

  5. Nicole closed this discussion on 27 Sep, 2010 05:04 PM.

  6. Brian Koehler re-opened this discussion on 27 Sep, 2010 06:29 PM

  7. 5 Posted by Brian Koehler on 27 Sep, 2010 06:29 PM

    Brian Koehler's Avatar

    Nicole,

    I tried the export, it does contain the tags, but unfortunately when there are multiple tags, I can't use it with Excel. My goal is to count how many tickets are open for each tag. I am not aware of any excel command to count if a cell "contains" a value versus equals a value.

    I tried using spaces but that messes up the rest of the export.

    Can you have each tag separated by a comma? This makes importing into excel easy. Even if the heading is off that is okay.

    Thanks,

    Brian Koehler, PMP
    ITR Group Inc.
    651-757-4525

    -----Original Message-----
    From: Nicole [mailto:[email blocked]]
    Sent: Monday, September 27, 2010 12:06 PM
    To: Brian Koehler
    Subject: Re: Include tags in the export file [Suggestions]

  8. Support Staff 6 Posted by Tiger Team on 27 Sep, 2010 07:13 PM

    Tiger Team's Avatar

    Unfortunately the file is a CSV file, so it's already separated by
    commas. Also, tags can be two words with a space - e.g., "Version 2.0"
    - so your tag list will look like `ui bugs "Version 2.0" launch`

    For excel, have you used the 'countif' function?

  9. Support Staff 7 Posted by Tiger Team on 27 Sep, 2010 07:14 PM

    Tiger Team's Avatar

    http://office.microsoft.com/en-au/excel-help/countif-HP005209029.aspx
    has some functions that look pretty much like what you want here.

  10. 8 Posted by Brian Koehler on 27 Sep, 2010 07:43 PM

    Brian Koehler's Avatar

    Yes I have used the count if function. I appreciate you helping with this. However, one of the limits with Excel you cannot count if there are two values in a cell. All their examples have one value in the cell. Since there are multiple tags in the export field I have a work around. I convert using comma, then delete all columns except tags. Save it, then open with spaces as a delimiter, then I get the single values in each cell.

    Example:

    Column A
    tag1
    tag2
    tag1 tag2

    if you use the expression: countif(A1:A3,"tag1") you will only get a return of 1 not 2.
    I am not aware of how to use the countif command with a "contains" function.

    Also I don't believe tags can have spaces in lighthouse, at least we don't allow them in our tagging.

    Thanks,

    Brian Koehler, PMP
    ITR Group Inc.
    651-757-4525

    -----Original Message-----
    From: Court3nay [mailto:[email blocked]]
    Sent: Monday, September 27, 2010 2:16 PM
    To: Brian Koehler
    Subject: Re: Include tags in the export file [Suggestions]

  11. Support Staff 9 Posted by Tiger Team on 27 Sep, 2010 09:13 PM

    Tiger Team's Avatar

    A few options:

    - you can use "Text to Columns" to split the tags column into multiple
    columns without messing with the CSV file.

    - If you want to do this regularly, you could also build your tag list
    with something like this:

    https://spreadsheets.google.com/ccc?key=0AsxdtgWhAZ2HdC1uMmNic3ppWFpxVExzdmk5SnF5OVE&hl=en&authkey=CIjT5eEO

    Basically it takes a few rows, splits the tags out, and does a count
    of them in your document using a simple uniqueness checker and a
    countif.

    You'll probably use 'lookup' in excel instead of 'index' (they're
    basically equivalent). And I'd put this as Sheet 2, where Sheet 1 is
    your CSV export, so you can just add the sheet to the doc and it
    magically calculates everything. Let me know if you want me to explain
    anything in there.

  12. 10 Posted by Brian Koehler on 27 Sep, 2010 09:24 PM

    Brian Koehler's Avatar

    Courtney,

    Thanks for the help! I am able to get what I want by highlighting the tags column and choosing "data" - "text to columns"

    Thanks,

    Brian Koehler, PMP
    ITR Group Inc.
    651-757-4525

    -----Original Message-----
    From: Court3nay [mailto:[email blocked]]
    Sent: Monday, September 27, 2010 4:15 PM
    To: Brian Koehler
    Subject: Re: Include tags in the export file [Suggestions]

  13. Nicole closed this discussion on 28 Sep, 2010 05:05 PM.

Discussions are closed to public comments.
If you need help with Lighthouse please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac