# Importing from TroopWebHost **URL:** \ **Category:** Using Scoutbook & Scoutbook Plus\ **Created:** [September 15, 2020, 2:24pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278 "2020-09-15T14:24:46Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![DanielDornback](https://avatars.discourse-cdn.com/v4/letter/d/e480ec/32.png) [@DanielDornback](https://discussions.scouting.org/u/DanielDornback)\ **Post date:** [September 15, 2020, 2:24pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/1 "2020-09-15T14:24:46Z")
We are transitioning from TWH. All of our scouts, leaders, parents, and completed advancements are loaded. What’s missing: - Activity Logs (camping nights, attendance, etc.) - Partial merit badges How do we import these without manually recreating all this? ---
**Author:** ![edavignon](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/edavignon/32/16_2.png) [@edavignon](https://discussions.scouting.org/u/edavignon)\ **Post date:** [September 15, 2020, 4:49pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/2 "2020-09-15T16:49:53Z")
Currently there is no import capability for logs. They must be input manually, however, with the log system, you can create unit events and add Scouts & Leaders so this should reduce the amount of work. Advancement, including partial MBs can be imported via the Troop Roster Import page, however, it may be faster to manually add the partial MB data to Scoutbook. ---
**Author:** ![DanielDornback](https://avatars.discourse-cdn.com/v4/letter/d/e480ec/32.png) [@DanielDornback](https://discussions.scouting.org/u/DanielDornback)\ **Post date:** [September 15, 2020, 5:23pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/3 "2020-09-15T17:23:06Z")
That’s a bummer - we have scouts with 5+ years of events. This will take weeks to update properly. Is there a way to upload past calendar events? Is there a template to upload partial merit badges? All the help files are circular references. Roster Import template link takes you here: > **[Scoutbook CSV Data Import (SB) - Scoutbook Knowledge Base](https://help.scoutbook.scouting.org/knowledge-base/scoutbook-csv-data-import-sb/)** > > You can upload your data using our generic CSV templates. We only support uploading advancements.csv file imports. Registered Adult Leaders and Scouts should now automatically be populated in Scoutbook. For more assistance, see the getting started... This link takes you back to the first link: > **[Transitioning to Scoutbook from a Third Party Application (SB) - Scoutbook...](https://help.scoutbook.scouting.org/knowledge-base/transitioning-to-scoutbook-from-a-3rd-party-application-sb/)** > > This guide is to assist a unit in transitioning from another 3rd party application to Scoutbook. Your unit roster Scouts and Adults should already be in Scoutbook. Also any advancements your unit has previously reported to your council via Internet... Those say you can import, but no instructions I can find and no templates. ---
**Author:** ![DonovanMcNeil](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/donovanmcneil/32/24_2.png) [@DonovanMcNeil](https://discussions.scouting.org/u/DonovanMcNeil)\ **Post date:** [September 15, 2020, 5:26pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/4 "2020-09-15T17:26:06Z")
when I transitioned platforms I went in to each scout and made one event for everything - so the scout had 65 night camping on one day - it is much faster and serves the purpose ---
**Author:** ![DanielDornback](https://avatars.discourse-cdn.com/v4/letter/d/e480ec/32.png) [@DanielDornback](https://discussions.scouting.org/u/DanielDornback)\ **Post date:** [September 15, 2020, 5:28pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/5 "2020-09-15T17:28:51Z")
> [@DonovanMcNeil](#): > > I went in to each scout and made one event for everything - so the scout had 65 night camping on one day - it is much faster and serves the purpose Yeah, good call - bummer to lose all that history. We’ve moved three systems in 10 years and have been able to port that data each time. Frustrating that Scoutbook makes it very complicated to get started with an existing unit. Also makes it hard to calculate for specific items: OA camping nights = X over X period, no more than 1 long term camp; Service hours used for a specific rank; etc. ---
**Author:** ![CharleyHamilton](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/charleyhamilton/32/3113_2.png) [@CharleyHamilton](https://discussions.scouting.org/u/CharleyHamilton)\ **Post date:** [September 15, 2020, 5:51pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/6 "2020-09-15T17:51:13Z")
On the OA front, it only looks backward 2 years from the present. Based on that, I would try to catalog camping within the last two years in some “detail” (dates, nights, scouts & adults by event). Then, you could pursue @DonovanMcNeil’s approach of “smearing” the information as needed to get it in the logs. Personally, I’m enough of a twitchy engineer that I would probably see what the text/CSV export file from TWH looks like, then try reformatting/pre-processing that in Excel so that I can more easily generate the input data to add to Scoutbook manually. For example, create an “event” worksheet that more or less matches the layout of the campout event interface. Then, figure out a way to scrape information related to that event (e.g. event name) from the export file. That information (start & end dates, # days, # nights, list of scouts & adults, other misc info) would get compiled in the “event” worksheet, so I could more easily transfer it. Repeat _ad nauseum_ for other events that have logs implemented (currently hiking & service). I would work backwards in time creating the events and input everything as it existed. But as I said, I’m a twitchy engineer. That doesn’t necessarily make me the best role model in cases like this. :^) ---
**Author:** ![BradleyPade](https://avatars.discourse-cdn.com/v4/letter/b/41988e/32.png) [@BradleyPade](https://discussions.scouting.org/u/BradleyPade)\ **Post date:** [September 15, 2020, 9:35pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/7 "2020-09-15T21:35:26Z")
This is a major shortcoming of Scoutbook. We really need a way to import activities. ---
**Author:** ![system](https://global.discourse-cdn.com/scouting/original/1X/66e9612584db5dbf76de17f00ad877998c0ba3d6.png) [@system](https://discussions.scouting.org/u/system)\ **Post date:** [September 22, 2020, 9:35pm UTC](https://discussions.scouting.org/t/importing-from-troopwebhost/183278/8 "2020-09-22T21:35:41Z")
Closed on September 22, 2020, 9:35pm UTC This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.