Well, yeah, if you're into specifying font-face and size in each cell. Which doesn't matter with unlimited server capacity and 8G networks, but DOES for limited server space and dial-up. What's more, cleaning up Xcel's code is more time-consuming that doing it Pat's way in the first place. Cheryl Wjhonson wrote: > does not Excel have an ability to "Export as HTML" ? > I think it does > > > > > > > > -----Original Message----- > From: Pat Asher<pjroots@att.net> > To: rootsweb-help<rootsweb-help@rootsweb.com> > Sent: Mon, Jan 21, 2013 5:04 pm > Subject: Re: [ROOTSWEB-HELP] Search Routine > > > At 06:24 PM 1/20/2013, James R. Davis wrote: >> Pat, >> That is beautiful. Sorts like I wanted. Now how do I get my data >>from and Excel spreadsheet into the HTML code to create that table? >> Jim > > Spreadsheet to table is simply a matter of adding columns for the > appropriate table tags, e.g. > > <.tr><.td>DATA<./td><td>DATA<./td></.tr> > > Fill down, then copy and paste between<.table> and<./table> tags in > the HTML for any page. > > If you're asking about the specifics for the JavaScript, those > options are going to depend on the formatting of the data in your > spread sheets, see http://tablesorter.com/docs/ > > > Pat Asher >

At 08:20 PM 1/21/2013, Wjhonson wrote: >does not Excel have an ability to "Export as HTML" ? >I think it does It does, but with the bloated code it generates, a 20 row table could be 250kb instead of 50. I have been cleaning up a website where pages were generated from a word processor. One page was 795kb before cleaning, and 84kb after -- displaying exactly the same. It just takes a lot less time to load <g> Pat Asher

does not Excel have an ability to "Export as HTML" ? I think it does -----Original Message----- From: Pat Asher <pjroots@att.net> To: rootsweb-help <rootsweb-help@rootsweb.com> Sent: Mon, Jan 21, 2013 5:04 pm Subject: Re: [ROOTSWEB-HELP] Search Routine At 06:24 PM 1/20/2013, James R. Davis wrote: >Pat, > That is beautiful. Sorts like I wanted. Now how do I get my data >from and Excel spreadsheet into the HTML code to create that table? >Jim Spreadsheet to table is simply a matter of adding columns for the appropriate table tags, e.g. <.tr><.td>DATA<./td><td>DATA<./td></.tr> Fill down, then copy and paste between <.table> and <./table> tags in the HTML for any page. If you're asking about the specifics for the JavaScript, those options are going to depend on the formatting of the data in your spread sheets, see http://tablesorter.com/docs/ Pat Asher ------------------------------- To unsubscribe from the list, please send an email to ROOTSWEB-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Excel has an option to convert spread sheets to html but it adds a lot of unneeded junk. A web page that explains how to convert spreadsheets to html without the extra junk is here: http://borisbrooks.com/comp/xltables.htm. Jim Rickenbacker On 1/20/2013 5:24 PM, James R. Davis wrote: > Pat, > That is beautiful. Sorts like I wanted. Now how do I get my data > from and Excel spreadsheet into the HTML code to create that table? > Jim > > -----Original Message----- > From: rootsweb-help-bounces@rootsweb.com > [mailto:rootsweb-help-bounces@rootsweb.com] On Behalf Of Pat Asher > Sent: Sunday, January 20, 2013 5:09 AM > To: rootsweb-help@rootsweb.com > Subject: Re: [ROOTSWEB-HELP] Search Routine > > At 04:28 AM 1/20/2013, James R. Davis wrote: >> Or a corollary to this idea, how can we display the first page of a >> spreadsheet with column headers that are clickable to sort the >> spreadsheet by that field and maybe also sub-sort by other predefined >> fields? Of course we would also want to transition to subsequent pages of > the spreadsheet. >> James R. Davis. > Here is a JavaScript you can use to sort columns in a table. > > http://archiver.rootsweb.ancestry.com/th/read/Freepages-Help/2012-10/1349475 > 717 > > However, it will not grab lines from other web pages. Each table on each > web page will only sort itself. > > > Pat Asher > > > ------------------------------- > To unsubscribe from the list, please send an email to > ROOTSWEB-HELP-request@rootsweb.com with the word 'unsubscribe' without the > quotes in the subject and the body of the message > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSWEB-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message >

