Blog of the Future: A Different Perspective by a different Robert S.

This vision is without video and you’ll have to trust me, I’m doing you a favor by sparing you from looking at my mug and hopefully sparing you the angst that my fellow Robert S(coble) generates.

In the simplest terms, the blog of the future will make a lot of cool things easily accessible to the average person that currently can only be done by gear heads. On the gear head scale, with Allen Stern being somewhere in the 8 range, I’d rate my present skills at about a 5. I hope to have that bumped up to a 6 by the end of the year.  It takes some work and I’m very rusty.

Back in the simpler times of the early 1990s, I coded my first web page entirely within Windows’ "Notepad" application (in Windows 3.1!).  Obviously the world has changed a lot since then, and I am not a young man so learning new stuff isn’t as easy as it once was.

I’m in the process of launching a website and tried to do it completely via free tools (Wordpress.com, Blogger, etc).  Luckily I had the good fortune to speak with Mr. Stern who advised me that I ought to think one year out.  He nicely suggested that if I didn’t take his advice, I’d come to regret it.  While I was hesitant to attempt learning something new, given Allen’s results when it came to building a successful blog I carefully considered his words.

He recommended that I give Drupal a try.  I didn’t wind up using Drupal, though I did play around with it and think it’s a great platform and I liked many aspects much more than Wordpress (the 2.x variety, not wordpress.com). The primary reason I wound up going with Wordpress (2.x) is that a much larger community is building stuff for it (themes, widgets, plugins, etc).

I’d rate my skills at CSS as "not very good" and so the more stuff out there that I could hopefully modify to taste, the better off I felt I’d be, especially as I’m the site’s webmaster and our software development budget for outside contractors is $0.00.  The propeller on my beanie may be a little rusty, but I do have the beanie and without it, there’s no way to approach fully utilizing the current tools available.  Even Wordpress with all its community support requires the beanie.

This sort of thing is still highly inaccessible for most people and while I understand some companies focusing on web site development like it this way, I believe there has to be some good result just by more people being able to easily craft better looking web sites.  Here, despite whatever jargon, and despite whatever may have been inaccurate and despite his love for Kyte.TV, I’m fully aligned with Robert Scoble.  This stuff is still way harder than it has to be.  Allen, whose propeller spins much more smoothly than my own needs to hire a Drupal guru to make certain modifications.  This makes me feel a little better and a little worse.  Better because the stuff is so complex that sometimes even the gurus need gurus and worse because we have no budget for gurus.

Things that are relatively simple in the computer world are not yet simple in the Web publishing world.  The site I’m affiliated with and the webmaster for, TVbytheNumbers.com is all about presenting data. One of the keys to success on the web is that your stuff needs to look very good. If your content is great, but it looks like hell people will not stick around to realize how great your content is.  As with everything else, appearances do matter a lot.  In the computer world, it’s really easy for me to create a great looking chart or table, copy it, paste it into an e-mail or another document and voila, good looking content.  It should be this easy in the web publishing world, but it’s not. The copy/paste functionality is simply non-existent for formatted tables.

Fortunately for charts, it’s easy to save them as graphic images and have them look good within posts. Still, figuring out that I could change the size of the Wordpress image thumbnail to utilize it better for our purposes required a fair bit of research.  But when it comes to certain data tables, saving them as images doesn’t always look so great.  Drupal may handle this better, and if so, I might have to give it another look, but remember, even Allen needs to hire a guru for Drupal so what hope do I have!?

Fortunately, someone did develop a table plug-in for Wordpress, and it works very well and allows you to import data in from Excel so you don’t have to reenter all the data.  The bad news is that the plug-in only works for posts, not content within sidebar widgets.  As our site focuses on the numbers of TV and is pretty much nothing but numbers, sometimes we need a way to make the numbers –especially the numbers we know people want to see – stand out.

For the sidebar widgets, is it possible to just code tables in raw HTML or CSS? Yes. But given the volume of it, doing all of this manually is a lot of overhead and the type of thing where you increase the odds you’ll make mistakes.  Via various experimenting I tried the following process to handle formatted tables in Widgets without the overhead of manually coding them:

  • Format the data however I want in Excel
  • Save it as a web page and publish it locally on my desktop
  • View the page’s source code and steal it from myself
  • Copy this code into the widget on Wordpress

And you know what? It actually works!  My first thought was, "Hey, why can’t I just do that for getting tables into posts as well?"  Sadly, the answer is because it simply will not work!   Even the little things become maddening and this is through no fault of the web publishing tools, this time it’s a "Microsoft sucks" kind of thing.

The data in certain columns in my tables is left justified and appears left justified in Firefox and Safari (looks perfect on the iPhone).  But in Internet Explorer for some reason it tries to center them. Only they’re not quite centered, and as you’d expect from the company who brought you the Zune, it’s a little bit uh..off-center.

While my guess is that on CenterNetworks a substantial portion of the visitors are using Firefox, the universe of people interested in TV metrics is 75% IE (fairly evenly split between IE 6 & IE 7) based on our early data.  While I attempt to resolve this, I am living with the off-centeredness under the theory that a highly stylized table that doesn’t justify everything properly is still more eye-catching than a well aligned simple text list.  The point is there are a lot of maddening aspects to this and inertia being what it is, most people will simply give up.

