A series of implementation measures on SSDCRM old system data migration to new system

As a result of recent customer references to the old system of CRM data migration problem, in order to effectively help people solve this practical difficulties. The technical Group will write out the processing methods in batches in the near future. Today, let's talk about how the 5x system's review information is migrated to the 7x new system.

solutions to the introduction of new systems for old system reviews

Problem Description:

The comment information in each module of the 5x system is saved in the ec_modcomments table ( accessed via phpmyadmin). Export the table's ec_modcomments.sql file directly.

the table structure in the 7x system differs from the old system. The main value of Crmid is different. For example:5x system, a contact record module with the comment information, it corresponds to the crmid is 3613. in the 7x new system, the corresponding comment information for the Contact record module corresponds to the crmid 2005.

for the above situation, we think 5x comments smoothly into the 7x system, you need to take the following countermeasures:

1, for example, we need to 5x system Contact record contract orders and so on several modules corresponding to the comments information into the 7x system. First of all, in the 7x system to contact the record contract orders , and several corresponding modules to create a new message, add comments. You can then enter phpMyAdmin to find the modcomments table. Record the Crmid values for the new comment information that you just added .

2, ibid, statistics of the old system comment records corresponding crmid value corresponding to which module

3, complete as above work, run 7x system, enter phpMyAdmin backstage, find modcomments table, import (Imports) ec_ Modcomments.sql file, and then in the list of imported information, refer to the crmid values in steps 1and2 , corresponding to the modifications.

This article from the "SSD Software Technology Development Group" blog, declined reprint!

A series of implementation measures on SSDCRM old system data migration to new system