From wiki.ginstr.com
Jump to: navigation, search
m (Mark moved page plugins to Plugins)
Line 15: Line 15:
 
! scope="col" | Applications
 
! scope="col" | Applications
 
|-
 
|-
| title="Plugin" | <code>Working Times Generator</code>
+
| title="Plugin" | <code><span id="Working_Times_Generator">Working Times Generator</span></code>
 
| title="Brief Description" | Generates data in tables <code>TMTargetServices</code>, <code>TMTargetServicesPerRoom</code>, <code>TMServicesRendered</code> and <code>TMServicesPerformed</code> based on master data entered in master data tables of Plus<sup>©</sup> apps
 
| title="Brief Description" | Generates data in tables <code>TMTargetServices</code>, <code>TMTargetServicesPerRoom</code>, <code>TMServicesRendered</code> and <code>TMServicesPerformed</code> based on master data entered in master data tables of Plus<sup>©</sup> apps
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
|-
 
|-
| title="Plugin" | <code>Incidents Processor</code>
+
| title="Plugin" | <code><span id="Incidents_Processor">Incidents Processor</span></code>
 
| title="Brief Description" | Combines data sent from device to existing data in table <code>TMServicesRendered</code> and also moves data sent from device related to incidents from table <code>TMClientIncidentsReported</code> to table <code>TMIncidentsReported</code>
 
| title="Brief Description" | Combines data sent from device to existing data in table <code>TMServicesRendered</code> and also moves data sent from device related to incidents from table <code>TMClientIncidentsReported</code> to table <code>TMIncidentsReported</code>
 
Also sends e-mail alert to manager when record is created in table <code>TMOverdueEmployeeCheckIn</code> and related to employees that are late for work in some tour / zone
 
Also sends e-mail alert to manager when record is created in table <code>TMOverdueEmployeeCheckIn</code> and related to employees that are late for work in some tour / zone
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
|-
 
|-
| title="Plugin" | <code>Time per Zone Refresher</code>
+
| title="Plugin" | <code><span id="Time_per_Zone_Refresher">Time per Zone Refresher</span></code>
 
| title="Brief Description" | Updates records in table <code>TMTourTimeReport</code> with real time spent in each tour / zone for each working day
 
| title="Brief Description" | Updates records in table <code>TMTourTimeReport</code> with real time spent in each tour / zone for each working day
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
|-
 
|-
| title="Plugin" | <code>Services Modification Processor</code>
+
| title="Plugin" | <code><span id="Services_Modification_Processor">Services Modification Processor</span></code>
 
| title="Brief Description" | Updates data in table <code>TMServicesRendered</code> in case some data is changed via UI
 
| title="Brief Description" | Updates data in table <code>TMServicesRendered</code> in case some data is changed via UI
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
|-
 
|-
| title="Plugin" | <code>SOS Processor</code>
+
| title="Plugin" | <code><span id="SOS_Processor">SOS Processor</span></code>
 
| title="Brief Description" | Sends e-mail alert to manager when record with SOS alert is sent from device to table <code>TMClientSOS</code>.
 
| title="Brief Description" | Sends e-mail alert to manager when record with SOS alert is sent from device to table <code>TMClientSOS</code>.
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
| title="Applications" | All [[:Category:Plus_apps|Plus<sup>©</sup> apps]]
 
|-
 
|-
| title="Plugin" | <code>Missing Employee Checker</code>
+
| title="Plugin" | <code><span id="Missing_Employee_Checker">Missing Employee Checker</span></code>
 
| title="Brief Description" |  Sends e-mail alert to manager in case some employee fails to show up to work as expected.
 
| title="Brief Description" |  Sends e-mail alert to manager in case some employee fails to show up to work as expected.
 
| title="Applications" | Fair Parken Parking Manager
 
| title="Applications" | Fair Parken Parking Manager
 
|-
 
|-
| title="Plugin" | <code>Optitime to BRZ converter</code>
+
| title="Plugin" | <code><span id="Optitime_to_BRZ_converter">Optitime to BRZ converter</span></code>
 
| title="Brief Description" |  Creates CSV file in format used by app called BRZ based on CSV file from Optitime app and ginstr tables
 
| title="Brief Description" |  Creates CSV file in format used by app called BRZ based on CSV file from Optitime app and ginstr tables
 
| title="Applications" | Wähler/Kuhlmann Builder's Yard Asset Management
 
| title="Applications" | Wähler/Kuhlmann Builder's Yard Asset Management
 
|-
 
|-
| title="Plugin" | <code>Generic Scheduler</code>
+
| title="Plugin" | <code><span id="Generic_Scheduler">Generic Scheduler</span></code>
 
| title="Brief Description" | Sends e-mail alerts based on frequency defined in table of app where this plugin will be integrated.
 
| title="Brief Description" | Sends e-mail alerts based on frequency defined in table of app where this plugin will be integrated.
 
| title="Applications" | <code>None to date</code>
 
| title="Applications" | <code>None to date</code>
 
|-
 
|-
| title="Plugin" | <code>Dashboard Issue Scheduler</code>
+
| title="Plugin" | <code><span id="Dashboard_Issue_Scheduler">Dashboard Issue Scheduler</span></code>
 
| title="Brief Description" | Generates content in tables <code>dashboard</code> and <code>dashboard issues</code> based on content in table <code>issues</code>.
 
