# Importing Scoutbook csv duplicates Patrol membership **URL:** \ **Category:** TroopTrack Bugs\ **Created:** [April 14, 2023, 5:25pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169 "2023-04-14T17:25:57Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![egrubbs](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/egrubbs/32/3343_2.png) [@egrubbs](https://community.trooptrack.com/u/egrubbs)\ **Post date:** [April 14, 2023, 5:25pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/1 "2023-04-14T17:25:57Z")
Every time that I import the scout (youth) csv from scoutbok, it adds the scout to the patrol again. The patrol name shows up duplicated on the scout’s profile page, and the patrol page shows each scout multiple times. ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [April 14, 2023, 7:18pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/2 "2023-04-14T19:18:02Z")
Is all of the information for BSA ID, First Name, Last Name all the same? I am not sure what specific fields are required to match to allow an update vs a new entry, perhaps @dave can shed some light on that? I am curious why you are importing information from ScoutBook multiple times? I just want to understand other workflows to be able to better assist any TT users in how they use TT. ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [April 14, 2023, 7:53pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/3 "2023-04-14T19:53:34Z")
I messaged Dave off list and he said first they try and match via BSA ID then name for an FYI. I read your post again and realized you were saying it just shows the same Youth multiple times on the Patrol Page and shows the Patrol multiple times in the Profile so no new youth is created. Just to make sure have you done a complete refresh of the TT page and or logged out and back in again, I have had times where there were weird issues that were only present until doing a refresh especially dealing with the Patrol page? ---
**Author:** ![egrubbs](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/egrubbs/32/3343_2.png) [@egrubbs](https://community.trooptrack.com/u/egrubbs)\ **Post date:** [April 14, 2023, 8:34pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/4 "2023-04-14T20:34:47Z")
We import multiple times to make sure the scout’s information stays in sync with Scoutbook, so updates don’t need to be made manually in both systems. This was also standard operating procedure for syncing SOAR with Scoutbook. You are correct that the scouts are not being duplicated. It is only the reference between the scouts and the patrols that is duplicated. Logging in and out didn’t fix it. The only thing that fixes it is to edit the Registration Info on each scout. ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [April 14, 2023, 9:01pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/5 "2023-04-14T21:01:44Z")
Thank you for the clarification about the Patrol info, I will pass it along to Dave. I am curious what data is updated in ScoutBook that needs to be synced back to TT? In our use of TT we have no need to use any of the features of ScoutBook. We are able to track everything in TT and then upload achievements into [advancements.scouting.org](http://advancements.scouting.org) and that updates ScoutBook with Youth advancements. Our use of TT pre-dated BSA’s purchase of ScoutBook so we never had any experience with it so just kept going with TT after that acquisition. I did look at SB to see if it could replace TT, as trying to be Thrifty, however I did not see enough feature parity in SB to warrant leaving TT. ---
**Author:** ![chgray](https://avatars.discourse-cdn.com/v4/letter/c/c77e96/32.png) [@chgray](https://community.trooptrack.com/u/chgray)\ **Post date:** [April 17, 2023, 2:54am UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/6 "2023-04-17T02:54:28Z")
Hey @AaronStorey I’m seeing this too - whenever I import Scouts.csv and then visit the Patrol list, each Scout will be added multiple times to the patrol - I’m confident the BSA ID’s are all correct. I noticed this because the Patrols had literally 20+ instances of each Scout 🙂 ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [April 17, 2023, 3:30am UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/7 "2023-04-17T03:30:37Z")
I did speak with Dave about this and he said he would work on it and it should be a relatively easy fix. ---
**Author:** ![egrubbs](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/egrubbs/32/3343_2.png) [@egrubbs](https://community.trooptrack.com/u/egrubbs)\ **Post date:** [April 17, 2023, 8:52pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/8 "2023-04-17T20:52:49Z")
Aaron, I think we were so used to the SOAR integration (one-way from Scoutbook) that we never thought about pushing advancements from TroopTrack. After the ASMs are comfortable with TroopTrack, it could be beneficial if the parents only have to learn one UI. The other possible benefits are: 1. Adding (possibly also deactivating) scouts without having to edit the CSV to get rid of the already imported scouts. 2. Automatically linking parents. SOAR used the scout CSV file’s Parent\_1\_Email, Parent\_2\_Email, and Parent\_3\_Email. The email can be entered incorrectly, but it is a little bit more reliable than matching street addresses for Households. ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [April 17, 2023, 9:59pm UTC](https://community.trooptrack.com/t/importing-scoutbook-csv-duplicates-patrol-membership/13169/9 "2023-04-17T21:59:57Z")
While it is not perfect TT can really be used as a complete system and then export out Advancements (IA2.0).