Fix Validate_Tax_Numbers program

The program stopped working and needs to be fixed. It's giving wrong results.

This is what was posted last time.

This project has 2 parts:

1. VALIDATION OF GST/HST REGISTRY NUMBER

2. VALIDATION OF A QST REGISTRATION NUMBER

VALIDATION OF GST/HST REGISTRY NUMBER:

I need a software which will take the Excel file as input with a list of code numbers, names and dates. The software will output the same file with an additional 4th column which would be populated based on the website search result.

Site: [login to view URL]

Click on “I AGREE”  This will forward to a new GST/HST REGISTRY SEARCH page

Here, you will take the input file and search one row at a time and populate the 4th column based on the search result. The options I have seen are:

• RESULT: GST/HST number registered on this transaction date.

• RESULT: Insufficient information entered.

Note: In control panel, under Region, my Short date format is: M/dd/yy - you HAVE TO set the same to make the date format work.

Please refer to the sample files and results to make sure you understand before starting

** This is the first milestone

VALIDATION OF A QST REGISTRATION NUMBER:

It’s similar to GST/HST Registry but different list and website.

This second software will take an Excel file as Input with a list of code numbers and names. The software will output the same file with 5 additional columns which would be populated based on the website search result.

Site:

[login to view URL]

(in the example link, the 1219432212TQ0001 number at the end is what you will get from the Excel file)

Here, you will input file and search one row at a time and populate result columns.

Column 3 (Heading FOUND): FOUND / NOT FOUND (whether it’s found or not)

Column 4 (Heading STATUS): VALID, INACTIVE OR NON-EXISTANT (based on the search result)

Column 5 (EFFECTIVE DATE) : Effective date of status (based on the search result)

Column 6 (Business Name): Business name (based on the search result) - This is labelled "Business's name" on the website

Column 7 (Firm Name): Firm name (This is labelled "Business name" on the website)

For example, number "1219432212" has "8241899 CANADA INC" as business name and "PRECIVAL" as Firm Name.

Please refer to the sample files and results to make sure you understand before starting

** This is the second and final milestone

PHP JavaScript Software Architecture C# Programming HTML

Project ID: #32137987

About the project