Importing WHMCS into WHMCS?

[platinumn23]

There should be a script or some easy way to import WHMCS B into WHMCS A.

 

For instance, we just bought a company whom uses WHMCS. Now, I want to import that billing db into my current one so we have everyone in there together.

 

Is there any easy way to do this?

 

Thanks,

Robert

[Matt]

Hi Robert,

 

There is no automated script for doing that at the current time.

 

Matt

[platinumn23]

Any chances of making one? or having one made?

 

WHMCS is very popular and buying a host whom uses it is growing as well.

 

I would guess we need Clients, Packages, Invoices, and Domains (if any) to be able to get migrated over..

[Tech Entrance]

I think you can get someone to custom code this as a module.

[ask21900]

WHMCS uses sql to hold it's data. Why not just create a simple php script to pull the info table by table from one DB, and insert into the other?

 

ie (not valid code, but you get the idea):

 

For Each Table in DB1 Select * from Table

$ThisRow=Result

Connect to DB2

Insert into Table ($ThisRow)

 

 

Shouldn't take but an episode of your favorite show to code and implement...

 

For that matter, you could just export to file, and import using any of the free utils out there.

[PPH]

WHMCS uses sql to hold it's data. Why not just create a simple php script to pull the info table by table from one DB, and insert into the other?

 

ie (not valid code, but you get the idea):

 

For Each Table in DB1 Select * from Table

$ThisRow=Result

Connect to DB2

Insert into Table ($ThisRow)

 

 

Shouldn't take but an episode of your favorite show to code and implement...

 

For that matter, you could just export to file, and import using any of the free utils out there.

And this solution would renumber invoices and/or client ids appropriately with the conflicts between the too?

[othellotech]

It can be done with some php/MySQL, getting the domainid, and userid right takes a bit of thinking and pre-planning.

[platinumn23]

I can't believe noone else has ran into this issue before.. or atleast, they aren't willing to share..

 

I would imagine, since Matt would know the script the best, and is noticing more and more people using it that he would write an import script going from one to another.

 

I guess on the same note, the import of one whmcs to another whmcs is a possible 'loss' as someone looses a license customer.

[brianoz]

WHMCS themselves might be prepared to do it as a custom import if you ask; I don't see why not. Ask and let us know what the result is ...

[ask21900]

I hadn't thought of the numbering conflict. (I wrote that in the middle of the night). It might be easier to get someone to code a custom mod, if you don't want to go through the trouble. Sounds like an interesting project though. I only wish I had the time.

 

If anybody is interested, my 2 cents... I haven't got around to looking at the DB yet, but 20 years of coding leads me to believe that this is as any other relational DB: The tables are based on an index, most likely numerical. Therefore, I would proceed as follows:

 

In DB1 Select * from clients

$ClientOffset = mysql_numofrows(result)

For Each table in DB2 For each row in table ClientID = ClientID + ClientOffset

 

Repeat procedure for each index (invoiceID, PaymentID, etc)

 

 

Hopefully that can give someone a starting point.

[PPH]

Well as I noticed in Matt's earlier post "at the present time" which I would assume means he is either considering it or it is already in the works

 

I agree that it would be useful for any company acquiring another that is running WHMCS or one that uses it for 2 that may be joined into one at some point.