Patent ID: 8584003
Filing Date: 2013-11-12
Classification: G06F

Abstract:
1. A system for mapping payload data to spreadsheet lists, the system comprising: a processor that is configured to perform operations; a spreadsheet storage unit adapted to store spreadsheet data including at least one spreadsheet list using the processor, wherein the at least one spreadsheet list describes a spreadsheet structure including one or more fields included in a row of a spreadsheet and includes at least one path associated with a field; wherein the path identifies a location of payload data that is associated with the spreadsheet list; a payload data storage unit adapted to store payload data using the processor; and a mapping unit using the processor that is adapted to receive spreadsheet data from the spreadsheet storage unit, receive payload data from the payload data storage unit, and map the payload data to the at least one spreadsheet list independent of any schema associated with the payload data by generating a set of parent paths for the at least one path, determining at least one longest parent path of the set of parent paths, designating the at least one longest parent path as at least one branch bottom path, generating a set of nodes from payload data, wherein the set of nodes is generated by evaluating the at least one branch bottom; and retrieving a value of the field within a row of the spreadsheet list by tracing the bottom path to the at least one path associated with the field within the spreadsheet data and causing the spreadsheet to be displayed via an output device wherein the spreadsheet manifests the spreadsheet structure populated with the payload data.