Blog Azeroth

A forum for World of Warcraft Bloggers
It is currently Sat Aug 23, 2014 1:25 pm

All times are UTC




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Blogroll Tool
PostPosted: Sat Aug 02, 2008 4:16 am 
Offline
User avatar

Joined: Thu Jan 24, 2008 12:02 am
Posts: 49
Location: Australia
Hi All,

Firstly I want to say that I have been using a blogroll from Delmain. Now I love this blogroll. It looks great and is very functional. The only real problem I have is the time it can take to set it up (for noob coders like me) and the time it takes to add each new blog.

With that in mind I have created the following Spreadsheet.
Clicky

Basically there are 3 Tabs.
Custom Info is where you can personalise the global information.
Blog List is where you add your Blog Sites and Label them.
HTML Blogroll is the HTML Data you copy and paste into any HTML widget that supports Java.

I am really interested in feedback on this. Please also feel free to let me know if I missed you on the list.

_________________
Razorbax
http://www.threedruidnoob.com


Top
 WWW Profile Send private message  
 
 Post subject:
PostPosted: Mon Aug 04, 2008 8:15 pm 
Offline
User avatar

Joined: Fri Jan 25, 2008 9:45 pm
Posts: 238
Location: Utah
Server: Illidan (US)
I took a look at it, but didn't get a chance to test it out, very interesting use of Excel though. If I get a chance to try and implement on a test blog I will let you know.

_________________
Image


Top
 WWW Profile Send private message  
 
 Post subject:
PostPosted: Wed Aug 06, 2008 9:34 am 
Offline
User avatar

Joined: Tue Jul 29, 2008 10:51 am
Posts: 14
Location: NL
Server: Eonar EU
Took a look at it - very well put together and very useful. Thanks! :)

_________________
Blog: Holier Than Thou
Do not interfere in the affairs of dragons for you are crunchy and taste good with ketchup.


Top
 WWW Profile Send private message  
 
 Post subject:
PostPosted: Wed Aug 06, 2008 11:14 am 
Offline
User avatar

Joined: Thu Jan 24, 2008 6:27 am
Posts: 47
Location: Orlando, Florida
Server: Arthas
Oh man, awesome. Definitely looks good. Thanks Razor.

_________________
They See Me Trollin'
Delmain - Troll Shadow Priest - Arthas (US)


Top
 WWW Profile Send private message  
 
 Post subject:
PostPosted: Thu Aug 21, 2008 1:40 pm 
Offline
User avatar

Joined: Thu Jan 24, 2008 2:33 pm
Posts: 26
Location: Miami
Server: Bleeding Hollow
Hey Raz.

I tried it yesterday and overall I have to tell it works great. I have a couple of questions about it. Like the order set up and how to add the link to the "Submit -Correct Your Blog" part.

How can you remove it if you don't want it?

I will try to talk to you in BA but if I don't see you soon, I'll just email you. Thank so much for the work you have done with it. It is a really great tool and makes such an awesome looking feature easy to work with!

_________________
Bre-80 Priest
Bleeding Hollow-US
Aculeus Upon Ordeum


Top
 WWW Profile Send private message  
 
 Post subject:
PostPosted: Fri Aug 22, 2008 6:29 am 
Offline
User avatar

Joined: Thu Jan 24, 2008 12:02 am
Posts: 49
Location: Australia
Heya Bre!

You should just have to enter your email address in the field to get the submit link to work, its just an email link so will open the users email client.

To get rid of the email line.
First off, delete the email address on the "Custom Info" tab so the field is blank.
There is a hidden tab called "Web Data". Unhide this (rightclick on another tab and click unhide).
You will then need to Un-Protect the Sheet. This in version 2008, you click "Review" Tab then "Unprotect Sheet"
Cell B4, change from
Code:
><a href=mailto:

to
Code:
>

Then change Cell G4 from
Code:
">Submit-Correct your Blog</a></div></h2>

to
Code:
</div></h2>


That should work.

On the "Web Data" page you can change the text "Submit-Correct your Blog" to anything you want.

The Order is covered by the Label and Title columns. It will go from top to bottum in that order. You can rename them all to suit.

Look forward to seeing what you come up with;)

Razor

_________________
Razorbax
http://www.threedruidnoob.com


Top
 WWW Profile Send private message  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
mergenine: WoW Alliance BB3
World of Warcraft ® ©2004-2007 Blizzard Entertainment, Inc. All rights reserved.