Import your data from and to IA 2.0 / Scoutbook

I’ve exported our troop advancement details from scoutbook, and I get a CSV file of around 4MB. Now when I try to import that file I get a " 413 Request Entity Too Large" message from the site.

How do I go about getting all this data into our site? Is there another way that I can sync the data between Scoutbook?

Thanks,
Dave

I will get this over to the TT admins, no there is no other way to sync data into TT.

1 Like

@TeamPeak, Dave asked that you e-mail him about this dave@trooptrack.com

1 Like

We’ve recently reactivated our girl’s TroopTrack account that we quit using a couple years ago. I’ve added all the new scouts and insured all the BSA ID numbers and names are correct. I’m now trying to bring in all the advancement from Scoutbook, but running into issues.

In Scoutbook, I used the Export/Backup - Advancement option to download a CSV file. When I try to load that in TroopTrack by setting the Type of Import to Ranks I get a number of errors about the column headers.

  • Unrecognized headers: BSA Member ID, Middle Name, Advancement Type, Advancement, Version, Date Completed, Approved, Awarded, MarkedCompletedBy, MarkedCompletedDate, CounselorApprovedBy, CounselorApprovedDate, LeaderApprovedBy, LeaderApprovedDate, AwardedBy, and AwardedDate
  • Missing headers: rank_advancement and completed_on

I then tried Merit Badges and got similar errors.

Can advancement data from Scoutbook be imported into TroopTrack?

Use Type of Import Scoutbook Advancement. Otherwise you have to format the export for the Ranks Import Specifically as shown in the other article.

Thanks for the reply, Aaron. For some reason my eyes didn’t go past Merit Badges and Ranks so I didn’t even notice the Scoutbook options at the bottom of the list. I used Scoutbook Advancement this time and everything imported.

Thanks!

When I try to import the file from trooptrack IA2.0 gives an error “Invalid advancement type:”

Correct there is a problem with the SB importer.

1 Like

I was informed that this issue has been fixed.

My case was recently updated with the same information, but upon attempting another import (with a fresh export from SB), I received the same errors as before, sadly. I’ve provided support with the file used and the list of errors. Hopefully they can resolve it (although we’re into a new year at this point, so it’s less urgent than before)

I just attempted to upload advancements to Scoutbook a few minutes ago. The first time since September 7th. The first file rejected for “Invalid advancement type:” but no further explanation. I then separated merit badges from rank. Merit badge file uploaded with no issues. Rank file rejected again.

| "org.mule.weave.v2.core.exception.UnexpectedFunctionCallTypesException: You called the function ‘++’ with these arguments: 1: String ("Invalid advancement type: ") 2: Null (null) But it expects one of these combinations: (Array, Array) (Date, Time) (Date, LocalTime) (Date, TimeZone) (LocalDateTime, TimeZone) (LocalTime, Date) (LocalTime, TimeZone) (Object, Object) (String, String) (Time, Date) (TimeZone, LocalDateTime) (TimeZone, Date) (TimeZone, LocalTime) 9| "Invalid advancement type: " ++ $.AdvancementType ^^ Trace: at anonymous::main (line: 9, column: 31) " evaluating expression: "%dw 2.0 output application/java var advancementTypes = [“meritbadge”,“rank”,“award”,“adventure”] var invalidTypes = vars.csv.parsedContent filter ( not ( advancementTypes contains $.AdvancementType ) ) distinctBy $.AdvancementType — invalidTypes map ( “Invalid advancement type: " ++ $.AdvancementType )”.

I compared my file with previous uploads and there is nothing apparently different. Fortunately I only had 9 rank advancements to update so I was able to get them handled manually.

I’ll see what happens the next time.

@DavidThompson3, You said you are uploading to Scoutbook is that correct or are you uploading from ScoutBook to TT?

From TT to Scoutbook.