Two WHMCS -> One Blesta

[thrustnet]

I've been a long-time-watcher of Blesta, recently with the hiccups of WHMCS ('Native' Stripe Plugin prevented billing because "old data" was in place)  I'm more than ever ready to explore other options and Blesta has always been on my radar, but I have two questions.

Number one would be, I have one WHMCS install in 6.x and another in 7, is it possible to import two installs into one? I'd love to have a single install with the two options so I can maintain everything in one spot.

The second is will my current Stripe configurations migrate over as well?

[Michael]

Just to add to Paul, I believe you could use the WHMCS -> WHMCS importer on their end and then import over to Blesta.

[Paul]

4 hours ago, thrustnet said:

I've been a long-time-watcher of Blesta, recently with the hiccups of WHMCS ('Native' Stripe Plugin prevented billing because "old data" was in place)  I'm more than ever ready to explore other options and Blesta has always been on my radar, but I have two questions.

Number one would be, I have one WHMCS install in 6.x and another in 7, is it possible to import two installs into one? I'd love to have a single install with the two options so I can maintain everything in one spot.

The second is will my current Stripe configurations migrate over as well?

Welcome! I'm not sure if you'd be able to import 2 -> 1, unless you import them as separate companies within Blesta. If you'd like to give it a try, PM me your trial key (Settings > System > General > License Key) and I'll add an addon company to your trial.

If they are in separate companies, they'd be in the same install, and you can switch back and forth between companies to manage without having to log into a different location.

Re: Stripe, probably not, I believe they just released that. Give it a spin. It may be something that you would need to migrate manually. Blesta uses "Payment Accounts" for CC and ACH, so depending how they store it it may be imported, but may need some finessing to get working.

I'd say, give it a spin, and we'll help with any questions or issues that arise. https://docs.blesta.com/display/user/Migrating+to+Blesta (Shows WHMCS 5.x, but has been known to work with 6, not 100% sure re v7)

[thrustnet]

4 hours ago, Paul said:

Welcome! I'm not sure if you'd be able to import 2 -> 1, unless you import them as separate companies within Blesta. If you'd like to give it a try, PM me your trial key (Settings > System > General > License Key) and I'll add an addon company to your trial.

1

Yes - separate companies, just tired of two WHMCS installs so that would function perfectly! I'll send you a PM!

4 hours ago, Paul said:

If they are in separate companies, they'd be in the same install, and you can switch back and forth between companies to manage without having to log into a different location.

Re: Stripe, probably not, I believe they just released that. Give it a spin. It may be something that you would need to migrate manually. Blesta uses "Payment Accounts" for CC and ACH, so depending how they store it it may be imported, but may need some finessing to get working.

I'd say, give it a spin, and we'll help with any questions or issues that arise. https://docs.blesta.com/display/user/Migrating+to+Blesta (Shows WHMCS 5.x, but has been known to work with 6, not 100% sure re v7)

 

 

I was actually using a 3rd party plugin originally, the big switch to 7 actually has caused me more trouble than saved me lol - I have a gatewayid in the DB for the stripe ID (cus_ format) - Each will have this general format the big issue is WHMCS's module is picky and if it detects old data in the card BLOB data it won't process properly. 

I'm coming off a long night (oh heck a long year) I'll get some sleep under my belt and give it a whirl tomorrow. Thanks for the reply! Much appreciated! 

[thrustnet]

31 minutes ago, Licensecart said:

Just to add to Paul, I believe you could use the WHMCS -> WHMCS importer on their end and then import over to Blesta.

Honestly I considered that originally when considering just consolidating billing, but how Blesta handles having multipul companies, very handy indeed - let's me manage my non-profits and such which are free in a seperate system vs. mucking up everything in one. Appreciate the thought!

[Michael]

10 minutes ago, thrustnet said:

Honestly I considered that originally when considering just consolidating billing, but how Blesta handles having multipul companies, very handy indeed - let's me manage my non-profits and such which are free in a seperate system vs. mucking up everything in one. Appreciate the thought!

The multi-company Paul mentioned would be awesome for you, non-profits on one side and the main one on the other:

http://videos.blesta.com/video/65308950

[JNdev]

Maybe you can try merge 2 separate installs into 1 whmcs

  https://forum.whmcs.com/showthread.php?35663-WHMCS-to-WHMCS-(Merge)-two-companies

 

So moving to blesta not hard

[Blesta Addons]

you can import the two whmcs to blesta as i think ,
the first import should be run completely , the second import should exclude the company settings.

before we have imported blesta twice without any issue .

 

[thrustnet]

Here's where things stand for me - I tried pulling in the WHMCS 7 install first and it imported just no invoices, no cc, no history really of any kind - so I figure my still 6.x build would be easier, it throws this error:

http://cloud.thrustnet.com/0o1i3A0V093R