At 06:24 PM 1/20/2013, James R. Davis wrote: >Pat, > That is beautiful. Sorts like I wanted. Now how do I get my data >from and Excel spreadsheet into the HTML code to create that table? >Jim Spreadsheet to table is simply a matter of adding columns for the appropriate table tags, e.g. <.tr><.td>DATA<./td><td>DATA<./td></.tr> Fill down, then copy and paste between <.table> and <./table> tags in the HTML for any page. If you're asking about the specifics for the JavaScript, those options are going to depend on the formatting of the data in your spread sheets, see http://tablesorter.com/docs/ Pat Asher

Pat, That is beautiful. Sorts like I wanted. Now how do I get my data from and Excel spreadsheet into the HTML code to create that table? Jim -----Original Message----- From: rootsweb-help-bounces@rootsweb.com [mailto:rootsweb-help-bounces@rootsweb.com] On Behalf Of Pat Asher Sent: Sunday, January 20, 2013 5:09 AM To: rootsweb-help@rootsweb.com Subject: Re: [ROOTSWEB-HELP] Search Routine At 04:28 AM 1/20/2013, James R. Davis wrote: >Or a corollary to this idea, how can we display the first page of a >spreadsheet with column headers that are clickable to sort the >spreadsheet by that field and maybe also sub-sort by other predefined >fields? Of course we would also want to transition to subsequent pages of the spreadsheet. >James R. Davis. Here is a JavaScript you can use to sort columns in a table. http://archiver.rootsweb.ancestry.com/th/read/Freepages-Help/2012-10/1349475 717 However, it will not grab lines from other web pages. Each table on each web page will only sort itself. Pat Asher ------------------------------- To unsubscribe from the list, please send an email to ROOTSWEB-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Pat Asher wrote: > At 10:16 PM 1/19/2013, singhals wrote: >> I have a question about fillable-forms -- anyone have a >> family group sheet up where visitors can just fill in their >> info and e-mail it back to you? If so (a) where can I see >> it, and (b) can I crib the code for someone else? > > Instructions for using Mailmerge for a Family Group Sheet are here: > > http://freepages.computers.rootsweb.ancestry.com/~pasher/fgs.htm > > > Pat Asher Thanks, Pat! Cheryl

Here's a simpler approach. If your search key is the surname, then just export the information, TEXT only, (Excel is an ugly pig), one surname per HTML page. No searching is required. The users simply go to the page of that surname using Google. -----Original Message----- From: Dennis Wolstenholme <dennywj_8@hotmail.com> To: rootsweb-help <rootsweb-help@rootsweb.com> Sent: Sat, Jan 19, 2013 9:26 pm Subject: [ROOTSWEB-HELP] Search Routine I have a very large database that I would like to put up on my web site. I would like to have the capability to allow a user to search the database and have all the records return to them. I can have the records in an excel spreadsheet. Surname would be the primary field for the search. The records come from several sources, such as SSDI, cemeteries, vital records, etc. so there will be several hits for every query. Any body have a routine that will run on a rootsweb web site? Denny Wolstenholme ------------------------------- To unsubscribe from the list, please send an email to ROOTSWEB-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

At 04:28 AM 1/20/2013, James R. Davis wrote: >Or a corollary to this idea, how can we display the first page of a >spreadsheet with column headers that are clickable to sort the spreadsheet >by that field and maybe also sub-sort by other predefined fields? Of course >we would also want to transition to subsequent pages of the spreadsheet. >James R. Davis. Here is a JavaScript you can use to sort columns in a table. http://archiver.rootsweb.ancestry.com/th/read/Freepages-Help/2012-10/1349475717 However, it will not grab lines from other web pages. Each table on each web page will only sort itself. Pat Asher

