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

Scrapebox csv

Discussion in 'Black Hat SEO Tools' started by ronegraT, Jan 4, 2013.

  1. ronegraT

    ronegraT Power Member

    Joined:
    Dec 29, 2010
    Messages:
    620
    Likes Received:
    101
    Occupation:
    sleeping
    Location:
    Sweden
    Why is it possible to save results in scrapebox as csv or excel files but not to import.

    I have a couple of csv files i would like to import in scrapebox, is it copy and paste? or should i rename the file to .txt?
     
  2. scrapefox

    scrapefox Power Member

    Joined:
    Dec 3, 2011
    Messages:
    692
    Likes Received:
    277
    Why do you need to import the csv? Generally you're only going to be wanting the one column from them, so just open it up in excel (or whatever program you prefer) and copy and paste that column.

    I might be missing something, but I can't see any major reason you'd need to import a csv.
     
    • Thanks Thanks x 1
  3. GiorgioB

    GiorgioB Supreme Member

    Joined:
    Feb 28, 2012
    Messages:
    1,288
    Likes Received:
    1,318
    Occupation:
    Making money
    Location:
    Touching the Sky
    save your excel as a .txt file
     
    • Thanks Thanks x 1
  4. ronegraT

    ronegraT Power Member

    Joined:
    Dec 29, 2010
    Messages:
    620
    Likes Received:
    101
    Occupation:
    sleeping
    Location:
    Sweden
    To do pr checks, se if sites stile are live and such, or is there any other program that works whit csv files?
     
  5. scrapefox

    scrapefox Power Member

    Joined:
    Dec 3, 2011
    Messages:
    692
    Likes Received:
    277
    If you're re-checking the PR, you probably don't need the original PR column.

    If do still want to convert your CSV to the correct text format. Just open it up in Notepad++ and do the following replaces:

    "," replace with |

    then

    " replace with nothing

    That'll give you the format url|pr which is what scapebox uses if you export as a text. Save the file with the .txt extension and you're done.

    edit - there might be simpler ways, but it's not something I've needed to do if I'm honest, so that was just off the top of my head.
     
  6. HatIsBlacked

    HatIsBlacked Regular Member

    Joined:
    Dec 30, 2010
    Messages:
    224
    Likes Received:
    57
    the op has a point.
    sb should be smart enough to read in, what it wrote out. that you have to go another step and reduce it to a text file, then import back in as a text file is silly. having to keep two sets of data files to represent the same thing is silly as well (txt, csv)
     
  7. hpv222

    hpv222 Power Member

    Joined:
    Feb 8, 2010
    Messages:
    736
    Likes Received:
    274
    Trying to import from csv file does't really make sense - what if the csv has column 1, 3, and 12 all populated with URLs, what should SB import? The 1st column only? The 3rd one? All three?
     
  8. HatIsBlacked

    HatIsBlacked Regular Member

    Joined:
    Dec 30, 2010
    Messages:
    224
    Likes Received:
    57
    CSV is a means to interchange data via a file format between applications. It is a perfectly fine format. It doesnt matter how many columns, or what column position a data element is assigned.
    Its the meaning of the column name that matters.


    What it boils down to is that ScrapeBox should have the ability to import CSV files and have reserved column names in its application context (URL, PR, etc. as column names).
    When it reads and writes its own CSV file, it knows about this (and this should be documented to users as well).

    This way SBox can read in a CSV created by a user or by its own self, and fully understand what each column means.
    It filters out columns it doesn't understand. It keeps columns that have matching reserved column names specific to its context.
     
  9. loopline

    loopline Jr. VIP Jr. VIP

    Joined:
    Jan 25, 2009
    Messages:
    3,374
    Likes Received:
    1,799
    Gender:
    Male
    Home Page:
    The CSV export is for eye ball viewing and perhaps sorting. Basic text files are the input because they are fail safe.

    I spend a lot of time on this forum and otherwise answering peoples questions and TRUST me when I say that some people seemingly work hard to make simple things complicated. If you opened sbox up for import of csv it would cause countless hours of support, which would take away from development. I mean we don't pay a monthly fee and we get more value then what we pay for scrapebox when we buy it. So they have no obligation to develop it further, but of course they want to. However if they waste all their time on stupid support, then they can't develop it. Its like scrapefox says, you would have to add the option to specify all sorts of "how scrapebox should behave if" type stuff.

    Ive seen lots of features added and then removed or not added in the first place, because they could be messed up too easily and they would or did create more support work or problems then they solved. Its just an issue, when you have tens of thousands of users, you have to take into account what ummm ... shall we say.... stupid people might do. I hate calling people stupid, because most people are not stupid, they just act stupid or are lazy or not using what brains they have. None the less, these people ruin it for everyone, plus there is just people that might not know and then make a mess of things.

    Further more, I worked in retail for 12 years. It is ABSOLUTELY NOT about reality. It does NOT matter what the truth in a situation is, it only matters what people believe. So even if the customer was wrong, or stupid, it doesn't matter, because if they believe they are right and they are paying, they can always not pay and spread discontentment, even if its untrue. So if you make scrapebox have tons of awesome features that tons of people can easily mess up. Then those people shortly start assuming its not their fault but the programs, and then they start saying scrapebox is bad and then the developer loses money. Its just how life is, people never assume they are wrong, read How to Win Friends and Influence People by Dale Carnegie for a lot more info on this.

    Al Capone killed lots of people. The story is told of how he was making out with his girlfriend one day and a officer came up to his car window, Al Capone jumped out and just murdered the police man. Just a few weeks later he was caught up in a hotel and the police were in adjacent buildings and there was a gun fight. As he was dripping blood, he wrote a note that said something to the tune of "Here is a man who was a benefactor of the common public, who tried to give people the finer pleasures of life." It goes on, and he says, in so many words, that he was an upstanding citizen and great person. If someone who murdered so many and committed so much crime can write a note in his final minutes before he died and thinks of himself as a good person, its no wonder the average human could create a giant mess for themselves and then blame some one else.

    Yeah... Im long winded, but thats my 2 cents. lol
     
  10. davidzweber9

    davidzweber9 Junior Member

    Joined:
    Nov 27, 2012
    Messages:
    141
    Likes Received:
    26
    Location:
    Newport Beach
    Yes Matt alright!

    I read HTWFAIP quite often, great book. Carnagie Melon.
     
  11. LordKrafty

    LordKrafty Registered Member

    Joined:
    Oct 20, 2013
    Messages:
    65
    Likes Received:
    8
    Occupation:
    Krafty
    Location:
    Florida
    Home Page:
    imsimpler's text editor works wonders also, one of the most useful free program i use everyday.