Service desk data transfer interface
A system, method and computer program product for importing data in a network-based customer relationship application is provided. First, data to be imported to a customer relationship application utilizing a network is identified. A set of predetermined rules associated with the customer relationship application are identified. The data is imported to the customer relationship application utilizing the network in accordance with the set of predetermined rules. The data is stored in memory accessible to the customer relationship application. The fields in which the data is stored in the memory are customized by a user. A system, method and computer program product for exporting data in a network-based customer relationship application is also provided. Data to be exported from a customer relationship application utilizing a network is identified. The data is stored in memory accessible to the customer relationship application, in fields which are user-customizable. A set of predetermined rules associated with the customer relationship application is identified. The data is exported from the customer relationship application utilizing the network in accordance with the set of predetermined rules. A system, method and computer program product are also provided for generating an application for managing network data transfer operations. A screen for receiving a designation of a type of application to be created is displayed. A screen for receiving a designation of an origin of the data is also displayed. A screen for receiving a designation of a destination for the data is further displayed. A mapping of fields between the origin of the data and the destination of the data is generated. The application is created. A screen is also displayed that allows a user to manipulate the mapping. A data transfer operation is performed upon execution of the application.
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;
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;
importing the identified data from the origin to the destination utilizing the network in accordance with the set of predetermined rules, wherein the act of 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; 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 as recited in claim 1 , wherein a service application for importing the data is generated based on the rules.
3. The method as recited in claim 2 , wherein the service application runs periodically at user-defined intervals.
4. The method as recited in claim 1 , wherein the predetermined rules are specified based on user interaction with an application creation program.
5. 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 croup consisting of a VBScript function or a JavaScript function.
6. The method as recited in claim 1 , further comprising exporting data from the customer relationship application utilizing the network.
7. The method as recited in claim 1 , wherein the rules relate to at least one of referential integrity, required fields, and automatic sequence numbering.
8. A computer program product stored in a computer readable medium for importing data from an origin to a destination, the computer program comprising:
computer code for identifying data, over a network, to be imported from the origin to the destination, the destination associated with a customer relationship 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 importing the identified data from the origin to the destination utilizing the network in the accordance with the set of predetermined rules, wherein the computer coder 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; 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.
9. 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;
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 importing 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; 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.
10. 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;
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
exporting the identified data from the origin to the destination utilizing the network in accordance with the set of predetermined rules, wherein the act of 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,
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. The method as recited in claim 10 , wherein a service application for exporting the data is generated based on the rules.
12. The method as recited in claim 11 , wherein the service application runs periodically at user-defined intervals.
13. The method as recited in claim 10 , wherein the predetermined rules are specified based on user interaction with a service application creation program.
14. The method as recited in claim 10 , 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.
15. The method as recited in claim 10 , further comprising importing data to the customer relationship application utilizing the network.
16. The method as recited in claim 10 , wherein the rules relate to at least one of referential integrity, required fields, and automatic sequence numbering.
17. A computer program product for exporting data from an origin to a destination, the computer program 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;
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 exporting 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,
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.
18. 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;
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 exporting 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,
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.