FTP Staff

The Staff FTP will import file that is located on the SFTP server.  The file name needs to have the word "staff" in the name in order for the import to recognize the file as the student import (i.e. new_staff_import.csv (all lower case).  The file has to be in the same order as the field mappings located in the Import Settings.

Once your FTP site has been configured with your site information, connect to the site and paste your file under the remote site side.  

 A message should display that file has transferred to FTP site.  

.

In One to One Plus, the file will be automatically imported and a submitted message will display.

If any issues are detected, you can click the link to view the log file and identify the problem within the file.

The status will change to complete once it has finished the process. It will also update the appropriate columns with the number of records that were created, updated, unchanged or if errors were found. If errors are found, they can be fixed in the file and uploaded again.

When you click on the Missing Lookups link, a screen will appearing showing you the Table that contains the missing information.  You can then select the to add the Value or the Mapping icon to map the value to an internal value that has already been added to the system.   You can choose the button to add one record at a time or choose the button which allows you to add missing lookups more efficiently, saving each new record or mapping and advancing to the next record automatically.

Once you enter the required fields marked with a red asterisk (*), you can select the button to create records one at a time, or use the button to add missing lookups more efficiently—saving each new record or mapping and automatically advancing to the next missing lookup.

Import Logs are also stored to show the status of previous imports. You can also download the imported file for each entry by clicking the "File" link on the right side (see below).