New to Digital? Tutorials Shop Contact Us
Gallery Forums New Posts New Products Chat Freebies Contests/Challenges Calendar Club Digital Newsletter Subscriptions/Feeds Scrap The Map Your Timezone?
The Store
Tutorials Articles DSU Classes Mentoring Beyond the Layout Product Reviews Links Glossary
About Us Team Digital Contact Us DSP Blog Media Retailer Info Designers Vendors Legal Licensing Graphics Store Locator Questions? Site Map

Go Back   Digital Scrapbook Place > DSP Site Information > Site Info

Reply
 
Thread Tools Display Modes
Old 01-08-2008, 09:58 PM   #1
Kathleen
DET Alumni
 
Kathleen's Avatar
 
Join Date: Apr 2007
Location: Is this Heaven? No, it's Iowa!
Posts: 7,655
Photos: 286  Users Photo Gallery
Giving Credit and Posting Links Made Easier

Do you links look like this:

http://store.digitalscrapbookplace.c...oducts_id=6913

... but you want them to look like this:

Swirl Box Embellishment Stamp Set by Suzanne C. Walker

I can be really goofy and very particular about things sometimes! It took me a while to figure out how people were creating neat and clean links in posts, and once I did, it took me a bit longer to figure out a way I was happy with to keep track of information and easily have the information at the ready.

I use Excel way too much in my day job, so it seemed like a natural fit to create a spreadsheet to do the work of creating the link for me. By entering three bits of information (kit name, designer, and store number) when I purchase a kit, Excel then creates the "code" for me to copy and paste into a post and create a "pretty" link. I can sort in Excel by kit name or designer, and if I am really curious check out the pivot table to see which designers top my list.

The Excel sheet has more instruction information included.

If I have done this correctly, you should be able to get the ZIP file in this post and unzip the Excel file.

I hope you find this useful, feel free to PM me if you have questions, or post in this thread.

~ Kathleen

January 24, 2011 Update

Version 4 is now available! Read about it in post 252 of this thread.

With the recent store upgrades, I updated some formulas so everything should be working well again!.

I also updated Post 93 in this thread which has some good step-by-step instructions on copy/pasting into the spreadsheet, as well as transferring from one spreadsheet (old version) to another (new version).

Post any questions, and I will do what I can to help. Attached Files DSP Links to Share v4.zip (280.9 KB, 0 views)
Kathleen is offline   Reply With Quote
Old 01-09-2008, 03:03 AM   #2
shazzt
DET Alumni
 
shazzt's Avatar
 
Join Date: Jun 2004
Posts: 25,564
Photos: 793  Users Photo Gallery
I usually just manually type the code in but that looks like a cool idea!
PS - the tutorial for sharing links is here if anyone is interested .
__________________
Cheers Sharon

shazzt is offline   Reply With Quote
Old 01-09-2008, 04:05 AM   #3
felynn
DET Alumni
 
felynn's Avatar
 
Join Date: Jul 2007
Posts: 7,141
Photos: 2,133  Users Photo Gallery
The excel file looks really cool. I'll give it a try.

I usually just make a "pretty link" of the kit and paste it into the terms text file that comes with the kit.
__________________
felynn is offline   Reply With Quote
Old 01-18-2008, 02:35 PM   #4
Scrapping4Him
DET Alumni
 
Scrapping4Him's Avatar
 
Join Date: Dec 2004
Location: Sunny So Cal - San Diego area - love my Canon T2i and CS5
Posts: 12,062
Photos: 2,173  Users Photo Gallery
Awesome spreadsheet Kathleen! I've been doing something very similar but those lovely formulas make it way easier and faster to do the data entry. Thanks for sharing this!!!
__________________
Mandy
Need Inspiration? Go check out the DET Gallery!!!



Scrapping4Him is offline   Reply With Quote
Old 01-18-2008, 06:53 PM   #5
scamptx
~Scampering Across the Universe~ April '08 Spotlight Member & DET Alumni
 
scamptx's Avatar
 
Join Date: Nov 2005
Location: Texas, but my heart's in NYC
Posts: 19,174
Photos: 757  Users Photo Gallery
Oh thank you, thank you! I had made a spreadsheet, but I'm not nearly as skilled in Excel...love this!
__________________
<< Click on the WOS!
scamptx is offline   Reply With Quote
Old 01-18-2008, 07:26 PM   #6
Jill W
DET Alumni
 
Jill W's Avatar
 
