FR2812738A1 - Method of processing and transfer of client data between two databases, uses an update file to hold data taken from two databases after nominating identifier field and fields to be validated - Google Patents

Abstract

Data is transferred between two databases (5, 7), one (5) created initially by the user. The first database (5) is automatically updated by access to a second database (7) held on a second remote computer (4). A predefined field is selected as search field to identify a client record, and validation fields nominated. An update file (6) is used to compare data held in each of the databases.

Description

<Desc / Clms Page number 1>
The present invention relates to a method for processing and transferring computer data between two libraries. It relates more particularly to a data processing and transfer method intended to automatically update the information in a personal file constituting a first library created by a computer database system.

In many fields and many companies, it is traditional to build up a customer file generally comprising all the information relating to an address and a telephone correspondence in order to regularly inform these people of the evolutions and novelties that these companies can offer.

However, it turns out that such files very quickly become partly obsolete, in particular due to the increased mobility of both legal and natural persons.

To solve this problem, it is known to manually check at least once a year the contact details of each customer or supplier constituting for example the customer or supplier file respectively according to the information which they have communicated. We understand that such processing is tedious, time consuming and unreliable since nothing indicates that the information has been updated.

It is this drawback that the invention intends to remedy more particularly by proposing a process for processing and transferring file data which is more efficient and faster.

To this end, the subject of the present invention is a method for processing and transferring computer data between two libraries, one of which is created beforehand by the user, said data including in particular information relating to the identification of individuals. , characterized in that it consists in automatically updating the library which has been created by - access to a second library belonging to a second central unit arranged remotely from a first unit comprising the first library from a system Communication ; - selection of at least one predefined field in said first library

<Desc / Clms Page number 2>

 designated research field and selection of at least one comparison field designated field to be validated; - import of the search field into the second library; - comparison of the field to be validated with the identical field of the second library; - transfer of the first library to a computer file identified by the user on the first central unit; - import at least the field to validate from the second library to the computer file in the case where it is different.

Thanks to the invention, the data to be processed are very quickly and automatically updated according to the choice of the user.

According to advantageous aspects of the invention, the method incorporates one or more of the following characteristics - the first central unit incorporates additional information in the computer file on the validity of the field or fields to be validated of the validated or corrected type; - the data stored in the first library includes for each individual, also called record, at least two of the following information - name of the individual; - address; - postal code and / or department; - telephone number; and said two pieces of information are fields contained in the second library; - the search field corresponds at least to the name of the individual field and the field to validate corresponds to the telephone number field; - the first central unit transfers the date from the day of

<Desc / Clms Page number 3>

 processing, its duration and the number of validated records to a second computer file.

The characteristics of the invention mentioned above, as well as others, will appear more clearly on reading the following description of an exemplary embodiment, with reference to the single appended figure in which a block diagram is represented. an interface according to the invention.

There is shown in the single figure, a data processing system consisting of a console 1 connected to a first central unit 2 by an appropriate computer link 3. This central unit 2 is further provided with a communication system allowing access to a second remote central unit 4 of the type, for example a modem.

This first central unit 2 or a peripheral thereof comprises, stored in a memory, a library 5 consisting for example of information relating to natural or legal persons. This information includes, for example for each person or individual, fields Name, Telephone number, Address, City, Department, etc., and constitutes what will later be referred to as the customer or supplier file.

The data processing system is designed to produce at least one computer file 6 for updating the library 5 by comparison with a second library 7 stored on the second central unit 4.

According to the invention, when a user of the data processing system knows that he has to update his library 5 or customer file, he accesses the second library 7, belonging to a central processing unit 4 remotely, in order to submit at least one field from its customer file as search criteria for all of its file designated as search field. Furthermore, the user also defines at least one comparison field, which will be designated in the following field to be validated.

During the search for the search field or fields of the customer file in the second library 7, the central unit 2 compares, once these fields are found according to a particular embodiment, at least one field to be validated identical to the two libraries such as for example the telephone number and creates a first computer file 6 into which the data from the first library 5 are transferred as well as the compared field or fields to be validated belonging to the second library 7 in the case where this or these are

<Desc / Clms Page number 4>

 different. The central unit 2 can also incorporate additional information on the validity of the compared field or fields or their corrections.

Furthermore, according to an alternative embodiment, the central unit 2 also creates, at the request of the user, a second computer file 6 ′ into which the date of the treatment day, its duration and the number of recordings are transferred. (or fields) validated.

It is understood that such processing finds its application advantageously in particular for the verification and validation of the telephone coordinates of a plurality of individuals. In such a case, the second library is made up of information from telephone subscribers. In addition, access to this second library is facilitated by all possible communication accesses, for example minitel or internet.

It is understood that the invention is applicable to the updating of all types of data.

In general, numerous technical data or contact details can be stored in the file created in order to be used by the user for other needs such as sending bulk mail, classification by field of activity or again by geographic region.

<Desc / Clms Page number 5>

Claims (5)

1. Method for processing and transferring computer data between two libraries (5; 7), one of which (5) is created beforehand by the user, said data including in particular information relating to the identification of individuals, characterized in that it consists in automatically updating the library which has been created by - access to a second library (7) belonging to a second central unit (4) arranged at a distance from a first unit (2) comprising the first library (5) from a communication system; - Selection of at least one predefined field in said first library designated search field and selection of at least one comparison field designated field to be validated; - import of the search field into the second library; - comparison of the field to be validated with the identical field of the second library; - transfer of the first library to a computer file (6) identified by the user on the first central unit (2); - import at least the field to be validated from the second library (7) to the computer file (6) in the event that it is different. 2. Method for processing and transferring data according to claim 1, characterized in that the first central unit (2) incorporates additional information in the computer file (6) on the validity of the field or fields to be validated of the validated type or corrected. 3. Method for processing and transferring data according to any one of the preceding claims, characterized in that the data stored in the first library (5) comprises for each individual, also called record, at least two of the following information - name of the individual; - address ; <Desc / Clms Page number 6>  - postal code and / or department; - telephone number; and in that said two pieces of information are fields contained in the second library (7). 4. Method for processing and transferring data according to claim 3, characterized in that the search field corresponds at least to the name field of the individual and the field to be validated corresponds to the telephone number field. 5. Method for processing and transferring data according to any one of the preceding claims, characterized in that the first central unit transfers the date of the processing day, its duration and the number of validated records to a second computer file (6 ').