What's new to Extracting data

This section outlines changes to the Extracting data manual arising from changes made to Synergetic (versions 64.13-65.19).

Note: The look and feel of Synergetic depends on the PC it is running on. The screenshots in this manual use both the version 65 and pre-65 look and feel. You may notice a slight difference in appearance between this manual and Synergetic running at your organisation but the functionality is exactly the same.

Change	More information	See...
Crystal reports documentation added.	Information about using crystal reports and creating specific reports has been added.	Extracting data for Crystal reports

Last modified: 29/05/2013 4:02:36 PM

This section outlines changes to the Extracting data manual arising from changes made to Synergetic (versions 62.46-63.18).

Change	More information	See...
Some Synergetic views are obsolete.	The following Synergetic views are obsolete: vxeOliverBorrowingExport vStudentContactsLivesWith vStudentReportsSemesterYear vStudentAssessmentAreasResults vStudentAssessmentAreaSendMat.	Main Synergetic views
One Synergetic finance view is obsolete.	The following Synergetic finance view is obsolete: vDebtorSiblingDiscounts.	Main Finance views
Field name corrected in documentation.	File Semester should read FileSemester, in the Useful fields section.	Extracting data using the Microsoft Query wizard

Change

More information

See...

Some Synergetic views are obsolete.

The following Synergetic views are obsolete:

vxeOliverBorrowingExport
vStudentContactsLivesWith
vStudentReportsSemesterYear
vStudentAssessmentAreasResults
vStudentAssessmentAreaSendMat.

Main Synergetic views

One Synergetic finance view is obsolete.

The following Synergetic finance view is obsolete: vDebtorSiblingDiscounts.

Main Finance views

Field name corrected in documentation.

File Semester should read FileSemester, in the Useful fields section.

Extracting data using the Microsoft Query wizard

Last modified: 29/05/2013 4:02:36 PM

This section outlines the changes to the Extracting data manual arising from changes made to Synergetic (version 60.37-62.45).

Change	More information	See
New views added.	vFutureContactsRelationOnly vFuuremedDetailsPrimContact	Main Synergetic views

This section outlines the changes to the Extracting data manual arising from changes made to Synergetic (version 59.15-v60.37).

Change	More information	See
Views available for use.	The introduction has been updated and two new topics have been added, listing the main views available: Main Synergetic views Main Finance views.	Extracting data from the Synergetic database Synergetic views Main Synergetic views Main Finance views
New views added.	Descriptions have been included for the following views, which were added recently: vxeOliverBorrowingExport vStudentRelationsAll vNZMOE_StudentDataChanges vStudentContactsLivesWith vNZMOE_eAR_SchoolDetails vStudentParentsMCEETYA vStudentAbsenceEvents vStudentAbsenceEventsAttendances vStudentMedicalDetails Fields in the following views have been changed or added but no specific information has been included in the documentation: vCommunityAddresses vCommunityAddressesConstit vDebtorFees vStudentMedDetailsPrimContact vStudentsCurrentPastFutureCombined vStudentContactAddress Absences vStudentReportsSemesterResults vStaffTimetableFull vStudentClassesAll pvStudentAssessmentMarkbookAreas vTimetableRooms vCreditorTransactions pvPayrollEmployeeLeaveEntitleAll vPayrollEmployeeLeaveSummary	Main Synergetic views
Updated topics.	Additional screen captures have been included to: improve the readability of the examples provide updated information for a later release of Microsoft Excel (2003).	Extracting data using the Microsoft Query wizard Extracting student name and contact details example Editing a Microsoft Query using the wizard Extracting student name and contact details example
New topics.	New topics have been included to provide information on using stored procedures to retrieve Synergetic data. Examples are provided for developing mail merge letters.	Using stored procedures to retrieve Synergetic data Creating mail merge letters using stored procedures Printing mail merge letters using an existing document Reprinting mail merge letters