User system applicaton interaction for a system as a service

• US 8,205,010 B1
• Filed: 12/16/2009
• Issued: 06/19/2012
• Est. Priority Date: 12/16/2009
• Status: Active Grant

• Current Assignee: Workday Incorporated
• Original Assignee: Workday Incorporated
• Inventors: Black, David, Beck, Daniel Walter
• Primary Examiner(s): Elchanti, Hussein A.
• Application Number:
  US12/653,732
• Time in Patent Office: 916 Days
• Field of Search: 709/220, 709/223, 709/246
• US Class Current: 709/246
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

A system for providing data for loading a user system application comprises a processor and a memory. The processor is configured to generate a data for loading a user system application using a template and provide the data for loading the user system application. The memory is coupled to the processor and is configured to provide the processor with instructions.

Claims

1. A system for providing data from a business software system for loading a user system application, comprising:

a business software system data stored on a storage device; and

a processor configured to;

generate the business software system data for loading into a user system application using a template, wherein the template generates the business software system data into a spreadsheet application format;

send the business software system data in the spreadsheet application format for loading into the user system application;

receive a modified business software system data in the spreadsheet application format;

validate the modified business software system data in the spreadsheet application format, wherein validating comprises transforming the modified business software data from the spreadsheet application format back into data that is storable in the business software system; and

enter the modified business software system data into the business software system; and

a memory coupled to the processor and configured to provide the processor with instructions.

2. A system as in claim 1, wherein generating the business software system data for loading into the user system application using the template includes one or more directives.

3. A system as in claim 2, wherein the one or more directives comprise metadata embedded in an XML schema.

4. A system as in claim 2, wherein the one or more directives comprise one or more default directives.

5. A system as in claim 2, wherein the one or more directives comprise an inbound and an outbound directive.

6. A system as in claim 2, wherein the one or more directives comprise a directive associated with one or more of the following:

structure of the data, formatting, data mapping, data manipulation, business process, and business subprocess.

7. A system as in claim 1, wherein the processor is further configured to generate the template.

8. A system as in claim 7, wherein the template comprises a customized template that is saved after customization.

9. A system as in claim 7, wherein the customized template comprises a tenant specific template.

10. A system as in claim 7, wherein the template includes instructions for appending data from the server system.

11. A system as in claim 7, wherein the template does not include instructions for appending data from the server system.

12. A system as in claim 1, wherein the user system application comprises an application that can read the spreadsheet application format.

13. A system as in claim 1, wherein receiving the modified business software system data comprises receiving a modified spreadsheet file from the user system application.

14. A system as in claim 13, wherein the modified business software system data received from the user system application is validated using the template that was used to generate the data for loading into the user system application.

15. A system as in claim 14, wherein validation includes providing status including one or more errors.

16. A system as in claim 14, wherein validation uses one or more directives.

17. A system as in claim 1, wherein the modified business software system data is converted for a business software system server.

18. A system as in claim 17, wherein the business software system server executes a business process using a data associated with the modified spreadsheet.

19. A method for providing data from a business software system for loading a user system application, comprising:

generating a business software system data, using a processor, for loading into a user system application using a template, wherein the template generates the business software system data into a spreadsheet application format;

sending the business software system data in the spreadsheet application format for loading into the user system application;

receiving a modified business software system data in the spreadsheet application format;

validating the modified business software system data in the spreadsheet application format, wherein validating comprises transforming the modified business software data from the spreadsheet application format back into data storable in the business software system; and

entering the modified business software system data into the business software system.

20. A computer program product for providing data from a business software system for loading a user system application, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:

generating a business software system data for loading into a user system application using a template, wherein the template generates the business software system data into a spreadsheet application format;

sending the business software system data in the spreadsheet application format for loading into the user system application;

receiving a modified business software system data in the spreadsheet application format;

validating the modified business software system data in the spreadsheet application format, wherein validating comprises transforming the modified business software data from the spreadsheet application format back into data that is storable in the business software system; and

entering the modified business software system data into the business software system.