Datasheet view are available on multiple modules. You can find them in students, agents, homestay, and schools. For ISP Cloud, the datasheet view comes with a predefined set of available fields. Data brought into the datasheet view is made available based on the school year set on screen in the top-right corner, or based on the filter for school year is it is active. If no details are available for the school year or filters set up, the datasheet view will not display any information.
For each individual module the available fields in the datasheet view will include data relevant to the module you’re accessing. For example, for students you will find student details, custodian information, parent and siblings details, and so on.
In each datasheet view the fields are in alphabetical order. ISP Cloud is a web-based system, which enables you to search for a certain field by using the native browser search (usually activated by using a combination of CTRL+F)
When using the system for the very first time, the datasheet view will have a default set of fields visible. On the left side of the screen, the fields in datasheet view are available in a quick menu; all active fields are marked with an eye icon (). Inactive fields have a dash (–). To activate or deactivate fields based on your preferences, you will need to toggle the eye icon/dash.
Once you have decided on the columns you need, you can arrange them in your preferred order. To do that, click on the header of the column, and drag it left or right. Drop the column(s) according to your preferences. In the end, click on the Save preferences button to save all the changes made.
The Reset preferences button will take you back to the default settings. All and any changes you have made will be replaced with the default setting for the datasheet views.
SORTING AND FILTERS
When searching for information in the datasheet view, clicking on the column name will order the available information ascending () or descending (). A small arrow is available on each column as indicator to the sort type.
NUMBER OF ENTRIES PER PAGE
The datasheet views offer you to option to display a different number of entries per page. The default number of entries is set to 25. You can set the view of the datasheet to show 10 entries, 50, 75, 100, or All. However, the number of views per page is reset each time you go to another tab or module.
Details from the datasheet view can be exported into csv files, or into Excel documents. The Excel documents retrieve data similar to the csv files. You can export all data at once, by selecting “All” as view for information. Data is exported based on the school year (or school year filter) as well as based on the filters applied on the datasheet columns.