METHOD, SYSTEM AND COMPUTER PROGRAM FOR GENERATING ELECTRONIC CHECKLISTS

• US 20150370776A1
• Filed: 06/18/2014
• Published: 12/24/2015
• Est. Priority Date: 06/18/2014
• Status: Active Grant

• Current Assignee: Yokogawa Electric Corporation
• Original Assignee: Yokogawa Electric Corporation
• Inventors: New, Ren Jie
• Granted Patent: US 9,514,118 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 40/117 Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/146 Coding or compression of tree-structured data
• CPC Class Codes: G06F 40/186 Templates
• CPC Class Codes: G06Q 10/063114 Status monitoring or status determination for a person or group

Abstract

The invention comprises a method, system and computer program for database implementation of electronic checklists. The invention implements using at least one processor, the steps of (i) displaying at a user interface, a first electronic checklist template within a template editor (ii) defining a modified electronic checklist template, wherein defining the modified electronic checklist template comprises modifying the first electronic checklist template based on inputs received at the template editor; and (iii) generating a database implemented electronic checklist template. The database implemented electronic checklist template may comprise a markup language encoding of the modified electronic checklist template and at least one system controlled column. Data input within data fields of the at least one system controlled column may be determined by one or more system information parameters, and one or more predefined rules of system behaviour associated with the at least one system controlled column.

Claims

1. A method for database implementation of electronic checklists, the method comprising implementing using at least one processor, the steps of:

displaying at a user interface, a first electronic checklist template within a template editor;

defining a modified electronic checklist template, wherein defining the modified electronic checklist template comprises modifying the first electronic checklist template based on inputs received at the template editor;

and

generating a database implemented electronic checklist template, the database implemented electronic checklist template comprising;

a markup language encoding of the modified electronic checklist template; and

at least one system controlled column, wherein data input within data fields of the at least one system controlled column is determined by;

one or more system information parameters; and

one or more predefined rules of system behaviour associated with the at least one system controlled column.

2. The method according to claim 1, wherein the first electronic checklist template comprises checklist definition information extracted from a pre-existing checklist template.

3. The method according to claim 1, wherein defining the modified electronic checklist template includes selecting for inclusion within the modified electronic checklist template, a system controlled column within the first electronic checklist template, said system controlled column having one or more predefined rules of system behaviour associated therewith.

4. The method according to claim 1, wherein generating the database implemented electronic checklist template comprises:

parsing content of the modified electronic checklist template;

generating a markup language encoded checklist template comprising columns and column descriptors corresponding to columns and column descriptors parsed from the modified electronic checklist template; and

for each checklist item parsed from the modified electronic checklist template, adding a template row to the markup language encoded checklist template and populating the added template row with data fields extracted from the parsed checklist item.

5. The method according to claim 1, wherein generating the database implemented electronic checklist template further comprises one or more of

for each section defined in the modified electronic checklist template, adding a merged row to the markup language encoded checklist template, and setting content of the merged row to a corresponding section title parsed from the modified electronic checklist template;

for each drop down list defined in the modified electronic checklist template, generating a drop down list control object and populating the drop down list control object with corresponding drop down options parsed from the modified electronic checklist template;

or

selecting a system controlled column for inclusion within the modified electronic checklist template, and associating predefined rules of system behaviour with said system controlled column.

6. The method according to claim 1, wherein the system information parameters determining data input within data fields of the at least one system controlled column includes at least one of:

identity of a user updating a checklist item data field;

date of modification of a checklist item data field; and

time of modification of a checklist item data field.

7. The method according to claim 1, wherein generating the database implemented electronic checklist template further comprises configuring at least one data field corresponding to a system controlled column within the markup language encoded checklist template, to respond to a predefined event trigger by implementing a predefined system behaviour determined by one or more predefined rules of system behaviour associated with the at least one data field.

8. The method according to claim 7, wherein the predefined system behaviour comprises one of:

responding to input seeking to assign responsibility for a checklist item, by displaying to the assigning user, a drop down list of selectable assignees;

responding to input generated predefined event trigger by generating a corresponding event notification to one or more recipients;

responding to input generated predefined event trigger by assigning responsibility for a specific checklist item to a specified assignee;

or

responding to input received from the user interface for a checklist item, by executing a data validation check in connection with data submitted by said input, and wherein the data validation check is based on one or more predefined data validation rules associated with the checklist item.

9. The method according to claim 1, further comprising responding to input requesting a checklist instance of the database implemented electronic checklist template by:

retrieving checklist definition information corresponding to the database implemented electronic checklist template;

