Application integration using XML

• US 7,720,809 B2
• Filed: 06/06/2006
• Issued: 05/18/2010
• Est. Priority Date: 06/06/2006
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Veluswamy, Rajesh, Reitzel, Per, Knudsen, Bardur
• Primary Examiner(s): Vo; Tim T.
• Assistant Examiner(s): OWYANG, MICHELLE N
• Application Number:
  US11/422,480
• Publication Number:
  US 20070282866A1
• Time in Patent Office: 1,442 Days
• Field of Search: 707/104.1, 705 1- 45, 715700-866
• US Class Current: 707/609
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06Q 30/08 Auctions

Abstract

A method and system for integrating form data in an ERP system with a target application are provided. The method includes receiving a first input from a user of an ERP system while a form is running on an application layer of the ERP system to initiate a data integration process. Next, a metadata form XML file is generated at an ERP platform layer from the form running on the application layer. Then, the metadata form XML file is sent from the ERP platform layer to the application layer for use by target applications in integrating data from the form into the target applications.

Claims

1. A computer storage medium having stored thereon computer-executable instructions for implementing steps of a method comprising:

receiving a first input from a user of an enterprise resource planning (ERP) system while a form is running on an application layer of the ERP system to select one of a plurality of target applications and to initiate a data integration process, the application layer running on top of an ERP platform layer in the ERP system, the first input being received through a button in a toolbar of a graphical user interface of the ERP system, the plurality of target applications including a word processing program, a spreadsheet program, a database program, and an email program;

generating a metadata form XML file at the ERP platform layer from the form running on the application layer, the metadata form XML file being a linked list data structure having data from the form and information about controls from the form;

sending the metadata form XML file from the ERP platform layer to the application layer for use by the selected target application in integrating data from the form into the selected target application;

automatically selecting a default stylesheet as a first stylesheet based upon which one of the plurality of target applications is selected by the user with the first input;

transforming the metadata form XML file into a target application XML file using a target application transformation engine and the first stylesheet at the application layer, the target application XML file being in a format that is compatible with the target application, the target application transformation engine being implemented within the application layer;

sending the target application XML file to the ERP platform layer;

launching the selected target application from the ERP platform layer using the target application XML file to provide integrated form data with the target application; and

manipulating the integrated form data utilizing the target application.

2. The computer storage medium of claim 1, wherein the toolbar of the graphical user interface has a plurality of buttons, each button initiating the data from the form to be exported, and each button corresponding to a different target application.

3. The computer storage medium of claim 2, wherein the data from the form includes information from a plurality of fields, wherein at least one of the plurality of fields includes a dropdown list, wherein at least a second one of the plurality of fields includes numerical data, and wherein at least a third one of the plurality of fields includes textual data, and wherein the method further comprises displaying the integrated form data using the selected target application.

4. The computer storage medium of claim 3, wherein the information about the controls from the form includes a control ID, a control type, and a control value, and wherein the step of generating the metadata form XML file at the ERP platform layer further comprises:

extracting the form data from the form running on the application layer;

structuring the extracted form data into a form data structure in memory of the ERP platform layer; and

transforming the form data structure in memory of the ERP platform layer into the metadata XML file.

5. A computer-implemented method of integrating form data in an enterprise resource planning (ERP) system with a target application, the method comprising:

displaying a graphical user interface along with a form running on an application layer, the graphical user interface including a plurality of different input controls, the plurality of different input controls including a first button, a second button, and a third button, the first button corresponding to integrating the form data with a word processing program, the second button corresponding to integrating the form data with a spreadsheet program, and the third button corresponding to a dialogue box that enables a user to select the target application from a plurality of possible target programs and to select a stylesheet for the target application, the dialogue box and the form being displayed in separate windows within the graphical user interface;

selecting an input control, from the plurality of different input controls displayed on the graphical user interface along with the form running on the application layer, to select the target application and to initiate a generating step;

in response to initiation of the generating step, generating a metadata form XML file at an ERP platform layer from the form running on the application layer, the metadata form XML file comprising all field data from the form including captions and groupings;

sending the metadata form XML file to the application layer;

transforming the metadata form XML file into a target application XML file for the target application at the application layer using a target application transformation engine and a first stylesheet, the first stylesheet having been selected by the user utilizing the dialogue box;

sending the target application XML file to the ERP platform layer;

launching the selected target application from the ERP platform layer using the target application XML file to provide the integrated form data with the target application;

