{"id":15408,"date":"2017-12-30T10:22:34","date_gmt":"2017-12-30T10:22:34","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=15408"},"modified":"2020-06-23T10:18:06","modified_gmt":"2020-06-23T10:18:06","slug":"re-point-gumu-sage-crm-sage-x3-integration-connection-to-different-sage-x3-folder","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/12\/30\/re-point-gumu-sage-crm-sage-x3-integration-connection-to-different-sage-x3-folder\/","title":{"rendered":"Re-point GUMU™ Sage CRM – Sage X3 Integration connection to different Sage X3 folder"},"content":{"rendered":"

There are many instances where client generally setup their Sage CRM server with TEST Sage X3 folder using GUMU™ integration<\/a> for testing purpose and once they completes their testing, client can take same Sage CRM to Live by re-pointing to different Sage X3 folder (Live folder).<\/p>\n

New\u00a0Stuff:\u00a0<\/em><\/strong>GUMU™Integration v\/s Sage Integration for Sage CRM and Sage X3<\/a><\/p>\n

For achieving this, user can follow below instructions.<\/p>\n

    \n
  1. Take complete backup of Sage CRM system including DB.<\/li>\n
  2. Take complete backup of Sage X3 system including DB.<\/li>\n
  3. Below are the steps for pointing different Sage X3 folder from same Sage X3 server in Sage CRM GUMU configuration.<\/li>\n<\/ol>\n

    a. Let\u2019s consider currently \u2018TEST\u2019 folder is integrated and now user want to point \u2018LIVE\u2019 folder in GUMU™ integration.
    b. Delete all the records from Sage CRM database which are related to \u2018TEST\u2019 folder.<\/p>\n

      \n
    1. To delete the records, login into Sage CRM SQL database server.<\/li>\n
    2. Now user have to delete data from CUSTOM_CAPTIONS table, to delete it run the below query in SQL
      Update<\/i><\/em>\u00a0<\/i><\/em><\/span>Custom_Captions<\/i><\/em><\/span>\u00a0<\/i><\/em>set<\/i><\/em>\u00a0<\/i><\/em><\/span>Capt_deleted<\/i><\/em><\/span>=<\/i><\/em>‘75′<\/span><\/i><\/em>\u00a0<\/i><\/em>where<\/i><\/em>\u00a0<\/i><\/em><\/span>Capt_Code<\/i><\/em><\/span>\u00a0<\/i><\/em>like<\/i><\/em>\u00a0<\/i><\/em>‘TEST%’<\/i><\/em><\/span>\u00a0<\/i><\/em>and<\/i><\/em>\u00a0<\/i><\/em>Capt_Deleted<\/i><\/em><\/span>\u00a0<\/i><\/em>is<\/i><\/em>\u00a0<\/i><\/em>null<\/i><\/em><\/li>\n
    3. Now delete all the TEST records created in CRM and which are associated with old Sage X3 folder from below tables of Sage CRM.<\/li>\n<\/ol>\n