Skip to main content

How to export data from Synergetic

This guide points you to where to find class, subject, teacher and student data in Synergetic so you can bring it into Atomi. It's for school administrators, registrars or IT staff who manage Synergetic.

Written by Holly

Synergetic doesn't have one export that covers everything in a single file. Class, subject and year level data come out cleanly from one screen, but teacher and student email addresses usually need help from whoever manages your Synergetic database.

Prerequisites

  • A Synergetic user account with access to Class Maintenance (in the Curriculum or Assessments module). Access is controlled through Group/User Security Maintenance, so confirm with whoever manages Synergetic security that your login can see the Students and Staff tabs.

  • Access to Staff Maintenance and Student Maintenance for individual email lookups.

  • For a bulk email export, your Synergetic report writer or IT administrator is best, since this typically needs a database query rather than a standard export.

  • Microsoft Excel, to combine the exports.

Note: Synergetic runs as both a Windows desktop application and a browser-based portal called SynWeb. Screens may differ depending on which your school uses, so check with your Synergetic administrator if a menu doesn't match what you see.

Where to find each export

  • Classes, year levels and subjects: click the Module menu item, then Students or Assessments, then the Class Maintenance menu item. Click the General tab to see Class ID, Description, Normal Year Level and Learning Area (subject).

  • Teacher and student names: click the Staff tab or the Students tab on the same Class Maintenance window, then right-click the grid and click the Export to Excel (all fields) menu item on each.

  • Teacher and student email addresses: not shown on those tabs. Ask your Synergetic report writer or IT administrator to run a database extract joining classes, students, staff and contact details.

Combine the exports using each person's Synergetic ID as the matching key. For the exact, current navigation and help setting up a database extract, see Synergetic's help and support portal.

Note: Once you've exported this data, head back to Preparing your data for import into Atomi to format it using the Atomi Import Template and send it through to us.

Troubleshooting

Class Maintenance doesn't show teacher or student email addresses. This is expected. The Staff and Students tabs only show name, ID, role and class status. You'll need the separate database extract step above for emails.

The "Export to Excel (all fields)" option isn't in my right-click menu. This is usually a security permissions issue. Ask your Synergetic system administrator to check that your security group has grid export access enabled.

My combined spreadsheet has duplicate or mismatched rows. This usually happens when a class has more than one teacher, or when ID columns don't match exactly between exports (for example, a dropped leading zero). Format ID columns as text and match on ID rather than name.

I can't get to Class Maintenance or the database extraction tools at all. Both need specific permission levels that aren't part of a standard Synergetic login. Ask your Synergetic administrator to check your access.

Where to go for help

For anything specific to how your school's Synergetic system is set up, check Synergetic's help and support portal or submit a support ticket to their team directly.

For questions about bringing this data into Atomi, email provisioning@getatomi.com.

Did this answer your question?