1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

what's the best way to make this script

Discussion in 'Black Hat SEO Tools' started by browndog, Jun 2, 2013.

  1. browndog

    browndog Newbie

    Joined:
    Feb 9, 2013
    Messages:
    47
    Likes Received:
    4
    Hey guys, Hopefully someone can tell me the best way to make this script.

    I have several excel files with about 500-600 entries. I have to copy and paste each entry into a website and it pulls up a report. Then I have to copy a line from the report into another website which gives me the info I really need.

    I want to create a script that has keyboard hot keys. So if I'm on the excel file and hit "z" it will copy the box I'm on and paste it into the search box on the designated website. Then when the search is complete I would hit "x" and it would copy the line of text I need and paste it into the other website that will be open in another browser window.

    How hard would something like this be to make? And What language would you recommend?

    thanks
     
  2. Sam Woods

    Sam Woods Junior Member

    Joined:
    Mar 5, 2013
    Messages:
    132
    Likes Received:
    32
    You could make it in PHP/Python and run it off localhost, so you wouldn't even need to hot-key it and it would do everything for you.
     
    • Thanks Thanks x 1
  3. browndog

    browndog Newbie

    Joined:
    Feb 9, 2013
    Messages:
    47
    Likes Received:
    4
    I don't think I can automate it fully. I would be doing the work for a company and the websites I have to use are subscription based. Their policies state that no automation software can be used. I'm thinking that a hot key script would save me a ton of time and still allow me to stay within the ballpark of their policies.
     
  4. browndog

    browndog Newbie

    Joined:
    Feb 9, 2013
    Messages:
    47
    Likes Received:
    4
    Also, I might end up just paying someone to do this for me. If I went that route, would someone be able to complete this without me giving them my login details? Like I said, the site it subscription based, so there is no way to get into it without logging in. Would I be able to just scrape the html code from the site and have them design the script to paste the text in the appropriate area? Hopefully I explained that well enough to make sense.
     
  5. CeMPUTER

    CeMPUTER Registered Member

    Joined:
    Sep 2, 2011
    Messages:
    88
    Likes Received:
    23
    Hmm I would do it in python - but in your case I recommend you to use a normal Macro program ... did not used one for ages so I can not recommend you a good one. But with a good macro program your hotkey solution should be no problem :)
     
  6. Rambaldi

    Rambaldi Registered Member

    Joined:
    Nov 30, 2009
    Messages:
    81
    Likes Received:
    11
    Occupation:
    Programmer
    Location:
    Sweden
    Save the excel document to CSV, it is much easier to work with in script.