Data conversion system and method
View Patent ↗A data conversion system and method are provided. Specifically, under the present invention, a collection of data records is received from a first application. The data records include data fields for storing data entries, with at least one of the data fields including multiple data entries. Each data entry is tagged with a corresponding data header (meta data) and individually arranged, along with a corresponding record identifier, into a separate row of a table. This eliminates any multiple value data fields so that the data can be more accurately manipulated and reported by a second application.
1. A method for converting data from a first format to a second format, comprising the steps of:
providing a plurality of data fields for storing data entries, wherein at least one of the data fields has a plurality of data entries that are not separately addressed, and wherein each data field has an associated data header and an associated record identifier; and
building a table based upon the data entries, wherein the table comprises rows having a single data entry, a corresponding data header, and a corresponding record identifier in a separate field from the corresponding data header.
2. The method of claim 1 , further comprising the step of selecting predetermined rows of the table and arranging the selected rows to generate a report.
3. The method of claim 1 , wherein the building step comprises the step of tagging each data entry in the data fields with a corresponding data header.
4. The method of claim 1 , wherein each row in the table comprises a first data field and a second data field.
5. The method of claim 4 , wherein the first data field of at least one row comprises a single data entry tagged with a corresponding data header, and wherein the second data field of the at least one row comprises a record identifier corresponding to the single data entry.
6. A method for converting data from a first format to a second format, comprising the steps of:
providing a plurality of data records having data fields for storing data entries, wherein at least one of the data fields has a plurality of data entries that are not separately addressed, and wherein each data field has an associated data header and an associated record identifier;
tagging each data entry in the data fields with a corresponding data header; and
building a table based upon the data records, wherein the table has rows that comprise a single data entry, a corresponding tagged data header, and a corresponding record identifier in a separate field from the corresponding data header.
7. The method of claim 6 , wherein each row of the table comprises a first data field and a second data field.
8. The method of claim 7 , wherein the first data field of at least one row comprises a single data entry and a corresponding tagged data header.
9. The method of claim 8 , wherein the second data field of the at least one row comprises a record identifier corresponding to the single data entry.
10. The method of claim 6 , further comprising the step of selecting predetermined rows of the table and arranging the selected rows into a report.
11. A method for converting data from a first format to a second format, comprising the steps of:
providing a plurality of data records having data fields for storing data entries, wherein at least one of the data fields has a plurality of data entries that are not separately addressed, and wherein each data field has an associated data header and an associated record identifier;
building a table based upon the data records, wherein the table has rows that comprise a single data entry, a corresponding data header, and a corresponding record identifier in a separate field from the corresponding data header; and
selecting predetermined rows of the table and arranging the selected rows into a report.
12. The method of claim 11 , wherein the building step comprises the step of tagging each data entry in the data fields with a corresponding data header.
13. The method of claim 11 , wherein each row of the table includes a first data field and a second data field.
14. The method of claim 13 , wherein the first data field of at least one row comprises a single data entry and a corresponding data header, and wherein the second data field of the at least one row comprises a record identifier corresponding to the single entry.