tsiedsma

I agree, an option would be great. It would also be nice to support running the importer to import staff and clients, then run it later to import packages / products / services. Then run it again and just import misc, or support tickets or whatever. Obviously some items require others to exist, you can't import invoices without clients and so on. I'd also like an option to not import clients that don't have active services or domains. Since you don't have an affiliate system, there is no reason for me to import users in my system that are no longer active or don't have any services.

Well i let the first import run overnight, nothing else was going on. The second one ran while I'm doing other tasks. Nothing resource intensive though so I dunno.

Results from latest import: importStaff ----------------- importStaff took: 0.8861 seconds ----------------- importClients ----------------- importClients took: 703.2672 seconds ----------------- importContacts ----------------- importContacts took: 5.5433 seconds ----------------- importTaxes ----------------- importTaxes took: 0.009 seconds ----------------- importCurrencies ----------------- importCurrencies took: 0.089 seconds ----------------- importInvoices ----------------- importInvoices took: 318.2752 seconds ----------------- decrypted 0 values using WHMCS' custom algorithm decrypt took: 0 seconds total time took: 1028.0708 seconds Array ( [last_name] => Array ( [empty] => Please enter a last name. ) )

running now...

There shouldn't be any price overrides for that product at all. Especially from $8.95 / month to $230.10 / month...

Ok, checked the tblpricing No results found. The WHMCS productid is 160 so I looked for that and got these results: SELECT * FROM `tblpricing` WHERE `type` = 'product' AND `relid` = '160'

Dude, I have no idea... gmp should be enabled, yes. It's in the php.ini. As for the pricing, I'll check the table, not sure what I'm looking for. As for your theory, want me to try it and tell you how it goes before you release a new importer? I may have the largest database of anyone here...

Here is my example of the pricing issues... There are several plans where Blesta has multiple prices for the one term even though only one is truly valid. Blesta: WHMCS:

Damn, still took forever. importStaff ----------------- importStaff took: 0.253 seconds ----------------- importClients ----------------- importClients took: 934.4394 seconds ----------------- importContacts ----------------- importContacts took: 2.1911 seconds ----------------- importTaxes ----------------- importTaxes took: 0.005 seconds ----------------- importCurrencies ----------------- importCurrencies took: 0.024 seconds ----------------- importInvoices ----------------- importInvoices took: 328.3218 seconds ----------------- importTransactions ----------------- importTransactions took: 31530.5644 seconds ----------------- importPackages ----------------- importPackages took: 7.1774 seconds ----------------- importServices ----------------- importServices took: 244.932 seconds ----------------- importSupportDepartments ----------------- importSupportDepartments took: 0.07 seconds ----------------- importSupportTickets ----------------- importSupportTickets took: 51.706 seconds ----------------- importMisc ----------------- mail log took: 3061.2902 seconds settings took: 0.659 seconds calendar events took: 0.001 seconds importMisc took: 3061.9542 seconds ----------------- decrypted 10522 values using WHMCS' custom algorithm decrypt took: 1.3451 seconds total time took: 36161.6394 seconds Array ( [last_name] => Array ( [empty] => Please enter a last name. ) )

Thanks for the link, interesting requirement. Works now.

Why can't I just connect to http://localhost/blesta ??? I'm trying to start a new trial to just do the import with my core i7 and SSD drive so I have no performance related issues.

Ugh, I can't even get that to work on XAMPP on Windows. Is there a way to find out what the problem is? I figured I would let my core i7 do the heavy lifting, then copy the database to the server to see how things look.

I'm gonna try it on my computer instead of my dev VPS. Any chance I can get a Dev license for Blesta without having an active license?

You're right, I did some digging and there is nothing in the blesta code that does any of the advanced stuff I saw in the SQL logs. Either way, the queries were definitely related to processing transactions which took a majority of the time. Since my WHMCS license is owned, I may keep it around as an archive. I can always modify the client area pages in Blesta to pull in data via the WHMCS API such as invoice history and stuff so I don't have to worry so much about importing historic data.

I am using the latest version of the importer, after I received that error I checked my whmcs database and couldn't find any missing first or last names. Not sure where the error came from but it happened twice. The other issue is the length of time the importer takes. Perhaps it's because of how WHMCS does things, maybe because of how you do things. I watched the queries running on the server and it appears that when you apply transactions there are temporary tables created and this takes a boatload of time. I have yet to see a complete import even with a seriously reduced WHMCS database.

Is there any update on the outstanding issues?

LOL, I love this. Your function that you hacked together to decrypt their data is faster than the one they use. That just proves how much better at this you are than them.

Have you benchmarked WHMCS decryption using the WHMCS decrypt function? Just curious if you found that their function was faster or slower than what you came up with. If you take the whmcs/includes/functions.php file, you can run the decrypt function. You'll need the $cc_encryption_hash variable defined before running the function as they appear to globalize that variable and use it in the function. I know this because it doesn't work without it in the script. <?php include('whmcs/includes/functions.php'); $cc_encryption_hash = '1234'; $password = decrypt($encryptedpassword); ?> Edit: You probably already know this and have even seen the source since a quick search on your favorite pastebin type site for anything WHMCS related returns lots of results for decoded files and functions...

On my smaller test database: Answered 5 Closed 4731 In Progress 1 My actual database has much much more. The test import showed all of them as Open.

In my testing, that isn't working.

I had a migration running for most of the day, it completed with an error "Please enter a last name". execution time: 26777.006063 seconds (7.43806 hours) LOL That was a full database import, it did get the packages but not the client packages. It also didn't get the support tickets this time.

True, there will always be those people with the attitude of "If you want my business, you will have to bend over backwards to earn it. But if you screw up, I'm out the door and onto the next". Anyone that's been in business long enough will tell you that those are not the customers you want which is why those people in this thread are not getting the attention they think they are entitled to.

I guess not everyone understands what Beta means. be·ta noun a version of a product (such as a computer program) that is almost finished and that is used for testing

As it stands, I cannot import my actual production database until this importer can be optimized to run in a shorter time window, or until it can be done in segments. It doesn't even get through all of the transaction processing before it dies. I have Apache, MySQL and PHP all set with timeout values of 18,000 seconds. That's 5 hours and should be more than enough time. This is a test server, so those values are ok for me but not everyone will be able to or want to make those changes on their servers. I can't be the only one with this large of a database, I have been using WHMCS for 5 or 6 years so thats alot of invoices, transactions, emails and clients.