Dynamically transferring data from a spreadsheet to a remote applcation
View Patent ↗A method for dynamically transferring data from a spreadsheet to a database in disclosed. The method comprises scanning a spreadsheet to identify potential record cells; selectively converting each potential record cell into an actual record cell for a remote application; and identifying record attributes associated with each actual record cell.
1. A computer-implemented method, comprising:
in a computing device communicably connected to a remote application through a network:
scanning a spreadsheet in order to identify potential record cells;
selectively converting each identified potential record cell into an actual record cell in said spreadsheet for said remote application;
identifying record attributes associated with each said actual record cell, wherein the selective conversion of each identified potential record cell into the actual record cell comprises retrieval of data in plurality of cells in the spreadsheet based on a save map component associated with the spreadsheet and based on at least one user input corresponding to a selection from a list of predefined records associated with a plurality of predefined tables included in the remote application, and wherein the remote application is associated with a database for exchange of data;
executing a record construction component associated with the spreadsheet, wherein the record construction component assembles a record for the remote application based on the record attributes of each said actual record cell; and
transmitting the assembled record to the remote application.
2. The method of claim 1 , wherein said scanning comprises recognizing when a spreadsheet cell has been marked as a potential record cell.
3. The method of claim 1 , wherein said selectively converting of each said potential record cell into an actual record cell is based on a condition associated with said potential record cell.
4. The method of claim 1 , wherein identifying the record attributes comprises accessing the save map component associated with the spreadsheet; wherein the save map component defines the record attributes associated with an actual record cell.
5. The method of claim 4 , wherein the record attributes are based on spreadsheet cells in the spreadsheet.
6. The method of claim 4 , wherein the record attributes are based on spreadsheet cells from at least one other spreadsheet.
7. A non-transitory computer-readable medium, having stored thereon, a sequence of computer-executable instructions which causes a computer to perform the steps, comprising:
scanning a spreadsheet in order to identify potential record cells;
selectively converting each identified potential record cell into an actual record cell in said spreadsheet for a remote application;
identifying record attributes associated with each said actual record cell, wherein
the selective conversion of each identified potential record cell into the actual record cell comprises retrieval of data in plurality of cells in the spreadsheet based on a save map component associated with the spreadsheet and based on at least one user input corresponding to a selection from a list of predefined records associated with a plurality of predefined tables included in the remote application, and wherein the remote application is associated with a database for exchange of data;
executing a record construction component associated with the spreadsheet, wherein the record construction component assembles a record for the remote application based on the record attributes of each said actual record cell; and
transmitting the assembled record to the remote application.
8. The computer-readable medium of claim 7 , wherein said scanning comprises recognizing when a spreadsheet cell has been marked as a potential record cell.
9. The computer-readable medium of claim 7 , wherein said selectively converting of each potential record cell into an actual record cell is based on satisfaction of a condition associated with the potential record cell.
10. The computer-readable medium of claim 7 , wherein identifying the record attributes comprises accessing the save map component associated with the spreadsheet; wherein the save map component defines the record attributes associated with an actual record cell.
11. The computer-readable medium of claim 10 , wherein the record attributes are based on spreadsheet cells in the spreadsheet.
12. The computer-readable medium of claim 10 , wherein the record attributes are based on spreadsheet cells from at least one other spreadsheet.
13. A system communicably connected to a remote application through a network, the system, comprising:
a processor; and
a memory coupled to the processor, the memory storing instructions which when executed by the system causes the system to perform a method comprising:
scanning a spreadsheet in order to identify potential record cells;
selectively converting each identified potential record cell into an actual record cell in said spreadsheet for said remote application;
identifying record attributes associated with each said actual record cell, wherein
the selective conversion of each identified potential record cell into the actual record cell comprises retrieval of data in plurality of cells in the spreadsheet based on a save map component associated with the spreadsheet and based on at least one user input corresponding to a selection from a list of predefined records associated with a plurality of predefined tables included in the remote application, and wherein the remote application is associated with a database for exchange of data;
executing a record construction component associated with the spreadsheet, wherein the record construction component assembles a record for the remote application based on the record attributes of each said actual record cell; and
transmitting the assembled record to the remote application.
14. The system of claim 13 , wherein said scanning comprises recognizing when a spreadsheet cell has been marked as a potential record cell.
15. The system of claim 13 , wherein said selectively converting of each potential record cell into an actual record cell is based on satisfaction of a condition associated with the potential record cell.
16. The system of claim 13 , wherein the method further comprises identifying the record attributes comprises accessing the save map component associated with the spreadsheet; wherein the save map component defines the record attributes associated with an actual record cell.