Service desk data transfer interface

Abstract

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.

Claims

1. A method comprising: accessing, by a computing device at a client site, a network-based customer relationship application; loading, by the computing device, metadata from the customer relationship application; associating a database local to the computing device with the customer relationship application; generating, by the computing device and using the metadata from the customer relationship application, a map for mapping data between the local database and a database external to the computing device; creating a transfer application using the mapping, the transfer application being installed in the customer relationship application as a service; displaying, by the computing device, a screen for allowing manipulation of the mapping, the manipulation including customization of field names at the client site; and executing, by the computing device, the transfer application, the executing including mapping first fields for data at the external database to second fields for data at the local database, and the mapping translating first field names of the first fields to customized second field names of the second field.

2. The method as recited in claim 1, further comprising specifying an interval of time that elapses between automatic execution of the transfer application.

3. The method as recited in claim 1, further comprising: displaying, by the computing device, a screen for receiving a designation of a type of application to be created for the transfer application, wherein the type of application is at least one of a Structured Query Language import application, a Structured Query Language export application, an Open Database Connectivity import application, an Open Database Connectivity export application, a file import application, a file export application, an electronic mail import application, and an electronic mail export application.

4. The method as recited in claim 1, further comprising receiving a specification of a name for the transfer application.

5. The method as recited in claim 1, further comprising receiving login information.

6. The method as recited in claim 1, further comprising gathering logging information.

7. The method as recited in claim 1, wherein the manipulation of the mapping further includes altering the mapping of the first fields for data at the external database to the second fields for data at the local database.

8. The method as recited in claim 7, wherein the altering includes specifying the fields to be transferred from the external database.

9. The method as recited in claim 7, wherein the altering includes providing the names of the fields from the external database which correspond to selected fields of the local database.

10. The method as recited in claim 7, wherein the altering includes providing the names of the fields from the local database which correspond to selected fields of the external database.

11. The method as recited in claim 7, wherein the altering includes specifying the fields to be transferred from the local database.

12. The method as recited in claim 1, wherein the mapping of the first fields for data at the external database to second fields for data at the local database includes custom fields added at the client site to the local database.

13. The method as recited in claim 1, wherein creating the transfer application further includes using at least one scripting function selected from a group consisting of a VBScript function and a JavaScript function.

14. A program storage device, readable by a programmable control device, comprising instructions stored on the program storage device for causing the programmable control device to perform a method comprising: accessing, by a computing device at a client site, a network-based customer relationship application; loading, by the computing device, metadata from the customer relationship application; associating a database local to the computing device with the customer relationship application; generating, by the computing device and using the metadata from the customer relationship application, a map for mapping data between the local database and a database external to the computing device; creating a transfer application using the mapping, the transfer application being installed in the customer relationship application as a service; displaying, by the computing device, a screen for allowing manipulation of the mapping, the manipulation including customization of field names at the client site; and executing, by the computing device, the transfer application, the executing including mapping first fields for data at the external database to second fields for data at the local database, and the mapping translating first field names of the first fields to customized second field names of the second field.

15. The program storage device as recited in claim 14, wherein creating the transfer application further includes using at least one scripting function selected from a group consisting of a VBScript function and a JavaScript function.

16. A client site system comprising: a processing unit; a display device coupled to the processing unit; and a memory coupled to the processing unit, the memory storing program instructions executable by the processing unit to: access a network-based customer relationship application; load metadata from the customer relationship application; associate a database local to the client site system with the customer relationship application; generate, using the metadata from the customer relationship application, a map for mapping data between the local database and a database external to the client site system; create a transfer application using the mapping, the transfer application being installed in the customer relationship application as a service; display, on the display device, a screen for allowing manipulation of the mapping, the manipulation including customization of field names at the client site system; and execute the transfer application, the execution including mapping first fields for data at the external database to second fields for data at the local database, and the mapping translating first field names of the first fields to customized second field names of the second field.

17. The system as recited in claim 16, wherein creating the transfer application further includes using at least one scripting function selected from a group consisting of a VBScript function and a JavaScript function.

