Parent Square

This page is currently under development. Notes are in https://app.asana.com/0/1204620012374748/board

To manually send a file to ParentSquare

Create a properly formatted CSV (Done by SchoolToolTeam)
Name the file correctly
- Required files - These files will upload with the automatic / scheduled upload
  - schools.csv
  - students.csv
  - parents.csv
  - staff.csv
  - terms.csv
  - sections.csv
  - rosters.csv
  - Optional files
- additional_staff.csv - These files will require manual uploads
  - attendance.csv
  - groups.csv
  - group_members.csv
  - group_user_members.csv
  - emergency_contacts.csv
Place the file(s) in \\scripts01\PS_Uploads ( Scripts01 D:\ParentSquare\ )
Uploading to Parent Square from Scripts01
- Automatic Uploads
  - Powershell Script is "E:\PowerShell\ParentSquare\sFTPParentSquare.ps1"
    - Uses config file "D:\ParentSquare\Configs\FileNames.csv"
  - The Scheduled Task on Scripts01 'sFTP ParentSquare Upload' uploads every 10 minutes
  - Uses WinSCP
- Manual Uploads
  - Launch WinSCP
  - Connect to ParentSquare sFTP site - A backup of site configs is located in C:\Backups
    - Creds are in LastPass as ParentSquare sFTP shared at the Network Analyst level

General Information

File Names

Required files

1. schools.csv

2. students.csv

3. parents.csv

4. staff.csv

5. terms.csv

6. sections.csv

7. rosters.csv

Optional files

* additional_staff.csv

* attendance.csv

* groups.csv

* group_members.csv

* group_user_members.csv

* emergency_contacts.csv

sFTP Seutp (modified 07/18/2024)

Timing Sheet - https://docs.google.com/spreadsheets/d/1wi-n_cmyQmIQhoOnQYaYNfmef_cyLCetYHGh2AlayvQ/edit#gid=0

SchoolTool Main Site Scheduled exports sFTP using

Protocol: SFTP
Server: sftp2.parentsquare.com
SSL: No
Port: 22
Username: wswhe7b9aee5c
Password: In LastPass note "ParentSquare sFTP" shared at the Analyst Level
Filename: /sftp-parentsquare-production/wswhe7b9aee5c/%filename%.csv
Email on success& failure: wswheboces+parentsquarefileupload@mycheckcentral.cc

sFTP Seutp OLD

Server: Scritps01
Upload File Location: D:\ParentSquare\Uploads
PowerShell Script: E:\PowerShell\ParentSquare\sFTPParentSquare.ps1
- Uses a config file that is a list of the file names to be uploaded: "D:\ParentSquare\Configs\FileNames.csv"
- Uses WinSCP to do uploads
Scheduled Task: 'sFTP ParentSquare Nightly Upload' running as wswheboces\Script_SchoolTool
- Runs at 4:45am each weekday
LastPass Note with Credentials: 'ParentSquare sFTP' - Shared at the Analyst Level
Check Central Check is configured
- wswheboces+parentsquarefileupload@mycheckcentral.cc

These links should help with getting Admin started:

3-Minute Overview

Introduction to Administrators

DISTRICT WALKTHROUGH: To support your Administrators and Implementation Team, here are a few short videos that provide a solid overview of the platform and cover some basic navigation, platform functionality and troubleshooting tips:

I'm happy to schedule a Q&A for your team if there are any questions about the videos.

TRAINING: Please see this Training Help Page that outlines training. (Spoiler alert: My favorite resources are the webinars for teachers and admin.) I recommend sharing the training resources with anyone who will post so they have a good understanding of the interface and can start sending information quickly.

Classes & Training:
- Train-the-Trainer Materials
- ParentSquare Admin & Teacher Summer Camp 2023 - Campers will receive a Certificate of Completion for 5 PD hours.

LAUNCH: Here are some resources for getting started with ParentSquare:

Launch Kit - includes announcement, handout, and presentation samples/templates
Steps to Launch ParentSquare
Sending invitations to register
Welcome to ParentSquare post
Admin Help Pages
Posts vs. Alerts
Parent Opt-Out Form

As you continue to use ParentSquare, additional questions are likely to come up about specific features or tools. We have a huge help and support knowledge base on a variety of topics. If you can’t find what you are looking for, the fastest way to get your questions answered is to live chat with us from our help pages, call us at 888-496-3168, or email support@parentsquare.com.