Rock Sample Data GitHub

Datasets

Three sizes. One church.

Pick the size that fits the job. Every dataset has the same Cast at the same broadcast campus, so what you learn on one carries to the others.

Core 1

Loads in about 4 seconds

  • The Cast: 87 households, 185 people
  • 1 campus: Phoenix
  • Every feature, with full history

For tests and most development.

Core 3

Loads in under 10 seconds

  • The Cast, plus 75 generated households at each of Peoria and Gilbert
  • 3 campuses
  • Campus test groups at every new campus

For campus features and filters.

Full 7

Loads in 20 to 40 seconds

  • The Cast, plus the Crowd: about 25,000 people
  • 7 campuses across the Valley
  • Volume for reports, charts, and search

For demos, performance, and reporting.

What's inside

Every dataset fills every feature.

People and households

The Cast in every dataset, plus generated households in Core 3 and Full 7. Every Cast person has a photo, except a few left without one on purpose.

Attendance and check-in

Years of Sundays, with kids checked in by family security code and students checking in to the Sunday student service.

Giving

Gifts on each giver's rhythm, through scheduled, online, and Sunday channels, in batches, with scanned checks that match each gift.

Giving analytics

Giving attributes, journey stages, and a year of giving alerts, filled in the way Rock computes them.

Small groups

Groups with leaders, hosts, topics, history, photos, and Group Finder test cases at every campus.

Serving and scheduling

Eight teams per campus, with rotations, preferences, blackout dates, six weeks of future schedules, and volunteer check-in.

Connections

Requests to serve that follow each household's journey, with activities and placements.

Prayer

Requests in every state, the prayer team's prayers and comments, and the Cast's own requests tied to their stories.

Notes

Six note types with View security, the Cast's hand-written notes, and generated notes with replies, alerts, and mentions.

Steps

Rock's Discipleship Path built out to seven steps and a four-step Student Path, each step made from a record the data already has, with classes in progress at every campus, camps and mission trips from student check-ins, and program completions.

Achievements

The Kids Check-in streak and its seven achievements, so check-in shows real progress.

Businesses

Businesses at every campus that give, each with one or two contacts.

Always fresh

History that always ends today.

Old sample data used fixed dates, so "last 12 months" reports slowly emptied out. This data stores who people are and generates what they did when you install it, counting back from install day.

Ages and grades never drift. A first-time guest always visited two weeks ago. Christmas and Easter always land where they should.

One exact Rock

Made for your version.

Each package is built for one exact Rock release. It records that Rock's version and newest migration, and the loader refuses a database that doesn't match.

Before a package is published, it's loaded into a clean copy of that Rock and checked. See how we prove it.

Install it

From the repository, in three steps.

  1. Check the data

    node cast/validate-cast.js
node validation/check-standards.js

  2. Build the packages for your Rock

    cd builder
dotnet run -- --rock C:\Development\Rock

  3. Load one into a fresh Rock database

    cd ../loader-cli
dotnet run -- --package ../packages/core-1.zip --connection "Server=localhost;Database=RockSample;Integrated Security=true;TrustServerCertificate=true"

You need the .NET 10 SDK, Node.js 20 or later, and SQL Server with a freshly installed Rock database. Sample data installs into a fresh database only. See the quick start for every option.