displaying the integrated form data in the target application; and

manipulating the integrated form data utilizing the target application.

6. The computer-implemented method of claim 5, wherein the plurality of different input controls are displayed in a toolbar of the graphical user interface, and wherein each of the plurality of different input controls has a graphical icon.

7. The computer-implemented method of claim 6, wherein the ERP system includes a plurality of different types of forms, the different types of forms including charts, tables, reports, and function libraries.

8. The computer-implemented method of claim 5, wherein the plurality of possible target programs include a word processing program, a spreadsheet program, a database program, and an email program, and wherein generating the metadata form XML file at the ERP platform layer further comprises:

extracting the form data from the form running on the application layer;

structuring the extracted form data into a form data structure in memory of the ERP platform layer; and

transforming the form data structure in memory of the ERP platform layer into the metadata XML file.

9. The computer-implemented method of claim 8, wherein the first stylesheet is a pivot table, and wherein the steps of extracting the form data from the form and structuring the extracted form data into the form data structure further comprises:

extracting the form data from the form and structuring the extracted form data into the form data structure using a data extraction component running on the ERP platform layer, the ERP platform layer having a runtime database management system and business logic, the business logic implementing the form.

10. The computer-implemented method of claim 8, wherein structuring the extracted form data into the form data structure in memory of the ERP platform layer further comprises structuring the extracted form data into the form data structure such that the form data structure contains information about form data controls, the information about form data controls including a control ID, a control type, and a control value.

11. The computer-implemented method of claim 5, wherein the dialogue box has two columns, a first of the two columns supporting selection of an application and the second of the two columns supporting selection of a stylesheet.

12. The computer-implemented method of claim 5, and further comprising:

adding extra information to the metadata form XML file at the application layer, the extra information including information that is not directly part of data from the form.

13. An enterprise resource planning (ERP) system comprising:

a processing unit and computer storage medium of an ERP system computer, the computer storage medium having stored thereon computer-executable instructions which configure the processing unit of the ERP system computer to implement ERP system components comprising;

an ERP platform layer;

an application layer running on top of the ERP platform layer;

an integrated development environment and runtime database management system on top of the ERP platform layer;

an application running on the application layer which implements a form on the application layer, the form having a plurality of different selectable input controls each corresponding to a different one of a plurality of target applications, wherein each of the selectable input controls is configured such that when selected, the selected input control selects the corresponding one of the plurality of target applications and initiates data extraction;

a dialogue box that displays a plurality of possible target applications for exporting data to and a plurality of possible stylesheets to use with the plurality of possible target applications;

a data extraction component configured to extract form data from the form running on the application layer of the ERP system in response to selection of the input control on the form, and to structure the extracted form data into a form data structure in memory of an ERP platform layer;

a data XML transformation engine configured to transform the form data structure in the memory of the ERP platform layer into a metadata XML file, the metadata XML file having a plurality of data fields and corresponding data field identifiers, the data fields including an object type field, an id field, and a caption field; and

wherein the ERP platform layer is configured to send the metadata XML file to the application layer for use by the selected target application.

14. The ERP system of claim 13, wherein the ERP system components which the processing unit is configured to implement further comprise a target application transformation engine running on the application layer and configured to use a first stylesheet to transform the metadata XML file into a target application XML file at the application layer, and wherein the metadata XML file further has a plurality of row sections, each row section including a control type field, a value field, a width field, and a name field, each row section further including textual information corresponding to its control type field and numerical information corresponding to its width field.

15. The ERP system of claim 14, wherein the ERP application layer is configured to send the target application XML file to the ERP platform layer for launching of the selected target application to provide integrated form data with the target application, and wherein the dialogue box includes a plurality of boxes that are arranged in rows and columns, a first one of the columns including information about the plurality of possible target applications, a second one of the columns including information about the plurality of possible stylesheets, and a third one of the columns enabling a user to make a selection.

16. The ERP system of claim 15, wherein the first stylesheet is chosen from the plurality of possible stylesheets, and wherein the dialogue box further includes a send button, a cancel button, a help button, and a header, the header being located at a top of the dialogue box and including textual information that describes the dialogue box.

17. The ERP system of claim 16, wherein the data extraction component runs on the ERP platform layer, and wherein the selected target application displays a document, the document including information from the metadata XML file and information from the application layer, the information from the application layer including a company name, a current date, and a user id.