Merging multiple databases

[kmm2908]

We are just starting on creating a script to merge multiple WHMCS databases into one installation and I wanted to see if I could pick any brains that have already accomplished this.

 

Can anyone help with a list of fields that we need to check for duplicates?

 

Obvious ones being clientid, emails, contactid, invoiceid, invoiceitemsid, ordernum, ordersid, transid, refundid, adminid, affiliateid, domainsid, productids, domainpricingid, packageid, hostingid, hostingaddonid, addonid...

 

Any other tips or any code anyone wants to share would be gratefully received.

 

Thanks in advance for anyone that can help.

[Infopro]

Any other tips or any code anyone wants to share would be gratefully received.

Merge WHMCS data to another WHMCS - WHMCS Forums

[kmm2908]

Yep thanks for above. I should have said that I have already tried the merge script but it doesn't cover what we need to do.

 

We want to import new data from new company but also keep it separate within WHMCS. We intend to use Client groups and a coded invoice system to achieve this.

[Alex - Arvixe]

Yep thanks for above. I should have said that I have already tried the merge script but it doesn't cover what we need to do.

 

We want to import new data from new company but also keep it separate within WHMCS. We intend to use Client groups and a coded invoice system to achieve this.

 

Have you considered playing with the multi-brand mod by ModulesGarden? Might save you some development time/money and simply building an importer into the multibrand system: http://www.modulesgarden.com/products/whmcs/multibrand/features

[kmm2908]

Thanks for the suggestion Alex. I have been talking to them but not sure what they have will cover what we need. Also too many posts about poor support and the product not being the finished article yet motivated me to start our own coding.

 

Anybody used the module and have an experience to share?

[blakeh]

I too am interested in comments on the multibrand module. Buying 2 companies and will have 3 brands to keep separate, but don't want to use client groups and need branding separate.

[Alex - Arvixe]

I too am interested in comments on the multibrand module. Buying 2 companies and will have 3 brands to keep separate, but don't want to use client groups and need branding separate.

 

I have not used it but they do offer a free trial so you can evaluate it.

[kmm2908]

@blakeh the biggest problem I had with it after taking a look is they have no import facility. So if you buy a new company you still have to handle the import process, which is a major task. Hence the reason we have decided to create our own import script and multi-site setup.

 

In fact without a proven import process to handle possible duplicate emails and database table id's I can't see the point of it.

[Alex - Arvixe]

@blakeh the biggest problem I had with it after taking a look is they have no import facility. So if you buy a new company you still have to handle the import process, which is a major task. Hence the reason we have decided to create our own import script and multi-site setup.

 

In fact without a proven import process to handle possible duplicate emails and database table id's I can't see the point of it.

 

Did you discuss this with them? If I recall correctly, this is a feature they're working on and should have it included in the next update. Hopefully they can confirm that here.

[kmm2908]

I look forward to their update.

[blakeh]

I honestly can't see using the script, just because the company we're buying, the products are a mess and we need to audit everything anyway. So we would manually enter the clients, enter the services, as they map to ours. After that point the thing I'd like to auto-import would be account notes and invoice history. Account notes should be easy but past invoices, I'm betting not so much.