dynamiczip:faq:customer_combiner
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
dynamiczip:faq:customer_combiner [2017/01/06 19:27] – chuck | dynamiczip:faq:customer_combiner [2017/01/06 21:34] – chuck | ||
---|---|---|---|
Line 1: | Line 1: | ||
======Using the Professional Service Tools Customer Combiner====== | ======Using the Professional Service Tools Customer Combiner====== | ||
- | 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 have an identical address ID, you may receive the following error on the [[dynamiczip: | + | 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 ===== | ||
- | If you have already run the Customer Combiner and received the above error (for the DZ Customer Address Supplement Table: | + | If you have already run the Customer Combiner and received the above error (for the DZ Customer Address Supplement Table: |
- Open [[dynamiczip: | - Open [[dynamiczip: | ||
Line 16: | Line 16: | ||
- Run the Customer Combiner tool again. | - 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: | + | If you have already run the Customer Combiner and received the above error (for the DZ Customer Supplement Table: |
- Open [[dynamiczip: | - Open [[dynamiczip: |
dynamiczip/faq/customer_combiner.txt · Last modified: 2019/03/13 18:51 by conni