GregTHP Posted May 29, 2009 Share Posted May 29, 2009 Everybody, I just bought some clients from another hosting company. We both have WHMCS 4.0 and I was wondering if there’s a script or something out there where I can transfer all of the WHMCS info from the old company to my company? Google hasn't really "shown me the way" so to speak and thus the ask for guidance here. Please let me know if you know of a way, or have any thoughts in doing this. Manually isn't the best, but if nothing turns up here it's my only option. It's about 150 users. 0 Quote Link to comment Share on other sites More sharing options...
Stream101 Posted May 29, 2009 Share Posted May 29, 2009 The only way I could think of is to copy the database entries. IT will screw up their passwords though, because both installs have a different hash code. 0 Quote Link to comment Share on other sites More sharing options...
ffeingol Posted May 29, 2009 Share Posted May 29, 2009 Contact support. I was told that they can merge WHMCS systems. 0 Quote Link to comment Share on other sites More sharing options...
GregTHP Posted May 29, 2009 Author Share Posted May 29, 2009 I did contact support and they sent me to the import scripts web page where it says to do it by hand I tried to move the tbclients database but it keeps erroring even tho none of the information is the same. 0 Quote Link to comment Share on other sites More sharing options...
Victor Lugo Posted May 29, 2009 Share Posted May 29, 2009 Do you use an instant messenger? I may be able to help, as I've successfully merged WHMCS databases for two of my clients. 0 Quote Link to comment Share on other sites More sharing options...
bear Posted May 30, 2009 Share Posted May 30, 2009 Do you use an instant messenger?I may be able to help, as I've successfully merged WHMCS databases for two of my clients. Sharing here would benefit all, so why not post the method instead of taking it off the public forum? 0 Quote Link to comment Share on other sites More sharing options...
DialAHost Posted May 30, 2009 Share Posted May 30, 2009 PHPMYADMIN, more than likely you will have to do it manually. I had the same problem, it Encrypts all the passwords and clients can't get in. Good Luck 0 Quote Link to comment Share on other sites More sharing options...
PureEvil Posted June 8, 2009 Share Posted June 8, 2009 Has anyone found a way to do this? I'm having the same issue. Moving that much data by hand seems a bit silly. 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted June 8, 2009 Share Posted June 8, 2009 I posted in another thread the "overview" methodology - it's quite involved but we've done it successfully with eight acquisitions in the last 6 months 0 Quote Link to comment Share on other sites More sharing options...
PureEvil Posted June 8, 2009 Share Posted June 8, 2009 I resolved this by simply getting 6 people working on it by hand. I also had everyone call any customer that had not updated their information in a while and got them all updated with current info. It sucked but its done. I contacted tech support and they stated simply copy the database from one server to the other. Maybe it would have worked, not sure as we just jumped in with both feet and hammered it out. 0 Quote Link to comment Share on other sites More sharing options...
Austdata Posted June 10, 2009 Share Posted June 10, 2009 I contacted tech support and they stated simply copy the database from one server to the other. Maybe it would have worked, not sure as we just jumped in with both feet and hammered it out. That's not going to work. You have invoice numbers, order numbers and all sorts of other incrementing things that will conflict at best, overwrite at worst. In the end something critical will be screwed. 0 Quote Link to comment Share on other sites More sharing options...
suhailc Posted June 23, 2009 Share Posted June 23, 2009 There now is a WHMCS to WHMCS import script. Not sure if its ready for V4 yet. I'll check and update this thread. 0 Quote Link to comment Share on other sites More sharing options...
siforek Posted June 26, 2009 Share Posted June 26, 2009 So long as you change the password hash there should be no problem with exporting the clients from one DB to another. 0 Quote Link to comment Share on other sites More sharing options...
D9Hosting Posted June 26, 2009 Share Posted June 26, 2009 So long as you change the password hash there should be no problem with exporting the clients from one DB to another. Wouldn't there be an issue with clashing invoice numbers and client ID's? 0 Quote Link to comment Share on other sites More sharing options...
siforek Posted June 26, 2009 Share Posted June 26, 2009 Wouldn't there be an issue with clashing invoice numbers and client ID's? Guess you're right.. The way i would approach it would be to write a script that gets all the clients, invoices, etc from one database, store it in an array that then inserts it all into the "new" DB.. 0 Quote Link to comment Share on other sites More sharing options...
Austdata Posted June 26, 2009 Share Posted June 26, 2009 You know, you could make that "array" the new DB and cut out one step in that approach. 0 Quote Link to comment Share on other sites More sharing options...
phpforfun Posted July 7, 2009 Share Posted July 7, 2009 I wish this was possible as well.... If you want, youc an make a script, or I can make it for you Reach into the DB, for each user, enter them into the new DB, and continue off of the ID field if its auto_inc, then maybe have it recreate the passwords?... Should be easy. 0 Quote Link to comment Share on other sites More sharing options...
bear Posted July 7, 2009 Share Posted July 7, 2009 or I can make it for you Nice of you to offer making this for free. Should be easy. If it were, chances are someone would have done it by now. 0 Quote Link to comment Share on other sites More sharing options...
Lawrence Posted July 7, 2009 Share Posted July 7, 2009 Nice of you to offer making this for free. If it were, chances are someone would have done it by now. It would be easier on the older WHMCS version (3.8.x and lower) as the client password format and other encryptions were reversible. You would just need the hash for the WHMCS being imported (which was stored in the configuration php file in a variable). With v4, the client password would need to be randomly regenerated regardless, as it's in a MD5 type format now and cannot be decrypted. Overall, the import is not too difficult for a decent programmer. You would need to loop through each client, insert them into the DB, and track the new client ID that would result. Use that to then bring over invoices, e-mails and the like (decrypting and doing new encrypting as needed). It is more of a PITA than anything. 0 Quote Link to comment Share on other sites More sharing options...
siforek Posted July 7, 2009 Share Posted July 7, 2009 It would be easier on the older WHMCS version (3.8.x and lower) as the client password format and other encryptions were reversible. You would just need the hash for the WHMCS being imported (which was stored in the configuration php file in a variable). With v4, the client password would need to be randomly regenerated regardless, as it's in a MD5 type format now and cannot be decrypted. Overall, the import is not too difficult for a decent programmer. You would need to loop through each client, insert them into the DB, and track the new client ID that would result. Use that to then bring over invoices, e-mails and the like (decrypting and doing new encrypting as needed). It is more of a PITA than anything. Agreed. I'd do it if I actually needed it myself. It's more of a "one-time" use needed type of script, so you couldn't really charge for it and it's hard for a programmer to justify doing the work for free if they don't need it personally. 0 Quote Link to comment Share on other sites More sharing options...
phpforfun Posted July 15, 2009 Share Posted July 15, 2009 I just purchased a company as well, this is going to suck moving them, lol. WHMCS should make this an option, they have all kinds of import tools, except for whmcs to whmcs. 0 Quote Link to comment Share on other sites More sharing options...
Austdata Posted July 15, 2009 Share Posted July 15, 2009 Having a WHMCS to WHMCS tool would seem to make sense. It would be a great feature. 0 Quote Link to comment Share on other sites More sharing options...
suhailc Posted July 15, 2009 Share Posted July 15, 2009 Hi, Guys as stated earlier, THERE IS a WHMCS > WHMCS import script for V3. I've asked Matt about V4 and he said this will be released shortly. 0 Quote Link to comment Share on other sites More sharing options...
Austdata Posted July 15, 2009 Share Posted July 15, 2009 I hadn't noticed, is there a link? 0 Quote Link to comment Share on other sites More sharing options...
suhailc Posted July 15, 2009 Share Posted July 15, 2009 No you have to request it via a support ticket. 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.