The timetable (in its graphical form) and the reports (in their table form) can be printed and exported to various file formats.
How to print or export?
If you are going to be printing or exporting the timetable, first make sure you are in the "Timetable" module (the tab at the bottom left corner of the workspace); if you are printing or exporting a report, switch to the "Reports" module (Note: exporting to a CSV or a text file is done from the Reports module only). Now, to open the print/export window, just select "File", "Print/Export" in the main menu.
When you select "File", "Print/Export" in the main menu, a window will open up in which the first page is the "Settings" page. This page is the one which configures what will actually be printed or exported and in which format.
Let's go over the various fields one by one and understand what they are for.
How to select the printer or the exported format?
The first field at the top of the settings page, which is named "Export to:", controls the output format of the exported timetable. It allows selecting either a "Printer" (and lists all the printers connected to your computer), "HTML/Image files", "iCalendar File" and "CSV/Text File". To select one of the formats, click inside the check box near the desired export format:
If you are exporting a report, the "Export to" field contains the option "CSV/Text File". This exports the report into a tab or comma delimited text file (CSV), which can then be opened in various applications which support this format (Excel for example).
How to export to a PDF file?
Exporting to a PDF file is considered the same as printing, because basically, a PDF file is like a printed document – only in an electronic format. Therefore, in order to export to PDF, a PDF printer driver needs to be installed. It mimics a printer connected to your computer and you will actually see that printer driver in the list of printers; only instead of actually printing to paper, this driver creates a PDF file. There are various PDF printer drivers available. We recommend the "doPDF" printer driver which is available at:
Note: Windows 10 already has a built-in PDF printer driver named "Microsoft Print to PDF".
How to export to Google Calendar?
Google Calendar, Microsoft Outlook and other calendar apps can import appointments and events from an iCalendar file format. Our software can export the scheduled activities to such a file by selecting the "iCalendar File" format in the "Export to" field at the top of the settings page. Once the iCalendar file is created (it has the .ics extenstion), you can import it into Google Calendar by following the steps at:
How to select the resources?
The "Resources" section controls whose resources' timetables will be printed or exported. When you open the window, this value initially contains the same resources whose timetable was displayed on screen in the main timetable pane. The selection of resources is done inside a popup list which appears when you click to the right of the appropriate resource type:
Note: To select all the resources, click twice inside the check-box at the top of the popup list (the one near the caption "Teachers" in the above example). You need to click twice because the first click clears the existing selection and the second click selects all the items in the list.
A single printed or exported document can only contain the timetables of resources of the same type (e.g. only teachers, or only groups). If you need to export several types of timetables, first select the relevant resources of the first type, click "Print" to generate one document, then select the second type of resources and click "Print" again. The window does not close when you click "Print" so this process is quick.
The "Resources" section contains two additional options:
- Separate table for each resource – If this option is not selected and you have several resources selected, they will all be exported in a single timetable (or report). However, if this item is selected, each resource's timetable will be printed/exported separately. For example, if you have selected 3 teachers and turned this option on, 3 pages will be generated, each with one teacher's schedule. If this option is turned off, 1 page will be generated with a weekly timetable which includes all 3 teachers.
- Separate table for each activity – This option allows you to export timetables of discrete activities. When this option is selected, the timetable of each resource is broken down to many "sub timetables", each containing the cells of only a single activity. All these "sub timetables" are then exported as distinct tables.
How to select the time range?
The "Time" section determines the time range of the exported timetables. You can select the days (either generic or from a calendar if you are in the Changes mode) and if needed, narrow down to specific periods or a specific range of hours during the day:
This section also includes the following two options:
- Separate table for each day – This means that the selected days will not all be part of a single timetable, but rather that multiple timetables will be generated, one for each day.
- Separate table for each week – This is relevant when multiple weeks were selected in the Days field. In such case, turn this field on to generate a separate timetable for each week (unless of course you want them all to be in the same timetable).
How to configure the layout of the axes?
In the same manner that the axes can be rotated on screen (by selecting "View", "Rotate Axes" in the main menu), they can also be rotated in the printout (without having to leave the print settings window). This is done in the "Axes" section of the settings. The layout possibilities depend on whether a timetable grid displays a single resource's or multiple resources' timetables.
For a grid which contains a single resource's timetable there are 2 possible layouts of the axes:
Whereas a grid which displays the timetable of multiple resource has 4 possible layouts of the axes:
How to configure what information is shown in each cell?
When you are viewing a schedule on screen, you can configure what information is shown in each cell by selecting "View", "Settings" in the main menu. By default, the settings that you make there also apply to the printouts. However, if you would like to change these settings especially for the printed timetable, you can do so without leaving the print window. At the top of the list, under the "Contents" item there is an option named "Different contents than on screen":
If you select that option, a "Contents" icon will appear at the left hand side of the window. If you click that icon, you will be able to configure the cell contents just like in the View Settings window, and this configuration will be applied only to the printed timetable. It will also be saved for all the future times in which you will need to print/export the timetable.
The Options section contains various settings which affect the visual aspect of the exported schedule, the span of tables across pages, the size of the paper, margins and more. The Options section has 3 sub sections: "Visual Setup", "Table Setup" and "Page Setup".
This sub section contains several settings which affect the visual aspects of the printed/exported timetable. Here are the available settings here:
- Print in color? – Whether the cells are drawn in color like on screen or not. If not, there are two options: either all cells are gray or all cells are white (saves ink on inkjet printers).
- Line thickness – This is the thickness of the lines in-between the table cells. You can increase the default if the lines appear too thin on your printer.
- Cell padding - This is the amount of space left between the cell's lines and the interior text. When printing dense tables this value can be reduced in order to fit more text in each cell.
- Span across multiple lines – When the check box near this option is selected, the spanning of text across multiple lines (as otherwise defined in "View", "Settings") is overridden with a single Yes/No value. This Yes/No value applies to all the properties of every cell.
- Same font for everything – When the check box near this option is selected, the font (as otherwise defined in "'View", "Settings") is overridden with a single font that you can choose. This font will then be used for to output all the properties of every cell.
- Increase all font sizes by – When the check box near this option is selected, the font sizes (as defined in "View", "Settings" or overridden using the previous option) are increased by a value that you specify. You can use this option if the printed text appears too small compared to the screen.
- Can decrease font size down to – By default, in case not all the contents of a cell fit in, the ones for which there is not enough space are not shown at all. However, if you select this option (by clicking the check box near it), you can allow the program to decrease the size of the font in order to try and fit all the text in a cell. The recommended minimal font size is 4.
This section controls the way the printed tables are spanned across pages. Using these setting you can have the program position many tables on a single page; or - you can have each table span across many pages:
- Tables per page horizontally/vertically – Set these values when you would like to "tile" each printed page with many tables. These two fields set the number of tables horizontally and vertically on each page. The total number of tables per one page will be the product of these two values.
- Pages per table horizontally/vertically – If, on the other hand, you would like each printed table to span across multiple pages, use these two values. The table's columns and rows will be divided equally between the pages.
- Skip empty tables – When this option is set and a table contains no scheduled activities whatsoever, the program will skip it and not print it at all.
This last section's settings are related to paper size, margins and titles.
- Paper Size – The size of the paper you will be printing on. The default is A4. You can also set a custom size.
- Width and Height – When exporting to HTML/image files, the "Paper Size" setting is irrelevant and thus is hidden. Instead, these dimensions of the exported timetable can be entered in screen pixels units.
- Orientation – Whether to print in portrait or in landscape paper orientation.
- Margins – Top, bottom, left and right margins. These margins are subtracted from the overall size of the paper and the content is printed in the resulting area. The margins are left blank.
- Header and Footer – The contents of a header and footer can be edited in the "Titles" page of the Print/Export window. They are basically RTF (rich text format) files. After you edit them, they are saved under the file names that appear in these two fields. This is to allow you to alternatively edit them in an external application (like Word or Wordpad).
- Header/Footer Height – This is the total space allocated for the header and footer at the top and the bottom of the printed page.
CSV/Text File Options
When exporting a report to a text file, the "Options" section contains only the following 3 options.
- Delimiter – This is the character that will be used to separate the fields in a single line of the text file. A comma is used in CSV files whereas a Tab is used in tab delimited text files.
- Field Beginning/Ending – These two characters are used to enclose every field in the exported file. Some applications require that each field be enclosed in quotation marks for example (which is the default).
The "Titles" page contains two edit fields – the header and the footer:
The toolbar at the top of the page has the following buttons:
- Font and Size – To set the font and the size of a portion of text, first select it, then click this button and select the desired font. You can also change the font size in the edit field to the right of the font's name (inside the popup list of fonts).
- Style and Alignment – This selector allows you to make text bold, underlined or italic. It also allows you to control the alignment: left, right or center.
- Color – This button controls the color of the selected text.
- Insert Image – This button allows you to insert an image file (jpg, png, bmp) into the header or the footer.
- Date, Time, Page, File Name – The last button inserts a text "placeholder" which is replaced by the appropriate value during the actual printing. For example, if you insert the [page] placeholder into the footer, each page will have a page number at the bottom.
The last page in the window is the Preview page. You can use it to see how the printout looks like before actually printing it. If you are exporting to a file, clicking the Preview button is the same as clicking the Export button.
The next chapter: Importing Data.