Data Integration with Skyward Qmlativ

userXello Admin Xello productAccounts Time3 minutes

Xello securely exchanges data with Student Information Systems (SIS) through data integration. It's required to create student accounts in the program, and automatically takes care of tasks like deactivating, transferring, and updating student accounts, as long as the information in the SIS is kept up to date.

Data file export

Skyward Qmlativ exchanges data with Xello through a scripted integration. There are four data export reports to run: Course Master, Schools, Student Courses, Students. To find these files:

  1. From your Skyward Qmlativ account, click Administrative Access.
  2. From the left menu, click Reporting and select Report Manager.
    Click to enlarge

Clone a report from Skyward

If you're migrating from Skyward to Skyward Qmlativ, there is no way to edit a report that was created by Skyward (Owner). Instead, you can clone a report and edit the fields you want to include in the file export. For example, the student number in the original report may not be the same student number as in the SIS.

To clone a report: 

  1. Next to the report you want to clone, click the down arrow and select Clone Report.
    Click to enlarge
  2. The title of the new report will be the original report name, followed by (Clone). For example, the clone of "Career Cruising Students" will be "Career Cruising Students (Clone)"

Schedule a report

To schedule a report in Skyward Qmlativ: 

  1. From the Report Manager page, find the report you want to schedule.
  2. To the left of the report name, click the arrow icon to open the Report Details.
    Click to enlarge
  3. From the left menu, click Scheduled Reports.
    Click to enlarge
  4. From the top right, click Add Scheduled Report.
    Click to enlarge
  5. Fill out the form details, then click Save & Add Export Location to add FTP credentials.
    Click to enlarge
  6. Next to File Destination, click Add FTP/SFTP Connection.
    Click to enlarge
  7. Enter the FTP credentials and click Save.
    • The Host name is ftp
    • Leave the Remote Directory field blank.
    Click to enlarge
  8. Back on the Save & Add Export Location page, select the File Destination.
    Click to enlarge
  9. The report will be scheduled and in queue.
    Click to enlarge
  10. To the left of the report name, click the down arrow and select Run Report Now.
    Click to enlarge