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 05-17-2008, 08:43 AM   #31
Simply Hx
Addicted to this place
 
Simply Hx's Avatar
 
Join Date: Feb 2008
Location: England
Posts: 2,849
Photos: 161  Users Photo Gallery
You all sound so knowledgeable... I'm such a computer dummy, and definitely an Excel dummy LOL... but I'm going to give this a try! Thanks Kathleen!

I'll be back in a year to let you know how I've got on with it!!!

Hx
Simply Hx is offline   Reply With Quote
Old 05-18-2008, 08:15 AM   #32
LadyCarolyn
I live at this place!
 
LadyCarolyn's Avatar
 
Join Date: Jan 2008
Posts: 3,195
Photos: 295  Users Photo Gallery
KATHLEEN, what a wonderful creation. NOW, I have to go and sort the hundreds of kits that I have . . ...a good rainy day project that might take quite awhile. Maybe I will start by designer as I do have everything filed in subfolders by designer name and number.

Fantastic.

Quote:
Originally Posted by kathleen08 View Post
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
__________________
Camera Equipment Nikon D90, Nikon Lenses f/2.8 18-55mm, f2.8 24-70mm, f/2.8 70-200mm, f/2.8 100mm Macro, SB-600 flash, SB-900 flash, Tokina wide angle f/2.8 11-16mmm, f/1.4 50mm prime lens, f/2.8 85mm portrait lens, 1.7 converter, Canon Powershot G10
LadyCarolyn is offline   Reply With Quote
Old 05-18-2008, 09:16 AM   #33
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
I'm so glad someone bumped this thread and it is helpful!

A note that might help ... carlalee posted this earlier in this thread:

"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."

I haven't tried this (already had all my stuff in Excel), so not sure exactly how it works or what you have to have in ACDSee to start with.

I find upkeep is pretty easy, and just do some copying and pasting when I buy new stuff.

Good luck!

~ Kathleen
Kathleen is offline   Reply With Quote
Old 05-18-2008, 11:40 AM   #34
nachtstern
Addicted to this place
 
nachtstern's Avatar
 
Join Date: Apr 2008
Location: VA
Posts: 2,158
Photos: 253  Users Photo Gallery
now if someone would fine an easy way to do all this with Picasa there would be muchos loving from my side!

also, how would I go about adding freebies from DSp to the list?
each of them has a different link
__________________

nachtstern is offline   Reply With Quote
Old 05-18-2008, 05:29 PM   #35
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
I can't help with Picasa, but for freebies and posting bonuses, I add the name and designer, I put a 0 in the store number column (so I know its not missing), and in column F (formula for store link), I replace it with a link to some information. If it was a freebie, I put the link to where I downloaded it, if it was a posting bonus I but a link to the preview image in the gallery or link to thread in the forums about the challenge. If none of these is available, I link to the designers store. So for your posting link then you have a link to something.

~ Kathleen
Kathleen is offline   Reply With Quote
Old 05-20-2008, 06:35 AM   #36
Kaer
Addicted to this place
 
Kaer's Avatar
 
Join Date: Aug 2005
Location: Netherlands
Posts: 1,550
Photos: 238  Users Photo Gallery
I use Picasa and this is how I do it:
I create manually the pretty link and put it in the albumdescription. When I want to use it for credits I only need to copy and paste it.

Quote:
Originally Posted by nachtstern View Post
now if someone would fine an easy way to do all this with Picasa there would be muchos loving from my side!
__________________

Thanks to dutchsparky for the lovely sunday scrappers blinkie
Kaer is offline   Reply With Quote
Old 07-27-2008, 02:46 PM   #37
tora
I live at this place!
 
tora's Avatar
 
Join Date: Feb 2008
Location: Iceland
Posts: 4,108
Photos: 341  Users Photo Gallery
this is just what Ive been thinking about for some time now, but my lack of turning my Icelandic thoughts to English words is VERY POOR , I only envy those who have been doing this neat link stuff, now Im so going to try making this work for me. Thank you for sharing your idea.
__________________
Tora - Mac, PS CS5.1 & Bamboo Fun
tora is offline   Reply With Quote
Old 10-16-2008, 08:57 PM   #38
omio
Oh Me, Oh My
 
omio's Avatar
 
