# Importing Data from Troop WebHost **URL:** \ **Category:** Using Scoutbook & Scoutbook Plus\ **Created:** [April 30, 2019, 3:55pm UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734 "2019-04-30T15:55:14Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![HeidiSnow](https://avatars.discourse-cdn.com/v4/letter/h/85e7bf/32.png) [@HeidiSnow](https://discussions.scouting.org/u/HeidiSnow)\ **Post date:** [April 30, 2019, 3:55pm UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/1 "2019-04-30T15:55:14Z")
Can I import Scout history from TroopWebhost? I’d love camping nights, service hours… I’m trying to figure out from purely an Advancement standpoint how much we use SB. ---
**Author:** ![jacobfetzer](https://avatars.discourse-cdn.com/v4/letter/j/b782af/32.png) [@jacobfetzer](https://discussions.scouting.org/u/jacobfetzer)\ **Post date:** [May 1, 2019, 11:39am UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/2 "2019-05-01T11:39:18Z")
@HeidiSnow In theory you can. From your unit roster page, click roster import. There are some instructions there and a link to instructions for creating the logs.csv file. I’m not sure how difficult it will be to get the Troop WebHost data into that format. ---
**Author:** ![HeidiSnow](https://avatars.discourse-cdn.com/v4/letter/h/85e7bf/32.png) [@HeidiSnow](https://discussions.scouting.org/u/HeidiSnow)\ **Post date:** [May 1, 2019, 4:21pm UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/3 "2019-05-01T16:21:24Z")
Thanks. I’ll poke around and see what I can do. ---
**Author:** ![ElizabethCarlston](https://avatars.discourse-cdn.com/v4/letter/e/ccd318/32.png) [@ElizabethCarlston](https://discussions.scouting.org/u/ElizabethCarlston)\ **Post date:** [June 7, 2019, 1:10am UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/4 "2019-06-07T01:10:45Z")
Did you ever get this figured out? I am trying tonight, and not having much luck. ---
**Author:** ![DougVibbert](https://avatars.discourse-cdn.com/v4/letter/d/3ec8ea/32.png) [@DougVibbert](https://discussions.scouting.org/u/DougVibbert)\ **Post date:** [June 12, 2019, 10:23pm UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/5 "2019-06-12T22:23:51Z")
I would suggest moving from troopwebhost to scoutbook completely. I’ve been using both and the fact of the matter is troopwebhost is not an official record. Scoutbook is. Scoutbook replaces paper records and allows so much easier tracking of service hours, advancement criteria, immediate blue cards through electronic communication. We went from a troop that uses troopwebhost and frankly if I knew that would require my son to have to track everything through paper records again I would never have chosen that troop. ---
**Author:** ![AndrewRussell](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@AndrewRussell](https://discussions.scouting.org/u/AndrewRussell)\ **Post date:** [June 17, 2019, 1:54am UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/6 "2019-06-17T01:54:55Z")
While I agree scoutbooks is the official site, the features are not yet there for us. We wanted one stop shopping for everything and if that means we need to sync twice a year at COH then I am good with that. Troopwebhost is a great site and being updated with features and functions much faster than scoutbooks. We have used both and this is the best way for us to host our calendar, communicate, do sign ups, and bill. When Scoutbooks can do all that we will look again, but not before that. It was painful this time after they changed it this year and there has been very little documentation that we could find, but we did figure it out. To sync from Troopwebhost you can do the following: Login to troopwebhost as someone who has access to advancement reports. Menu-\>Advancement-\>Recognize recent achievements-\>Export to Internet Advancement 2.0 Select your dates. Pick boys/girls if necessary. Click to download the SBL\_advancement.txt file. Login to [Scoutbook.scouting.org](http://Scoutbook.scouting.org) as the scoutmaster or the big3. Click roster Click on import file at the top right. Drop your SBL\_advancement.txt file into the browser. It will process some things right away, like if a scout ID number is wrong it will throw an error. You can either manually update the file, or fix troopwebhost and download the file again following the same steps above. It will be batch processed to scoutbooks overnight and should show up the next day in scoutbooks. Be sure to check your error logs then to be sure everything synced up properly as we always had a few boys that failed to sync automatically even with the correct numbers. Eagle cannot be synced to council so that will always error. This is normal as the council will update it for you. As long as names and scout IDs match the rest should work. You can order the awards this way, but we went to the scoutshop to purchase the badges instead. Best of luck. Scoutbooks is good, but Troopwebhost has been great. ---
**Author:** ![DavidHouse](https://avatars.discourse-cdn.com/v4/letter/d/d6d6ee/32.png) [@DavidHouse](https://discussions.scouting.org/u/DavidHouse)\ **Post date:** [June 21, 2019, 7:50pm UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/7 "2019-06-21T19:50:18Z")
Where did you see it was an overnight import Andrew? I’m used the old import where it was real-time. I’m stuck… after importing a file it says “Pending” and I can’t do anything with it. ---
**Author:** ![DanDurig](https://avatars.discourse-cdn.com/v4/letter/d/dfb087/32.png) [@DanDurig](https://discussions.scouting.org/u/DanDurig)\ **Post date:** [June 22, 2019, 12:28am UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/8 "2019-06-22T00:28:06Z")
This should help. > **[Introduction to Internet Advancement (IA) - Scoutbook Knowledge Base](https://help.scoutbook.scouting.org/knowledge-base/internetadvancement/)** > > Internet Advancement is available to unit key three members via my.Scouting.org. ORDirectly: http://advancements.scouting.org Internet Advancement writes to the Scoutbook database so anything approved will instantly show up in Scoutbook (and visa... Start at 5:10 if you need to sync the file from troopweb host. The instructions above work for getting the file to your PC from troopweb host. The video says they are processed hourly. I waited less than an hour and checked the next day for the error report so I thought it was a batch but did not know the timeframe either. If you want to manually update items that error out start at the beginning of the video. Best of luck! ---
**Author:** ![DavidHouse](https://avatars.discourse-cdn.com/v4/letter/d/d6d6ee/32.png) [@DavidHouse](https://discussions.scouting.org/u/DavidHouse)\ **Post date:** [June 22, 2019, 1:16am UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/9 "2019-06-22T01:16:28Z")
Great, thank you for the information, that’s very helpful. ---
**Author:** ![system](https://global.discourse-cdn.com/scouting/original/1X/66e9612584db5dbf76de17f00ad877998c0ba3d6.png) [@system](https://discussions.scouting.org/u/system)\ **Post date:** [June 29, 2019, 1:16am UTC](https://discussions.scouting.org/t/importing-data-from-troop-webhost/105734/10 "2019-06-29T01:16:30Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.