| title="Brief Description" | Generates content in tables <code>dashboard</code> and <code>dashboard issues</code> based on content in table <code>issues</code>.
 
Plugin is scheduled and once it runs it populates tables <code>dashboard</code> and <code>dashboard issues</code> with info on :-
 
Plugin is scheduled and once it runs it populates tables <code>dashboard</code> and <code>dashboard issues</code> with info on :-
Line 58: Line 58:
 
| title="Applications" | TDS Escalation
 
| title="Applications" | TDS Escalation
 
|-
 
|-
| title="Plugin" | <code>Time Spent per Status</code>
+
| title="Plugin" | <code><span id="Time_Spent_per_Status">Time Spent per Status</span></code>
 
| title="Brief Description" |  Calculates time spent for each status option set.
 
| title="Brief Description" |  Calculates time spent for each status option set.
 
In case of Oxford Plastics the plugin calculates the time spent in a status for a specific product.
 
In case of Oxford Plastics the plugin calculates the time spent in a status for a specific product.
 +
 +
Oxford Plastics app has tables :-
 +
:*<code>product scans</code>
 +
:*<code>product status spent time</code>.
 +
 +
When a record appears in table <code>product scans</code> with some status then plugin record is generated in table <code>product status spent time</code> for that same product and status with value 0.00 in column "'''spent time'''" and with unchecked value in column "'''interval closed'''" (indicating that product is still in that status).
 +
 +
If a new record appears in table <code>product scans</code> with same status then just time in column "'''spent time'''" of table <code>product status spent time</code> is updated but value remains [[File:checkbox0.png|link=]] <code>unchecked</code> in column "'''interval closed'''" of table <code>product status spent time</code>.
 +
 +
If a new record appears in table <code>product scans</code> for that product but with different status than in table <code>product status spent time</code> in existing record, then the value of time in column "'''spent time'''" is updated and also value in column "'''interval closed'''" is changed to [[File:checkbox1.png|link=]] <code>checked</code> and also at the same time a new record is created for new status of that product with value 0.00 in column "spent time" and with [[File:checkbox0.png|link=]] <code>unchecked</code> value in column "'''interval closed'''"
 
| title="Applications" | Oxford Plastics
 
| title="Applications" | Oxford Plastics
 
|-
 
|-
 
|}
 
|}

Revision as of 14:11, 3 September 2018

Plugins

Plugins handle certain complex functionalities which cannot be handled in any other way (for example executing some calculations based on data in two separate tables, or sending e-mails based on data which requires certain information from different tables of an app etc..)

The plugins section of the SSO 'My account page' displays a list of all plugins installed for the currently logged in SSO account. This section also affords access to settings pertaining to each installed plugin and a checkbox which can be used to enable/disable each plugin as required.


The table below contains a brief description of all currently-available plugins.

Plugin Brief Description Applications
Working Times Generator Generates data in tables TMTargetServices, TMTargetServicesPerRoom, TMServicesRendered and TMServicesPerformed based on master data entered in master data tables of Plus© apps All Plus© apps
Incidents Processor Combines data sent from device to existing data in table TMServicesRendered and also moves data sent from device related to incidents from table TMClientIncidentsReported to table TMIncidentsReported

Also sends e-mail alert to manager when record is created in table TMOverdueEmployeeCheckIn and related to employees that are late for work in some tour / zone

All Plus© apps
Time per Zone Refresher Updates records in table TMTourTimeReport with real time spent in each tour / zone for each working day All Plus© apps
Services Modification Processor Updates data in table TMServicesRendered in case some data is changed via UI All Plus© apps
SOS Processor Sends e-mail alert to manager when record with SOS alert is sent from device to table TMClientSOS. All Plus© apps
Missing Employee Checker Sends e-mail alert to manager in case some employee fails to show up to work as expected. Fair Parken Parking Manager
Optitime to BRZ converter Creates CSV file in format used by app called BRZ based on CSV file from Optitime app and ginstr tables Wähler/Kuhlmann Builder's Yard Asset Management
Generic Scheduler Sends e-mail alerts based on frequency defined in table of app where this plugin will be integrated. None to date
Dashboard Issue Scheduler Generates content in tables dashboard and dashboard issues based on content in table issues.

Plugin is scheduled and once it runs it populates tables dashboard and dashboard issues with info on :-

  • total number of issues
  • number of resolved issues
  • number of unresolved issues
  • time required to resolve issue
  • number of issues in certain category (this info is generated in table dashboard issues)
TDS Escalation
Time Spent per Status Calculates time spent for each status option set.

In case of Oxford Plastics the plugin calculates the time spent in a status for a specific product.

Oxford Plastics app has tables :-

  • product scans
  • product status spent time.

When a record appears in table product scans with some status then plugin record is generated in table product status spent time for that same product and status with value 0.00 in column "spent time" and with unchecked value in column "interval closed" (indicating that product is still in that status).

If a new record appears in table product scans with same status then just time in column "spent time" of table product status spent time is updated but value remains checkbox0.png unchecked in column "interval closed" of table product status spent time.

If a new record appears in table product scans for that product but with different status than in table product status spent time in existing record, then the value of time in column "spent time" is updated and also value in column "interval closed" is changed to checkbox1.png checked and also at the same time a new record is created for new status of that product with value 0.00 in column "spent time" and with checkbox0.png unchecked value in column "interval closed"

Oxford Plastics