Data source write back and offline data editing and storage in a spreadsheet
First Claim
1. A method of bi-directional communication between a spreadsheet application and a database, comprising:
- connecting a spreadsheet to a data source;
importing via the spreadsheet application data to the spreadsheet from the data source;
modifying the imported data in the spreadsheetpublishing data from the spreadsheet to the data source via the spreadsheet application;
determining whether publishing the data to the data source creates a conflict with data previously published to the data source via the spreadsheet application; and
storing the data at the data source including writing via the spreadsheet application any changes made to the data in the spreadsheet over corresponding data previously stored at the data source;
whereby publishing the data to the data source includes publishing imported data back to the data source and writing the modified imported data over the data in the data source from which the data was imported to the spreadsheet.
2 Assignments
0 Petitions
Accused Products
Abstract
Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user'"'"'s data changes and other data changes made to the same source data contained in the database data source.
-
Citations
31 Claims
-
1. A method of bi-directional communication between a spreadsheet application and a database, comprising:
-
connecting a spreadsheet to a data source; importing via the spreadsheet application data to the spreadsheet from the data source; modifying the imported data in the spreadsheet publishing data from the spreadsheet to the data source via the spreadsheet application; determining whether publishing the data to the data source creates a conflict with data previously published to the data source via the spreadsheet application; and storing the data at the data source including writing via the spreadsheet application any changes made to the data in the spreadsheet over corresponding data previously stored at the data source; whereby publishing the data to the data source includes publishing imported data back to the data source and writing the modified imported data over the data in the data source from which the data was imported to the spreadsheet. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
-
27. A computer storage medium readable by a computing system and encoding a computer program of instructions for executing a computer process for bi-directional communication between a spreadsheet application and a database, said computer process comprising:
-
connecting a spreadsheet to a data source; importing data to the spreadsheet from the data source via the spreadsheet application; modifying the imported data in the spreadsheet via the spreadsheet application; publishing the modified imported data back to the data source and writing the modified imported data over the data in the data source from which the data was imported to the spreadsheet; determining whether publishing the data to the data source creates a conflict with data previously published to the data source via the spreadsheet application; and storing the data at the data source including writing via the spreadsheet application any changes made to the data in the spreadsheet over corresponding data previously stored at the data source. - View Dependent Claims (28, 29)
-
-
30. A method of bi-directional communication between a spreadsheet application and a database, comprising:
-
connecting a spreadsheet to a data source via a bi-directional communication protocol allowing data to flow between the spreadsheet and the data source; importing via the spreadsheet application, data to the spreadsheet from the data source; modifying the imported data in the spreadsheet via the spreadsheet application; exporting via the spreadsheet application the modified imported data back to the data source and writing the modified imported data over the data in the data source from which the data was imported to the spreadsheet; determining whether writing the modified imported data to the data source creates a conflict with data previously written to the data source by comparing the modified imported data with data previously written to the data source; and storing the data at the data source including writing via the spreadsheet application any changes made to the data in the spreadsheet over corresponding data previously stored at the data source. - View Dependent Claims (31)
-
Specification