18. A method comprising: receiving, by a computing device at a client site, a designation of an origin of data for a transfer application, the origin of the data being a database external to the computing device; receiving, by the computing device at the client site, a designation of a destination for data for the transfer application, the destination of the data being a database local to the computing device, and the destination being associated with a customer relationship application that is network-based and accessed from the client site; loading metadata from the customer relationship application; generating, by the computing device and using the metadata from the customer relationship application, a map for mapping of fields between the origin of the data and the destination of the data for the transfer application, wherein the map for the mapping of the fields includes custom fields added by the computing device at the client site, the custom fields provided to the customer relationship application for execution at the client site; creating the transfer application using the mapping, the transfer application being installed in the customer relationship application as a service; displaying, by the computing device, a screen for allowing manipulation of the mapping, the manipulation of the mapping including altering the mapping of fields of the destination of the data to the fields from the origin of the data; and performing a data transfer operation upon execution of the transfer application.

19. The method as recited in claim 18, wherein the altering includes specifying the fields to be transferred from the origin of the data.

20. The method as recited in claim 18, wherein the altering includes providing names of the fields from the origin of the data which correspond to selected fields of the destination of the data.

21. The method as recited in claim 18, wherein the altering includes providing names of the fields from the destination of the data which correspond to selected fields of the origin of the data.

22. The method as recited in claim 18, wherein the altering includes specifying the fields to be transferred from the origin of the data.

23. The method as recited in claim 18, wherein creating the transfer application further includes using at least one scripting function selected from a group consisting of a VBScript function and a JavaScript function.

24. The method as recited in claim 1, further comprising: associating at least one predetermined rule with the mapping for the transfer application using the loaded metadata from the customer relationship application, the at least one predetermined rule specified by the customer relationship application, the at least one predetermined rule maintaining at least one of referential integrity, one or more required fields, and automatic sequence numbering of the data mapped from the local database to the external database.

Description

BRIEF DESCRIPTION OF THE DRAWINGS

(1) FIG. 1 is a representation of a customer relationship application architecture according to one embodiment.

(2) FIG. 2 shows a representative hardware environment that may be associated with the workstations of FIG. 1, in accordance with one embodiment.

(3) FIG. 3 is a flow diagram of a process for importing data in a network-based customer relationship application according to one embodiment.

(4) FIG. 4 is a flowchart of a process for exporting data in a network-based customer relationship application according to one embodiment.

(5) FIG. 5 is an illustration of a table of data of an external database according to an embodiment.

(6) FIG. 6 is a depiction of a screen of an API application wizard according to an embodiment.

(7) FIG. 7 is an illustration of a login data screen of an API application wizard according to an embodiment.

(8) FIG. 8 is an illustration of a module selection screen of an API application wizard according to an embodiment.

(9) FIG. 9 is a depiction of a logging options screen of an API application wizard according to one embodiment.

(10) FIG. 10 is an illustration of a finish screen of an API application wizard according to an embodiment.

(11) FIG. 11 is an illustration of an application option screen according to one embodiment.

(12) FIG. 12 is a depiction of a mapping screen according to one embodiment.

(13) FIG. 13 illustrates the mapping screen of FIG. 12 upon user manipulation according to an embodiment.

(14) FIG. 14 depicts an SQL import options screen accessible from the application options screen of FIG. 11.

(15) FIG. 15 illustrates a services application selection screen according to one embodiment.

(16) FIG. 16 depicts the table of the external database of FIG. 5 after an application created using the wizard of FIGS. 6-10 has exported data therefrom, according to an embodiment.

(17) FIG. 17 illustrates a portion of a table of a local database after an application created using the wizard of FIGS. 6-10 has imported data thereto, according to one embodiment.

DESCRIPTION OF THE PREFERRED EMBODIMENTS

