Difference between revisions of "ProDon:Merging and Deleting a Client"
(→Selecting Clients to be Merged) |
|||
| Line 3: | Line 3: | ||
== Introduction == | == Introduction == | ||
| − | This procedure allows you to eliminate duplicates from the [[ProDon: | + | This procedure allows you to eliminate duplicates from the [[ProDon:Client Management|"Client management"]]. There is presence of a duplicate when there are more than one client file for the same client, this situation generally occurs following a transfer of data coming from another database. |
| − | This function is used to merge clients on a "cas-by-case" basis, to find and merge all potential duplicates of the database, use instead [[ProDon: | + | This function is used to merge clients on a "cas-by-case" basis, to find and merge all potential duplicates of the database, use instead [[ProDon:Researching and eliminating duplicates|"Searching and Eliminating Duplicates"]]. |
'''CAUTION: '''Before merging: | '''CAUTION: '''Before merging: | ||
| − | *For individuals, carefully check their last names, first names and addresses | + | *For individuals, carefully check their last names, first names and addresses in the client files to be merged. |
| − | *For companies, organizations or associations, carefully check the last name and the first name of the main contact | + | *For companies, organizations or associations, carefully check the last name and the first name of the main contact in the client files to be merged. |
== Selecting Clients to be Merged == | == Selecting Clients to be Merged == | ||
Revision as of 12:17, 5 October 2011
Introduction
This procedure allows you to eliminate duplicates from the "Client management". There is presence of a duplicate when there are more than one client file for the same client, this situation generally occurs following a transfer of data coming from another database.
This function is used to merge clients on a "cas-by-case" basis, to find and merge all potential duplicates of the database, use instead "Searching and Eliminating Duplicates".
CAUTION: Before merging:
- For individuals, carefully check their last names, first names and addresses in the client files to be merged.
- For companies, organizations or associations, carefully check the last name and the first name of the main contact in the client files to be merged.
Selecting Clients to be Merged
First, go to the "Client management".
|
To do so, from the software home page, click on the "Clients" menu, then select " |
|
|
After clicking on " | |
| |
|
A: Search, using the search bar, the client to keep. |
B: Double-click on the line of the client to keep to open his or her file. |
|
After double-clicking on the line of the client to keep, the file opens. | |
| |
|
C: In the client file, click on the "Special Functions" menu. |
D: Then select "Merge and delete another client". |
|
After clicking on "Merge and delete another client", the "List of clients" window opens. | |
| |
|
E: Search for the duplicate using the search bar. |
F: Double-click on the line of the duplicate. |
Merging Clients
|
After selecting the duplicate at step F, the "Merge duplicates" window opens. | |
 | |
|
NOTE: The blue cells can not be modified, the green cells contain identical information for both clients, and the orange cells contain information that differs from one client to the other. | |
|
A: By clicking in a blank cell of the "Result" column next to an orange line, a drop-down list appears. This list contains the information from both columns, select the information to keep. |
B: When all the orange lines contain the right information in the "Result" column, click on the " |
|
CAUTION: Once the client is merged, it is impossible to bring him or her back in the database. | |
Document name: ProDon:Merging and Deleting a Client
