System and method for GUI supported specifications for automating form field extraction with database mapping
View Patent ↗A GUI (Graphical User Interface) supported specification method for form field extraction and database mapping in a computer system that includes converting a form file into a fixed electronic document format by using a GUI which is used to specify the form file and conversion parameters and extracting fields from the fixed electronic document format by using the GUI that is used to specify the fields to be extracted; and mapping the fields onto the database schema by using a GUI which is used to specify the mapping between the fields and the database schema.
1. A method, comprising:
providing a form a word processor format (WPF), wherein the form includes a table having at least a column or row;
converting the form into a portable document format (PDF) document, wherein the PDF document includes a grid that corresponds to the table such that cells of the grid correspond to cells of the table, and
generating an extensible markup language (XML) file that is not part of the PDF document,
wherein generating the XML file comprises:
for each cell of the grid of the PDF document, extracting x and y coordinate values of the PDF document for all corner edge points of the cell, wherein the extraction is not derived from text inside the table;
assigning the coordinate values of the cells to a database table and respective columns of the table; and
storing the assignments in the XML file, and
wherein the method is performed using a graphical user interface (GUI).
2. The method of claim 1 , wherein the cells of the table comprise at least one of a header field, a footer field, a radio field or a data entry field.
3. The method of claim 2 , wherein the header field, the footer field and the radio field comprise one or more sub-fields.
4. The method of claim 3 , wherein at least one of the header field, the footer field and the radio field is selected by a user through the GUI as a group of the sub-fields bounded by a dialog box.
5. The method of claim 1 , wherein each cell has four sides.
6. A system, comprising:
a memory for storing a program;
a processor in communication with the memory, the processor operative with the program to:
provide a form in a word processor format (WPF), wherein the form includes a table having at least a column or row;
convert the form into a portable document format (PDF) document, wherein the PDF document includes a grid that corresponds to the table such that cells of the grid correspond to cells of the table, and
generate an extensible markup language (XML) file that is not part of the PDF document,
wherein generating the XML file comprises:
for each cell of the grid of the PDF document, extracting x and y coordinate values of the PDF document for all corner edge points of the cell, wherein the extraction is not derived from text inside the table;
assigning the coordinate values of the cells to a database table and respective columns of the table; and
storing the assignments in the XML file.
7. A computer program product, comprising:
a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
computer readable program code configured to provide a form in a word processor format (WPF), wherein the form includes a table having at least a column or row;
computer readable program code configured to convert the form into a portable document format (PDF) document, wherein the PDF document includes a grid that corresponds to the table such that cells of the grid correspond to cells of the table; and
computer readable program code configured to generate an extensible markup language (XML) file that is not part of the PDF document,
wherein generating the XML file comprises:
for each cell of the grid of the PDF document, extracting x and y coordinate values of the PDF document for all corner edge points of the cell, wherein the extraction is not derived from text inside the table;
assigning the coordinate values of the cells to a database table and respective columns of the table; and
storing the assignments in the XML file.
8. The computer program product of claim 7 , wherein the cells of the table comprise at least one of a header field, a footer field, a radio field or a data entry field.
9. The computer program product of claim 8 , wherein the header field, the footer field and the radio field comprise one or more sub-fields.
10. The computer program product of claim 9 , wherein the header field, the footer field and the radio field are selected by a user through a graphical user interface (GUI) as a group of the sub-fields bounded by a dialog box.