1
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
5
<html xmlns="http://www.w3.org/1999/xhtml">
7
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
9
<title>Importing and Exporting from Spreadsheet — The SchoolTool Book</title>
11
<link rel="stylesheet" href="_static/flourish.css" type="text/css" />
12
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
14
<script type="text/javascript">
15
var DOCUMENTATION_OPTIONS = {
18
COLLAPSE_INDEX: false,
23
<script type="text/javascript" src="_static/jquery.js"></script>
24
<script type="text/javascript" src="_static/underscore.js"></script>
25
<script type="text/javascript" src="_static/doctools.js"></script>
26
<script type="text/javascript" src="_static/jquery.colorbox-min.js"></script>
27
<script type="text/javascript" src="_static/flourish.js"></script>
28
<link rel="shortcut icon" href="_static/favicon.ico"/>
29
<link rel="author" title="About these documents" href="about.html" />
30
<link rel="top" title="The SchoolTool Book" href="index.html" />
31
<link rel="next" title="Populating Your School" href="populating.html" />
32
<link rel="prev" title="Setting Up Courses" href="courses.html" />
33
<link rel="stylesheet" type="text/css" href="http://fonts.googleapis.com/css?family=Ubuntu:regular,bold&subset=Latin" />
37
<div class="schooltool">
40
<a href="http://www.schooltool.org/">
41
<span class="school">school</span><span class="tool">tool</span>
42
<img alt="Logo" src="_static/logo-small.png" />
45
<ul class="navigation">
47
<a href="http://schooltool.org/">
52
<a href="features.html">
57
<a href="http://launchpad.net/schooltool-project/+announcements">
62
<a href="screenshots.html">
67
<a href="system-requirements.html">
82
<script type="text/javascript">
83
$(document).ready(function() {
84
$(window).scroll(function() {
85
var scrollTop = $(window).scrollTop();
87
$('div.related').css('position', 'fixed');
88
$('div.related').css('top', '0');
90
$('div.related').css('position', 'absolute');
91
$('div.related').css('top', '64px');
100
<li class="right" style="margin-right: 10px">
101
<a href="populating.html" title="Populating Your School"
102
accesskey="N">next</a></li>
104
<a href="courses.html" title="Setting Up Courses"
105
accesskey="P">previous</a> |</li>
106
<li><a href="index.html">The SchoolTool Book</a> »</li>
110
<div id="search-box">
111
<form class="search-form" id="google-appliance-search-form" method="get"
112
accept-charset="UTF-8"
113
action="search.html">
115
<div id="edit-keys-wrapper" class="form-item">
116
<input type="text" class="form-text"
117
onfocus="if(this.value=='Type to search'){this.value=''}"
118
onblur="if(this.value==''){this.value='Type to search';}"
119
value="Type to search" size="20" id="edit-keys" name="q"
121
<input type="hidden" value="yes" name="check_keywords" />
122
<input type="hidden" value="default" name="area" />
124
<img src="_static/arrow.png" class="form-submit"
125
onclick="$(this).closest('form').submit()"
126
style="cursor: pointer" />
130
<!-- End Search Bar -->
134
<div class="document">
135
<div class="documentwrapper">
136
<div class="bodywrapper">
139
<div class="section" id="importing-and-exporting-from-spreadsheet">
140
<span id="spreadsheet"></span><h1>Importing and Exporting from Spreadsheet<a class="headerlink" href="#importing-and-exporting-from-spreadsheet" title="Permalink to this headline">¶</a></h1>
141
<p>To import or export data from a spreadsheet, you must be logged in as a member of <strong>Clerks</strong> or <strong>Site Managers</strong>. Select the <strong>School</strong> tab, and click on the <strong>Import XLS</strong> link in the sidebar:</p>
143
<div><img alt="_images/spreadsheet-0.png" src="_images/spreadsheet-0.png" />
145
<p>The “What is this?” sidebar contains links to three spreadsheets, of which one is empty, and two are populated with sample data. The empty spreadsheet is documented by a complete set of tooltips – hover the mouse pointer over a row or column header for further explanation of its function.</p>
146
<p>Note that importing <tt class="docutils literal"><span class="pre">large_sample_data.xls</span></tt> creates a database file of approximately 230 megabytes, and a temporary file the same size, so you’ll need a free half gigabyte of disk space if you want to generate everything at once. This is also much more memory intensive than routine use of SchoolTool. A server with less than 512 MB of RAM will go heavily into virtual memory – and, if there is little or no swap partition, this may cause the memory-starved server to start killing processes to free memory.</p>
147
<p>While data is being imported from the spreadsheet you’ll see a little notifier on the page:</p>
149
<div><img alt="_images/spreadsheet-1.png" src="_images/spreadsheet-1.png" />
151
<p>After a successful import, you will be sent back to the main <strong>School</strong> page:</p>
153
<div><img alt="_images/spreadsheet-2.png" src="_images/spreadsheet-2.png" />
155
<p><tt class="docutils literal"><span class="pre">large_sample_data.xls</span></tt> creates a full school of 1000 students and two years of section enrollments. <tt class="docutils literal"><span class="pre">sample_data.xls</span></tt> has 466 students but only six teachers and a handful of sections (budget cuts). Users are either “student” or “teacher” followed by a three digit number (for example, “<strong>student000</strong>” or “<strong>teacher001</strong>”), and their passwords are the same as their ID’s.</p>
156
<p>To export data to a spreadsheet, navigate to the <strong>School</strong> tab, select <strong>Reports: School Export</strong> in the sidebar menu, and click on the <strong>Download</strong> button to confirm the dialog:</p>
158
<div><img alt="_images/spreadsheet-3.png" src="_images/spreadsheet-3.png" />
160
<p>Your browser will download an Excel format file (readable by LibreOffice and most other current spreadsheet applications) named export.xls.</p>
167
<div class="sphinxsidebar">
168
<div class="sphinxsidebarwrapper">
169
<h4>Previous topic</h4>
170
<p class="topless"><a href="courses.html"
171
title="previous chapter">Setting Up Courses</a></p>
173
<p class="topless"><a href="populating.html"
174
title="next chapter">Populating Your School</a></p>
177
<div class="clearer"></div>
180
<p class="copyright">
181
© Copyright 2014, the Shuttleworth Foundation. This work is licensed under the Creative Commons Attribution 3.0 Unported License.
184
Last updated on May 22, 2014.
185
Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 1.2.2.
186
<a href="_sources/spreadsheet.txt"
187
rel="nofollow">Show Source</a>
b'\\ No newline at end of file'