Home› Trading Cards & Memorabilia Forum

for the love of god

bouwobbouwob Posts: 100 ✭
in Trading Cards & Memorabilia Forum
Please add an export to excel link. It would take me all of about 12 minutes to write this functionality up in .net and would save me 45 hours of busy work to do it by hand.

If you would like to see this functionality to be able to easily organize your collection in excel, please +1 this thread.

Thanks,
I am working on the Nolan Ryan master set. Need 1004 more cards to complete. I might actually spend more on plastic than I did on cardboard.

Comments

  • jimradjimrad Posts: 2,777 ✭✭✭
    +1
    Positive transactions with: Bkritz,Bosox1976,Brick,captainthreeputt,cpettimd,craigger,cwazzy,DES1984,Dboneesq,daddymc,Downtown1974,EAsports,EagleEyeKid,fattymacs,gameusedhoop,godblessUSA,goose3,KatsCards,mike22y2k,
    MULLINS5,1966CUDA,nam812,nightcrawler,OAKESY25,PowderedH2O,relaxed,RonBurgundy,samsgirl214,shagrotn77,swartz1,slantycouch,Statman,Wabittwax
  • jeffcbayjeffcbay Posts: 8,950 ✭✭✭✭
    +1

    I'm assuming you're talking about the Pop report. It doesn't take that long to paste it into Excel and massage it a little to look nice, but it really would be nice to have an export button. Having the ability to SORT is a wonderful thing.
  • bouwobbouwob Posts: 100 ✭
    I do not care about the population report and wouldn't even offer it if I was in charge of PSA. Its a paid service and if you want to see, you need to pay (eliminates trading of lists amongst paid members and non paid members).

    I am looking for my collection with registry cards. list of all cards I have and don't have with only my grade listed.
    I am working on the Nolan Ryan master set. Need 1004 more cards to complete. I might actually spend more on plastic than I did on cardboard.
  • twileytwiley Posts: 1,923 ✭
    You think thats bad.....

    Look at this forum site's Copyright?!?!?!?

    Since I joined. I can't believe it hasn't been hacked.

    I guess this forum is a small time and overlooked...

    image
  • nightcrawlernightcrawler Posts: 5,110 ✭✭


    << <i>I do not care about the population report and wouldn't even offer it if I was in charge of PSA. >>




    I'm glad you're not in charge. Not that I don't agree with you, but the pop report's been good for business.
  • twileytwiley Posts: 1,923 ✭
    LINK
  • Dpeck100Dpeck100 Posts: 10,912 ✭✭✭✭✭
    The pop reports is one of the major drivers of price and the desire to sub commons and other hard to get in high grade cards.

    I think it is a great service and there is no chance it will go away.
  • Mdube16Mdube16 Posts: 744 ✭✭
    On the Excel menu...

    Data-> Import External Data-> New Web Query

    It works...you can drop any list online into excel without typing it
  • HuncrelanHuncrelan Posts: 216 ✭


    << <i>On the Excel menu...

    Data-> Import External Data-> New Web Query

    It works...you can drop any list online into excel without typing it >>



    Thanks, works like a champ.

    Paul
  • jeffcbayjeffcbay Posts: 8,950 ✭✭✭✭


    << <i>On the Excel menu...

    Data-> Import External Data-> New Web Query

    It works...you can drop any list online into excel without typing it >>

    .

    That actually works pretty well with the Set Registry page, but I can't get it to work with the Pop Report, because it's a secure site (you need to be logged in).

    Whenever I want to import a page from the SMR/Pop Report/Set Registry, I just select the entire list (list only), copy it to my clipboard, then in Excel go to: Edit-> Paste Special-> Paste as Unicode Text. That pastes in without all the extra crap. Then all I have to do is format the column widths and it's all good. Both ways take minimal effort, and require no need to summon the love of any gods.
  • gemintgemint Posts: 6,126 ✭✭✭✭✭
    I'd like to see PSA and VCP team up to allow registered set information to be imported into VCP's 'my collection' so I don't have to manually re-enter my collection into VCP.

    Edited to add - Either this or allow VCP members to display current VCP average or last value data in the PSA set registry pages (like they do for populations).
    https://ebay.com/sch/gemint/m.html?_nkw=&_armrs=1&_ipg=&_from=
  • bouwobbouwob Posts: 100 ✭


    << <i>

    << <i>On the Excel menu...

    Data-> Import External Data-> New Web Query

    It works...you can drop any list online into excel without typing it >>

    .

    That actually works pretty well with the Set Registry page, but I can't get it to work with the Pop Report, because it's a secure site (you need to be logged in).

    Whenever I want to import a page from the SMR/Pop Report/Set Registry, I just select the entire list (list only), copy it to my clipboard, then in Excel go to: Edit-> Paste Special-> Paste as Unicode Text. That pastes in without all the extra crap. Then all I have to do is format the column widths and it's all good. Both ways take minimal effort, and require no need to summon the love of any gods. >>



    Thank you Mdube16

    Also if you are using 2010 office, just log in on the web page that is showed in excel and the go to the registry you are looking for.
    I am working on the Nolan Ryan master set. Need 1004 more cards to complete. I might actually spend more on plastic than I did on cardboard.
  • TNP777TNP777 Posts: 5,710 ✭✭✭
    yeah, some things around here may be a little antiquated, but our chat room is state of the art! Our search function is top-notch, too.

    Dodgers collection scans | Brett Butler registry | 1978 Dodgers - straight 9s, homie
  • purduepetepurduepete Posts: 791 ✭✭✭


    << <i>yeah, some things around here may be a little antiquated, but our chat room is state of the art! Our search function is top-notch, too. >>



    I see what you did there...image
    Tom

    Collecting: Topps 1952-79, Bowman 1952-55, OPC 1965-71, and Pre-War White Sox cards
Sign In or Register to comment.