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.