Things have come a long, long way since my days of coding HTML manually in Notepad and that produced results that didn’t look as good as the most basic blog of today. But as much as things have progressed, there is still a long way to go.

In my vision of the blog of the future, everything will be much simpler.  While I don’t always agree with Scoble, and could pick many nits in his production on the blog of the future, I’m not quick to throw the baby out with the bathwater.  The baby here is this: good looking, highly functional blogs that are easier to produce.  Scoble is trying to move the needle on that front and in this I support him 100%. I think you should too. Yes, even you Allen!

This article was authored by Robert Seidman, whose career included stops at IBM and Charles Schwab, covered the consumer Internet and online services extensively from 1994 to 2000. In those preblog times, Seidman's Online Insider had a distribution of over 50,000 and was considered a "must read" by many executives at the companies he wrote about. He is co-founder of TVbytheNumbers.com, launching in September.

AddThis
Forward
RSS Feed
COMMENTS - Add New Comment
Submitted by Curt Grymala on September 7, 2007 - 6:24pm.

Doesn't WordPress use TinyMCE as its WYSIWYG editor? If not, I'm pretty sure there's a TinyMCE plug-in for WordPress.

With TinyMCE, all you need to do is copy the stuff from Excel and then press the "Paste from Word" button in TinyMCE (when using that particular feature of TinyMCE, I suggest using Internet Explorer, as it doesn't work quite the same in Mozilla). TinyMCE will then nicely format your entire table, keeping all of the alignments, colors, etc. in place.

TinyMCE's "Paste from Word" interface is so much cleaner and more effective than exporting something from an Office application.

Good luck with all of it. I know where you're coming from, and I empathize with you.

Submitted by rseidman on September 7, 2007 - 7:03pm.

Hi Curt, so far as I understand it Wordpress uses TinyMCE as its WYSIWYG editor. I am definitely able to envoke the "Paste from Word" menu and utilize it, but it does not work. Actually, it *looks* perfect in the editor after pasting.

But if I save, publish or simply move from the Visual tab to the Code tab and back..it gets totally screwed up. It preserves a portion of header, and that's about it. I even tried pasting the table from Excel into Word, and then copying that and using the paste from Word feature. Same result.

I am using Office 2007 and perhaps that's the problem. I will see if i have Office '03 on another machine, and give it a try that way.

Thanks!

Robert

Submitted by Curt Grymala on September 9, 2007 - 9:16am.

Hmm. It sounds like it's one of three things:
1) drupal is not using TinyMCE
2) drupal is performing some kind of automatic edits on the code upon submission of the blog entry
3) drupal is using some sort of customized version of TinyMCE that is not implementing the Paste from Word feature properly

I would suggest the following in order to help suss it out:

Download the TinyMCE package from http://tinymce.moxiecode.net/. Unzip it into a folder on your computer somewhere. Open the "example_full.htm" file that's in the examples directory.

Then, copy the table from Excel and paste it into that instance of TinyMCE using the Paste from Word button (which shouldn't be a menu of any kind, it should just be a button you press that automatically pastes the content into the window).

Your version of Office shouldn't make any difference to TinyMCE, as I am also using 2007, and I don't have any problems.

Unfortunately, I don't use drupal, so I can't really help with the technical aspects of it specifically.

Again, good luck with all of it, and I look forward to seeing your site when you officially unveil it soon.

Submitted by Robert Seidman on September 9, 2007 - 8:18pm.

Sorry for the confusion: tried Drupal, but didn't go with it and the site is run in Wordpress. I am definitely not able to publish tables via copy/paste (even using 'Paste from Word').

I did find a way to publish tables to posts by posting them directly via Word, but this isn't a great solution. If I edit the post within Wordpress and click on the "Code" tab, the beautiful tables disappear. I could live with that if I was the only one posting to /editing the site, but I'm not. And it didn't solve my problem with formatting in the sidebar widgets.

I have no doubt I'll get it figured out, but I'm equally sure it's way harder than it will be in the future. I really appreciate you trying to help, Curt. Thanks!

You can see the site now, it's live in a "soft launch" period. If you're into data about the television business, there's already quite a bit of it up. Any tables you see within posts were generated via plugin. In case my name isn't linked here, it's tvbythenumbers.com . Thanks again,

Robert

Submitted by centernetworks on September 9, 2007 - 8:22pm.

you know - you could try embedding the tables from google spreadsheet or zoho sheet

that might work brilliantly!

Submitted by Joseph on September 19, 2007 - 5:26pm.

Unlimited iPhone Downloads!

The Top Site to Download iPhone Music, Movies and Games! Unlimited Free Downloads. Download everything you want! Includes all the tools, software, and support that you need. 300X Times Faster! Start Now!

Click Here Right Now to Download!
http://www.webnetads.com/iphone

Become a sponsor

SPONSORS

SocialText
Clicky Web Analytics
Web 2.0 Expo New York 2008

PARTNERS

read centernetworks anywhere!
Advertise here

OTHER STUFF