Migrating from ModernBill 4.4

[jcncnc]

I'm getting ready to import my ModernBill data into WHMCS. But I've been reading some information on these forums from customers, who in 2010 brought up several issues that I'm concerned about. I wonder if anybody might have any knowledge, comments or thoughts on these.

 

Issue 1: http://forum.whmcs.com/showthread.php?32120-Issues-with-State-and-custom-import

 

In this forum a guy said that importing from ModernBill 4 caused problems when he didn't have a U.S. State listed for a particular client. I have several clients with no state because either they're not in the US, or they just didn't put their state in originally. Does anybody know if that is still a problem with the MB import script?

 

Issue 2:

 

Another guy in this same thread said he had problems when phone numbers didn't conform to US syntax. I have many international clients who don't have US phone numbers. And a few clients with no phone numbers. Just curious if anyone knows if this is still a problem with the import script or if it has been resolved?

 

Issue 3: http://forum.whmcs.com/showthread.php?30753-Importing-Data-and-Support-Queue

 

The guy here said that the import script gets messed up if you have a "quantity" of something. Like in several cases I'm billing somebody for maybe one reseller package but they have 5 domains, so I bill to them as 5 units of that particular web hosting product. Let's say this package is $7.00 per domain, so their monthly billing should be $35.00. This guy says though that when it's imported using the import script, that WHMCS will bill it only as $7.00. Apparently it doesn't recognize that the quantity is 5. It assumes all quantities are 1.

 

Issue 4: If you had created invoices in ModernBill for one-time charges, he says the import script changes the original date of ALL your one-time charges to 12/31/1969, and then it causes WHMCS to re-bill every single one-time charge - the first time you run it!

 

I'm hoping these have been fixed since it was two years ago that they were brought up. And it's critical that I know in advance as it will greatly change how I plan to proceed with the migration.

 

Any thoughts or information anyone might have would be greatly appreciated. Thanks!

[WHMCS Kim]

Hi Jcncnc,

 

I will paste here the answers given to you from our Developer Andrew for this query so anyone else with the same concerns can see the answers:

 

Issues 1&2:

 

http://forum.whmcs.com/showthread.php?32120-Issues-with-State-and-custom-import

Both of these issues were caused by custom coding that the user is completing, not the ModernBill Import Script. The script will import the client data as it is currently whether or not it conforms to how the data is normally entered in WHMCS.

 

Issue 3:

I have checked this for you and have been advised that the import script will loop through the quantities and add a product for each. So where you would see 1 product in MB, you would see 5 in WHMCS.

 

Issue 4:

One Time Invoices are imported as invoices. They will not be reinvoiced.

 

 

As with any import of any data, we advise you to run some test imports first to see how the data is imported and what may need to be checked. We provide data at http://docs.whmcs.com/Maintenance on how to reset your database so you can reimport as many times as you wish to.

When you have run the import script, you should always check the data imported. And if you have any issues, please let us know and we can take a look.

 

The import script does import all clients. It isn't possible to change this as it is transferring all your transaction records and data. You can if you wish, delete the clients you do not wish to be transferred once the data has been migrated.

 

On a side note, please do not forget to activate a payment gateway in your WHMCS before running the import script. It is listed in the import script instructions, but some users do not see this.

 

Unfortunately the modernbill database isn't standard across all installations as different users utilise different sections. And what one user does in MB, may not work the same way for another user.