Automated import of data

• US 20040003057A1
• Filed: 05/16/2003
• Published: 01/01/2004
• Est. Priority Date: 05/17/2002
• Status: Abandoned Application

• Current Assignee: Transcentive, Inc. (Computershare Limited)
• Original Assignee: Transcentive, Inc. (Computershare Limited)
• Inventors: Pak, Wellington, Broad, John
• Application Number:
  US10/439,490
• Publication Number:
  US 20040003057A1
• Time in Patent Office: Days
• US Class Current: 709/219
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A method for importing data from a client system to a destination application on a server system is presented. At the client system, the method includes identifying a type and location of a plurality of data items for importing, and requesting import of the data items. Each of the requests includes the identifying information. At the server system, the method includes receiving the requests and based on the identifying information, retrieving the data from the client system and individually storing the plurality of data items at the server system. The server system also individually retrieving, in response to predefined criteria, the stored data items and loading the data items to the destination application. During the loading, the server generates and stores a log. The log includes status information regarding the loading of each data item. The status information includes statistics and errors that occur during loading.

Claims

1. In a network configured data processing system, a method for importing data from a client system to a destination application on a server system, comprising:

at the client system, the method including;

identifying a type and location of each of a plurality of data items for importing; and

requesting import of the plurality of data items, each request including the identifying information; and

at the server system, the method including;

receiving the requests;

based on the identifying information, retrieving the plurality of data items from the client system and individually storing the plurality of data items at the server system;

in response to predefined criteria, individually retrieving each of the stored plurality of data items and loading the plurality of data items to the destination application; and

generating and storing a log, the log including status information regarding the loading of each of the plurality of data items.

2. The method as set forth in claim 1, wherein the predefined criteria includes predetermined time schedule.

3. The method as set forth in claim 1, wherein the predefined criteria includes a set of rules for processing import requests.

4. The method as set forth in claim 3, wherein the set of rules includes one of a first rule for processing requests in a first-in-first-out sequence and a second rule that data files exceeding a predefined threshold are processed during periods of relatively minor system processing.

5. The method as set forth in claim 1, wherein the status information includes statistics and errors that occur during loading.