Join Date: Aug 2006
Location: Northern Illinois
Posts: 12,340
Photos: 1,291  Users Photo Gallery
Oh what a swell formula! I don't know why I hadn't thought about doing it that - I keep track of all of my kits in Excel so this would work great! (However, after a lot of practice, using the html code is simple now ... but I'm going to try your formula...).
I can't imagine work OR home computing without Excel!!
Thanks for sharing!
__________________

MY BLOG
Jill W is offline   Reply With Quote
Old 01-18-2008, 08:29 PM   #7
lmilgram
Addicted to this place
 
lmilgram's Avatar
 
Join Date: Jul 2005
Location: Upstate NY
Posts: 2,159
Photos: 350  Users Photo Gallery
This is cool! I'm a big fan of Excel too, but I was really excited to learn how to store the credits right in the Photoshop file....no more random Text Files for me! Thank you!
__________________
--Lisa--

lmilgram is offline   Reply With Quote
Old 01-18-2008, 10:18 PM   #8
Kathleen
DET Alumni
 
Kathleen's Avatar
 
Join Date: Apr 2007
Location: Is this Heaven? No, it's Iowa!
Posts: 7,655
Photos: 286  Users Photo Gallery
Glad to be able to share a few little tidbits of information. I have learned so much at DSP, so it is fun to give a little back!

~Kathleen
Kathleen is offline   Reply With Quote
Old 01-19-2008, 12:49 AM   #9
Muma
DET Alumni
 
Muma's Avatar
 
Join Date: Mar 2007
Location: Bedfordshire, UK
Posts: 7,871
Photos: 375  Users Photo Gallery
Just downloaded your excel file and I'm impressed LOL .... I have played with excel a few times but not really got to grips with it. I think the formulas put me off. However I took a look at this and I'm certainly gonna keep this up to date ...... thank you very much for your hard work.
__________________
Sue xx
Come Visit the DET Gallery for Inspiration
Muma is offline   Reply With Quote
Old 01-19-2008, 09:14 AM   #10
Emma
Yay I can choose my name!
 
Emma's Avatar
 
Join Date: Mar 2004
Location: Austin, TEXAS!
Posts: 15,136
Photos: 293  Users Photo Gallery
hey, that's pretty cool! I always feel so nerdy when I make Excel stuff, and I'm not even that good at it, but I love how all the numbers come out so neatly at the end when my formulas work!

For those wondering how to make neat links like that, first go to the URL you want to use and copy it from the Address Bar. Then use the "Go Advanced" reply in the forums and type the WORDS you want, highlight them and click the Globe/Link icon at the top and paste in the URL.

If you then hit PREVIEW, it'll generate the code for you, which you can then copy/paste into the gallery since it has no Advanced area (two different pieces of software, gallery and forum, though they both use PHP code, the gallery makes you put it in manually: bummer!)

hope that help
__________________



SELLING MY SIGMA NIKON F 10-20mm f/4-5.6 ULTRA WIDE-ANGLE LENS
Emma is offline   Reply With Quote
Old 01-19-2008, 10:05 AM   #11
carlalee
Addicted to this place
 
carlalee's Avatar
 
Join Date: Jan 2006
Location: Down the road 2nd house on the left
Posts: 2,175
Photos: 174  Users Photo Gallery
Hey Kathleen - you gave me a *THUNK* V8 moment! So like I have an Excel spreadsheet that I've been keeping since before my ACDSee days with all of this same info with one BIG exception - DUH no formulas! Sometimes it takes quite a while to complete my postings because of all of the copying and pasting to get things right. How EASY is this. YOU TOTALLY ROCK CHICK!!!! Say a little tid bit for you, did you know you can generate a text file listing of ALL of your digiscrapping supplies using ACDSee? Then you can open the text file with Excel, then using your spreadsheet get maybe 90% of the work done in just a few minutes. TYVM -c-
__________________
17" MacBook Pro i7 10.6.4 (Snow Leopard) PS CS5 & Wacom Graphire 4, Canon PowerShot SD750
AKA: clskip on Twitter

carlalee is offline   Reply With Quote
Old 01-20-2008, 11:59 AM   #12
Fade2Pink
Digital Elite Alumni
 
Fade2Pink's Avatar
 
Join Date: Jan 2008
Location: SLC, UT
Posts: 10,506
Photos: 781  Users Photo Gallery
Very cool, thank you!!
Fade2Pink is offline   Reply With Quote
Old 01-20-2008, 01:27 PM   #13
Meryl
DSP Senior Designer
 
Meryl's Avatar
 
Join Date: Mar 2004
Location: KwaZulu Natal, South Africa
Posts: 30,992
Photos: 1,943  Users Photo Gallery
Kathleen this is great I keep all my links in a spreadsheet but am not clever enough to make it create a pastable pretty link thanks fantastic work
__________________
Meryl From KwaZulu Natal & proudly South African!
Meryl is offline   Reply With Quote
Old 01-20-2008, 05:11 PM   #14
Caro
*** Carolyn aka sammdc *** DSP Spotlight August 2008
 
Caro's Avatar
 
Join Date: Feb 2006
Location: Western Australia
Posts: 28,053
Photos: 2,227  Users Photo Gallery
wow that is awesome work
Caro is offline   Reply With Quote
Old 01-20-2008, 05:55 PM   #15
Erica
Team Digital Senior Designer
 
Erica's Avatar
 
Join Date: Jan 2007
Location: Auckland, New Zealand
Posts: 21,338
Photos: 1,367  Users Photo Gallery
Great idea Kathleen and I too use excel a lot (even used to teach it) but I keep all my kit info in a wordpad doc and just do what Emma suggests above.
__________________

Erica is offline   Reply With Quote
Reply
Smile!
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 01:54 PM. (Change your account settings?)
The current DSP Time (Eastern) is: Find the local time of an event?


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
©2004-2012 Digital Scrapbook Place, Inc. All rights reserved. Terms of Use · Legal/Privacy Notices · Retailers · Media · Contact
 
Facebook digital scrapbooking . . Flickr digital scrapbooking . . YouTube digital scrapbooking . . Pinterest digital scrapbooking . . Twitter digital scrapbooking