Data insertion from a database into a fixed electronic template form that supports overflow data

• US 20060059418A1
• Filed: 09/14/2005
• Published: 03/16/2006
• Est. Priority Date: 09/14/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Elkady, Osama
• Granted Patent: US 7,996,759 B2
• Time in Patent Office: Days
• US Class Current: 715/269
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/186 Templates

Abstract

One embodiment in accordance with the invention relates to inserting data (e.g., XML data) from a database into an electronic template form that includes a table. Furthermore, each table can expand to fit any amount of inserted data and can also expand onto additional pages. The additional pages may have the format of supplemental pages that include the expanded table or that of duplicate pages that also include the other information (e.g., brief description of the table, letterhead, etc.) that was included on the first page. The font size and space can be calculated along with the line wrap for the supplemental page format or duplicate page format.

Claims

1. A method for inserting data into a field of a fixed electronic template page, said method comprising:

receiving said fixed electronic template page;

mapping data to said field of said fixed electronic template page;

merging said data with said field of said fixed electronic template page based on said mapping;

determining if there is overflow data that will not fit within said field;

creating an additional electronic document page that includes an extension area of said field to handle said overflow data, provided there is said overflow data that will not fit within said field; and

merging said overflow data with said extension area of said field of said additional electronic document page.

2. The method as described in claim 1, wherein said field comprises a text field.

3. The method as described in claim 1, wherein said field comprises a table.

4. The method as described in claim 1, wherein said additional document page comprises information also included as part of said fixed electronic template page.

5. The method as described in claim 1, further comprising:

converting said fixed electronic template page and said additional electronic document page into a format that can be printed.

6. The method as described in claim 1, wherein said merging said data comprises embedding a font into said fixed electronic template page.

7. The method as described in claim 6, wherein said embedding said font provides multi-lingual support.

8. A computer system comprising:

a processor;

a bus coupled to said processor; and

a memory device coupled to said bus to communicate with said processor for performing a method comprising;

receiving a fixed electronic template form page;

binding data of a database to a field of said fixed electronic template form page;

merging said data with said field of said fixed electronic template form page based on said binding;

ascertaining whether there is overflow data that will not fit within said field;

creating an additional electronic document page that includes an extension area of said field to handle said overflow data, provided there is said overflow data that will not fit within said field; and

merging said overflow data with said extension area of said field of said additional electronic document page.

9. The computer system of claim 8, wherein said field comprises a text field.

10. The computer system of claim 8, wherein said field comprises a table.

11. The computer system of claim 8, wherein said additional document page comprises information also included as part of said fixed electronic form page.

12. The computer system of claim 8, wherein said method further comprising:

converting said fixed electronic form page and said additional electronic document page into a format that can be printed.

13. The computer system of claim 8, wherein said merging said data comprises embedding fonts into said fixed electronic form page.

14. The computer system of claim 8, wherein said embedding fonts provides multi-lingual support.

15. A computer readable medium having computer readable code embodied therein for causing a computer system to perform a method comprising:

receiving a fixed electronic page;

linking data to said field of said fixed electronic page;

merging said data with said field of said fixed electronic page based on said linking;

determining whether there is overflow data that does not fit within said field;

creating an additional electronic document page that includes an extension area of said field to handle said overflow data, provided there is said overflow data that does not fit within said field; and

merging said overflow data with said extension area of said field of said additional electronic document page.

16. The computer readable medium of claim 15, wherein said field comprises a text field.

17. The computer readable medium of claim 15, wherein said field comprises a table.

18. The computer readable medium of claim 15, wherein said additional document page comprises information also included as part of said fixed electronic form page.

19. The computer readable medium of claim 15, further comprising:

converting said fixed electronic form page and said additional electronic document page into a format that can be printed.

20. The computer readable medium of claim 15, wherein said merging said data comprises embedding a font into said fixed electronic form page.

21. The computer readable medium of claim 20, wherein said embedding said font provides multi-lingual support.