thrustnet

Each time on a fresh install. That's why it seemed odd that it was saying a duplicate key. Unless WHMCS is really wacky. 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.

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?

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 ) )

I made those changes too - didn't work.

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.

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!

Yes - separate companies, just tired of two WHMCS installs so that would function perfectly! I'll send you a PM! 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!

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?