Difference between revisions of "School dinners"

From InsightWiki
Jump to navigation Jump to search
(5 intermediate revisions by the same user not shown)
Line 6: Line 6:
  
 
Account balances cannot be adjusted or topped-up using this page; this must be done as normal through the school. <br> <br>
 
Account balances cannot be adjusted or topped-up using this page; this must be done as normal through the school. <br> <br>
 
[[Image:dinner01.jpg|800px]] <br> <br>
 
 
[[Image:dinner02.jpg]] <br> <br>
 
  
 
==Configuration==
 
==Configuration==
Line 27: Line 23:
 
  DATASERVER= <br>
 
  DATASERVER= <br>
 
  DATAUSERNAME= <br>
 
  DATAUSERNAME= <br>
  DATAPASSWORD= <br> <br>
+
  DATAPASSWORD=
 +
<br> <br>
  
 
===Vericool===
 
===Vericool===
Line 33: Line 30:
 
Save a file called "VericoolCashless.INI" into the Insight bin folder. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
 
Save a file called "VericoolCashless.INI" into the Insight bin folder. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
  
DATASERVER= <br>
+
DATASERVER= <br>
DATAUSERNAME= <br>
+
DATAUSERNAME= <br>
DATAPASSWORD= <br> <br>
+
DATAPASSWORD=
 +
<br> <br>
  
 
===EasyTrace===
 
===EasyTrace===
Line 41: Line 39:
 
Save a file called "EasyTraceCashless.INI" into the Insight bin folder. The file will be converted to .CONFIG as soon as the program is run. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
 
Save a file called "EasyTraceCashless.INI" into the Insight bin folder. The file will be converted to .CONFIG as soon as the program is run. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
  
DATASERVER= <br>
+
DATASERVER= <br>
DATABASENAME= <br>
+
DATABASENAME= <br>
DATAUSERNAME= <br>
+
DATAUSERNAME= <br>
DATAPASSWORD= <br> <br>
+
DATAPASSWORD=
 +
<br> <br>
  
 
===Cyclone===
 
===Cyclone===
Line 50: Line 49:
 
Save a file called "Cyclone.INI" into the Insight bin folder. The file will be converted to .CONFIG as soon as the program is run. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
 
Save a file called "Cyclone.INI" into the Insight bin folder. The file will be converted to .CONFIG as soon as the program is run. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
  
DATASERVER= <br>
+
DATASERVER= <br>
DATABASENAME= <br>
+
DATABASENAME= <br>
DATAPASSWORD= <br> <br>
+
DATAPASSWORD=
 +
<br> <br>
  
 
===IMPACT===
 
===IMPACT===
Line 58: Line 58:
 
Save a file called "IMPACTQuery.INI" into the Insight bin folder. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
 
Save a file called "IMPACTQuery.INI" into the Insight bin folder. The file will need to following fields, where you enter the relevant data for each field: <br> <br>
  
[GENERAL] <br>
+
[GENERAL] <br>
HOST= <br>
+
HOST= <br>
PORT= <br>
+
PORT= <br>
MINIFIED=1 <br>
+
MINIFIED=1 <br>
KEYFIELD=PERSONID <br>
+
KEYFIELD=PERSONID <br>
DAYS= <br> <br>
+
DAYS=
 +
<br> <br>
 +
 
 +
==Reporting==
 +
 
 +
A report for the School Dinners option can be found via '''Reports''' > '''School Dinners'''. This report is generated when the first user accesses the school dinners option and reports back whether it has been successful or not. In order for it to run successfully the relevant ini.personalisation file should be in the correct folder and should be able to access the relevant database as shown above. <br> <br>
 +
 
 +
If successful the report will show the PATH, SOURCE, Transaction count, Columns (relating to items on a receipt) and Rows (giving specific information about the entries in the columns). If the request is unsuccessful then errors will show for the relevant field. <br> <br>
 +
 
 +
<div>[[Image:inscdinn1.jpg]]</div> <br> <br>
  
[[Category:Usage]]
+
[[Category:Features]]
[[Category:Configuration]]
+
[[Category:Management]]
 +
[[Category:Reports]]

Revision as of 08:30, 14 April 2016

Usage

Some cashless catering systems can be linked with Insight, so that parents can see what their children are eating for lunch, what's on the menu and how much money they have remaining on their account.

By default this page will show today's menu. Parents can view their child's receipts by clicking the money bag button at the top left of the page.

Account balances cannot be adjusted or topped-up using this page; this must be done as normal through the school.

Configuration

To configure school dinners, you will need to create a file and store it in Insight's bin folder on the IIS server that hosts Insight (typically found via C:\inetpub\wwwroot\INSIGHT\bin)

The format and information required for each of the files is found below. They must be named and typed exactly as shown in the examples.

SIMS

The SIMS school dinners system will be used if none of the systems below are being used.

NRS

Save a file called "NRS2000Cashless.INI" into the Insight bin folder. The file will need to following fields, where you enter the relevant data for each field:

DATASERVER= 
DATAUSERNAME=
DATAPASSWORD=



Vericool

Save a file called "VericoolCashless.INI" into the Insight bin folder. The file will need to following fields, where you enter the relevant data for each field:

DATASERVER= 
DATAUSERNAME=
DATAPASSWORD=



EasyTrace

Save a file called "EasyTraceCashless.INI" into the Insight bin folder. The file will be converted to .CONFIG as soon as the program is run. The file will need to following fields, where you enter the relevant data for each field:

DATASERVER= 
DATABASENAME=
DATAUSERNAME=
DATAPASSWORD=



Cyclone

Save a file called "Cyclone.INI" into the Insight bin folder. The file will be converted to .CONFIG as soon as the program is run. The file will need to following fields, where you enter the relevant data for each field:

DATASERVER= 
DATABASENAME=
DATAPASSWORD=



IMPACT

Save a file called "IMPACTQuery.INI" into the Insight bin folder. The file will need to following fields, where you enter the relevant data for each field:

[GENERAL] 
HOST=
PORT=
MINIFIED=1
KEYFIELD=PERSONID
DAYS=



Reporting

A report for the School Dinners option can be found via Reports > School Dinners. This report is generated when the first user accesses the school dinners option and reports back whether it has been successful or not. In order for it to run successfully the relevant ini.personalisation file should be in the correct folder and should be able to access the relevant database as shown above.

If successful the report will show the PATH, SOURCE, Transaction count, Columns (relating to items on a receipt) and Rows (giving specific information about the entries in the columns). If the request is unsuccessful then errors will show for the relevant field.

Inscdinn1.jpg