(18) FIG. 1 depicts an illustrative customer relationship application architecture 100 according to one embodiment. As shown, the architecture 100 includes a database tier 102, which includes one or more data servers, such as one or more Structured Query Language (SQL) servers 104 and one or more Relational Database Management Systems (RDBMS) 106. The database tier 102 is in communication with a business logic tier 108 that delivers customizable business rules and application executables, preferably as a set of Component Object Model (COM) objects that are managed by Microsoft Transaction Server (MTS). A presentation/client tier 110 is also in communication with the business logic tier 108. The presentation/client tier 110 provides web communication and presentation services, which can consist of Active Server Pages that deploy on Microsoft's Internet Information Server 112 for example. Several workstations 114 are coupled to the Information Server 112. Note that this architecture is provided by way of example only and represents only one possible configuration of the architecture 100. One skilled in the art will appreciate that the various components described above may be removed, interchanged and/or added to without straying from the scope and spirit of the various possible embodiments enabled herein. Further, it should be noted that the customer relationship application may include any type of application used to perform any customer-related task. For example, the customer relationship application can be a service desk application, a customer contact application, etc.

(19) FIG. 2 shows a representative hardware environment associated with the workstations 114 of FIG. 1, in accordance with one embodiment. Such figure illustrates a typical hardware configuration of the workstation having a central processing unit 210, such as a microprocessor, and a number of other units interconnected via a system bus 212.

(20) The workstation shown in FIG. 2 includes a Random Access Memory (RAM) 214, Read Only Memory (ROM) 216, an I/O adapter 218 for connecting peripheral devices such as disk storage units 220 to the bus 212, a user interface adapter 222 for connecting a keyboard 224, a mouse 226, a speaker 228, a microphone 232, and/or other user interface devices such as a touch screen and a digital camera (not shown) to the bus 212, communication adapter 234 for connecting the workstation to a communication network 235 (e.g., a data processing network) and a display adapter 236 for connecting the bus 212 to a display device 238.

(21) The workstation may have resident thereon an operating system such as the Microsoft Windows NT or Windows 2000 Operating System (OS), the IBM OS/2 operating system, the MAC OS, or UNIX operating system. It will be appreciated that a preferred embodiment may also be implemented on platforms and operating systems other than those mentioned. A preferred embodiment may be written using JAVA, C, and/or C++ language, or other programming languages, along with an object oriented programming methodology. Object oriented programming (OOP) has become increasingly used to develop complex applications.

(22) FIG. 3 is a flow diagram of a process 300 for importing data in a network-based customer relationship application. In operation 302, 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 in operation 304. In operation 306, 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 in operation 308. Note that memory as used in this document can include persistent and/or non-persistent storage, such as RAM, a hard drive, tape media, etc. The fields in which the data is stored in the memory can be customized by a user.

(23) FIG. 4 is a flowchart of a process 400 for exporting data in a network-based customer relationship application. In operation 402, data to be exported from a customer relationship application utilizing a network is identified. The data has been stored in memory accessible to the customer relationship application, in fields which are user-customizable. In operation 404, a set of predetermined rules associated with the customer relationship application is identified. In operation 406, the data is exported from the customer relationship application utilizing the network in accordance with the set of predetermined rules.

(24) The predetermined rules can be specified based on user interaction with an application creation program, and can further include rules for referential integrity, required fields, and/or automatic sequence numbering. In yet another embodiment, the data is transformed. Preferably, the data is transformed based on user-created scripting functions.

(25) An embodiment will now be presented by way of example. The example will describe an API wizard which receives basic information required to create an API service application that manages a Structured Query Language (SQL) import operation for importing data from an external database (the origin of the data) into a Clients field of a local database of a customer relationship application (the destination of the data).

(26) The wizard maintains the use of existing logic and business rules in the customer relationship application, ensuring correct data imports from a variety of external data sources. The wizard is also used to import data into the customer relationship application in a manner that follows all the rules of the customer relationship application environment. Referential integrity, required fields, and/or automatic sequence numbering can be enforced through the applications created using the wizard. Thus, the wizard makes it possible to bridge legacy and other systems to the customer relationship application.

