Template CSV File Format

For creating Peerbots templates outside of the Peerbots app

John Choi

Last Update há 2 anos

Although it is possible to edit and create all your templates and buttons completely within the Peerbots app, it is also possible to create templates in standardized spreadsheet tools such as Microsoft Excel, Google Sheets or OpenOffice Calc.

When you create a template in a spreadsheet editor outside of Peerbots, you MUST include the following 7 columns, in correct order, and with the correct spelling and lowercase letters in the first row for Peerbots to parse the file correctly:

title | color | emotion | speech | goal | subgoal | proficiency


(Note: For a description of what each of these properties does, check the article on Editing Buttons.)


Below, here is an example table file for the default "Colors" template:

titlecoloremotionspeechgoalsubgoalproficiency
Light BlueLight BlueNeutralLight BlueNone
BlueBlueNeutralBlueNone
GreenGreenNeutralGreenNone
RedRedNeutralRedNone
PurplePurpleNeutralPurpleNone
PinkPinkNeutralPinkNone
YellowYellowNeutralYellowNone
OrangeOrangeNeutralOrangeNone
GreyGreyNeutralGreyNone
BlackBlackNeutralBlackNone
WhiteWhiteNeutralWhiteNone
TurquoiseTurquoiseNeutralTurquoiseNone

When you are done and ready to use template from the spreadsheet editor in Peerbots, export it as a ".csv" file, and then import it to the Peerbots app


Note: When creating a template outside of Peerbots, you must NOT include the semicolon ";" and comma "," characters anywhere, or the Peerbots app will fail to parse the app.


Here is the default Colors template in the Peerbots controller:

Note: some properties are dropdown selections with limited number of possible inputs. When editing CSV files in an outside spreadsheet editor, the following properties can only accept the following inputs:

coloremotiongoalsubgoalproficiency
Light BlueNeutralNone(see subgoal lists)None
BlueSurprisedEmotional(see subgoal lists)Exposure
GreenHappyCommunication(see subgoal lists)Understanding
RedSadSocial(see subgoal lists)Practicing
PurpleConcernedCognitive(see subgoal lists)Demonstrating
PinkSleepMotor(see subgoal lists)
YellowADL(see subgoal lists)
Orange
Grey
Black
White
Turquoise

Subgoals are specific to each Goal type. See the full list of Subgoals for each Goal below:

NoneEmotionalCommunicationSocialCognitiveMotorADL
NoneNoneNoneNoneNoneNoneNone
TransitionsVolume modulationJoint attentionSafetySensory awarenessChores
Tone of voiceVerbalizing with a peerBullyingFollowing directionsPersonal spaceGrooming
Recognizing emotionsConveying needs and wantsModeling behaviorGood choicesLarge motor skillsBathing
Expressing emotionsTaking turns and listeningSocial referencingSequencingFine motor skillsToileting
Self awarenessClassroom behaviorsMaking friendsCategoriesBody awarenessFeeding
BoundariesReceptive languageSharingPrioritiesMindfulnessSleeping hygiene
Flexible mindsetExpressive languageInteractive playMemoryRelaxationHealthy habits
RespectNonverbal communicationConversationsCreativityFitnessDressing
Self regulationSpeaking up clearlyPaying attentionScheduleBoundariesShoes
Perspectives of othersBeing PoliteCooperationSelf monitoringWeather awareness
EmpathyApologiesVisual trackingImaginationChronology
Self controlTeamworkEye gazeProblem solvingHolidays seasons
Understanding humorListeningTaking turnsFlexible thinkerDaily routine
Peer pressurePointingEye contactPerspective takingTransportation
EmpowermentSelf advocacyComplimentsAcademics
Self esteemPhoneticsGood sportsmanshipBehavioral education
GrammarGroup participationInsight
GreetingsJoining others
VocabularyRespect
Sharing ideasAccepting differences
Disagree respectfullyCompromising
Criticism

Was this article helpful?

0 out of 0 liked this article

Still need help? Message Us