Interoperability of accounting packages and commerce servers

• US 20050022154A1
• Filed: 05/14/2004
• Published: 01/27/2005
• Est. Priority Date: 03/02/2000
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Jhingran, Anant Deep, Gottemukkala, Vibby, Chung, Jen-Yao, Cohen, Mitchell Adam
• Application Number:
  US10/845,729
• Publication Number:
  US 20050022154A1
• Time in Patent Office: Days
• US Class Current: 717/100
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions

Abstract

A method for transferring a structured document between a server and a software package, in accordance with the present invention, includes providing a structured document including entered information from a server and translating the structured document into a format understandable to a software package resident on a personal computer. The software package supports entering and extracting required information using only a user interface in the software package. The translated structured document is integrated into the software package by employing a program or applet for directly entering and extracting information to and from the software package without human intervention. The program includes operating system commands for mimicking input device actions for automatically interacting with the user interface.

Claims

1. A method for transferring a transaction between a server and a software package comprising the steps of:

providing a structured document including entered information from a server;

translating the structured document into a format understandable to a software package resident on a personal computer, wherein said software package supports entering and extracting required information using only a user interface in the software package; and

integrating the translated structured document into the software package by employing a program for automatically entering and extracting information to and from the software package without human intervention;

wherein the program comprises operating system commands for mimicking input device actions for automatically interfacing with the user interface.

2. The method as recited in claim 1, wherein the step of integrating includes the step of moving a transaction represented by the structured document into the software package by employing a programming interface provided by the software package.

3. The method as recited in claim 1, wherein the step of integrating includes the step of moving a transaction represented by the structured document into the software package by creating a computer file in a format that can be imported into the software package.

4. The method as recited in claim 1, wherein the structured document includes a business document and the software package includes business software.

5. The method as recited in claim 1, wherein the structured document includes one of an invoice and a purchase order and the software package includes accounting software.

6. The method as recited in claim 1, wherein the structured document includes an extensible markup language (XML) document and the step of translating includes the step of converting the XML document to another format using an extensible stylesheet language (XSL) document and an XSL processor.

7. The method as recited in claim 1, wherein the step of translating includes the steps of:

converting the structured document to an intermediate format; and

converting the structured document from the intermediate format to the format understandable to the software package.

8. The method as recited in claim 1, wherein the step of translating includes the step of invoking input and output adapters associated with the structured document for, respectively, parsing and creating an output format for the structured document.

9. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps as recited in claim 1.

30. The method of claim 1, wherein mimicking input device actions comprises mimicking at least one of a keyboard entry and a mouse click.

10. A method for transferring a structured document between a software package and a server comprising the steps of:

providing a transaction from a software package;

extracting the transaction represented in the software package by translating the transaction into a structured document using a program for directly extracting information from the software package without human intervention; and

integrating the structured document onto a server;

wherein the only functionality included in the software package for extracting the information from the software package is a manual interface requiring a plurality of human interface device inputs; and

wherein the program comprises operating system commands for automating the plurality of human interface device inputs to extract the information from the software package.

11. The method as recited in claim 10, wherein the step of extracting includes the step of moving the transaction from the software package by employing a programming interface provided by the software package.

12. The method as recited in claim 10, wherein the step of extracting includes the step of moving the transaction from the software package by creating a computer file in a format that can be exported from the software package.

13. The method as recited in claim 10, wherein the structured document includes a business document and the software package includes business software.

14. The method as recited in claim 10, wherein the structured document includes one of an invoice and a purchase order and the software package includes accounting software.

15. The method as recited in claim 10, wherein the structured document includes an extensible markup language (XML) document and the step of integrating includes the step of providing the XML document from another format using an extensible stylesheet language (XSL) document and an XSL processor.

16. The method as recited in claim 10, wherein the step of extracting includes the steps of:

converting the transaction to an intermediate format; and

converting the intermediate format to the structured document for use by the server.

17. The method as recited in claim 10, wherein the step of extracting includes the step of invoking input and output adapters associated with the transaction for, respectively, parsing and creating an output format for the transaction.

18. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps as recited in claim 10.

31. The method of claim 10, wherein the plurality of human interface device inputs comprises a plurality of keyboard entries and mouse clicks.

32. The method of claim 10, wherein the software package comprises an accounting software package.

33. The method of claim 32, wherein the accounting software package comprises one of PEACHTREE™

and QUICKBOOKS™

.

34. The method of claim 32, wherein the accounting software package comprises one of PEACHTREE™

5.0 and QUICKBOOKS™

5.0.

19. A method for transferring a transaction between a server and a commercial software package comprising the steps of:

providing an initial structured document including entered information from a server;

translating the initial structured document into a format understandable to a commercial software package;

preserving additional information needed for a return document;

integrating the translated structured document into the commercial software package by employing a program independent of the commercial software package for directly entering and extracting information to and from the commercial software package without human intervention; and

creating the return document by merging the extracted information and the additional information;

wherein entering and extracting the information using only the commercial software package requires using a user interface in the commercial software package, said user interface accessible using only a series of human interface actions; and

wherein the program comprises operating system commands for mimicking the series of human interface actions for automatically interfacing with the user interface.

20. The method as recited in claim 19, wherein the step of integrating includes the step of moving a transaction represented by the structured document into the software package by employing a programming interface provided by the software package.

21. The method as recited in claim 19, wherein the step of integrating includes the step of moving a transaction represented by the structured document into the software package by creating a computer file in a format that can be imported into the software package.

22. The method as recited in claim 19, wherein the structured document includes a business document and the software package includes business software.

23. The method as recited in claim 19, wherein the structured document includes one of an invoice and a purchase order and the software package includes accounting software.

24. The method as recited in claim 19, wherein the structured document includes an extensible markup language (XML) document and the step of translating includes the step of converting the XML document to another format using an extensible stylesheet language (XSL) document and an XSL processor.

25. The method as recited in claim 19, wherein the step of translating includes the step of converting the structured document to and from an intermediate format.

26. The method as recited in claim 25, wherein the step of preserving additional information needed for a return document includes the step of preserving the additional fields in the intermediate format until the additional fields are merged into the return document.

27. The method as recited in claim 25, wherein the step of preserving additional information needed for a return document includes the step of storing the additional fields until the additional fields are merged into the return document.

28. The method as recited in claim 19, wherein the step of translating includes the step of invoking input and output adapters associated with the structured document for, respectively, parsing and creating an output format for the structured document.

29. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps as recited in claim 19.