Method and system for importing and exporting table data

• US 20020052893A1
• Filed: 12/13/2000
• Published: 05/02/2002
• Est. Priority Date: 12/14/1999
• Status: Abandoned Application

• Current Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Grobler, Dirk, Janssen, Ocke
• Application Number:
  US09/738,488
• Publication Number:
  US 20020052893A1
• Time in Patent Office: Days
• US Class Current: 715/509
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A computer based method imports table data from a selected source document into a selected target document. The source document is at least partly written in a tag language and the target document is in a format accessible by a database software application. The method includes: temporarily storing data of a selected source; analyzing the table structure of the temporarily stored source data; and generating a target table in accordance with the table structure of the source data.

Claims

1. A method of importing table data from a selected source document into a selected target document, said source document being at least partly written in a tag language and said target document being in a format accessible by a database application, said method comprising:

temporarily storing the,table data from said selected source document;

analyzing the table structure of the temporarily stored table data; and

generating a target table in accordance with the table structure of the source data, and in said format accessible by said database application.

2. The method of claim 1, wherein said method further comprises:

performing said selection of the source and the target documents using a drag-and-drop operation.

3. The method of claim 1, wherein said generating a target table further comprises:

generating said target table in accordance with definitions selected by the user.

4. The method of claim 1, further comprising:

performing an automatic recognition of the format of said table data from said selected source document.

5. The method of claim 1, wherein

said table data from said selected source document is in a format selected from the HTML format and the rich text format (RTF).

6. A method of exporting table data from a selected source document into a selected target document, said source document being in a format accessible by a database application, said target document being at least partly written in a tag language, said method comprising:

temporarily storing the table data from the selected source document;

obtaining the table structure of the temporarily stored table data; and

generating a target table in accordance with the obtained table structure using said tag language.

7. The method of claim 6, wherein said method further comprises:

performing said selection of the source and the target documents using a drag-and-drop operation.

8. The method of claim 6, wherein said generating said target table further comprises:

generating said target table in accordance with definitions selected by the user.

9. The method of claim 6, wherein

said table data from said selected source document is in a format selected from the HTML format and the rich text format (RTF).

10. A computer program product comprising computer program code for a method for importing table data from a selected source document into a selected target document, said source document being at least partly written in a tag language and said target document being in a format accessible by a database application, upon execution of said computer program code, said method comprising:

temporarily storing the table data from said selected source document;

analyzing the table structure of the temporarily stored table data; and

generating a target table in accordance with the table structure of the source data, and in said format accessible by said database application.

11. The computer program product of claim 10, wherein said method further comprises:

performing said selection of the source and the target documents using a drag-and-drop operation.

12. The computer program product of claim 10, wherein said generating said target table further comprises:

generating said target table in accordance with definitions selected by the user.

14. The computer program product of claim 10, said method further comprising:

performing an automatic recognition of the format of said table data from said selected source document.

15. The computer program product of claim 10, wherein

said table data from said selected source document is in a format selected from a HTML format and a rich text format (RTF).

17. The computer program product of claim 16, wherein said method further comprises:

performing said selection of the source and the target documents using a drag-and-drop operation.

18. The computer program product of claim 16, wherein said generating said target table further comprises:

generating said target table in accordance with definitions selected by the user.

19. The computer program product of claim 16, wherein

said table data from said selected source document is in a format selected from the HTML format and the rich text format (RTF).

16. A computer program product comprising computer program code for a method of exporting table data from a selected source document into a selected target document, said source document being in a format accessible by a database application, said target document being at least partly written in a tag language, upon execution of said computer program code, said method comprising:

temporarily storing the table data from the selected source document;

obtaining the table structure of the temporarily stored table data; and

generating a target table in accordance with the obtained table structure using said tag language.

20. A system comprising:

a processor; and

a memory coupled to said processor, and having stored therein computer instructions for a method of importing table data from a selected source document into a selected target document, said source document being at least partly written in a tag language and said target document being in a format accessible by a database application, wherein upon execution of said computer instructions on said processor, said method comprises;

temporarily storing the table data from said selected source document;

analyzing the table structure of the temporarily stored table data; and

generating a target table in accordance with the table structure of the source data, and in said format accessible by said database application.

21. A system comprising:

a processor; and

a memory coupled to said processor, and having stored therein computer instructions for a method of exporting table data from a selected source document into a selected target document, said source document being in a format accessible by a database application, said target document being at least partly written in a tag language, wherein upon execution of said computer instructions on said processor, said method comprises;

temporarily storing the table data from the selected source document;

obtaining the table structure of the temporarily stored table data; and

generating a target table in accordance with the obtained table structure using said tag language.