(27) The example will further show how the application can be installed in the customer relationship application as a Windows NT service at the end of the wizard's run, but note that the application may function as a standalone application, a Windows 2000 service, or as any other type of application.

(28) This example shows only one area in which an embodiment may be used. For example, creation of an application to export data from the customer relationship application to an external database follows a similar process, as would be understood by one skilled in the art. Thus, various embodiments can import from or export to SQL/ODBC data sources, text files, electronic mail, etc. One skilled in the art will understand how to make and use various embodiments for any area by simple variance from the following description.

(29) FIG. 5 depicts a screen 500 showing a table 502 of the contents of the external database, including client information that will be inserted in the local database. Note that the external and local databases may be any type of database, including a Microsoft Access database.

(30) Referring again to FIG. 5, the fields of the external database include a UserID field 504 that will be mapped to the client ID field in the local database. Other fields include UserFirstName 506, UserLastName 508, UserCompany 510, and UserDepartment 512, which will be mapped to the First Name, Last Name, Company ID, and Department ID fields of the local database, respectively (see FIG. 13 and the related discussion). The values of each field in the external database are also shown.

(31) The Status field 514 is set to 0, indicating that the particular row of data is ready to be imported into the local database. When the import function is successful, the value will change to 1 (as shown in FIG. 16).

(32) In use, the API wizard is started. The first screen shown is a basic information screen 600. See FIG. 6. The name of the application being created is entered in a Service Executable field 602. A Service Description field 604 is provided, into which a description of the application can be entered. The directory in which the application executable is saved is specified in the Service Directory field 606. The type of application is specified in the Application Type field 608. In this example, the application is an SQL import application. Other types of applications are described above. A service interval can be entered in the Service Interval field 610, indicating an amount of time that will elapse between executions of the application, such as every minute, every hour, once per day, etc. Here, the service interval is set at 10 seconds, meaning that 10 seconds will elapse between executions of the application. The Next button is selected.

(33) FIG. 7 illustrates a login data screen 700. Here, the user enters login information in the User and Password fields 702, 704 for logging in to the customer relationship application and/or external database (if required). The Next button is selected.

(34) At this point, the wizard loads customer relationship application metadata objects to further refine options that can be set for this application. Once the objects are loaded, the customer relationship application module or view that is being imported to (or exported from) can be selected from a Master Module drop-down menu 802 of the module selection screen 800 shown in FIG. 8. Submodules of the master module may further be specified by selecting them from a Detail Module drop-down menu 804. Once the application is installed, the user will have the opportunity to define the mapping of fields between the import table in Microsoft Access and the module in the customer relationship application, as described below.

(35) With continued reference to FIG. 8, the Clients module is selected from the Master Module menu 802. A group can be selected from the Group drop-down menu 806. In this example, a default group is selected. For those sites using segregated data, the selection of the group can provide an important mechanism in determining how the data is created within the customer relationship application. The Next button is selected.

(36) FIG. 9 depicts a logging options screen 900. Selectable options include whether to log data transfer information to a file, whether to start a new log file and when to do so, how long to keep log files, whether to save logging information to a Windows NT event log, whether to send an email to a user upon encountering an error, and whether to log successful operation. A level of debugging can also be set. If information is to be logged to a file, the path of the log file is entered in the Log file path field 902. If error messages are to be electronically mailed, the recipient's electronic mail address is specified in the EMail address field 904. In this example, successful operations are logged to the Windows NT event log. The Next button is selected.

(37) FIG. 10 illustrates a finish screen 1000 of the wizard. Upon selection of the Finish button 1002, the application is created.

(38) Upon creation of the application, an application option screen 1100 is displayed, as shown in FIG. 11, which summarizes the information entered in screens 6, 7, 8, and 9. The application options screen 1100 also allows a user to add additional information and/or modify already-entered information for this application.

(39) By default, the wizard creates a mapping that includes all of the available fields within the local database, including custom fields added at a client site. FIG. 12 depicts a mapping screen 1200 which lists the fields 1202 of the local database as determined during the data mapping created by the wizard. The mapping screen 1200 is displayed upon selection of the Edit button 1102 corresponding to the data definition file field of the application options screen 1100. See FIG. 11.

