This checklist is designed to guide users through the process of importing test scores, matching student files, and creating a table from an uploaded file. It provides step-by-step instructions to ensure smooth data management, helping you upload, map, and integrate test scores effectively into the system. By following this checklist, you'll be able to efficiently manage student data, ensure proper matches, and create accurate tables to support reporting and analysis. For a complete guide, please see Imports.
The Imports screen streamlines the process of importing test scores. This checklist aids users in importing test scores by guiding them through file uploads, field mapping, student matching, and finalizing import settings to ensure accurate data integration.
Choose a file either from your local device or one stored within the designated Focus School Software server directory.
It is important that the file selected be in one of the acceptable formats: CSV, Tab-Delimited, Pipe-Delimited, or Fixed Width.
Options include Comma Delimited, Fixed Width, Pipe Delimited (Single), and Tab Delimited.
It is important to note that when dealing with a Fixed-Width file, additional settings must be inputted by clicking the Field Positions button. For comprehensive guidance on completing those settings, see File Converter: Fixed Width to CSV.
Once all additional data input and/or file structure modifications have been finalized, it's time to specify the location for this data within the system. In this interface, you'll establish a one-to-one association between each column from your latest source data and the destination columns in the database tables.
Review total Valid Rows and Invalid Rows including Validation Errors you must address before complete the import process. The Invalid Rows data is displayed at the bottom of the Validation screen where you can carefully review all the information from the file.
Congratulations! You've now reached the final step of the import process, where all valid data has been successfully committed and is readily accessible in your system for end-users to access. Once again, statistics are provided to facilitate a final review of the import process.
The Student Match Files tab allows users to review and complete student matching processes. This checklist guides users in utilizing the Student Match import tool to identify student IDs for the students in an uploaded file. The import must be conducted first before users can access the matching process, ensuring accurate student data integration.
Choose a file either from your local device or one stored within the designated Focus School Software server directory.
It is important that the file selected be in one of the acceptable formats: CSV, Tab-Delimited, Pipe-Delimited, or Fixed Width.
Options include Comma Delimited, Fixed Width, Pipe Delimited (Single), and Tab Delimited.
It is important to note that when dealing with a Fixed-Width file, additional settings must be inputted by clicking the Field Positions button. For comprehensive guidance on completing those settings, see File Converter: Fixed Width to CSV.
In the pop-up window, map the columns from your file to the required match columns. Select the applicable File Column from each pull-down for the Match Column.
Review the students matched. The percentage bar shows how many students have been matched automatically. The Unmatched Students section displays all the students who were not automatically matched.
Once complete, you'll see the percentage of students match in the Student Match tool section.
Click the Student Match Files tab to review the student matching process. Any student matches conducted will be listed here. If needed, continue matching students to ensure all records are correctly linked before proceeding with the import.
The Create Table from File tool allows users to create a database table using data from an uploaded file. This checklist assists users in efficiently setting up a new table by guiding them through the process of selecting the file and mapping the data to ensure proper table creation and data integration.
Choose a file either from your local device or one stored within the designated Focus School Software server directory.
It is important that the file selected be in one of the acceptable formats: CSV, Tab-Delimited, Pipe-Delimited, or Fixed Width.
Options include Comma Delimited, Fixed Width, Pipe Delimited (Single), and Tab Delimited.
It is important to note that when dealing with a Fixed-Width file, additional settings must be inputted by clicking the Field Positions button. For comprehensive guidance on completing those settings, see File Converter: Fixed Width to CSV.
Enter a custom title for the table in the Table Name text box to define the name that will be used to reference the table within the system. This title should be descriptive and follow any naming conventions set by your organization to ensure consistency and ease of identification. The table name will be used for system reference, so choose a name that clearly reflects the content and purpose of the table.
If your district regularly receives files that need to be imported, you can automate the process using Scheduled Jobs. Instead of manually uploading the same file each time, Focus allows you to save an import configuration and schedule it to run automatically at set intervals. This ensures consistent data updates, minimizes manual effort, and reduces the risk of errors. The following steps walk you through creating a scheduled job directly from an import.
Choose a file either from your local device or one stored within the designated Focus School Software server directory.
It is important that the file selected be in one of the acceptable formats: CSV, Tab-Delimited, Pipe-Delimited, or Fixed Width.
Options include Comma Delimited, Fixed Width, Pipe Delimited (Single), and Tab Delimited.
It is important to note that when dealing with a Fixed-Width file, additional settings must be inputted by clicking the Field Positions button. For comprehensive guidance on completing those settings, see File Converter: Fixed Width to CSV.
Once all additional data input and/or file structure modifications have been finalized, it's time to specify the location for this data within the system. In this interface, you'll establish a one-to-one association between each column from your latest source data and the destination columns in the database tables.
Review total Valid Rows and Invalid Rows including Validation Errors you must address before complete the import process. The Invalid Rows data is displayed at the bottom of the Validation screen where you can carefully review all the information from the file.
For more information on how to set up scheduled jobs, see Scheduled Jobs.
Once created, you can view this job, as well as any others created via Imports > Settings > Scheduled Jobs and/or Setup > Scheduled Jobs.
You are done. Great job!