Latest Inquiries - Data Extraction Software

Canadian companies

Submitted: 5/31/2013

I want to extract in a excel file the following data:

Company Name

Mailng Address

Contact Name

Contact Title

Contact email

Contact Telephone

 

As you can see in the Target website, at the end, there is a link called "Next Company", tis s to get to the following company of the search result page

Replied: 6/4/2013 6:02:58 PM
Please check the attached demo project.
Ic.rip

Replied: 5/31/2013 7:56:36 PM
I've opened the target URL you gave, but the website show me Server Error,

can you please first verify this?
Replied: 6/3/2013 4:10:20 AM
Can you please try the below link?  Thanks

Replied: 6/3/2013 5:30:59 PM
Same error.

Thought you can tell me how did you fetch this URL, are you doing an query from a form submitting on this website?
Replied: 6/4/2013 4:31:08 AM

Here’s how you can get the results I get:

 

1.       Go to: http://www.ic.gc.ca/app/ccc/srch/bscSrch.do?lang=eng&profileId=&prtl=1&searchCriteriaBean.hitsPerPage=10&searchPage=%252Fapp%252Fccc%252Fsrch%252FcccBscSrch.do%253Flang%253Deng%2526amp%253Bprtl%253D1%2526amp%253Btagid%253D&V_SEARCH.scopeCategory=CCC.Root&V_SEARCH.depth=1&V_SEARCH.showStricts=false&searchCriteriaBean.sortSpec=title+asc&searchCriteriaBean.textField=&searchCriteriaBean.conceptOperator=and&searchCriteriaBean.column=&detailedSrchBtn=Go+to+Detailed+Search

2.       Please fill in the following fields and then click on Search:

a)      NAICS Code: 11, 22, 23, 31, 32, 33, 44, 45, 48, 49, 51, 52, 54

b)      Number of Employees: choose all from 101 to 1001+ (use Ctrl click for multiple items selection)

c)       Total Sales: choose from 1,000,000 to 50,000,000 (use Ctrl click for multiple items selection)

d)      Hits per Page (at the end of the page): 25

 

3.       Once you have clicked on Search you will get a result page where you will need to click on [custom profile] of the first record which will send you to a field page where you can select the needed fields. Please select the following fields only:

a)      At the Company Information section:

·         Mailing Address

b)      At the Contact Information section:

·         Name

·         Title

·         Telephone

·         Email

At the end of the page, click on Continue. The result page will be the first record of the overall search result.  It has a [Next Company] link to advance to the next record. So this result is the link I’ve been sending to you guys. It looks like that there is a time-out.

 

So what I would like to get is all records with all listed contacts:

 

Company-A        Address   Contact-Name-1           Title-1   Telephone-1      email-1

Company-A        Address   Contact-Name-2           Title-2   Telephone-2      email-2

Company-A        Address   Contact-Name-3           Title-3   Telephone-3      email-3

 

Company-B        Address   Contact-Name-1           Title-1   Telephone-1      email-1

Company-B        Address   Contact-Name-2           Title-2   Telephone-2      email-2

Company-B        Address   Contact-Name-3           Title-3   Telephone-3      email-3

 

Thank you