At 12:25 AM 1/20/2013, Dennis Wolstenholme wrote: > I have a very large database that I would like to put up on my web > site. I would like to have the capability to allow a user to > search the database and have all the records return to them. I can > have the records in an excel spreadsheet. Surname would be the > primary field for the search. The records come from several > sources, such as SSDI, cemeteries, vital records, etc. so there > will be several hits for every query. Any body have a routine that > will run on a rootsweb web site? Denny Wolstenholme Users may not upload their own scripts to their web accounts at RootsWeb, nor may they upload a raw database file. However, a database in spreadsheet format (Excel for example) can easily be converted to HTML. To prevent bloated coding, I would suggest you do so manually by adding columns for the requisite table row <.tr> and table data <.td> columns. Copy and paste between <.table><./table> tags on a web page. You can the either sort the table by surname yourself before creating the actual web page(s) or; you could easily create an alphabetized index to unsorted pages. Just copy the name column to a new spreadsheet and add a page no. column with links. Fill down the page no./link columns before repeating with the names from the next page. Pat Asher

What version of Excel are you using, and how many rows and cold? One option is to save it as a web page, and folks would have a page search available. Gloria Sent from my iPhone On Jan 19, 2013, at 11:25 PM, Dennis Wolstenholme <dennywj_8@hotmail.com> wrote: > > I have a very large database that I would like to put up on my web site. I would like to have the capability to allow a user to search the database and have all the records return to them. I can have the records in an excel spreadsheet. Surname would be the primary field for the search. The records come from several sources, such as SSDI, cemeteries, vital records, etc. so there will be several hits for every query. Any body have a routine that will run on a rootsweb web site? Denny Wolstenholme > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSWEB-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Or a corollary to this idea, how can we display the first page of a spreadsheet with column headers that are clickable to sort the spreadsheet by that field and maybe also sub-sort by other predefined fields? Of course we would also want to transition to subsequent pages of the spreadsheet. James R. Davis. -----Original Message----- From: rootsweb-help-bounces@rootsweb.com [mailto:rootsweb-help-bounces@rootsweb.com] On Behalf Of Dennis Wolstenholme Sent: Saturday, January 19, 2013 9:26 PM To: rootsweb-help@rootsweb.com Subject: [ROOTSWEB-HELP] Search Routine I have a very large database that I would like to put up on my web site. I would like to have the capability to allow a user to search the database and have all the records return to them. I can have the records in an excel spreadsheet. Surname would be the primary field for the search. The records come from several sources, such as SSDI, cemeteries, vital records, etc. so there will be several hits for every query. Any body have a routine that will run on a rootsweb web site? Denny Wolstenholme

I have a very large database that I would like to put up on my web site. I would like to have the capability to allow a user to search the database and have all the records return to them. I can have the records in an excel spreadsheet. Surname would be the primary field for the search. The records come from several sources, such as SSDI, cemeteries, vital records, etc. so there will be several hits for every query. Any body have a routine that will run on a rootsweb web site? Denny Wolstenholme

At 10:16 PM 1/19/2013, singhals wrote: >I have a question about fillable-forms -- anyone have a >family group sheet up where visitors can just fill in their >info and e-mail it back to you? If so (a) where can I see >it, and (b) can I crib the code for someone else? Instructions for using Mailmerge for a Family Group Sheet are here: http://freepages.computers.rootsweb.ancestry.com/~pasher/fgs.htm Pat Asher

I have a question about fillable-forms -- anyone have a family group sheet up where visitors can just fill in their info and e-mail it back to you? If so (a) where can I see it, and (b) can I crib the code for someone else? Thanks! Cheryl cc WVHampsh

At 05:54 AM 10/9/2012, David Railton wrote: >Does anyone else use BT Broadband and have problems with messages from Lists >being treated by them as spam. I have always had the occasional Rootsweb >list message treated as spam but there has a big increase in the last few >weeks. I have spoken to BT Broadband help about this but can get no sense >out of them. David, all you can do is explain to them that this is mail you have asked to receive. You not only have to actively subscribe, but you have to confirm that subscription. But because of the volume of mail sent by RootsWeb, convincing them will not be easy. Good luck. Pat Asher

