ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Kelvin Pulse Data Spec - 2024A
2
3
Required files/fields are highlighted in green
4
File names and column header names are case sensitive!
5
Each tab in this data specification represents a separate CSV file. You must submit at a minimum all the required files.
6
Conditionally required files/fields are highlighted in yellow
7
The spec has some additional fields that aren't necessary for Pulse. They exist for potential product expansion.
8
For the student demographic fields like is_sped, is_gate, etc. You can either populate these in the students.csv file (see specs), or you can provide that information in the student_programs.csv instead. Data provided in the student_programs.csv get imported into student groups. Populating the data in either place will work in Pulse. It's just you'll use different filter options in the reports depending on which way you load the data. Also you can load additional student groups via the student programs. Pretty much anything really, but I've seen groups like "504 plans", "military family", etc.
9
10
Very importantly field names must match exactly with the spec. This means you only need to provide columns for data you want to send and the column number/order doesn't matter.
11
For example, if you wanted to only send the required fields for sites.csv, then you could send something like this:
12
13
import_site_id,site_name
14
1,First School
15
2,Second School
16
3,Third School
17
18
Very IMPORTANT:
19
Each tab in the attached file spec represents a separate comma separated value (CSV) file. A spreadsheet will not be processed.
20
File names should match the names specified in the Kelvin Pulse Data Spec. The file names are case sensitive.
21
All of these files will need to be transferred securely using SFTP. We will provide you the credentials when you are ready to start sending us data.
22
The expectation is these files will be sent to us via an automated mechanism. Many SISs support features like this (i.e., Infinite Campus, PowerSchool, etc).
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100