Join Date: Jul 2005
Location: My own little world
Posts: 9,146
Photos: 201  Users Photo Gallery
I'm going to bump this up in the posts because I use this Excel sheet ALL the time. It's a great, easy way to post links with your LOs. Thanks, Kathleen!
__________________
omio is offline   Reply With Quote
Old 01-11-2009, 11:09 PM   #39
idtwinmom
Yay I can choose my name!
 
idtwinmom's Avatar
 
Join Date: Apr 2007
Location: Alaska
Posts: 10,990
Photos: 695  Users Photo Gallery
Wow! I am so impressed! I can't wait to get to a machine that has a program on it that can open your spreadsheet. (DH still has not given me the office disk to load on the laptop, even though I keep asking!)
__________________
idtwinmom is offline   Reply With Quote
Old 01-12-2009, 03:25 AM   #40
tora
I live at this place!
 
tora's Avatar
 
Join Date: Feb 2008
Location: Iceland
Posts: 4,108
Photos: 341  Users Photo Gallery
Quote:
Originally Posted by idtwinmom View Post
Wow! I am so impressed! I can't wait to get to a machine that has a program on it that can open your spreadsheet. (DH still has not given me the office disk to load on the laptop, even though I keep asking!)
You do not need a disk; go to www.openoffice.org and there you can download the free wersion of a good office pack (sorry need more words once again) but take a look at the website and youll see what Im talking about.
__________________
Tora - Mac, PS CS5.1 & Bamboo Fun
tora is offline   Reply With Quote
Old 01-12-2009, 01:30 PM   #41
sandygb
DET Alumni
 
sandygb's Avatar
 
Join Date: Feb 2006
Location: West Chester, PA United States
Posts: 37,585
Photos: 2,575  Users Photo Gallery
AWESOME info Tara!!!!! Thanks so much. I don't have MS Office and didn't have a spreadsheet program, so was only able to use the free Excel Viewer. I just downloaded the Open Office application from Sun and it is wonderful!

Thanks for the spreadsheet setup Kathleen!!! I currently use a text file to keep track of my kits and pretty links, but this looks so much easier to find the info easily!
__________________
Sandy
Canon Digital Rebel XTi

sandygb is offline   Reply With Quote
Old 01-12-2009, 01:38 PM   #42
diturpin
March '11 Spotlight Member, DET 8, 9 & 13 Alumni
 
diturpin's Avatar
 
Join Date: Dec 2005
Location: Nashville, TN
Posts: 9,276
Photos: 497  Users Photo Gallery
I just want to thank Kathleen again for her work on this file. I use it every day now that I'm on DET. I had an old system but this one is much better.

Open office is great for those of you that don't have Excel. I've heard rave reviews about it from my friends.
__________________
Diane [size=4]
diturpin is offline   Reply With Quote
Old 01-12-2009, 02:25 PM   #43
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 someone uncovered this thread for a new bunch of people!

I'm glad so many find it helpful, I know I would be lost without mine, and probably couldn't count the number of times I purchased something I already had!

If someone tries it in Open Office and it doesn't work, let me know and I will see if I can fix it up. I use Excel, but there is a computer here at home that has Open Office on it.
__________________
~ Kathleen


Visit the DET Gallery!
Kathleen is offline   Reply With Quote
Old 01-29-2009, 03:17 PM   #44
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
I've updated my spreadsheet to make it a little easier to get information into the spreadsheet. You can now copy your order information from the download page in the store (either right at time of purchase, or going to your history by navigating My Account > Show All Orders > View Button on each order) and paste it right into the spreadsheet, and you will get the name of the item you purchased, designer name and the appropriate "pretty links" code all done for you.

If you have been using the spreadsheet already, and want to simplify the input of information, you can download the new spreadsheet, and then copy the data you have in columns A, B & C in your existing spreadsheet into the new one (hope that makes sense).

I also made two brief videos that help show you how to use the spreadsheet. You can find the here.

For this updated spreadsheet, you can download: DSP Links to Share v2.zip

I also update my first post in this thread.

Let me know if you have any questions!
__________________
~ Kathleen


Visit the DET Gallery!
Kathleen is offline   Reply With Quote
Old 01-29-2009, 04:10 PM   #45
sandygb
DET Alumni
 
sandygb's Avatar
 
Join Date: Feb 2006
Location: West Chester, PA United States
Posts: 37,585
Photos: 2,575  Users Photo Gallery
Thanks Kathleen! I'm gonna give the new version a try!!!
__________________
Sandy
Canon Digital Rebel XTi

sandygb 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:32 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