Skip to content

Add importCsatScores script - #10

Open
JaredEzz wants to merge 1 commit into
mainfrom
add-csat-score-import
Open

Add importCsatScores script#10
JaredEzz wants to merge 1 commit into
mainfrom
add-csat-score-import

Conversation

@JaredEzz

Copy link
Copy Markdown

Adds a script to upload CIS safeguard scores from a CSAT tool CSV export into a Birdseye assessment, one business unit per run.

What it does

  • maps each safeguard's Average (0/25/50/75/100) straight to the process aspect — scales match 1:1, no conversion
  • marks Applicable = No safeguards ignored (or scores them with --scoreNotApplicable)
  • imports Discussion Comments + History as per-safeguard notes (--skipNotes to turn off); notes are saved before the ignore step so N/A safeguards keep their comments
  • finds or creates the target assessment on the BU
  • --dryRun to preview without writing

Follows the existing script convention (per-folder ostrichApi client, interactive api key, python 3.12+) and ships a scrubbed csat export example.csv — no customer data.

Testing

  • CSV parse + safeguard→aspect mapping + score/ignore/notes split validated offline against the example CSV and a real export (all 153 safeguards map cleanly)
  • live API path (auth → create → PUT) still needs a run against a real key + a CIS-subscribed BU

Uploads CIS safeguard scores from a CSAT tool CSV export into a Birdseye
assessment, one business unit per run. Maps each safeguard's Average to the
process aspect, marks Not Applicable safeguards ignored, and imports the
Discussion Comments and History columns as per-safeguard notes.

Follows the existing script convention (per-folder ostrichApi client,
interactive api key, python 3.12+) and ships a scrubbed example CSV.

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
@JaredEzz
JaredEzz requested review from eric-odonoghue and nathan-lockwood and removed request for eric-odonoghue and nathan-lockwood July 13, 2026 21:51
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant