Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

In a copied board, how do I mark all the cards incomplete?

Seems this would be a natural need.

Multiselect for Trello is great if you want to mark multiple cards complete however it does not act as a toggle so once marked complete, that's how it stays.

Been looking at various export to CSV and Excel extensions and different ones export differing data elements. Found only one that exports Completion status.

All well and good however, there seems to be far less support out there from importing into Trello.

Would really like to steer clear of Zapier (too complicated for the size of the board).

And another import extension starts at $10/mo. My need just doesn't rise to that level.

One would think there is a more elegant way to extend on the multi-row copy and paste within a list feature.

Any other approaches to this deceptively simple requirement?

Thank you in advance!

1 answer

1 accepted

0 votes
Answer accepted
Iain Dooley Community Leader Sep 24, 2020

@Eric Rosen so the issue is that you want to copy a board, and then on the copied board, for each card, mark the due date on the card as incomplete?

@Iain Dooley yes, that is correct. Once they are all marked incomplete, I would go about changing the dates of the cards while keeping their times of day. If there are ways to automatically shift all the dates by the same number of days without affecting their times, that too would be a huge time-saver.

Iain Dooley Community Leader Sep 25, 2020

@Eric Rosen here is a Trellinator function that would do it:

https://gist.github.com/iaindooley/f9eb194c8925092ed53abbeb40b81235

You can run it here in BenkoBot:

https://app.benkobot.com/

Just update the board names at the top. There's no feature for saving code in BenkoBot currently but you could save a link to that snippet and use it to copy your board and update the due dates when required.

Like Eric Rosen likes this

So elegant it's mind-boggling that no extensions or power-ups cover this contingency. Thank you, Iain.

Like Iain Dooley likes this

@Iain Dooley  finally getting around to applying this script on a newly copied board. I can find my API key and generate a token however, when I click the Go button, I get this message....

Failed to fetch undefined

Any advice or workarounds?

Thank you in advance.

Iain Dooley Community Leader Nov 15, 2020

@Eric Rosen I've reported the issue to my frontend dev and will let you know as soon as you can run it again, sorry for the hassle!

Iain Dooley Community Leader Nov 15, 2020

@Eric Rosen this should be resolved now, can you try again? Sorry for the hassle.

@Iain Dooley 

Got passed login.

The new board will have fewer cards and one less list relative to the old board.

Will that break anything?

Here's the code and the error response...

var board_name = "_DysbiosisDiet-Aug2020";//change this name
var new_name = "_DysbiosisDiet-NovDec2020";//change this name

////////don't change anything below here/////////
new Trellinator().board(board_name).copy(new_name).cards().each(function(card)
{
card
.markDueDateIncomplete()
.setDue(new Date(card.due()).addDays(85));//will leave time the same
});

Mentions to my member name, key and token are edited to maintain privacy...

Error: Server responded to https://api.trello.com/1/members/ER6/boards?filter=open&fields=all&lists=open&memberships=none&organization_fields=name%2CdisplayName&key=KEY&token=TOKEN with status code 504:
Response Timeout

Error: Server responded to https://api.trello.com/1/members/ER6/boards?filter=open&fields=all&lists=open&memberships=none&organization_fields=name%2CdisplayName&key=KEY&token=TOKEN with status code 504:
Response Timeout
at Response.getBody (/home/alpine/benkobot/node_modules/http-response-object/lib/index.js:41:23)
at Object.base.apply (/home/alpine/benkobot/node_modules/vm2/lib/contextify.js:620:32)
at Function.HttpApi.call (vm.js:5201:27)
at Function.TrelloApi.get (vm.js:8267:20)
at Trellinator.Member.boards (vm.js:6491:64)
at Trellinator.Member.board (vm.js:6473:21)
at module.exports (vm.js:8384:19)
at Object.base.apply (/home/alpine/benkobot/node_modules/vm2/lib/contextify.js:228:34)
at Socket.<anonymous> (/home/alpine/benkobot/benkobot.js:406:21)
at emitNone (events.js:111:20)

