dynamiczip:faq:customer_combiner
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dynamiczip:faq:customer_combiner [2017/01/04 19:10] – chuck | dynamiczip:faq:customer_combiner [2017/01/06 19:27] – chuck | ||
---|---|---|---|
Line 2: | Line 2: | ||
The Professional Service Tools Customer Combiner can be used to combine two customers into one. It does this by modifying all occurrences of one of the Customer ID's to the other Customer ID. This can result in a duplicate key error if Customer ID is part of a unique key in any SQL table. For example, the [[dynamiczip: | The Professional Service Tools Customer Combiner can be used to combine two customers into one. It does this by modifying all occurrences of one of the Customer ID's to the other Customer ID. This can result in a duplicate key error if Customer ID is part of a unique key in any SQL table. For example, the [[dynamiczip: | ||
- | Also, if two customers | + | Also, if two customers have an identical address ID, you may receive the following error on the [[dynamiczip: |
**[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ' | **[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ' | ||
Line 10: | Line 10: | ||
===== Solution ===== | ===== Solution ===== | ||
- | Prior to running | + | If you have already run the Customer Combiner |
- Open [[dynamiczip: | - Open [[dynamiczip: | ||
- Select the offending record and click Delete. | - Select the offending record and click Delete. | ||
- | - Repeat Step 2 for each offending record. | + | - Run the Customer Combiner tool again. |
- | If you have already run the Customer Combiner and received the above error (for the DZ Customer Supplement Table: DZ001100), then you will need to identify the duplicate records, determine which one you want to keep and delete the other one which we will refer to as the offending record. To delete the offending Customer Supplement | + | If you have already run the Customer Combiner and received the above error (for the DZ Customer Supplement Table: DZ001100), then you will need to identify the duplicate records, determine which one you want to keep and delete the other one which we will refer to as the offending record. To delete the offending Customer Supplement |
- Open [[dynamiczip: | - Open [[dynamiczip: | ||
- Select the offending record and click Delete. | - Select the offending record and click Delete. | ||
- | - Repeat Step 2 for each offending record. | + | - Run the Customer Combiner tool again. |
---- | ---- |
dynamiczip/faq/customer_combiner.txt · Last modified: 2019/03/13 18:51 by conni