Differences

This shows you the differences between two versions of the page.

--- annual_school_census_workbook_user_manual [2020/03/23 06:46] – [Protected Sheets] ghachey
+++ annual_school_census_workbook_user_manual [2022/05/04 19:31] (current) – [Rollover] ghachey
@@ Line 111: / Line 111: @@
 ===== Rollover =====
-<note warning>Always use some test copies of your data before you perform this on your live data. You need to do a number of practice runs to familiarise yourself with how this works.</note>
+<note warning>The rollover done in the workbook still work but is not supported and is no longer the recommended way to do a rollover. The rollover should be done directly within the EMIS online. Refer to [[https://docs.pacific-emis.org/doku.php?id=emis_user_manual#rollover_workbook|https://docs.pacific-emis.org/doku.php?id=emis_user_manual#rollover_workbook]]</note>
+<note important>Always use some test copies of your data before you perform this on your live data. You need to do a number of practice runs to familiarise yourself with how this works.</note>
 The rollover function allows you to anticipate enrolments for a new school year. The function is based around the Completed and Outcome columns (Outcomes view) and the ‘From’ column in the Enrolment.
@@ Line 206: / Line 208: @@
 FIXME
+===== Advanced =====
+==== Refresh Data Connection ====
+To improve data quality the workbook makes use of data connection to the EMIS database. It does that to retrieve the exact school name and various dropdown values. It can be useful to know how to refresh those data connection if any dropdown is updated in the EMIS for example. This is shown below.
+{{ :annual-census-user-manual:refresh-workbook-data-connection.png?nolink |}}