SEO Help (General Chat)
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   SEO Chat ForumsOtherSEO Help (General Chat)

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread SEO Chat Forums Sponsor:
  #1  
Old August 2nd, 2008, 01:32 PM
el zipa el zipa is offline
Registered User
SEO Chat Newbie (0 - 499 posts)
 
Join Date: Aug 2008
Posts: 7 el zipa User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 21 m 11 sec
Reputation Power: 0
Question Best solution for publishing table/grid?

Hi all, experienced programmer here, but novice when it comes to building web pages.

Background

The primary page of my site is a directory which is essentially just a table of data (imagine an Excel sheet with about 40 columns and 40 lines).

I put together the info in Excel, at the moment my strategy for publishing is as follows:
1) edit the data in Excel
2) save as CSV
3) convert CSV to XML
4) upload XML file to server
5) XML file is referenced by a Spry table on page

I can repeat steps 1 to 5 as often as I want, any time I want to edit the source data.

Question

I am not convinced about the wisdom of having the web page w/ Spry table and the XML in separate files. If the web page is called a.php referencing file b.xml , will Google see a.php and b.xml as part of the same set of information? Will Google even see the content of b.xml and index it? The content of my table needs to be indexed, it's the essence of that page.

Is there an easier way to do this?

I'd like to have some kind of table / datagrid object on the web page that allows the user to sort by clicking column headers.

If I can keep my master list in Excel, that would be ideal, as I sometimes may need a research assistant to make edits. But if it would save me a lot of time, I could pull the info into a web page designer like DreamWeaver as a one-off and make edits directly in the designer.

I can still choose any development environment at this stage. Not locked into anything. This is really a hobby project to bring my development skills into the 21st century.

All advice / orientation welcome.

Last edited by el zipa : August 2nd, 2008 at 01:37 PM.

Reply With Quote
  #2  
Old August 4th, 2008, 04:41 AM
JagNet's Avatar
JagNet JagNet is online now
Smoke me a kipper...
Click here for more information. Click here for more information
 
Join Date: Aug 2007
Posts: 2,134 JagNet User rank is Sergeant Major (2000 - 5000 Reputation Level)JagNet User rank is Sergeant Major (2000 - 5000 Reputation Level)JagNet User rank is Sergeant Major (2000 - 5000 Reputation Level)JagNet User rank is Sergeant Major (2000 - 5000 Reputation Level)JagNet User rank is Sergeant Major (2000 - 5000 Reputation Level)JagNet User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Month 1 Week 3 Days 2 h 5 m 13 sec
Reputation Power: 38
A quick Google of Spry tables suggests that the data is being loaded dynamically with Javascript, in which case this is far from ideal in terms of SEO.

A better option would be to use php to load the data directly from the CSV file on the server side, outputting the html page complete with tabulated data. See fgetcsv for one possible way of doing this.

For improved performance you could cache the result of the CSV to html table conversion, and then check file modification dates on the server to determine when the script needs to reconstruct the table data when you upload a new CSV file.

You can still use Javascript to enable sorting by columns. As an example, there's a jQuery plugin that does this: docs.jquery.com/Plugins/Tablesorter
Comments on this post
el zipa agrees: Great response, many thanks )
__________________
... I'll be back for breakfast
New to SEO? SEOChat SEO FAQs
Forum Rules and Posting Guidelines
URL canonicalization code solutions
Vigorously pursuing the floccinaucinihilipilification of cheap SEO tricks

Reply With Quote
  #3  
Old August 7th, 2008, 07:42 PM
el zipa el zipa is offline
Registered User
SEO Chat Newbie (0 - 499 posts)
 
Join Date: Aug 2008
Posts: 7 el zipa User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 21 m 11 sec
Reputation Power: 0
Thumbs up

Jag, thanks for the ideas, much appreciated.

So I'll stick with a plain HTML table to be sure about the indexing.

I really like that table sorting class, and will use it for sure.

Reply With Quote
Reply

Viewing: SEO Chat ForumsOtherSEO Help (General Chat) > Best solution for publishing table/grid?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT