Service desk data transfer interface
View Patent ↗A system and method for managing data transfer operations includes at least one data server including data stored in a plurality of data fields, at least one transaction server operatively coupled to the at least one data server and configured to provide at least one customizable business rule and a customer relationship application, an information server operatively coupled to the at least one transaction server, and at least one workstation operatively coupled to the information server. The least one workstation includes local memory accessible to the customer relationship application and configured to provide web communication and presentation services to a user of the at least one workstation that are deployed on the information server. The at least one customizable business rule specifies a mapping between the plurality of data fields and the local memory, the mapping having been provided by the user interacting with the web communication and presentation services.
1. A method for importing data from an origin to a destination, the method comprising:
identifying data to be imported, over a network, from the origin to the destination, the destination associated with a customer relationship application including a service application;
identifying a set of predetermined rules associated with the customer relationship application;
associating at least one user-specified function with the identified data, the at least one user-specified function capable of transforming at least a portion of the identified data;
periodically executing the service application in order to import the identified data from the origin to the destination utilizing the network in accordance with the set of predetermined rules, wherein the importing includes:
mapping first fields for the data in the origin to second fields for the destination,
translating first field names of the mapped first fields to second field names of the second fields, and
transforming at least a portion of the identified data from the origin to the destination using the at least one user-specified function, the at least one user-specified function being modifiable from an application option screen that includes access to a scripting language; and
making the imported data accessible to the customer relationship application, wherein the mapping and translating are customizable by the user such that the second field names and the second fields are customizable by the user.
2. The method of claim 1 , wherein the application option screen includes:
a first user input area for receiving a selection of the at least one user-specified function; and
a second user input area for receiving edits of the scripting language for the user-specified function.
3. The method of claim 1 , wherein the service application is generated based on the predetermined rules.
4. The method of claim 3 , wherein periodically executing the service application includes periodically executing the service application at user-defined intervals.
5. The method as recited in claim 1 , wherein the predetermined rules are specified based on user interaction with an application creation program.
6. The method as recited in claim 1 , wherein the at least one user-specified function comprises at least one user-created scripting function selected from the group consisting of a VBScript function or a JavaScript function.
7. The method as recited in claim 1 , further comprising exporting data from the customer relationship application utilizing the network.
8. The method of claim 1 , wherein the predetermined rules relate to at least one of referential integrity, required fields, and automatic sequence numbering.
9. A non-transitory computer program product being tangibly embodied in a non-transitory computer-readable storage medium, the computer program comprising:
computer code for identifying data, over a network, to be imported from an origin to a destination, the destination associated with a customer relationship application including a service application;
computer code for identifying a set of predetermined rules associated with the customer relationship application;
computer code for associating at least one user-specified function with the identified data, the at least one user-specified function capable of transforming at least a portion of the identified data;
computer code for periodically executing the service application in order to import the identified data from the origin to the destination utilizing the network in the accordance with the set of predetermined rules, wherein the computer code for importing includes:
computer code for mapping first fields for the data in the origin to second fields for the destination, computer code for translating first field names of the mapped first fields to second field names of the second fields, and
computer code for transforming at least a portion of the identified data from the origin to the destination using the at least one user-specified function, the user-specified function being modifiable from an application option screen that includes access to a scripting language; and
computer code for making the imported data accessible to the customer relationship application, wherein the mapping and translating are customizable by the user such that the second field names and the second fields are customizable by the user.
10. A system for importing data from an origin to a destination, the system comprising:
logic for identifying data over a network, to be imported from the origin to the destination, the destination associated with a customer relationship application including a service application;
logic for identifying a set of predetermined rules associated with the customer relationship application;
logic for associating at least one user-specified function with the identified data, the at least one user-specified function capable of transforming at least a portion of the identified data;
logic for periodically executing the service application in order to import the identified data from the origin to the destination utilizing the network in accordance with the set of predetermined rules, wherein the logic for importing includes:
logic for mapping first fields for the data in the origin to second fields for the destination, logic for translating first field names of the mapped first fields to second field names of the second fields, and
logic for transforming at least a portion of the identified data from the origin to the destination using the at least one user-specified function, the user-specified function being modifiable from an application option screen that includes access to a scripting language; and
logic for making the imported data accessible to the customer relationship application, wherein the mapping and translating are customizable by the user such that the second field names and the second fields are customizable by the user.
11. A method for exporting data from an origin to a destination, the method comprising:
identifying data, over a network, to be exported from the origin to the destination, the identified data accessible to a customer relationship application associated with the origin, the customer relationship application including a service application;
identifying a set of predetermined rules associated with the customer relationship application;
associating at least one user-specified function with the identified data, the at least one user-specified function capable of transforming at least a portion of the identified data; and
periodically executing the service application in order to export the identified data from the origin to the destination utilizing the network in accordance with the set of predetermined rules, wherein the exporting includes:
mapping first fields for the data in the origin to second fields for the destination,
translating first field names of the mapped first fields to second field names of the second fields, and
transforming at least a portion of the identified data from the origin to the destination using the at least one user-specified function, the user-specified function being modifiable from an application option screen that includes access to a scripting language, wherein the mapping and translating are customizable by the user such that the second field names and the second fields are customizable by the user.
12. The method of claim 11 , wherein the application option screen includes:
a first user input area for receiving a selection of the at least one user-specified function; and
a second user input area for receiving edits of the scripting language for the user-specified function.
13. The method of claim 11 , wherein the service application is generated based on the predetermined rules.
14. The method of claim 13 , wherein periodically executing the service application includes periodically executing the service application at user-defined intervals.
15. The method as recited in claim 11 , wherein the predetermined rules are specified based on user interaction with a service application creation program.
16. The method as recited in claim 11 , wherein the at least one user-specified function comprises at least one user-created scripting function selected from the group consisting of a VBScript function or a JavaScript function.
17. The method as recited in claim 11 , further comprising importing data to the customer relationship application utilizing the network.
18. The method of claim 11 , wherein the predetermined rules relate to at least one of referential integrity, required fields, and automatic sequence numbering.
19. A non-transitory computer program product for exporting data from an origin to a destination, the computer program product comprising:
computer code for identifying data, over a network, to be exported from the origin to the destination, the identified data accessible to a customer relationship application associated with the origin, the customer relationship application including a service application;
computer code for identifying a set of predetermined rules associated with the customer relationship application;
computer code for associating at least one user-specified function with the identified data, the at least one user-specified function capable of transforming at least a portion of the identified data; and
computer code for periodically executing the service application in order to export the identified data from the origin to the destination utilizing the network in accordance with the set of predetermined rules, wherein the computer code for exporting includes:
computer code for mapping first fields for the data in the origin to second fields for the destination, computer code for translating first field names of the mapped first fields to second field names of the second fields, and
computer code for transforming at least a portion of the identified data from the origin to the destination using the at least one user-specified function, the user-specified
function being modifiable from an application option screen that includes access to a scripting language, wherein the mapping and translating are customizable by the user such that the second field names and the second fields are customizable by the user.
20. A system for exporting data from an origin to a destination, the system comprising:
logic for identifying data, over a network, to be exported from the origin to the destination, the identified data accessible to a customer relationship application associated with the origin, the customer relationship application including a service application;
logic for identifying a set of predetermined rules associated with the customer relationship application;
logic for associating at least one user-specified function with the identified data, the at least one user-specified function capable of transforming at least a portion of the identified data; and
logic for periodically executing the service application in order to export the identified data from the origin to the destination utilizing the network in accordance with the set of predetermined rules, wherein the logic for exporting includes:
logic for mapping first fields for the data in the origin to second fields for the destination, logic for translating first field names of the mapped first fields to second field names of the second fields, and
logic for transforming at least a portion of the identified data from the origin to the destination using the at least one user-specified function, the user-specified function being modifiable from an application option screen that includes access to a scripting language, wherein the mapping and translating are customizable by the user such that the second field names and the second fields are customizable by the user.