Trello Utilities

Purpose

1. Fetch info from trello todo list
2. Execute some command with cards name in todo list
3. After this, move cards from todo list to ongoing list

References

• https://github.com/jeremytregunna/ruby-trello
• http://www.rubydoc.info/gems/ruby-trello/Trello
• https://larry-price.com/blog/2014/03/20/using-the-trello-api-in-ruby/

Installation

• Install latest ruby (Choose one of below)

  • https://www.ruby-lang.org
  • http://rvm.io

• Download and install dependencies gem packages

  git clone https://github.com/charlietag/trello-utils.git
  bundle install

Configuration

• Apply for Trello token

  • public_key
    • https://trello.com/app-key
  • member_token
    • Assume public_key above is 111111111111111111111
    • https://trello.com/1/authorize?expiration=never&key=111111111111111111111&name=Ruby%20Trello&response_type=token&scope=read%2Cwrite%2Caccount

• Create config file from sample

  cp config/config.yml.sample config/config.yml

• config.yml

  #API token
  public_key:xxxxxxxxxxxxxxxx
  member_token:yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy
  
  # Trello Resource
  trello_account: MyTrelloAccountID #charlie123123
  trello_board: MyBoardName #HelpCenter
  trello_list_todo: MyTodolistName #todo
  trello_list_ongoing: MyOngoingListName #ongoing
  
  # String Type
  # url | text
  # if card.name is a url, parse host only
  string_type: url
  
  # External Command
  # the following example will execute: /script/fetch_data.sh -u www.google.com (assume card.name is "www.google.com"
  # ex. /script/fetch_data.sh -u
  run_command: MyOSCommandOrScriptName

• Start to use

  • Fetch card name and execute external command

    ./trello.rb

  • Analyze trello usage

    ./analyze.rb

Trello API limitation

API Rate Limits

• http://help.trello.com/article/838-api-rate-limits
  • To help prevent strain on Trello’s servers, our API imposes rate limits per API key for all issued tokens.
  • There is a limit of 300 requests per 10 seconds for each API key and no more than 100 requests per 10 second interval for each token.
  • If a request exceeds the limit, Trello will return a 429 error.
• https://developers.trello.com/page/webhooks
  • For some cases, which someone own a callback server online, webhook is much more useful.