1. And... we're back. You'll notice that all of your images are back as well, as are our beloved emoticons, including the infamous :foo: We have also worked with our server folks and developers to fix the issues that were slowing down the site.

    There is still work to be done - the images in existing sigs are not yet linked, for example, and we are working on a way to get the images to load faster - which will improve the performance of the site, especially on the pages with a ton of images, and we will continue to work diligently on that and keep you updated.

    Cheers,

    Fok on behalf of the entire Styleforum team
    Dismiss Notice

Spreadsheet for the new Borrelli stuff...

Discussion in 'B&S Archive' started by discostu004, Jan 18, 2005.

  1. discostu004

    discostu004 Senior member Affiliate Vendor

    Messages:
    1,805
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
  2. arvi

    arvi Senior member

    Messages:
    235
    Joined:
    Sep 28, 2004
    Location:
    New York City
    sorry but the links didn't work
     
  3. discostu004

    discostu004 Senior member Affiliate Vendor

    Messages:
    1,805
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    try again, do they work? they work on my end. just let me know
    thx
    lance
     
  4. arvi

    arvi Senior member

    Messages:
    235
    Joined:
    Sep 28, 2004
    Location:
    New York City
    link to spreadsheet works but not the one to images
     
  5. bryce330

    bryce330 Senior member

    Messages:
    804
    Joined:
    Feb 18, 2003
    The images work for me - you have to capitalize JPG.
     
  6. discostu004

    discostu004 Senior member Affiliate Vendor

    Messages:
    1,805
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    1. click on the link with the "xxx" in the end
    2. open the sheet and find column B
    3. those numbers are the image numbers
    4. in the URL where teh "xxx" is (this link will not open a valid page), put the number in there like 6146.JPG

    that will pull up the corresponding pix
     
  7. arvi

    arvi Senior member

    Messages:
    235
    Joined:
    Sep 28, 2004
    Location:
    New York City
    ok..thanks..got it, albeit tedious
     
  8. discostu004

    discostu004 Senior member Affiliate Vendor

    Messages:
    1,805
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    there's no other way that i can think of. just giving you guys first crack at it before it goes up for anyone/everyone
     
  9. jerseyguy

    jerseyguy Well-Known Member

    Messages:
    72
    Joined:
    Jul 25, 2004
    Lance,

    If you want to add links to the images to the spreadsheet you could try something like this:

    =HYPERLINK(CONCATENATE("http://www.virtualclotheshorse.com/images/",MID(B250,1,4),".JPG"))
    =HYPERLINK(CONCATENATE("http://www.virtualclotheshorse.com/images/",MID(B250,6,4),".JPG"))
    =HYPERLINK(CONCATENATE("http://www.virtualclotheshorse.com/images/",MID(B250,11,4),".JPG"))

    only one link per cell, obviously, but all you'd have to do is paste this in one cell and fill it down (just change the B250 to the corresponding image # cell)
     
  10. discostu004

    discostu004 Senior member Affiliate Vendor

    Messages:
    1,805
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    thanks for the html, i might try that on the next round, this round is up on the site now
    thx
     
  11. taillfuzz

    taillfuzz Active Member

    Messages:
    33
    Joined:
    Aug 18, 2004
    This is an exceptional shipment and there are so many great pieces.
     
  12. discostu004

    discostu004 Senior member Affiliate Vendor

    Messages:
    1,805
    Joined:
    Apr 5, 2004
    Location:
    7,908 Feet, Colorado
    thanks, the pants are amazing..
     

Share This Page

Styleforum is proudly sponsored by