(40) Referring again to FIG. 12, the fields that will not be imported by the application are removed from the list in the mapping screen 1200. As shown in FIG. 13, the actual field names 1302 from the external SQL database are also inserted in place of the default mapping values for each of the corresponding fields of the local database.

(41) FIG. 14 depicts an SQL import options screen 1400 displayed upon selection of the Options button 1104 of the application options screen 1100 shown in FIG. 11. The SQL import options screen 1400 allows the user to define the source options for the SQL import. An ODBC data source for the Access table of the remote database, listed in the SQL ODBC field 1402, has already been defined in the Service Executable field 602 of the basic information screen 600, shown in FIG. 6.

(42) With continued reference to FIG. 14, the rows to import are designated by selecting the desired option from the Select rows to import drop-down menu 1404. In this example, the column values have been specified in the mapping screen 1200, and so the Column value is selected from the menu 1404. Another option of the menu includes importing all rows.

(43) The Status field of the external database is designated in the Import column for unprocessed field 1406. A designation that the rows to be imported have a status of 0 is entered in the Import column unprocessed value field 1408. The action on completion of a data transfer is selected in the Action on completion drop-down menu 1410. The Status field is designated in the Import column for completed 1412. By entering 1 in the Import column completed value field 1414, the application is instructed to change the value of the Status field for each row of the external database to 1 upon successful transfer of the data. Thus, once the import process is complete, the fields in the Status field 514 of the table 502 of the external database (FIG. 5) will change to 1, indicating that the data from each row has been imported into the local database.

(44) A rule for the action to be taken if an error occurs can be specified by selecting an option from the Action on error drop-down menu 1416. In this example, the data in the external database associated with the error is left open so that the import operation can be attempted again. Another option in the menu 1416 is deleting the row and logging the error.

(45) Another option is the use of scripting functions, preferably VBScript functions, which allows addition of custom code or custom logic at the client site 114 (FIG. 1) without further programming development. A VBScript function window (not shown) is accessible from the application option screen 1100 (FIG. 11) by selecting the Edit button 1106 associated with the VBScript Functions field 1108. The use of VBScript also allows VBA style functions to be written and added to the API wizard application. Note that any other scripting language can be used, including JavaScript.

(46) All options required to run the application according to the illustrative embodiment have now been specified. The application now executes according to the user-specified rules and parameters.

(47) FIG. 15 illustrates a services application selection screen 1500. As shown, the newly created application ClientInfo 1502 appears in the list of service applications. The application is started in the normal way in Windows NT by selecting the application 1502 and then selecting the start button 1504.

(48) When running, the application imports the specified data from the external database into the local database according to the mapping designation discussed with respect to FIGS. 12 and 13.

(49) The application option screen 1100 can be redisplayed while the application is running. This behavior is controllable from within the new Windows NT service application itself, such as by selecting and deselecting a check box on a Properties page.

(50) FIG. 16 depicts the table 502 of the external database. See also FIG. 5. As shown in FIG. 16, once the import process is complete, the values in the Status field 514 of the table 502 have changed to 1, indicating that the data from each row has been imported into the local database.

(51) FIG. 17 illustrates a portion of a table 1700 of the local database. As shown, the data from the external database has been imported and appears therein under the appropriate field headings.

(52) Thus, in summary, after the user enters the appropriate information in the fields of the wizard and specifies what is coming into the customer relationship application or going out of the customer relationship application, the end result is installation of a service application on a server such that the application can be run as a system service that can be scheduled or run periodically, not just as a normal program. This service is managed in a normal way, because it is a true operating system service in contrast to a normal program.

(53) While various embodiments have been described above, it should be understood that they have been presented by way of example only, and not limitation. For example, any of the network elements may employ any of the desired functionality set forth hereinabove. Thus, the breadth and scope of a preferred embodiment should not be limited by any of the above-described exemplary embodiments, but should be defined only in accordance with the following claims and their equivalents.