nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Producing a report providing dates on when cards were moved to a particular column

Peter Cranston_q45l5c

Hi,

One of my clients has asked If I can produce a report providing date when cards are moved to a particular column. He plans to use this as a priority list for his team to complete actions associated with this column.

I am using Trello premium but cannot see how to access this date which is available on the activity at the bottom of the card.

Any guidance much appreciated.

Regards,

Peter C

Accepted answers

Lara

Hi Peter,

Thanks for reaching out!

Right now, the CSV export from Trello Premium doesn't include actions (such as card moves), because there isn't a great way to represent that kind of many-to-one data points in a spreadsheet. That information is available in our JSON export if you have access to an engineer.

We have more info on this here:

Exporting data from Trello: https://support.atlassian.com/trello/docs/exporting-data-from-trello/
Making sense of Trello's JSON export: https://support.atlassian.com/trello/docs/making-sense-of-trellos-json-export/

Please let us know if you have any other questions, and we'll be happy to help.

All the best,

Lara
The Trello Team

All comments

Lara

Hi Peter,

Thanks for reaching out!

We have more info on this here:

Exporting data from Trello: https://support.atlassian.com/trello/docs/exporting-data-from-trello/
Making sense of Trello's JSON export: https://support.atlassian.com/trello/docs/making-sense-of-trellos-json-export/

Please let us know if you have any other questions, and we'll be happy to help.

All the best,

Lara
The Trello Team

Peter Cranston_q45l5c

Thanks for the update,

In the meantime I have managed to get accurate enough information form a NAVE export which provides the duration in seconds that each card has been in a column. A little Excel adjustment and I have my dates.

I will also look at JSON for future requirements.

Many thanks,

Peter C.

Cary Lee_kz74bj

To resurrect this thread, what is the key text to look for in the JSON file that shows that a card has moved? For example, on the card itself, the text would be "<member> moved this card from <LIST 1> to <LIST 2> <date, time>". However, I can't seem to find the relevant string to isolate this (as a first step, to then analyse).

Lara

Hi Cary,

You'll want to look at the updateCard action. Within that, you'll see which member moved the card from original list (listBefore) to destination list (listAfter).

I hope that helps!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

trello