Does anyone else use BT Broadband and have problems with messages from Lists being treated by them as spam. I have always had the occasional Rootsweb list message treated as spam but there has a big increase in the last few weeks. I have spoken to BT Broadband help about this but can get no sense out of them. I would be interested to hear from anyone who has the same problem and has successfully dealt with it. David

At 03:13 PM 10/1/2012, you wrote: >We are not familiar with html or ccs coding beyond the very basics and >relied on Expression Web at the end to produce a viable website. It did, >however, for some reason the Rootsweb banner is not positioned correctly. >We would appreciate any suggestions for changes that could be made to the >code to change the Rootsweb banner in the top position. ============== http://www.rootsweb.ancestry.com/~pagvcdar/ Expression Web is NOT a WYSIWYG web editor. You might want to read this first http://support.microsoft.com/default.aspx?scid=kb;en-US;2511858 EW expects you to have at least a basic understand of writing CSS and HTML and how to use it. I'm not sure why you did not use EW to develop and publish the site. Take a look at http://www.expression-web-tutorials.com/ocean/ which uses a one column layout. If you look at the source code you can see the difference in what you have and what this template uses. SUGGESTIONS: pt font sizes are used for print NOT for web design. Use em or % or small, medium, large, etc. A basic layout would consist of the following: <.div id="wrapper"> <.div id="banner"> </div> <.div id="menu"> </div> <.div id="content"> all of your content goes in this area. </div> </div> The id wrapper holds the entire content of your page banner holds your top banner menu holds your menu content is the actual content of the site. You also might find this helpful http://www.expression-web-tutorials.com/ew4-tutorials-ebook.html This is our chapter site http://www.rootsweb.ancestry.com/~vamscdar/index.htm which happens to use a left navigation menu rather than top. If you are interested, I will be glad to work with you on your site. pat Pat Geary Working With Rootsweb FreePages Accounts EBook (free) http://freepages.genealogy.rootsweb.ancestry.com/~gearyfamily/rootsweb-freepages-ebook.html

I suspect you're positioning your own banner at the *absolute* top of your page, instead of the relative top of its container. Something like that. -----Original Message----- From: Edward M. Wylonis <ewylonis@verizon.net> To: ROOTSWEB-HELP <ROOTSWEB-HELP@rootsweb.com> Sent: Mon, Oct 1, 2012 12:14 pm Subject: [ROOTSWEB-HELP] Top Rootsweb Banner in wrong position We have completed our freepages website and find that the Rootsweb top banner is positioned to the right of our webpage at the top. In order to see it you must zoom the page out three or four times. I use Firefox. We developed the website using Webeasy Version 8 for most of the website and Expression Web 4 to tweak some of the code and publish the website. Webeasy doesn't show you the code so we switched to Expression Web. I contacted Rootsweb support about the problem and they suggested that I get help here. We are not familiar with html or ccs coding beyond the very basics and relied on Expression Web at the end to produce a viable website. It did, however, for some reason the Rootsweb banner is not positioned correctly. We would appreciate any suggestions for changes that could be made to the code to change the Rootsweb banner in the top position. The link to the website is as follows: http://www.rootsweb.ancestry.com/~pagvcdar/ Thanks, Ed Wylonis ------------------------------- To unsubscribe from the list, please send an email to ROOTSWEB-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

We have completed our freepages website and find that the Rootsweb top banner is positioned to the right of our webpage at the top. In order to see it you must zoom the page out three or four times. I use Firefox. We developed the website using Webeasy Version 8 for most of the website and Expression Web 4 to tweak some of the code and publish the website. Webeasy doesn't show you the code so we switched to Expression Web. I contacted Rootsweb support about the problem and they suggested that I get help here. We are not familiar with html or ccs coding beyond the very basics and relied on Expression Web at the end to produce a viable website. It did, however, for some reason the Rootsweb banner is not positioned correctly. We would appreciate any suggestions for changes that could be made to the code to change the Rootsweb banner in the top position. The link to the website is as follows: http://www.rootsweb.ancestry.com/~pagvcdar/ Thanks, Ed Wylonis