from: https://api.trello.com/1/members/ER6/boards?filter=open&fields=all&lists=open&memberships=none&organization_fields=name%2CdisplayName&key=KEY&token=TOKEN params: {}

STACK: Error: Whoops!
at Function.Trellinator.getStack (vm.js:338:11)
at new InvalidRequestException (vm.js:5071:44)
at Function.HttpApi.call (vm.js:5209:11)
at Function.TrelloApi.get (vm.js:8267:20)
at Trellinator.Member.boards (vm.js:6491:64)
at Trellinator.Member.board (vm.js:6473:21)
at module.exports (vm.js:8384:19)
at Object.base.apply (/home/alpine/benkobot/node_modules/vm2/lib/contextify.js:228:34)
at Socket.<anonymous> (/home/alpine/benkobot/benkobot.js:406:21)
at emitNone (events.js:111:20)

undefined

@Iain Dooley I had one fundamental misunderstanding about the functioning of the code and now "get it." Unfortunately, Benko now tells me "quota exceeded." Can we reset that? One more attempt with my clearer understanding and I think all will work out :)

Iain Dooley Community Leader Nov 16, 2020

@Eric Rosen okay I've set you back to 0 seconds used :) let me know how you go! I don't think you should have received a 504 response timeout error regardless so it does seem odd ... 

@Iain Dooley I'm still getting quota exceeded. Do I need to clear cookies or something?

Iain Dooley Community Leader Nov 18, 2020

@Eric Rosen I think I see the problem -- it holds the job and re-executes it, but then it tells you every time that the quota was exceeded, and so any response you get from your job then ends up being drowned out by "quota exceeded" messages :) I've stopped that auto retry now so it just holds the job in a paused state to be restarted when your quota is replenished, and I've cleared out the messages from the queue.

I'm not sure what you're doing to use up the quota so much! At any rate I have given you an extra 10 minutes so you can at least finish running this job and see how it works :) If you're wanting to keep using it you'll probably need to get a paid plan. We have a "PAYG credit" plan that means you can just use it whenever you need it with no monthly payment. Email team@benkoworks.com for more info.

@Iain Dooley Thank you for all the assistances and accommodations you've provided me. Before making the next and hopefully final attempt, please allow me to ask a couple of questions so if any setup on my end needs to happen before running the code, I can take the appropriate steps.

Overall, how uniform does the code expect the cards in the source board to be? For example...

Does the code assume every card has a due date? 

Will it duplicate cards that don't have a due date and be able to keep going?

If a card has an attachment, will that matter?

I edited the "7" in the code to be "86" given the age of the due dates in the source board. Will that cause anything to break or will the expected date shifts be processed as expected?

Asking these questions so as not to require any more troubleshooting time as you've been altogether gracious and I very much appreciate the labor-saving this makes possible.

Iain Dooley Community Leader Nov 18, 2020

@Eric Rosen 

> Does the code assume every card has a due date? 

Currently yes but you could add a check:

if(card.due())

> Will it duplicate cards that don't have a due date and be able to keep going?

The cards are copied when the board is copied

> If a card has an attachment, will that matter?

Nope, attachments will have no impact

> I edited the "7" in the code to be "86" given the age of the due dates in the source board. Will that cause anything to break or will the expected date shifts be processed as expected?

No that's fine, it's "just a number" as they say

@Iain Dooley . Worked like a charm. Thank you, kindly :)

Like Iain Dooley likes this
Iain Dooley Community Leader Nov 19, 2020

@Eric Rosen Glad to hear it!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Trello

Taco Tuesday: Your favorite Trello blog takeaway

Hello friends! From the community that brought you Welcome Wednesday, Throwback Thursday and Friday Fun, welcome to Taco Tuesday, a weekly discussion about all things Trello. The best part? One Tac...

393 views 14 12
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you