vince512 Posted June 15, 2016 Share Posted June 15, 2016 Hello, I need to merge two WHMCS databases into one. I noticed the merge script that is posted on the site but it seems that is for version 4 and 5 and does not work on 6. Can someone lead me into the right direction on where to look either a script or even a manual solution. Thanks, Vince 0 Quote Link to comment Share on other sites More sharing options...
twhiting9275 Posted June 15, 2016 Share Posted June 15, 2016 This is something that is not possible using the current 'merge script', correct. Take a look at the API, you'll need to do some fancy SQL queries, but you can create the orders, invoices, services from the API, based on the old db. 0 Quote Link to comment Share on other sites More sharing options...
freemind Posted June 15, 2016 Share Posted June 15, 2016 i needed the v6 merge script too. 0 Quote Link to comment Share on other sites More sharing options...
twhiting9275 Posted June 15, 2016 Share Posted June 15, 2016 We all do. Believe me, we all do. It's been mentioned countless times, falling on deaf ears it seems. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 16, 2016 Share Posted June 16, 2016 We all do. Believe me, we all do.It's been mentioned countless times, falling on deaf ears it seems. that's true - all we hear is that it's coming... by the time it's released, no doubt WHMCS v7 will be available, so the merry-go-round will have to start all over again. 0 Quote Link to comment Share on other sites More sharing options...
silverspring Posted July 23, 2016 Share Posted July 23, 2016 Atleast give us merge script source code so we can try to figure out. 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted August 9, 2016 Share Posted August 9, 2016 basic method: step 1 - find the highest "id" on every table you currently have on 1st install step 2 - offset every id in every table on the 2nd install by that value and ensure everything still works step 3 - use mysql to export and import all the data from 2nd install to 1st install advanced method: only do the tables you actually need 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted August 11, 2016 WHMCS Support Manager Share Posted August 11, 2016 Hi, We are currently working on an updated import system for WHMCS v6 and v7. Keep an eye on our blog for the release announcement in the next month or so: http://blog.whmcs.com At present it would be necessary to import the data into WHMCS manually: http://docs.whmcs.com/Importing_Data#Manual_Client_Entry If you're using cPanel you can speed up the process somewhat using the WHM/cPanel import tool: http://docs.whmcs.com/CPanel/WHM_Import 0 Quote Link to comment Share on other sites More sharing options...
bear Posted August 11, 2016 Share Posted August 11, 2016 At present it would be necessary to import the data into WHMCS manually: http://docs.whmcs.com/Importing_Data...l_Client_Entry Looks like a bad link copy there. Might be this one? http://docs.whmcs.com/Importing_Data#Manual_Client_Entry 0 Quote Link to comment Share on other sites More sharing options...
wsa Posted August 12, 2016 Share Posted August 12, 2016 i think this one http://docs.whmcs.com/Importing_Data#Manual_Client_Entry 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted August 12, 2016 WHMCS Support Manager Share Posted August 12, 2016 Looks like a bad link copy there. Might be this one?http://docs.whmcs.com/Importing_Data#Manual_Client_Entry Whoops you're right, updated my original link. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted August 23, 2016 WHMCS Support Manager Share Posted August 23, 2016 Hi, I'm pleased to advise the new and much improved merge script; Import Assist is now available: https://marketplace.whmcs.com/product/46 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.