# Audit log has no dates

**URL:** <https://discussions.scouting.org/t/audit-log-has-no-dates/240174>\
**Category:** Scoutbook & Scoutbook Plus Bugs\
**Created:** [June 7, 2021, 2:43am UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174 "2021-06-07T02:43:41Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![TamaraMontgomery](https://avatars.discourse-cdn.com/v4/letter/t/5f8ce5/32.png) [@TamaraMontgomery](https://discussions.scouting.org/u/TamaraMontgomery)\
**Post date:** [June 7, 2021, 2:43am UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/1 "2021-06-07T02:43:41Z")

</div>

Just found the Audit log and would like to use it. However, the date field is empty

---

<div class="post-metadata">

**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:** [June 7, 2021, 3:08am UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/2 "2021-06-07T03:08:11Z")

</div>

Are the dates only empty for MBC actions (i.e. MBC approval of requirements/badges)? I noticed that, but for the rank requirements, I get a date in the report.

---

<div class="post-metadata">

**Author:** ![TamaraMontgomery](https://avatars.discourse-cdn.com/v4/letter/t/5f8ce5/32.png) [@TamaraMontgomery](https://discussions.scouting.org/u/TamaraMontgomery)\
**Post date:** [June 7, 2021, 4:19am UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/3 "2021-06-07T04:19:34Z")

</div>

I’m not getting any dates for any advancement. Other category entries do have dates

---

<div class="post-metadata">

**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:** [June 7, 2021, 6:30am UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/4 "2021-06-07T06:30:51Z")

</div>

Hrm… that’s interesting that we’re seeing different things.

What’s your role in the unit? I’m an ASM, a unit admin, and a key 3 delegate.

Which browser are you using? I’m using chrome on Android.

---

<div class="post-metadata">

**Author:** ![Stephen\_Hornak](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/stephen_hornak/32/16282_2.png) [@Stephen\_Hornak](https://discussions.scouting.org/u/Stephen_Hornak)\
**Post date:** [June 7, 2021, 1:12pm UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/5 "2021-06-07T13:12:10Z")

</div>

@TamaraMontgomery - the only time I do not see a date/time stamp on an entry is if it was done by someone outside of the unit. This appears to happen in my list with MBC entries.

---

<div class="post-metadata">

**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:** [June 7, 2021, 2:19pm UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/6 "2021-06-07T14:19:51Z")

</div>

Very old items will not have dates because they were not recorded in Scoutbook. If you post the BSA Member ID (no names) and the item(s) that is missing audit dates we can investigate.

---

<div class="post-metadata">

**Author:** ![TamaraMontgomery](https://avatars.discourse-cdn.com/v4/letter/t/5f8ce5/32.png) [@TamaraMontgomery](https://discussions.scouting.org/u/TamaraMontgomery)\
**Post date:** [June 7, 2021, 4:01pm UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/7 "2021-06-07T16:01:59Z")

</div>

To answer the questions above:  
-I am a unit admin in IA, unit admin and advancement chair in SB  
-I am using Firefox  
-the empty date field for advancement applies to all records, there are 21k of them  
-we have been using Scoutbook for several years (7 at least)  
-Until last year, if a counselor outside the unit approved MB requirements, a unit leader would enter them. Over the past year we have had a few MBCs who aren’t on the unit roster marking approvals in SB.  
-We have not been marking MB requirements properly (typically using the “leader approved “ field rather than going through the extra steps of assigning a MBC for the badge, and recording as “counselor approved “. Growing troop where most of the MBCs have been leaders. We are trying to improve the process and train everyone. The audit log looks like it would be valuable in that effort.

---

<div class="post-metadata">

**Author:** ![JenniferOlinger](https://avatars.discourse-cdn.com/v4/letter/j/ad7895/32.png) [@JenniferOlinger](https://discussions.scouting.org/u/JenniferOlinger)\
**Post date:** [June 7, 2021, 4:07pm UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/8 "2021-06-07T16:07:57Z")

</div>

In Scoutbook, try going to your main troop page, and then:

Export / Backup → Advancement

and open up the Advancement csv file in a spreadsheet program like Excel.

Are the dates in the export file? Or are they missing there, too?

---

<div class="post-metadata">

**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:** [June 7, 2021, 5:21pm UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/9 "2021-06-07T17:21:26Z")

</div>

> [@TamaraMontgomery](#):
>
> We have not been marking MB requirements properly (typically using the “leader approved “ field rather than going through the extra steps of assigning a MBC for the badge, and recording as “counselor approved “.

This has been a reasonable process in the past, when scouts/MBCs were using blue cards more extensively. The recent mods to the system eliminate the Leader Approved boxes for individual requirements, and only require Leader Approval of the finished badge, more akin to the traditional blue card process.

> [@JenniferOlinger](#):
>
> Are the dates in the export file? Or are they missing there, too?

In my case, @JenniferOlinger, the Counselor Approved dates are also missing. For reference, I am only looking back as early as 1/1/2021, so it seems unlikely that the “very old items” issue @edavignon noted is impacting the Counselor Approved items.

What I am seeing in particular is that when the merit badge requirement (or the overall merit badge) was marked Completed by the counselor, then the date marked completed is missing from the CSV file, as is the associated comma-delimiter. This results in a horizontal offset (i.e. missing column) in the data set where the Date Completed belongs for that item. I’ve included a screenshot to demonstrate the condition. I don’t see a similar issue for other items (e.g. rank advancement, awards) in the CSV file or the report.

 ![image](https://global.discourse-cdn.com/scouting/original/2X/b/b74e28399ef24f5447da297e9cf365f662c38d7c.png)

---

<div class="post-metadata">

**Author:** ![TamaraMontgomery](https://avatars.discourse-cdn.com/v4/letter/t/5f8ce5/32.png) [@TamaraMontgomery](https://discussions.scouting.org/u/TamaraMontgomery)\
**Post date:** [June 7, 2021, 9:07pm UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/10 "2021-06-07T21:07:25Z")

</div>

OK, in the exported backup file dates are there. Interestingly, on the Audit Report only Counselor Approved Merit Badges and Counselor Approved MB Requirements are the only records. No dates are showing in the Audit report, AND it seems to be limited to a subset of Advancement records.  
Another weird thing, in the backup file, the column “Marked Completed Date” has a name, and “Marked Completed By” has a date. So the data parsing is confused somewhere.  
Here is one Member ID affected 128803575

---

<div class="post-metadata">

**Author:** ![TamaraMontgomery](https://avatars.discourse-cdn.com/v4/letter/t/5f8ce5/32.png) [@TamaraMontgomery](https://discussions.scouting.org/u/TamaraMontgomery)\
**Post date:** [June 11, 2021, 3:58am UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/11 "2021-06-11T03:58:56Z")

</div>

Any further thoughts on why only Meritbadge counselor records, no dates are showing I the Audit log? Also when I creat a backup of advancement records, the date and name fields are switched. Is this a problem with the parsing of the data file, or is the source data file corrupted somehow?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/scouting/original/1X/66e9612584db5dbf76de17f00ad877998c0ba3d6.png) [@system](https://discussions.scouting.org/u/system)\
**Post date:** [June 18, 2021, 3:59am UTC](https://discussions.scouting.org/t/audit-log-has-no-dates/240174/12 "2021-06-18T03:59:13Z")

</div>

Closed on June 18, 2021, 3:59am UTC

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
