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.

I'm fairly sure Matt has something to help with this, or may be able to offer advice at the least. Mainly it's making sure the ids don't conflict, but they are cross referenced in a few places, IIRC.

There is no way to do this with a script. Matt does not have one, nor does anybody in the WHMCS community. It is impossible to do because several things are encrypted, and you need the encryption hash, which only the WHMCS staff know how to implement. Your only option as of right now is this: http://wiki.whmcs.com/Importing_Data

I just contacted Matt literally an hour ago, and all this info is current. :)

which only the WHMCS staff know how to implement
Pretty sure Matt is staff. ;)
Unfortunate that this isn't possible, as it's been asked for loads of times.

Exactly, which is why only they can make that, and they should get on that. ;)

The majority of the importing could be done without knowing anything about anything encrypted. Although I'm confused on how that'll matter at all with the database data. The logic of this is pretty simple to do.


Retrieve users from old database
Assign them new id's from last in current database. For example last id was 100 then the first user from the imported db becomes user id 101.
Store the old id vs new id in some way
Import relevant user tables where ID does not get referenced elsewhere while updating the user id.
Use same last id logic on invoice data and record old vs new while also updating to the new user id
Import transactions updating the user id and invoice id with the old vs new


That is just a quick thought on what is involved without looking into it to in depth. I obviously did not reference all tables in my example as that is the one thing I'm not sure on based on a quick assessment. If the current other system importers do not require a fresh install a lot of the logic to handle conflicting ID's should already be there.

Of course you could always go to some other software use it's importer for coming from whmcs. Then in turn use whmcs importer to get the data into the system if it does not require a fresh install to do and can handle adding entries only.

A lot of work no matter how you dice this I suppose. Still probably easier coding a solution then keying it all in manually.

I think its pretty easy to make such an import script. Just need 2 whmcs test installation and one or two days. I had the same issue before, but I didn't make the import script because the second whmcs has only a few accounts and I moved them manually.

I'm fairly sure Matt has something to help with this, or may be able to offer advice at the least. Mainly it's making sure the ids don't conflict, but they are cross referenced in a few places, IIRC.

There's a bit more to it than just packaging accounts, you have to grab the packages associated with the accounts, the helpdesk entries with the accounts. It really is something that shouldn't take but a few hours to test and do smoothly though.