Importing AWBS

[4uh]

Just wanted to provide some info while I'm testing the importing of data from AWBS to WHMCS.

 

The first problem I came up against was that invoices with a status VOID were still imported into WHMCS and seen as overdue. We have 1800, so manually deleting these after the import is not an option

 

In phpmyadmin on the AWBS database I have run the following query

 

SELECT *

FROM client_invoices

WHERE STATUS = '3'

 

This lists all the voided inoices. I then selected them all and deleted them from the database. You can also use DELETE FROM but I wanted to see them first.

 

I know that I will have a number of other cleanup queries to do before I import the data again so when I've worked out what to do I'll add the info here.

 

The WHMCS guys might want to consider changing the import script to not include the voided invoices.

[Matt]

Thanks for the report. I'll get this added into the importer - can you confirm if it's just a status of "0" that is unpaid, "1" for paid, and everything else cancelled?

 

Thanks,

Matt

[4uh]

Hi Matt,

 

I can confirm that 0 is unpaid, 1 is paid 3 is voided and 4 is refunded.

 

Regards,

 

Chris

[impactgc]

Has the script been updated?

 

Thanks,

Adam

[Matt]

It has, but you'll need to open a ticket to request it until it gets updated on the site.

 

matt