We currently use H-Sphere to handle all of our billing but are switching over to modernbill. We need our hsphere database copied into modernbill to include:
All Client billing data (clients billing due date should also be the same as in hsphere.
All client previous history (clients should still be able to pull up there old billing invoices.
The H-sphere database is a postgresSQL database and the modernbill database is a mySQL database with encryption. I can provide all the encryption details later but a simple script to read info out of hsphere and insert into modernbill should suffice. The big Key though is that it can do everything at one time because once modernbill has all the information and is running the billing we will have to tell our hsphere to stop running bills. We will leave the customer info in hsphere until we determine at a later date that it is no longer needed and that modernbill is running fine.
We currently have about 850 customers in hsphere, about 50 of them are resellers clients that do not need to be transferred into modernbill, only the reseller himself would need to be moved over.
One other note. The databases are on2 different physical servers so I would recommend exporting the hsphere database to an xml file (hsphere website has instructions on how to do this, then importing the results into modernbill. I also believe that hsphere provides a modernbill to hsphere import tool so you might be able to use that and reverse engineer it.
## Deliverables
1. Your script must NOT write to the hsphere database at all, only read its data.
2. Once you are ready to perform the process we will do so at an agreed upon time as once the transfer is completed i will have to tell hsphere to stop the billing process and let modernbill take over.
3. The job will be considered complete once I have verified modernbill is running sufficiently on its own and is handling all the billing with no problems. Please note that this might be a few days after the job has been completed.
## Platform
linux, mysql, postgressql