retrieving one or more predefined rules of system behaviour associated with all system controlled columns within the database implemented electronic checklist template;

and

generating a checklist instance for display at the user interface based on the retrieved checklist definition information;

wherein data input within data fields of each system controlled column within the displayed checklist instance is controlled by the retrieved predefined rules of system behaviour associated with said system controlled column.

10. A system for database implementation of electronic checklists, the system comprising:

a processor;

a template editor controller configured to;

display at a user interface, a first electronic checklist template within a template editor define a modified electronic checklist template, wherein the modified electronic checklist template comprises the first electronic checklist template modified based on inputs received at the template editor;

an electronic checklist application controller configured to generate a database implemented electronic checklist template, the database implemented electronic checklist template comprising;

a markup language encoding of the modified electronic checklist template; and

at least one system controlled column, wherein data input within data fields of the at least one system controlled column is determined by;

one or more system information parameters; and

one or more predefined rules of system behaviour associated with the at least one system controlled column.

11. The system according to claim 10, wherein the template editor controller is configured to display the first electronic checklist template based on checklist definition information extracted from a pre-existing checklist template.

12. The system according to claim 10, wherein the template editor controller is configured to enable selection for inclusion within the modified electronic checklist template, a system controlled column within the first electronic checklist template, said system controlled column having one or more predefined rules of system behaviour associated therewith.

13. The system according to claim 10, wherein the electronic checklist application controller is configured to:

parse content of the modified electronic checklist template;

generate a markup language encoded checklist template comprising columns and column descriptors corresponding to columns and column descriptors parsed from the modified electronic checklist template; and

for each checklist item parsed from the modified electronic checklist template, add a template row to the markup language encoded checklist template and populate the added template row with data fields extracted from the parsed checklist item.

14. The system according to claim 10, wherein the electronic checklist application controller is configured:

for each section defined in the modified electronic checklist template, to add a merged row to the markup language encoded checklist template, and set content of the merged row to a corresponding section title parsed from the modified electronic checklist template;

for each drop down list defined in the modified electronic checklist template, to generate a drop down list control object and populate the drop down list control object with corresponding drop down options parsed from the modified electronic checklist template;

or

to select for inclusion within the the markup language encoded checklist template, at least one system controlled column, and associating predefined rules of system behaviour with said system controlled column.

15. The system according to claim 10, wherein the system information parameters determining data input within data fields of the at least one system controlled column includes at least one of:

identity of a user updating a checklist item data field;

date of modification of a checklist item data field; and

time of modification of a checklist item data field.

16. The system according to claim 10, wherein the electronic checklist application controller configures at least one data field corresponding to a system controlled column within the markup language encoded checklist template, to respond to a predefined event trigger by implementing a predefined system behaviour determined by one or more predefined rules of system behaviour associated with the at least one data field.

17. The system according to claim 16, wherein the predefined system behaviour comprises one of:

responding to input seeking to assign responsibility for a checklist item, by displaying to the assigning user, a drop down list of selectable assignees;

responding to input generated predefined event trigger by generating a corresponding event notification to one or more recipients;

responding to input generated predefined event trigger by assigning responsibility for a specific checklist item to a specified assignee;

or

responding to input received for a checklist item, by executing a data validation check in connection with data submitted through said input, and wherein the data validation check is based on one or more predefined data validation rules associated with the checklist item.

18. The system according to claim 10, comprising a checklist instance generator configured to respond to input for a checklist instance of the database implemented electronic checklist template by:

retrieving checklist definition information corresponding to the database implemented electronic checklist template;

retrieving one or more predefined rules of system behaviour associated with all system controlled columns within the database implemented electronic checklist template;

and

generating a checklist instance for display at the user interface based on the retrieved checklist definition information;

wherein data input within data fields of each system controlled column within the displayed checklist instance is controlled by the retrieved predefined rules of system behaviour associated with said system controlled column.

19. A computer program product for database implementation of electronic checklists, comprising a non-transitory computer-readable storage medium having program code stored therein, the program code comprising computer readable instructions for:

displaying at a user interface, a first electronic checklist template within a template editor;

defining a modified electronic checklist template, wherein defining the modified electronic checklist template comprises modifying the first electronic checklist template based on inputs received at the template editor;

and

generating a database implemented electronic checklist template, the database implemented electronic checklist template comprising;

a markup language encoding of the modified electronic checklist template; and

at least one system controlled column, wherein data input within data fields of the at least one system controlled column is defined by;

one or more system information parameters; and

one or more predefined rules of system behaviour associated with the at least one system controlled column.