+ Reply to Thread
Results 1 to 14 of 14

Get data from website - connect to site database?

  1. 10-14-2011, 06:24 PM #1
    Roquete
    Roquete is offline
    Registered User
    Join Date
    12-06-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    17

    Exclamation Get data from website - connect to site database?

    Hello folks,

    I'm in need to obtain data from a website. The thing is that i need to open every link and copy a certain amout of data (variable) contained in the gray box and also to get a few more infos from the link

    http://www.reclameaqui.com.br/busca/...&x=12&y=18#966

    That's the "main page"

    http://www.reclameaqui.com.br/165026...a-de-respeito/

    That's an example : Basically i need the "green tittle", the gray data above (date information) and if possible the "Status da Reclamação" section.

    Any ideas how to do that?

    Thanks in advance
    Reply With QuoteRegister To Reply
  2. 10-15-2011, 01:14 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Get data from website - connect to site database?

    Hello Roquete,

    You should check the server and post the status. I have tried repeatedly to access this site and received a timeout message.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 10-16-2011, 04:58 PM #3
    Roquete
    Roquete is offline
    Registered User
    Join Date
    12-06-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Get data from website - connect to site database?

    Hey Leith,

    Weird, because here works fine.

    You can try as an alternative, to access www.reclameaqui.com.br

    In the search field, type "Banco do Brasil" and then click "Procurar".

    The result will be the "main page".

    And the links will be the examples i've mentioned above.

    Thanks
    Reply With QuoteRegister To Reply
  4. 10-27-2011, 01:58 PM #4
    Roquete
    Roquete is offline
    Registered User
    Join Date
    12-06-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Get data from website - connect to site database?

    Any hints?

    Thanks
    Reply With QuoteRegister To Reply
  5. 10-27-2011, 02:04 PM #5
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Get data from website - connect to site database?

    Hello Roquete,

    I am still getting a timeout error even with the alternate site.
    Reply With QuoteRegister To Reply
  6. 10-27-2011, 02:17 PM #6
    Roquete
    Roquete is offline
    Registered User
    Join Date
    12-06-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Get data from website - connect to site database?

    Wierd...

    Have you tried to google it? Everyone I send can access the website. I'm using both IE and Chrome.
    Reply With QuoteRegister To Reply
  7. 10-27-2011, 02:27 PM #7
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Get data from website - connect to site database?

    Hello Roquete,

    I can not reach the sites through Internet Explorer, FireFox, or Chrome. I have no problems with any other sites I type in, just yours. Google will bring up the site information but when I click the link it will not connect. Maybe some else here at the forum can try it out.
    Reply With QuoteRegister To Reply
  8. 10-27-2011, 02:49 PM #8
    Roquete
    Roquete is offline
    Registered User
    Join Date
    12-06-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Get data from website - connect to site database?

    Oh I see...I'll have to wait someone else then...hopefully they can access.

    It'll help me a lot...

    Thanks anyway for your time Leith!
    Reply With QuoteRegister To Reply
  9. 10-27-2011, 03:24 PM #9
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Get data from website - connect to site database?

    Hello Roquete,

    I have solicited help from the other moderators to try and access these sites. We will contact you with the results.
    Reply With QuoteRegister To Reply
  10. 10-27-2011, 03:49 PM #10
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Get data from website - connect to site database?

    Hi Leith,

    Hope the attachment helps. It seems that it might be a geographical issue.

    abousetta
    Attached Files Attached Files
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  11. 10-27-2011, 07:09 PM #11
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Get data from website - connect to site database?

    @ abousetta,

    I don't think "thank you" is adequate to express my thanks for all the work you did assembling this file. You definitely went above and beyond the call of duty.
    Reply With QuoteRegister To Reply
  12. 10-28-2011, 03:51 AM #12
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Get data from website - connect to site database?

    Leith, my effort is not even a drop in the bucket compared to the help you have provided me with in the past. I am glad that I was able to assist in whatever small way that I could.

    abousetta
    Reply With QuoteRegister To Reply
  13. 11-01-2011, 10:52 AM #13
    Roquete
    Roquete is offline
    Registered User
    Join Date
    12-06-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Get data from website - connect to site database?

    Leith,

    Could you find a possible solution for this?

    Thanks
    Reply With QuoteRegister To Reply
  14. 11-08-2011, 09:05 AM #14
    Roquete
    Roquete is offline
    Registered User
    Join Date
    12-06-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Get data from website - connect to site database?

    I'll bump to see if anyone can help.
    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1