Patent ID: 7337182
Filing Date: 2008-02-26
Classification: G06F,Y10S

Abstract:
1. A computer implemented method of managing an application of structured data and data mappings to a spreadsheet application, comprising: obtaining the structured data, wherein the structured data comprises one or more data definitions associated with the spreadsheet application; parsing the structured data to determine the one or more data definitions and structure required for valid data of the spreadsheet application; combining the structured data received from multiple sources to create a unified schema definition comprising data definitions and structure applicable to the structure data; selecting a root element from the unified schema definition for constructing a generalized instance; creating a map object to maintain all information about the data mappings, wherein the information about the data mappings comprises schema definitions used, name of the map, and relationship of fields to spreadsheet application cell ranges; building a generalized instance structure from the unified schema definition, wherein the generalized instance structure presents available fields and data content of the unified schema definition; and displaying a view of the generalized instance structure for providing a visual representation of a valid data file wherein the view contains fields for visually representing the fields and data content of the unified schema definition.