Method and system for converting files to a specified markup language
View Patent ↗A method and system for converting a delimited flat file to a markup language specified by a document type definition file. The method comprises the steps of providing a delimited flat file having columns with headings, and providing a map file conforming to said document type definition file and having tags and attributes including references matching said headings. A tree structure is formed from the map file, with each tag representing one or more nodes of the tree. The tree structure is traversed, node-by-node, and for each node, the attributes are entered into said markup language file. When the attributes include one of said references, text is retrieved from one of the columns with one of the matching headings of the flat file, and that text is entered into the markup language file.
1. A method of converting text in a delimited flat legacy file to text in a markup language specified by a document type definition file, said method comprising the steps of:
providing a delimited flat legacy file having a plurality of columns with text, each of said columns having a column heading;
providing a map file conforming to said document type definition file and having tags and attributes including references matching said headings, wherein each of the column headings is matched by one of the references included in said attributes;
forming a tree structure from said map file for mapping said text from said flat file into a defined format in said markup language file, and wherein each tag represents one or more nodes of said tree;
reading the map file and using the map file to map text from the legacy file into the defined format in said markup language file, including the step of traversing said legacy file, column by column, and for each of the columns, mapping all of the text in the column to said markup language file, including the steps of:
traversing said nodes of said tree structure, node-by-node, and when one of the references in the attributes of one of the nodes matches the heading of one of the columns of the legacy file, retrieving all of the text from said one of the columns of the legacy file, and entering said retrieved all text into said markup language file; and
traversing all of said nodes of said tree to ensure that references are found matching all of the column headings of the legacy file, and thereby to ensure that all of the text from the legacy file is retrieved therefrom and entered into the markup language file.
2. A method according to claim 1 , wherein the providing step includes the step of providing the map file with default text for certain elements and attributes in the markup language file.
3. A method according to claim 2 , further comprising the step of entering the default text into the markup language for attributes having references that do not match headings of the flat file.
4. A method according to claim 1 , wherein the flat file is a tab delimited flat file.
5. A method according to claim 1 , wherein the step of providing the map file includes the steps of:
a user creating said map file for converting text of a specified legacy tile to the markup language file;
said specified legacy file having a plurality of specified column headings; and
said user providing said map file with references matching all of the specified column headings of the specified legacy file.
6. A method according to claim 5 , wherein the step of the user creating said map file includes the step of the user specifying in said map file which elements of the legacy file are to have multiple occurrences in said markup language file, and which elements of the legacy file are to be nested in the markup language file.
7. A method according to claim 6 , wherein the step of the user providing said map file with references includes the step of the user providing said map file with the specified column headings of the specified legacy file.
8. A system for converting text in a delimited flat legacy file to text in a markup language specified by a document type definition file, said system comprising:
means for providing a delimited flat legacy file having a plurality of columns with text, each of said columns having a column heading;
means for providing a map file conforming to said document type definition file and having tags and attributes including references matching said headings, wherein each of the column headings is matched by one of the references included in said attributes;
means for forming a tree structure from said map file for mapping said text from said flat file into a defined format in said markup language file, and wherein each tag represents one or more nodes of said tree;
means for reading the map file and using the map file to map text from the legacy file into the defined format in said markup language file, including the step of traversing said legacy file, column by column, and for each of the columns, mapping all of the text in the column to said markup language file, including:
means for traversing said nodes of said tree structure, node-by-node, and when one of the references in the attributes of one of the nodes matches the heading of one of the columns of the legacy file, retrieving all of the text from said one of the columns of the legacy file, and entering said retrieved all text into said markup language file; and
means
traversing all of said nodes of said tree to ensure that references are found matching all of the column headings of the legacy file, and thereby to ensure that all of the text from the legacy file is retrieved therefrom and entered into the markup language file.
9. A system according to claim 8 , wherein the map file includes default text for certain elements and attributes in the markup language file.
10. A system according to claim 9 , wherein the traversing means includes means for entering the default text into the markup language for attributes having references that do not match headings of the flat file.
11. A system according to claim 8 , wherein the flat file is a tab delimited flat file.
12. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps for converting text in a delimited flat legacy file to text in a markup language specified by a document type definition file, said method steps comprising:
providing a delimited flat legacy file having a plurality of columns with text, each of said columns having a column heading;
providing a map file conforming to said document type definition file and having tags and attributes including references matching said headings, wherein each of the column headings is matched by one of the references included in said attributes;
forming a tree structure from said map file for mapping said text from said flat file into a defined format in said markup language file, and wherein each tag represents one or more nodes of said tree;
traversing said nodes of said tree structure, node-by-node, and when one of the references in the attributes of one of the nodes matches the heading of one of the columns of the legacy file, retrieving all of the text from said one of the columns of the legacy file, and entering said retrieved all text into said markup language file; and
traversing all of said nodes of said tree to ensure that references are found matching all of the column heading of the legacy file, and thereby to ensure that all of the text from the legacy file is retrieved therefrom and entered into the markup language file.
13. A program storage device according to claim 12 , wherein the providing step includes the step of providing the map file, with default text for certain elements and attributes in the markup language file.
14. A program storage device according to claim 13 , further comprising the step of entering the default text into the markup language for attributes having references that do not match headings of the flat file.
15. A program storage device according to claim 12 , wherein the flat file is a tab delimited flat file.