Data exchange tool

• US 7,337,192 B2
• Filed: 08/31/2005
• Issued: 02/26/2008
• Est. Priority Date: 05/24/2001
• Status: Expired due to Fees

• Current Assignee: RPX Corporation
• Original Assignee: David Stark, Mary Stark
• Inventors: Stark, David, Stark, Mary
• Primary Examiner(s): WOO, ISAAC M
• Application Number:
  US11/217,136
• Publication Number:
  US 20060074944A1
• Time in Patent Office: 909 Days
• Field of Search: 707100-1041, 707200-206, 707 1- 10
• US Class Current: 707/797
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

The present invention may generally be thought of as a software reference tool that enables users to easily understand XML and other file types, including proprietary file types, and that provides the user the capability to map from one file type to another by using system templates that correspond to each file type. The data mapped from one file type to another has been pre-programmed or selected by the user to include only the data elements that are key to the transaction involved.

Claims

1. A computer-implemented method of facilitating mapping data in a first file of a first data file type to a second file of a second data file type, the computer-implemented method comprising:

providing a proprietary library of data-definition templates stored in a computer-accessible media, said proprietary library of data-definition templates including a plurality of mapping templates associated with a set of publicly defined standard data file formats;

permitting a user to utilize a computer interface operably associated with said proprietary library of data-definition templates to selectively create and selectively modify at least one mapping template for use in automatically translating said first file of said first data file type selected from said set of publicly defined standard file formats to said second file of said second data file type selected from at least one proprietary file format, including;

defining a subset of less than all of a plurality of data elements of said at least one mapping template to be associated as critical data elements for said at least one mapping template;

defining invalid or incomplete data fields as part of said at least one mapping template; and

defining at least one comment associated with at least one of said critical data elements or said invalid or incomplete data fields;

automatically generating a data map report representing a selected data map of said first data file type to said second data file type, said data map report presenting all of said data elements of said first type in a first column representing a map of from data, said critical data elements in a second column corresponding to an associated one of said data elements of said first type representing a map of to data and said at least one comment in a third column corresponding to an associated one of said data elements of said first type; and

utilizing said library of data-definition templates to automatically and selectively map an input data file of a selected one of said first data file type to an output data file of a selected one of said second data file type, wherein said data map report facilitates evaluation of the mapping of said input data file to said output data file.

2. The method of claim 1 wherein automatically generating the data map report includes creating visual indicators for each data element indicating whether that element is mapped.

3. The method of claim 2 wherein the visual indicator indicates an element type selected from the group consisting of:

mapped data element, attribute data element and data element with no mapping.

4. The method of claim 1 wherein at least a portion of the automatically generated data map report further comprises a tree view of said first data file of said first file type wherein said tree view comprises data elements, each of which is accompanied by at least one comment indicating an association with at least one of said critical data elements.

5. The method of claim 1 wherein defining the subset of less than all of the plurality of data elements includes defining a data element that is an XML data element.

6. An apparatus facilitating mapping data in a first file of a first data file type to a second file of a second data file type, the apparatus comprising:

a computer system programmed to;

automatically provide a proprietary library of data-definition templates storable in a computer-accessible medium, said proprietary library of data-definition templates including a plurality of mapping templates associated with a set of publicly defined standard data file formats;

automatically communicate via the computer interface to facilitate selectively creating and selectively modifying at least one mapping template for use in automatically translating said first file of said first data file type selected from said set of publicly defined standard file formats to said second file of said second data file type selected from at least one proprietary file format;

associate a subset of less than all of a plurality of data elements of said at least one mapping template as critical data elements for said at least one mapping template;

include invalid or incomplete data fields as part of said at least one mapping template; and

include at least one comment associated with at least one of said critical data elements or said invalid or incomplete data fields;

automatically generate a data map report representing a selected data map of said first data file type to said second data file type, said data map report presenting all of said data elements of said first type in a first column representing a map of from data, said critical data elements in a second column corresponding to an associated one of said data elements of said first type representing a map of to data and said at least one comment in a third column corresponding to an associated one of said data elements of said first type; and

utilize said library of data-definition templates to automatically and selectively map an input data file of a selected one of said first data file type to an output data file of a selected one of said second data file type, wherein said data map report enables a user to evaluate the mapping of said input data file to said output data file.

7. The apparatus of claim 6 wherein at least a portion of said data map report further comprises visual indicators for each data element indicating whether said element is mapped.

8. The apparatus of claim 7 wherein at least a portion of the data map report further comprises visual indicators for each data element wherein the visual indicators are each of a type selected from the group consisting of:

mapped data element, attribute data element and data element with no mapping.

9. The apparatus of claim 6 wherein at least a portion of said data map report further comprises a tree view of data elements of said first data file wherein each of said data elements of said tree view is accompanied by at least one comment indicating a correspondence of at least one of said associated critical data elements to that data element.

10. The apparatus of claim 6 wherein each data element is an XML data element.