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

Is There Any Tool That Can Do This?

Discussion in 'Black Hat SEO Tools' started by LOL-Blaster, May 25, 2013.

  1. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    So I have an csv file that looks like this:
    url1 kw1
    url2 kw2
    url3 kw3
    Is there a tool that can take the data and generate list of hyperlinks like this:

    <a href="url1">kw1</a>SPACE<a href="url1">kw2</a>SPACE<a href="url2">kw1</a>...

    For those who aren't aware, that's 3x3=9 combinations

    Can I do it with excel?
     
    Last edited: May 25, 2013
  2. acamso

    acamso Regular Member

    Joined:
    Sep 22, 2010
    Messages:
    231
    Likes Received:
    82
    Occupation:
    acamso.com
    Home Page:
    I don't know of a specific tool, but I can do this for you. Just send me a PM.
     
  3. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Thanks but I want to learn how to do it myself.
     
  4. SandraElam

    SandraElam Registered Member

    Joined:
    Jul 23, 2011
    Messages:
    95
    Likes Received:
    11
    Never heard of such tool.... I think you will have to do it manually...
     
  5. acamso

    acamso Regular Member

    Joined:
    Sep 22, 2010
    Messages:
    231
    Likes Received:
    82
    Occupation:
    acamso.com
    Home Page:
    Oh oops..I'm sure you can this in excel with functions.. but can't help you there. :(

    You can check out some excel function tutorials.. Im sure youll find a way.
     
  6. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,063
    Likes Received:
    2,872
    Gender:
    Male
    You can do it easily by PHP. I have coded this for you. You need to place your csv file in the same folder (named data.csv .. change it if necessary)
     
  7. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,015
    Likes Received:
    634
    Location:
    http://twitter.com/divok
    i think You are trying to mix keywords and urls
    You could do this in python yourself
    Code:
    urls = {r'http://xyz', r'http://xyz' , r'http://xyz'}
    keywords = {'key1','key2','key3','key4'}
    htmllist=[]
    for url in urls :
         for keyword in keywords :
                 ahref = r'[COLOR=#FFFFCC]<a href="[/COLOR]'+url+r'[COLOR=#FFFFCC]">'+keyword+r'[/COLOR][COLOR=#FFFFCC]</a>[/COLOR][COLOR=#FFFFCC]'[/COLOR]
                htmllist.append(ahref)
    
    
    there might be few bugs , just wrote it off my mind
     
  8. RedLable

    RedLable Regular Member

    Joined:
    Feb 16, 2011
    Messages:
    244
    Likes Received:
    32
  9. srb888

    srb888 Elite Member

    Joined:
    Jul 30, 2008
    Messages:
    3,260
    Likes Received:
    5,067
    Gender:
    Male
    Occupation:
    WebzSurfer
    Location:
    Sun, Mon, Tue, WTF, Sat!!! :)
    The Excel process can be semi-automated easily, but explaining it here to make it easy for you will take some time.

    So if you trust me, and allow to do it for you, you may send me the text file of your URLs and KWs, and I can complete the process and send you the entire Excel file. If so, PM me the download link of that file.... :)

    You may tell me only the exact number of URLs and KWs in the file too instead of giving me the data.... then you may replace placeholders with the required data at your end.
     
    Last edited: May 25, 2013
  10. FuryKyle

    FuryKyle Jr. VIP Jr. VIP Premium Member

    Joined:
    Nov 19, 2010
    Messages:
    2,397
    Likes Received:
    1,369
  11. nesterdwarf

    nesterdwarf Regular Member

    Joined:
    May 30, 2008
    Messages:
    276
    Likes Received:
    539
    Location:
    State of Misery...er, Missouri...
    Code:
    http://www.sendspace.com/file/6c5ncz
    
    Code:
    https://www.virustotal.com/en/file/d3a480670aeeea52c387e67f63bec38ba6d0c35b096aca93773a3ee1a29fe4f5/analysis/1369475716/
    
    Coded this up for you in WinAutomation. All you have to do is save your file out of Excel as a .csv, run 'lol-blaster.exe', select the exported .csv and it will output a text file in the same location with the data like you specified. I've included a sample .csv file to show you how it works, and the .waj file in case you want to load it up in WA and see what it does.

    HTH
    ND
     
    • Thanks Thanks x 1
  12. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Ah, that's not what I want. I need a bot to make 3x3 combination of the hyperlink
     
  13. astronaut23

    astronaut23 Junior Member

    Joined:
    Jan 2, 2012
    Messages:
    168
    Likes Received:
    47
    I'm not sure about this one, but TextMechanic.com has a lot of similar tools. I use them all the time. They have permutation generators, randomizers, text combiners etc. Check it out, maybe you'll find what you need.
     
    Last edited: May 25, 2013
  14. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Yes, but they limit the number of input to 20 lines.
    That's why I want to know how to do it by myself.
     
    Last edited: May 25, 2013
  15. Panther28

    Panther28 Elite Member

    Joined:
    May 2, 2010
    Messages:
    2,268
    Likes Received:
    3,405
    Occupation:
    Internet.
    Location:
    Internet.
    use =CONCATENATE
     
  16. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Not what I am looking for either. I need 3x3=9 combinations of the link.
     
  17. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Into 9 combinations?
    How?
     
  18. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,063
    Likes Received:
    2,872
    Gender:
    Male
    LOL sorry I also misunderstood your question! I have recoded the PHP script for generating combinations


    Code:
    <?php 
    //vars
    $filename = "data.csv"; // the file must stay in the same folder where the script is
    $folder = dirname(__FILE__);
    $data =  $array = $string = NULL;
    
    //function
    
    function array_cartesian() {
        $_ = func_get_args();
        if(count($_) == 0)
            return array(array());
        $a = array_shift($_);
        $c = call_user_func_array(__FUNCTION__, $_);
        $r = array();
        foreach($a as $v)
            foreach($c as $p)
                $r[] = array_merge(array($v), $p);
        return $r;
    }
    
    // read the file
    $fp = @fopen($folder."/".$filename, "r");
    if(empty($fp))
        throw new Exception("file could not be read");
    //read from csv
    while($data = fgetcsv($fp)){
        $array['url'][] = $data[0];
        $array['anchor'][] = $data[1];
    }
    
    $array_new = array_cartesian($array['url'] ,$array['anchor'] );
    //print_r($array_new);
    
    foreach($array_new as $new){
        $string .= "<a href=\"{$new[1]}\">{$new[0]}</a>  ";
    }
    
    
    // print result
    echo htmlentities($string);
    
    data.csv should be formatted as
    Code:
    name1,url1
    name2,url2
    name3,url3
    name4,url4
    name5,url5
    
     
    • Thanks Thanks x 3
  19. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Can you make it so that blank values are ignored?
    The number of urls does not always equal the number of keywords
     
  20. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,063
    Likes Received:
    2,872
    Gender:
    Male
    Code:
    <?php 
    //vars
    $filename = "data.csv"; // the file must stay in the same folder where the script is
    $folder = dirname(__FILE__);
    $data =  $array = $string = NULL;
    
    //function
    
    function array_cartesian() {
        $_ = func_get_args();
        if(count($_) == 0)
            return array(array());
        $a = array_shift($_);
        $c = call_user_func_array(__FUNCTION__, $_);
        $r = array();
        foreach($a as $v)
            foreach($c as $p)
                $r[] = array_merge(array($v), $p);
        return $r;
    }
    
    // read the file
    $fp = @fopen($folder."/".$filename, "r");
    if(empty($fp))
        throw new Exception("file could not be read");
    //read from csv
    while($data = fgetcsv($fp)){
        $array['url'][] = $data[0];
        $array['anchor'][] = $data[1];
    }
    
    $array_new = array_cartesian($array['url'] ,$array['anchor'] );
    //print_r($array_new);
    
    foreach($array_new as $new){
        $n0 = trim($new[1]);
        $n1 = trim($new[0]);
        if(!empty($n0) && !empty($n1) )
        $string .= "<a href=\"{$new[1]}\">{$new[0]}</a>  ";
    }
    
    
    // print result
    echo htmlentities($string);
    
     
    • Thanks Thanks x 2