Difference between revisions of "School dinners"

From InsightWiki
Jump to navigation Jump to search
(6 intermediate revisions by the same user not shown)
Line 7: Line 7:
 
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>
+
==Configuration==
  
[[Image:dinner02.jpg]] <br> <br>
+
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) <br> <br>
  
==Configuration==
+
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. <br> <br>
  
 
===SIMS===
 
===SIMS===
  
default in the absence of another <br>
+
The SIMS school dinners system will be used if none of the systems below are being used. <br> <br>
  
 
===NRS===
 
===NRS===
  
bin folder NRS2000Cashless.INI <br> <br>
+
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: <br> <br>
  
DATASERVER= <br>
+
DATASERVER= <br>
DATAUSERNAME= <br>
+
DATAUSERNAME= <br>
DATAPASSWORD= <br> <br>
+
DATAPASSWORD=
 
+
<br> <br>
database name is always hardcoded <br> <br>
 
  
 
===Vericool===
 
===Vericool===
  
bin folder VericoolCashless.INI <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>
database name is always hardcoded <br> <br>
 
  
 
===EasyTrace===
 
===EasyTrace===
  
bin folder EasyTraceCashless.INI -> EasyTraceCashless.CONFIG upon first use (config is encrypted and unservable) <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===
  
bin folder Cyclone.INI -> Cyclone.CONFIG upon first use (config is encrypted and unservable) <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>
  
user is always hardcoded <br> <br>
+
===IMPACT===
  
===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: <br> <br>
 +
 
 +
[GENERAL] <br>
 +
HOST= <br>
 +
PORT= <br>
 +
MINIFIED=1 <br>
 +
KEYFIELD=PERSONID <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>
  
bin folder IMPACTQuery.INI <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>
  
[GENERAL] <br>
+
<div>[[Image:inscdinn1.jpg]]</div> <br> <br>
HOST= <br>
 
PORT= <br>
 
MINIFIED=1 <br>
 
KEYFIELD=PERSONID <br>
 
DAYS= <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