Data export arranged as tables

The TroopTrack Developer Program
1

I’m interested in creating some custom reports to track how are Australian Cubs are going with their Boomerang Badges. I thought the offline data from the API would be great but it isn’t returning the data how I thought it would - rather than being a direct table dump (in my 20 year old experience of SQL databases) it seems to have lots of tables/sub tables for each achievement/person.

Is there any easy way to do a table dump so I can import it into Access (or something similar) and fiddle with it?

2

An example of what I find hard to process is this sort of thing:

{
  "file": "achieveLevel2_49_11111",
  "contents": [
    {
      "achievement_id": 11111,
      "name": "Gold Boomerang",
      "purchased": false,
      "user": "Fred Nurk",
      "award_card_front": "",
  "award_card_back": "",
  "award_type_id": 49,
  "user_id": 123456,
  "user_achievement_id": 32345214,
  "descendants": [
    {
      "user_achievement_id": 32345215,
      "achievement_id": 23489,
      "name": "These are compulsory",
      "completed_on": ""
    },
    <etc>
  ],
  "percent_complete": 23,
  "completed_on": "",
  "reported_on": "",
      "approved_on": "",
      "scoutmaster_conference_on": "0001-01-01",
      "review_board_on": "0001-01-01"
    },

From my point of view it would be heaps simpler to just get a list of User Ids and Achievement Ids as one set of data and the achievement detail records as another. Does that make sense?

1 Like
3

Hi @peterm,

Here’s what the boss had to say:

“The API is for consuming in applications and isn’t designed to be a strait import/export tool. Some of our reports provide csv as an export format (if I remember correctly). Maybe you could look and see if there is already a solution for his problem by looking through the reports.”

You may check under Manage > Reports to see if there is a custom or preexisting report you can use.

This one has the scouts and their achievements and may be useful to you:

https://gwscouts.trooptrack.com/achieve/badge_book

4

I’ve looked and looked and looked - there is no way I can find to do what we NEED to do.

I raised it in this idea post:

I’m now trying to achieve that using your API (and failing badly).

I’ve got 24 Cubs doing Boomerang. Each one is missing different things to finish off the badge. The Bronze Boomerang award has 46 different requirements. I’m guessing Silver & Gold would have the same or more.

The only way I can work out which of the 46 bits are missing for each Cub is to go individually into their record and look at it. At that point I’d be transferring it to a paper spreadsheet to visualise it - and if I have to do that then why bother using TroopTrack? It is getting to the point where a Google Docs spreadsheet would be easier to manage for badge tracking.

5

Turns out you have a report which sort of does what I want - “requirement detail report”. For some reason it is hidden away in the Members section rather than the Achieve section. It’s also way down the bottom of the list - off the bottom of my screen. Not sure why I didn’t see it before - the name and location didn’t help.