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 may need to set the same to make the date format work.
** 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]
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.
** This is the second and final milestone
hello sir,
I have already done this project but modification needs. This is a bit tricky. So needs a bit more effort. I hope you will get required results with more satisfaction.
$55 CAD in 3 days
5.0 (2 reviews)
1.6
1.6
2 freelancers are bidding on average $38 CAD for this job
Interesting task.
I am a Professional developer with experience in Text Mining. My specialization is:
1) Scraping Data from Web
2) Cleaning/ Manipulating the Data
3) Analysis and Visualization
4) Integration with applications such as Web or Mobile
You project involves multiple skill sets, all of which I am good at. I will deliver the product in the form of a local web service or a script, your choice. Message me for discussion.
Payment is not an issue for me.