Nothing comes in, so really not sure where the hiccup is any ideas/suggestions? I've followed the instructions just seems that something about my install isn't playing nice.

[Michael]

12 minutes ago, thrustnet said:

Here's where things stand for me - I tried pulling in the WHMCS 7 install first and it imported just no invoices, no cc, no history really of any kind - so I figure my still 6.x build would be easier, it throws this error:

http://cloud.thrustnet.com/0o1i3A0V093R

Nothing comes in, so really not sure where the hiccup is any ideas/suggestions? I've followed the instructions just seems that something about my install isn't playing nice.

Try following: http://whmcsrefugees.com mate.

[thrustnet]

9 minutes ago, Licensecart said:

Try following: http://whmcsrefugees.com mate.

I made those changes too - didn't work. 

[Michael]

9 minutes ago, thrustnet said:

I made those changes too - didn't work. 

try importing with debugging on print.

[thrustnet]

Same as the displayed error:

 

importStaff
-----------------
importStaff took: 0.0079 seconds
-----------------

importClients
-----------------
importContacts
-----------------
importTaxes
-----------------
importCurrencies
-----------------
importInvoices
-----------------
importTransactions
-----------------
importPackages
-----------------
importPackageOptions
-----------------
importServices
-----------------
importSupportDepartments
-----------------
importSupportTickets
-----------------
importMisc
-----------------
decrypted 0 values using WHMCS' custom algorithm
decrypt took: 0 seconds
total time took: 0.4078 seconds
Array
(
    [error] => Array
        (
            [0] => The import completed but the following errors ocurred:
            [1] => importClients: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '90' for key 'PRIMARY' on line 124
            [2] => importContacts: There is already an active transaction on line 163
            [3] => importTaxes: There is already an active transaction on line 163
            [4] => importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124
            [5] => importInvoices: There is already an active transaction on line 163
            [6] => importTransactions: There is already an active transaction on line 163
            [7] => importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124
            [8] => importPackageOptions: There is already an active transaction on line 163
            [9] => importServices: There is already an active transaction on line 163
            [10] => importSupportDepartments: There is already an active transaction on line 163
            [11] => importSupportTickets: There is already an active transaction on line 163
            [12] => importMisc: There is already an active transaction on line 163
        )

)

 

[thrustnet]

I've been fiddling with the import function off and on today, what's odd is my WHMCS 7 install will import in with no history, however, my 6.3 company won't even give me the time of day  Is there anything that would stop me from doing a conversion into the raw Blesta database? Are there routines I'd need to know to import the data or can I just do it raw?

[Paul]

When you attempt another import, and you doing it on a restored/fresh Blesta database? You won't be able to re-attempt an import if it fails. I ask because of duplicate key errors, though it may be unrelated.

You could import data manually, any relationships between tables should be pretty obvious but if you have any questions let us know!

[thrustnet]

8 hours ago, Paul said:

When you attempt another import, and you doing it on a restored/fresh Blesta database? You won't be able to re-attempt an import if it fails. I ask because of duplicate key errors, though it may be unrelated.

 

Each time on a fresh install. That's why it seemed odd that it was saying a duplicate key. Unless WHMCS is really wacky.

8 hours ago, Paul said:

You could import data manually, any relationships between tables should be pretty obvious but if you have any questions let us know!

I'll see if I can find the time to give it a whirl, just was hoping for something sadly a bit more easier and less time consuming, just been a busy start to a new year after a rough 2016, trying to dive into 2017 with something better - at this point even considering blesta as a new front for new sign-ups and slowly migrated legacy accounts over if I can write a tool to import a single account properly, just work with customers on a slow migration throughout the year to finally phase out WHMCS by  mid-year, we shall see how it goes.

[Paul]

9 hours ago, thrustnet said:

Each time on a fresh install. That's why it seemed odd that it was saying a duplicate key. Unless WHMCS is really wacky.

WHMCS doesn't do much in the way of enforcing data integrity, so the issue is likely to do with that. Blesta expects data where it doesn't exist, or there is data in WHMCS that should be unique that isn't. Works great for some, and not for others. 

 

9 hours ago, thrustnet said:

I'll see if I can find the time to give it a whirl, just was hoping for something sadly a bit more easier and less time consuming, just been a busy start to a new year after a rough 2016, trying to dive into 2017 with something better - at this point even considering blesta as a new front for new sign-ups and slowly migrated legacy accounts over if I can write a tool to import a single account properly, just work with customers on a slow migration throughout the year to finally phase out WHMCS by  mid-year, we shall see how it goes.

New sign ups, and migrating accounts later could work if there's not too many. You could look to see what client has a key of 90 in Blesta after the import, and determine which client it was trying to import next, and compare with your WHMCS database. It's possible if you remove that client the import may get further or complete.