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?
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?
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.
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.