Rendrag

Just to reply to my own thread, incase anyone else wants to do this, we ended up just adding a new API call into our WHMCS install. See http://thewanderingsysadmin.net/?p=35 if you want info on extending the WHMCS API Cheers, Damien

It's not that it's only recording transactions which are paid in realtime via paypal/creditcard is it, and not showing the cheque/bank transfer ones? Just setting this up on our WHMCS now, don't suppose you have a list of goal URL's you'd care to share? Regards, Damien

Hi Folks, Is there a way to have Extra Bandwidth packs for customers as Addons or Configurable options, to add onto the bandwidth allowed in their plan? i.e. a Customer wants a particular level of Cpanel hosting, but needs an extra 100GB, they just add on a 100GB Bandwidth pack? I know I can create the addon, but I'd like it all automatic. We use soft limits in Cpanel/Plesk, and then let WHMCS bill the overage, so hoping I can just have WHMCS go 'Oh, they have 100GB quota and have purchased another 200GB, so we'll let them use 300GB before we charge them overages' Is that possible? Would also like to do that with SolusVM, but I'm guessing I should be posting on their forums as it's their own module? Thanks, Damien

Hi Folks, We talk to our WHMCS via API from our customer portal - customers don't actually ever see WHMCS, we just use it on the backend as it handles billing SO well. We're in the process of rebuilding the customer portal as it's getting a little too patched together and hard to maintain. One of the issues on my list is that we're generating PDF's separately to WHMCS so when we change something we have to change it in both WHMCS and the portal. Has anyone worked out a way to pull invoice PDF's from WHMCS? If I *really* have to, I can create an admin user, then use curl calls to login as them and pull them that way, but that seems a bit icky... Is there a way we can call the invoicing even from a local PHP script on the WHMCS server? We need to be able to pull a few other things (like list of domain questions), so I'm thinking we're going to have to write our own little json api that sits beside the WHMCS api anyway.. Thanks, Damien

Yep that was it. That's painful, that was 8 hours of emails going out like that Is there a not-horrendous way of re-sending all of those emails?

Thanks John, that answers a different question I had also Thanks for your help!

Hi Folks, We had a failed merge from another hosting provider who we bought out, over the weekend. Turned out we tried to import from a 2-year old copy of their database, did not go well at all (Can we get some error checking added to the merge functionality? Or even if you don't have time, can we get a non-encrypted copy of the merge script, and we'll add that for you? (Happy to sign an NDA if you like - we have at a few more of these to do this year, with > 1500 customers on each, so the boss has ok'd spending some time making the merge process more robust!) Anyway, I got that cleaned up, and re-imported from the correct database, and everything is going nicely now. Only issue is, that while cleaning up, I discovered a weird anomaly, which I'm not sure is by design, or just something has gone hinky over the years. select count(*) from tblinvoiceitems where not exists (select id from tblinvoices where id=tblinvoiceitems.invoiceid); # count(*) '2760' There's 2760 rows in tblinvoiceitems, with an invoiceid which does not exist in the tblinvoices table. Is that a data error (aka should I be deleting those rows), or is it by design (are they billable items awaiting invoicing or something?). The id's of the invoiceitems are pretty consistently spread from the start of our WHMCS installation up to present day As we pull data from these tables into our customer portal, I'd really like get a definitive answer on what these rows are for, if anything Thanks, Damien

Ok, so to answer my own question, it's fairly simple.. a) Go to cpanel server, and go to Transfer, and 'Copy an Account From Another Server'. Put in all the appropriate details, and let it run. It can take a while if there's a lot of files, mail, etc. b) Go into WHMCS, and terminate hosting. This removes it from the Plesk server. c) Still on the product page in WHMCS, change the package to be a cpanel package, then change the server to match the cpanel server you moved to, change status from Terminated to Active, and save d) click Change Package, to apply your chosen package to cpanel. Done! Note: if you're not using any funky DNS glue to put your cpanel/plesk servers behind other servers, you'll obviously need to have dropped your TTL prior to a), and done a redelegate prior to B.

Hi Folks, We've been finding cpanel a lot faster on identical hardware, compared to Plesk, so are moving some of our larger customers over to cpanel. I'm wondering if there's a tried and true method for how to move these while keeping WHMCS happy? I know we can login to cpanel, point it at plesk, and suck the clients across - but then we have WHMCS still thinking the clients are on the Plesk server? Is it just as simple as going into each client's package, changing the product from a Plesk product to a cpanel product, and selecting the new server? I don't suppose someone has written down a step by step howto for this? Thanks Damien

G'day Indexmain, Thanks for that, it looks like it worked. Well, did, until today when the client called to ask why I hadn't been replying to their emails! Seems that WHMCS hasn't sent email replies to their tickets since I made the change! Figured it out - if you have a blank password in the Master account, it doesn't send tickets responses to anyone! Thought I'd just post that here, incase someone sees this and tries leaving the master account email address blank

AHA! Thank,you that would be it

Hi Folks, Bit of a strange one which I can't figure out.. I have one client, who keeps seeing = signs all throughout the emails he receives from our WHMCS system. He tells me that he's on Outlook, which has me confused, as I've never seen them, and I'm also using outlook on one of my PC's. For example, one of the emails he received looks like this: Has anyone come across this? Thanks, Damien

Hi Folks, A customer just asked where they should put their EPP code to transfer their domain to us when putting in a new order. I thought they were a bit loony, so I went through the order process myself. And indeed, it never asks for the EPP Code! Would I have missed something in setup somewhere? I do generally have to go in manually and select the registrar to be used for *new* orders, before it will process so would this be related? Thanks, Damien

Hi Folks, Just wondering if it's possible to NOT send replies to all support tickets to the master contact for an account, if the ticket was raised by a contact? I have a client where one user is supposed to get invoices, and two other users are supposed to raise support tickets. The accounts person doesn't want to see support tickets, and the support people don't want to see invoices.. Any suggestions? Thanks, Damo

I had a client call today, saying they'd gone through the process to reset their password and no new password had arrived. Figured it was a case of thrombosis, so put through my own test. Sure enough, the initial reset email with the reset link arrived. I clicked on that, and it said reset successful. However that second email (subject of 'our password has been reset for X') never arrived. Now I actually have a supplier in Ireland who use WHMCS also, who has this exact same problem - I've been asking them about it for ages, and they assure me it's my mailserver. Now I'm thinking it's actually a WHMCS issue. Before I ask support about it, I figured I'd check here, to see if it's a common problem, and if so, what the fix is? Thanks, Damien