Collaborative spreadsheet data validation and integration
A system comprising a computer-readable storage medium storing at least one program and a method for integrating collaborative spreadsheet data into one or more network applications is presented. Spreadsheet data and an application data schema are accessed. The spreadsheet data corresponds to a spreadsheet having one or more validation rules. The application data schema comprises a set of constraints on application data consumed by an application hosted by an application server. A notification is displayed in response to determining that the one or more validation rules exclude at least one constraint from the set of constraints. The notification includes an indication that the application data is unable to be synchronized with the spreadsheet data and specifies one or more additional validation rules to associate with the spreadsheet to trigger synchronization of the application data with the spreadsheet data.
1. A system comprising:
one or more processors of a machine; and
a memory storing instructions that, when executed by at least one processor among the one or more processors, causes the machine to perform operations comprising:
accessing spreadsheet data of a spreadsheet having one or more data validation rules;
accessing an application data schema comprising a set of constraints on application data consumed by an application from among a plurality of applications hosted by one or more application servers;
determining the one or more data validation rules exclude at least one constraint from the set of constraints; and
in response to determining the one or more data validation rules exclude at least one constraint from the set of constraints,
preventing synchronization of the application data with the spreadsheet data; and
causing display-of a notification that includes an indication that the application data is unable to be synchronized with the spreadsheet data, the notification specifying the one or more additional validation rules to associate with the spreadsheet to trigger synchronization of the application data with the spreadsheet data, the one or more additional validation rules specified in the notification corresponding to the at least one constraint that has been determined to be excluded from the one or more data validation rules.
2. The system of claim 1 , wherein the operations further comprise:
based on determining that the one or more additional validation rules have been associated with the spreadsheet, synchronizing the application data consumed by the application with the spreadsheet data corresponding to the spreadsheet.
3. The system of claim 2 , wherein the operations further comprise:
causing display of a window that includes a user selectable list of predefined validation rules for association with one or more cells in the spreadsheet;
receiving a user selection, from the user selectable list, of one or more predefined validation rules for association with the one or more cells in the spreadsheet, the one or more predefined validation rules corresponding to the one or more additional validation rules.
4. The system of claim 2 , wherein:
the client device is a first client device from among a plurality of client devices accessing the spreadsheet;
the operations further comprise:
receiving, from a second client device accessing the spreadsheet, a modification to at least one entry in the spreadsheet;
validating the at least one entry according to the one or more data validation rules and the one or more additional validation rules; and
synchronizing the application data consumed by the application with the spreadsheet data such that the application data includes the modification to the at least one entry in the spreadsheet.
5. The system of claim 2 , wherein the operations further comprise:
receiving, from a client device, user specified logic, the logic comprising a name, a validator, and a value type; and
receiving, from the client device, one or more user specified configuration parameters;
wherein the user specified logic and the user specified configuration parameters correspond to at least one of the one or more additional validation rules.
6. The system of claim 1 , wherein the operations further comprise:
causing display of a synchronization interface to present a status of synchronization of the spreadsheet data with each of the plurality of applications, the status of synchronization of the spreadsheet data with a second application indicating the spreadsheet data is synchronized with the second application.
7. The system of claim 6 , wherein
the application data schema is a first application data schema;
the set of constraints is a first set of constraints; and
the operations further comprise:
accessing a further application data schema comprising a second set of constraints on application data consumed by the second application;
determining the one or more data validation rules include the second set of constraints; and
in response to determining the one or more data validation rules include the second set of constraints, synchronizing the application data consumed by the second application with the spreadsheet data.
8. The system of claim 6 , wherein the operations further comprise:
receiving, from a client device accessing the spreadsheet, a modification to at least one entry in the spreadsheet;
validating the at least one entry according to the one or more data validation rules; and
synchronizing the application data consumed by the second application with the spreadsheet data such that the application data includes the modification to the at least one entry in the spreadsheet.
9. The system of claim 1 , wherein the operations further comprise:
validating the spreadsheet according to the one or more data validation rules;
determining at least one cell in the spreadsheet includes an invalid entry; and
in response to determining the at least one cell in the spreadsheet includes the invalid entry, causing the at least one cell to be visually distinguished from remaining cells during display of the spreadsheet.
10. A method comprising:
accessing spreadsheet data of a spreadsheet having one or more data validation rules;
accessing an application data schema comprising a set of constraints on application data consumed by an application from among a plurality of applications hosted by one or more application servers;
determining the one or more data validation rules exclude at least one constraint from the set of constraints; and
in response to determining the one or more data validation rules exclude at least one constraint from the set of constraints,
preventing synchronization of the application data with the spreadsheet data; and
causing display of a notification that includes an indication that the application data is unable to be synchronized with the spreadsheet data, the notification specifying one or more additional validation rules to associate with the spreadsheet to trigger synchronization of the application data with the spreadsheet data, the one or more additional validation rules specified in the notification corresponding to the at least one constraint that has been determined to be excluded from the one or more data validation rules.
11. The method of claim 10 , further comprising:
based on determining that the one or more additional validation rules have been associated with the spreadsheet, synchronizing the application data consumed by the application with the spreadsheet data corresponding to the spreadsheet.
12. The method of claim 11 , further comprising:
causing display of a window that includes a user selectable list of predefined validation rules for association with one or more cells in the spreadsheet;
receiving a user selection, from the user selectable list, of one or more predefined validation rules for association with the one or more cells in the spreadsheet, the one or more predefined validation rules corresponding to the one or more additional validation rules.
13. The method of claim 11 , wherein:
the client device is a first client device from among a plurality of client devices accessing the spreadsheet;
the operations further comprise:
receiving, from a second client device accessing the spreadsheet, a modification to at least one entry in the spreadsheet;
validating the at least one entry according to the one or more data validation rules and the one or more additional validation rules; and
synchronizing the application data consumed by the application with the spreadsheet data such that the application data includes the modification to the at least one entry in the spreadsheet.
14. The method of claim 10 , further comprising:
receiving, from a client device, user specified logic, the logic comprising a name, a validator, and a value type; and
receiving, from the client device, one or more user specified configuration parameters;
wherein the user specified logic and the user specified configuration parameters correspond to at least one of the one or more additional validation rules.
15. The method of claim 10 , further comprising: causing display of a synchronization interface to present a status of synchronization of the spreadsheet data with each of the plurality of applications, the status of synchronization of the spreadsheet data with a second application indicating the spreadsheet data is synchronized with the second application.
16. The method of claim 15 , wherein:
the application data schema is a first application data schema;
the set of constraints is a first set of constraints; and
the operations further comprise:
accessing a further application data schema comprising a second set of constraints on application data consumed by the second application;
determining the one or more data validation rules include the second set of constraints; and
in response to determining the one or more data validation rules include the second set of constraints, synchronizing the application data consumed by the second application with the spreadsheet data.
17. The method of claim 15 , further comprising:
receiving, from a client device accessing the spreadsheet, a modification to at least one entry in the spreadsheet;
validating the at least one entry according to the one or more data validation rules; and
synchronizing the application data consumed by the second application with the spreadsheet data such that the application data includes the modification to the at least one entry in the spreadsheet.
18. The method of claim 10 , further comprising:
validating the spreadsheet according to the one or more data validation rules;
determining at least one cell in the spreadsheet includes an invalid entry; and
in response to determining the at least one cell in the spreadsheet includes the invalid entry, causing the at least one cell to be visually distinguished from remaining cells during display of the spreadsheet.
19. A non-transitory machine-readable storage medium embodying instructions that, when executed by at least one processor of a machine, cause the machine to perform operations comprising:
accessing spreadsheet data of a spreadsheet having one or more data validation rules;
accessing an application data schema comprising a set of constraints on application data consumed by an application from among a plurality of applications hosted by one or more application servers;
determining the one or more data validation rules exclude at least one constraint from the set of constraints; and
in response to determining the one or more data validation rules exclude at least one constraint from the set of constraints,
preventing synchronization of the application data with the spreadsheet data; and
causing display-of a notification that includes an indication that the application data is unable to be synchronized with the spreadsheet data, the notification specifying one or more additional validation rules to associate with the spreadsheet to trigger synchronization of the application data with the spreadsheet data, the one or more additional validation rules specified in the notification corresponding to the at least one constraint that has been determined to be excluded from the one or more data validation rules.
20. The non-transitory machine-readable storage medium of claim 19 , wherein the operations further comprise:
based on determining that the one or more additional validation rules have been associated with the spreadsheet, synchronizing the application data consumed by the application with the spreadsheet data corresponding to the spreadsheet.