Import clients from another WHMCS install?

[suhailc]

Hi,

 

I wanted to know if there are any import script for pulling in client data from one WHMCS install to another?

 

Regards,

Suhail.

[DataHosts]

You should be able to export the tblclients table and import into the new system. However, this will mess up your orders because each order has the ID tied to the client as well. Are you wanting to import just clients, or all data?

[suhailc]

Yeah it would have been all client data, so client profiles plus invoice data.

[DataHosts]

All you would need to do is export all data from the 1 DB and import into the other. The configuration would need to be changed, but license info is done via script and not DB

[suhailc]

Sure, but what if I have an existing WHMCS setup with clients, and I want to import only client data/invoices from another WHCMS install on another domain so I can consolidate all clients under one WHMCS install?

[Matt]

There is no way of merging two databases at the current time. An import script could be written for this but I've only ever seen two requests for doing this which means it isn't very worthwhile creating one unless someone were to contract me to make one.

 

Matt