Problem with validating a spreadsheet import.
Duz
Got a problem . Since you introduced me to "Validating" with FireFox,
I've been using FireFox exclusively for proof editing my pages. I've
done quite a few more pages since I last checked in with you, and
Toiletology.com has remained on page one for Google Search on "toilet"
now for over a month. It moves up and down from 3-9, and most times
we have two listings. I am a believer.
However, this morning my son who uses Internet Explorer found a page
< http://www.toiletology.com/toiletoogy-INDEX.shtml > will not open .
The background opens but nothing else. At first he thought it was his
computer, but when I checked I couldn't open it either. It still
opens in FireFox just fine.
FireFox validation shows 4 errors. Out of almost 100 pages this is the
only page I have not gotten a green OK on validation. I was going to
ask you about this but had not gotten around to it. This page has an
imported Excel spreadsheet as the content.
When you get a few minutes, could you please take a look at the source
code and tell me what I've done wrong? So far, this is the only page
we've found that has this problem ... so I'm assuming it is the
spreadsheet.
Duz
webado
--
www.webado.net
Webhosting and Design
Duz
>
Duz
=========================================
On Nov 1, 4:28 pm, webado <web...@gmail.com> wrote:
> That utl gives a 404 - the page does not exist.
>
> It will give a 404 in IE, FF and any other browser.
>
Sheryl Todd
Duz <kay.k...@ayrlawn.com> wrote:
Oh sorry. Misspelled the address ...< http://www.toiletology.com/Toiletology-INDEX.shtml
>
Duz
=========================================
On Nov 1, 4:28 pm, webado wrote:
> That utl gives a 404 - the page does not exist.
>
> It will give a 404 in IE, FF and any other browser.
>
> On 11/1/07, Duz wrote:
>
>
>
>
>
> > Hello Webado,
> > Got a problem . Since you introduced me to "Validating" with FireFox,
> > I've been using FireFox exclusively for proof editing my pages. I've
> > done quite a few more pages since I last checked in with you, and
> > Toiletology.com has remained on page one for Google Search on "toilet"
> > now for over a month. It moves up and down from 3-9, and most times
> > we have two listings. I am a believer.
>
> > However, this morning my son who uses Internet Explorer found a page
> > will not open .
> > The background opens but nothing else. At first he thought it was his
> > computer, but when I checked I couldn't open it either. It still
> > opens in FireFox just fine.
>
> > FireFox validation shows 4 errors. Out of almost 100 pages this is the
> > only page I have not gotten a green OK on validation. I was going to
> > ask you about this but had not gotten around to it. This page has an
> > imported Excel spreadsheet as the content.
>
> > When you get a few minutes, could you please take a look at the source
> > code and tell me what I've done wrong? So far, this is the only page
> > we've found that has this problem ... so I'm assuming it is the
> > spreadsheet.
> > Duz
>
> --www.webado.net
> Webhosting and Design
Sheryl Todd
President
Tapir Preservation Fund
http://www.tapirback.com/tapirgal/
Member, IUCN/SSC Tapir Specialist Group
Tapirs Google Group and E-mail List:
http://groups.google.com/group/tapirs
orego...@yahoo.com
ta...@tapirback.com
(503) 325-3179 . (503) 338-8646
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
webado
It was basiclaly that xml crap that was killing it. No idea what it
was meant to be and when it was meant to actually show anywhitn. I
remoevd it and fixed up the on-page css (lots of MS specific stuff
which is useless and invalid).
This zip file contians the fixed page:
http://only-validation.googlegroups.com/web/new-toiletology-INDEX.zip?gda=KXt1iEoAAADP1c1lFOGWI7vjPxWNg5wp5GPEex0q3CjqoPmWyZOYxGG1qiJ7UbTIup-M2XPURDQ9uAweqDi4KIP0VoAVRJ88LVYXi9D8UAWQhwehNjSrsA
It's is suffixed .shtml but obviously I have no way of knowing what
you include, so it's in fact the full page with all includes resolved.
You need to figure out what came from which include.
On Nov 1, 6:39 pm, Sheryl Todd <oregonta...@yahoo.com> wrote:
> Hi,
>
> I can't see anything except the background on my computer, either. I'm using IE6 with Windows XP.
>
> Sorry! I don't read javascript, so I can't offer any suggestions. . . .
>
> Sheryl
>
> Tapir Preservation Fundhttp://www.tapirback.com/tapirgal/
> Member, IUCN/SSC Tapir Specialist Group
>
> Tapirs Google Group and E-mail List:http://groups.google.com/group/tapirs
>
> ta...@tapirback.com
> (503) 325-3179 . (503) 338-8646
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection aroundhttp://mail.yahoo.com- Hide quoted text -
>
> - Show quoted text -
webado
first put through Tidy. Not sure what it fixed before I went to
manually fix things myself.
On Nov 1, 7:21 pm, webado <web...@gmail.com> wrote:
> I got it, ladies :)
>
> It was basiclaly that xml crap that was killing it. No idea what it
> was meant to be and when it was meant to actually show anywhitn. I
> remoevd it and fixed up the on-page css (lots of MS specific stuff
> which is useless and invalid).
>
> This zip file contians the fixed page:http://only-validation.googlegroups.com/web/new-toiletology-INDEX.zip...
> > Tired of spam? Yahoo! Mail has the best spam protection aroundhttp://mail.yahoo.com-Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
Duz
I've worked with this too much for now; I'm going to bed. I'll give
it another try tomorrow. I may just give up on the idea of using a
spreadsheet to get an index.
Duz
==========================================
Christina S
Did you use the file I gave you?
Excel spreadsheets are tricky to export to html. They used to be pretty OK
in Offfice 97, but anything later makes a hash of them.
If you are trying to include the spreadsheet data on the fly that won't
work.
Christina
www.webado.net
Duz
Yes, I unzipped the file you sent and tried to open it in my editor
without making any changes, but I get a "Stack Overload at line 1590"
error and the editor freezes. I'm not trying to include the
spreadsheet on the fly ... whatever that means.
Earlier you said, "... basically that xml crap that was killing it."
I did a search for "xml" but can't find any mention of it in the
file.
Me thinks, I'm in over my head.
Duz
Sheryl Todd
Sheryl Todd
President
Tapir Preservation Fund
http://www.tapirback.com/tapirgal/
Member, IUCN/SSC Tapir Specialist Group
Tapirs Google Group and E-mail List:
http://groups.google.com/group/tapirs
webado
comment (but obviously it is not treated as an html comment).
<!--
[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
<x:HorizontalResolution>-2</x:HorizontalResolution>
<x:VerticalResolution>0</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>67</x:ActiveRow>
<x:ActiveCol>2</x:ActiveCol>
<x:RangeSelection>$A$1:$C$68</x:RangeSelection>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
<x:Sorting>
<x:Sort>Column A</x:Sort>
</x:Sorting>
<x:PublishObjects>
<x:PublishObject>
<x:Id>7943</x:Id>
<x:DivID>ToiletologyINDEX_7943</x:DivID>
<x:SourceType>SourceRange</x:SourceType>
<x:Source>$B$1:$B$123</x:Source>
<x:HtmlType>HtmlStatic</x:HtmlType>
<x:Location HRef="C:\Data Files\~2004-Toiletology
\Index.shtml.htm"/>
</x:PublishObject>
<x:PublishObject>
<x:Id>27208</x:Id>
<x:DivID>ToiletologyINDEX_27208</x:DivID>
<x:SourceType>SourceRange</x:SourceType>
<x:Source>$B$2:$B$124</x:Source>
<x:HtmlType>HtmlStatic</x:HtmlType>
<x:Location
HRef="C:\Data Files\~2004-Toiletology\ToiletologyINDEX-
x.shtml.htm"/>
</x:PublishObject>
</x:PublishObjects>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet3</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>9210</x:WindowHeight>
<x:WindowWidth>11355</x:WindowWidth>
<x:WindowTopX>480</x:WindowTopX>
<x:WindowTopY>90</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1025"/>
</xml><![endif]
-->
Take that out and you're in business and all thats' needed after that
is to fix the rest of the code for some other validation errors (html
and css).
No idea why you aren't able to open the file I gave you in the
browser. Did you uplaod it and open it on the site?
Anyway, here it is on my test site: http://toiletology.client.webado.net/new-Toiletology-INDEX.shtml
webado
all the pages you have, which is what any robtos will discover as
well:
http://home.snafu.de/tilman/xenulink.html
It will also tell you about any broken and/or redirected links (to
pages, images or scripts) you may have so you can fix them.
You can also download and install the program GsiteCrawler form
http://gsitecrawler.com which can produce a perfect Google sitemap in
xml format (or other) that you can submit.
On Nov 2, 2:51 pm, Sheryl Todd <oregonta...@yahoo.com> wrote:
> Hi Duz,
>
> First, sorry for the double reply. I meant to post to the group with your question.
>
> I'm using the Google Webmaster Tools on the Google site. I went to the Tools link and then Set Crawl Rate. I'm not setting anything, but that page will show you 3 graphs about Google crawling your site. The top one is pages crawled per day, the next is about kbs downloaded during the crawl, and the last is how long it took. On the right are the numbers. The max pages crawled on a single day was 1173. On my graph, it's clear which day that was. It's a big spike. The graph shows about 3 months, and I'm only remembering last year for comparison. You also have to guess which day it is, but on another part of the Google Webmaster area, I saw which days certain pages were crawled. I don't actually have a page count for my whole site (does anyone know how to get that?). I do know I have approx 1173 (?) to 1500 pages. I can check the entire number of files on my hard drive, because I have a complete copy, but a lot of them are pictures and thumbnails. I don't know how to see the
> difference in file types with the Properties thing in Windows. So I'm only guessing it went through most of the site on that day.
>
> If you need further direction to the Webmaster Tools, let me know. It's been improved and really helps sort things out. I've got another post coming in a few minutes about using another part of these tools and QUESTIONS!!! :)
>
> By the way, I like your site. I also like this smaller forum. It seems there's nice help here.
>
> Sheryl
>
> Sheryl Todd
> President
> Tapir Preservation Fundhttp://www.tapirback.com/tapirgal/
> Member, IUCN/SSC Tapir Specialist Group
>
> Tapirs Google Group and E-mail List:http://groups.google.com/group/tapirs
>
Duz
errors that I had to start with. If you can also tell me how to fix
that "SHORTTAG YES" warning, I'll be able to fix a few thousand
others from the other pages that I've validated.
Duz
Validation Output: 4 Errors
1. Error Line 60, Column 35: character "\" not allowed in attribute
specification list.
{mso-displayed-decimal-separator:"\.";
✉
2. Warning Line 397, Column 494: NET-enabling start-tag requires
SHORTTAG YES.
… !important; margin:0px !important;" />
✉
The sequence <FOO /> can be interpreted in at least two
different ways, depending on the DOCTYPE of the document. For HMTL
4.01 Strict, the '/' terminates the tag <FOO (with an implied '>').
However, since many browsers don't interpret it this way, even in the
presence of an HMTL 4.01 Strict DOCTYPE, it is best to avoid it
completely in pure HTML documents and reserve its use solely for those
written in XHTML.
3. Error Line 419, Column 13: "X:STR" is not a member of a group
specified for any attribute.
<table x:str border=0 cellpadding=0 cellspacing=0 width=548
style='border-collap
✉
4. Error Line 424, Column 12: there is no attribute "HEIGHT".
<tr height=17 style='height:12.75pt'>
✉
You have used the attribute named above in your document, but
the document type you are using does not support that attribute for
this element. This error is often caused by incorrect use of the
"Strict" document type with a document that uses frames (e.g. you must
use the "Transitional" document type to get the "target" attribute),
or by using vendor proprietary extensions such as "marginheight" (this
is usually fixed by using CSS to achieve the desired effect instead).
This error may also result if the element itself is not
supported in the document type you are using, as an undefined element
will have no supported attributes; in this case, see the element-
undefined error message for further information.
How to fix: check the spelling and case of the element and
attribute, (Remember XHTML is all lower-case) and/or check that they
are both allowed in the chosen document type, and/or use CSS instead
of this attribute. If you received this error when using the <embed>
element to incorporate flash media in a Web page, see the FAQ item on
valid flash.
5. Error Line 450, Column 23: there is no attribute "X:STR".
<td class=xl27 x:str="Anatomy "><a
✉
You have used the attribute named above in your document, but
the document type you are using does not support that attribute for
this element. This error is often caused by incorrect use of the
"Strict" document type with a document that uses frames (e.g. you must
use the "Transitional" document type to get the "target" attribute),
or by using vendor proprietary extensions such as "marginheight" (this
is usually fixed by using CSS to achieve the desired effect instead).
This error may also result if the element itself is not
supported in the document type you are using, as an undefined element
will have no supported attributes; in this case, see the element-
undefined error message for further information.
How to fix: check the spelling and case of the element and
attribute, (Remember XHTML is all lower-case) and/or check that they
are both allowed in the chosen document type, and/or use CSS instead
of this attribute. If you received this error when using the <embed>
element to incorporate flash media in a Web page, see the FAQ item on
valid flash.
webado
Anyway, the SHORTTAG thign means do not close that tag with /> but
rather with > because you are not using an xhtml doctype.
Take out ALL the elements using mso- whatever in the style tag. This
too I did in the file I sent you. open it in Notepad and copy that
whole style tag and replace the one you have.
For this:
<td class=xl27 x:str="Anatomy ">
just write it as:
<td class="xl27" >
Not sure what it was meant to do, but it's nothing good:)
There is no such attribute for anyhting as x:str='...' . It's just
soemthign only Microsoft uses and understands and only when it
generates the html from its own applications like Excel or Word or
such. Once that's doen thsoe ought to have been removed but it failed
there adn kept them. Boo!
webado
there. Take that out. The table row (<tr>) takes its height from the
cells (<td> tags) in the row.
Just like you don't use height for table tag either.
All this I fixed in the file I sent you. Just go through it and pick
the relevant portions and replace them in the files you include to
create that page.
On Nov 2, 5:06 pm, Duz <kay.keat...@ayrlawn.com> wrote:
Duz
I've spend the best part of this afternoon working on my Index
Page < http://www.toiletology.com/Toiletology-INDEX.shtml >.
I finally got it to validate with "0" errors and "0" warnings.
Hurrrrrrrrrrray .
The fixed file you sent would not open properly. After I opened the
zip file, most of the file was one long running sentence. Extremely
difficult to read. Some of the graphics moved around the page.
However, I was able to select sections and import them into the
original file. This worked.
The errors and warnings were from html code written by Amazon and
Microsoft. I would have thought code written by their professional
writers would be perfect and surely would validate.
I'm very happy to learn how to correct those "warnings". I have
hundreds in the files I've already validated. How important do you
think it is to correct the warnings? I suspect most of them are the
Amazon code, and if I get enough of the SSI files corrected it may not
be the monumental undertaking it appears to be now.
Webado, I can't thank you enough for your help. I greatly appreciate
your time and efforts. Perhaps one day I can return the favor.
Duz
Sheryl Todd
President
Tapir Preservation Fund
http://www.tapirback.com/tapirgal/
Member, IUCN/SSC Tapir Specialist Group
Tapirs Google Group and E-mail List:
http://groups.google.com/group/tapirs
Sheryl Todd
Sheryl Todd
President
Tapir Preservation Fund
http://www.tapirback.com/tapirgal/
Member, IUCN/SSC Tapir Specialist Group
Tapirs Google Group and E-mail List:
http://groups.google.com/group/tapirs
webado
I also did install it at the address I gave you. Surely that opened ok
for you?
http://toiletology.client.webado.net/new-Toiletology-INDEX.shtml
All you need is to view source and copy it if the zip failed you.
webado
Amazon so they will be valid.
On Nov 3, 7:23 pm, webado <web...@gmail.com> wrote:
> Oh hmmm. I wonder what mess Google Groups did when I uploded the file.
>
> I also did install it at the address I gave you. Surely that opened ok
> for you?http://toiletology.client.webado.net/new-Toiletology-INDEX.shtml
> > Duz- Hide quoted text -
webado
something. maybe images from other sites, or scripts from other site.
Theres' no graphic missing.
Maybe you have something like an adblocker.
On Nov 3, 5:55 pm, Sheryl Todd <oregonta...@yahoo.com> wrote:
> Hi Duz,
>
> The file opens fine for me now, too, and the only thing missing is a graphic or link on the right-hand side just under the navigation bar of your page. It comes out plain white.
>
> Congratulations! Don't we learn a lot doing this :)
>
> Sheryl
>
> Duz <kay.keat...@ayrlawn.com> wrote:
>
> Hello Webado,
>
> I've spend the best part of this afternoon working on my Index
> Page <http://www.toiletology.com/Toiletology-INDEX.shtml>.
> I finally got it to validate with "0" errors and "0" warnings.
> Hurrrrrrrrrrray .
>
> The fixed file you sent would not open properly. After I opened the
> zip file, most of the file was one long running sentence. Extremely
> difficult to read. Some of the graphics moved around the page.
> However, I was able to select sections and import them into the
> original file. This worked.
>
> The errors and warnings were from html code written by Amazon and
> Microsoft. I would have thought code written by their professional
> writers would be perfect and surely would validate.
>
> I'm very happy to learn how to correct those "warnings". I have
> hundreds in the files I've already validated. How important do you
> think it is to correct the warnings? I suspect most of them are the
> Amazon code, and if I get enough of the SSI files corrected it may not
> be the monumental undertaking it appears to be now.
>
> Webado, I can't thank you enough for your help. I greatly appreciate
> your time and efforts. Perhaps one day I can return the favor.
>
> Duz
>
> Sheryl Todd
> President
> Tapir Preservation Fundhttp://www.tapirback.com/tapirgal/
> Member, IUCN/SSC Tapir Specialist Group
>
> Tapirs Google Group and E-mail List:http://groups.google.com/group/tapirs
>
Duz
You are very nice to help check on my pages. That graphic that isn't
showing on your screen is an ad for Auction Ads and sometimes it is
very slow to load. It is showing on both FireFox and IE on my
machine.
We certainly do learn a lot and there is so much more that I need to
learn. You'd think after 12 years of working on this site, I'd be
better at it than I am. Much of what I try to do is over my head.
This index is a good example; I do the index in Excel and then let
Excel convert it to html and expect it to work;amazingly it does in
many cases. I need to learn more about Xenu; I tried it several
months ago, but didn't really understand what I was getting.
Webado is incredibly good at promptly responding and then fixing
problems and explaining them. This group while small is a wonderful
resource.
Cheers, Duz
Sheryl Todd
Sheryl, your browser's security/privacy settings must be set to block
something. maybe images from other sites, or scripts from other site.
Theres' no graphic missing.
Maybe you have something like an adblocker.
On Nov 3, 5:55 pm, Sheryl Todd wrote:
> Hi Duz,
>
> The file opens fine for me now, too, and the only thing missing is a graphic or link on the right-hand side just under the navigation bar of your page. It comes out plain white.
>
> Congratulations! Don't we learn a lot doing this :)
>
> Sheryl
>
> Duz wrote:
>
> Hello Webado,
>
> I've spend the best part of this afternoon working on my Index
> Page .
Duz
I "fixed" about a dozen SSI files and solved all the "warning"
messages I was getting when I validated. They were all Amazon
problems. There are probably more, but I think I've caught most of
them. That was almost too easy.
Duz
webado
> > Amazon so they will be valid.- Hide quoted text -
Sheryl Todd
Sheryl Todd
President
Tapir Preservation Fund
http://www.tapirback.com/tapirgal/
Member, IUCN/SSC Tapir Specialist Group
Tapirs Google Group and E-mail List:
http://groups.google.com/group/tapirs
webado
On Nov 4, 7:06 pm, Sheryl Todd <oregonta...@yahoo.com> wrote:
> Hi Duz,
>
> I've "only" been working on my site for 11 years, and have a lot to learn :) Nearly 12 years. I started in January 2006. Webado helped me get out of a horrible situation with my site last November to January. I was thrilled to find this small group. As I have a lot more validating and upgrading to do, I'll be here! It's nice to be getting to know you.
>
> Sheryl
>
> Sheryl Todd
> President
> Tapir Preservation Fundhttp://www.tapirback.com/tapirgal/
> Member, IUCN/SSC Tapir Specialist Group
>
> Tapirs Google Group and E-mail List:http://groups.google.com/group/tapirs
>
Sheryl Todd
Sheryl Todd
President
Tapir Preservation Fund
http://www.tapirback.com/tapirgal/
Member, IUCN/SSC Tapir Specialist Group
Tapirs Google Group and E-mail List:
http://groups.google.com/group/tapirs
Sheryl Todd
Sheryl Todd
President
Tapir Preservation Fund
http://www.tapirback.com/tapirgal/
Member, IUCN/SSC Tapir Specialist Group
Tapirs Google Group and E-mail List:
http://groups.google.com/group/tapirs
webado
www.webado.net
Webhosting and Design
Sheryl Todd
webado
And I'm posting this at about 7:12pm EST.
Sheryl Todd
webado
If only you'd check this by coming to the group rather than just
answering emails you'd see :)
You got another thread which you seem to have lost track of:
http://groups.google.com/group/only-validation/browse_thread/thread/63ee2fd419b4e213
On Nov 6, 7:20 pm, Sheryl Todd <oregonta...@yahoo.com> wrote:
> Sorry, I'm rushing and sleepy. I didn't clarify that the e-mails were coming in halfway down the page in my Yahoo mailbox. That's why I overlooked your reply for a day, I didn't see it. Interestingly, this one came in at the top of my mailbox. Anyway, I know where to look for them now. Thanks for all your help. Actually, this is my thread :)
>
> Question: Since Sergio is posting our pages in Spanish, don't we need a different designation instead of EN at the top of the page? Unless you know already, either he or I can do the research. I was looking on the w3c page today and found that there's a lot of info in Spanish, too.
>
> There is still sooooooooo much to learn. If we let Tidy online do the page corrections for us, it changes a lot of font sizes, which then have to be re-coded. We're still working on the best way to do the cleanup in English and transition to Spanish. Actually, Dreamweaver did the same thing with my fonts, so clearly they are confusing to the software.
>
> Sheryl
>
> Sheryl Todd
> President
> Tapir Preservation Fundhttp://www.tapirback.com/tapirgal/
> Member, IUCN/SSC Tapir Specialist Group
>
> Tapirs Google Group and E-mail List:http://groups.google.com/group/tapirs
>