I have a spread sheet of Rev War Burials and would like to post this information on my rootsweb homepage. If I cut the spread sheet to only the data I wish to post it would be 200 rows and six columns. Any suggestions on the easiest way to code this for a rootsweb page? I've written the code for all my pages with notepad++. -- For Coyne, Cohen, Zick, Calkins, Kipers, Twitchell, Overend, Barron, Zick, Friberg and Engle in central New York visit my Homepage <http://freepages.genealogy.rootsweb.ancestry.com/%7Ecoyne2010/%0A> and follow the link to my tree. Also on Ancestry as Coyne2010. Hundreds of obits and weddings announcements in full. Revolutionary war veterans in Jefferson <http://www.findagrave.com/cgi-bin/fg.cgi?page=vcsr&GSvcid=237560> & Lewis <http://www.findagrave.com/cgi-bin/fg.cgi?page=vcsr&GSvcid=384130> county NY listed on findagrave.com.
At 06:35 PM 7/12/2013, you wrote: >I'm now wondering if it could have been CenturyLink, my internet >provider, that added the link? I have seen before where CenturyLink >would add a link to a date or some other information in my >email. God, I hate CenturyLink. Paul, The coding is in the page you, or someone to whom you gave access, uploaded to your Freepage site. Neither Freepages nor CenturyLink would create a link to another page on your site. The simple answer is to just remove the coding from the copy of the page on your computer. and upload the revised page to your Freepages web space. Pat Asher
I'm now wondering if it could have been CenturyLink, my internet provider, that added the link? I have seen before where CenturyLink would add a link to a date or some other information in my email. God, I hate CenturyLink. Paul ------------------------------ Message: 7 Date: Thu, 11 Jul 2013 21:27:50 -0400 From: JFlorian <cageycat@gmail.com> Subject: Re: [FreeHelp] Links I did not create To: freepages-help@rootsweb.com Message-ID: <CAE5hz-CJkYapmj7teSO5+UQf_OzPQ=oWa3ytXU0j8T-NCEFfLQ@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Unless I misunderstood your question, I disagree that Ancestry inserted the link. First, Ancestry would keep their inserted data with their banner. None of my freepages have a link inserted by ancestry, except the banner. The line is *Click **here*<http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm> * to see current special deals on DNA testing! -- The link is on the word "here". **There is NO link on the words "DNA Testing".* * * Second, if you View Source, the link was inserted in MS Word starting here (minus the dots): <....p class=MsoNormal><....b style='mso-bidi-font-weight:normal'><span style='font-family:"Verdana","sans-serif";mso-bidi-font-family:Arial; color:red'>Click </span></b><a href=" http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm "><b style='mso-bidi-font-weight:normal'><span style='font-family:"Verdana","sans-serif"; mso-bidi-font-family:Arial;color:red'>here</span></b></a><b style='mso-bidi-font-weight: normal'><span style='font-family:"Verdana","sans-serif";mso-bidi-font-family: Arial;color:red'> to see current special deals on DNA testing!<o:p></o:p></span></b></p> The link goes to here on your site: http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm Those percent 20 in your file name reflects a space between words. It makes shorter links if you use underscore or hyphen between words. Judy On Thu, Jul 11, 2013 at 8:33 PM, PAUL SHEATS Owner <paul.sheats@q.com>wrote:
Judy Numbering rows is easiest in Excel. We have had threads about converting Excel tables to HTML based around the HTML for a cell value in say A2 using a formula like ="<td>"&if(len(A2)=0," ",A2)&"</td>" Copying a table in Word and pasting in Excel converts it to a Excel then you can use formulae to create the HTML. See: http://members.iinet.net.au/~nickred/temp/little_table.xls Regards Nick My Sites My home <http://members.iinet.net.au/%7Enickred/> My newspaper extracts <http://members.iinet.net.au/%7Enickred/newspaper/index.html> Registry of Deeds Index Project <http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> Managed Sites Irish Genealogical Research Society <http://www.igrsoc.org/index.htm> Majura tennis Club <http://members.iinet.net.au/%7Enickred/majuratennis/> On 12/07/2013 5:00 PM, freepages-help-request@rootsweb.com wrote: > Another bad lesson: Manually inserting Row Number on a table with hundreds > of numbers----argggh, similar to:: pull out my thick hair strand by > strand! Never again. > > Judy
That hurts me to think of you hand coding all those Judy. Have you tried the spreadsheet on Open Office? http://freedownloads.us.com/products/openoffice2/suite.php?pk=11153 My brother has this and he swears by it. Jill -----Original Message----- From: freepages-help-bounces@rootsweb.com [mailto:freepages-help-bounces@rootsweb.com] On Behalf Of JFlorian Sent: 12 July 2013 16:55 To: freepages-help@rootsweb.com Subject: Re: [FreeHelp] FREEPAGES-HELP Digest, Vol 8, Issue 93 Hi Nick, There are many people who don't have Excel or Office Suite, or know how to use Excel. I'll be hand-numbering until I get a gift of the program. Judy On Fri, Jul 12, 2013 at 4:16 AM, Nick Reddan <nickred@webone.com.au> wrote: > Judy > > Numbering rows is easiest in Excel. We have had threads about > converting Excel tables to HTML based around the HTML for a cell value > in say A2 using a formula like ="<td>"&if(len(A2)=0," ",A2)&"</td>" > > Copying a table in Word and pasting in Excel converts it to a Excel > then you can use formulae to create the HTML. > > See: > http://members.iinet.net.au/~nickred/temp/little_table.xls > > > Regards > > > Nick ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message
No, but I will-- thanks! Judy On Fri, Jul 12, 2013 at 1:05 PM, Jill Muir <jill@shottle.plus.com> wrote: > That hurts me to think of you hand coding all those Judy. Have you tried > the spreadsheet on Open Office? > http://freedownloads.us.com/products/openoffice2/suite.php?pk=11153 > > My brother has this and he swears by it. > > Jill
Paul wrote: "I just discovered that a link is appearing on my home page that I did not create. Did Rootsweb Free pages create this link automatically, or did something else create it?" The offending code is in lines 1021-1031 of the generated page, as follows: <p class=MsoNormal><b >Click </b><a href="http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20d na%20project%20-%20hot%20deals.htm"><b style='mso-bidi-font-weight:normal'><span style='font- family:"Verdana","sans-serif"; mso-bidi-font-family:Arial;color:red'>here</span></b></a><b style='mso-bidi-font-weight:normal'> <span style='font-family:"Verdana","sans-serif";mso-bidi-font- family: Arial;color:red'> to see current special deals on DNA testing!<o:p></o:p></span></b></p> Stripping out the code bloat, it's: <p><span style='color:red'>Click <b> <a href="http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20d na%20project%20-%20hot%20deals.htm"><b>here</b></a> to see current special deals on DNA testing!</b></span></p> I can tell you for sure that Freepages did not create this; a person -- not an IT professional -- did. It has the earmarks of MS Word -> HTML saving. Further, the link is to a page on the ~sheetsdna site named "sheets%20dna%20project%20-%20hot%20deals.htm". (Bad file naming; shouldn't use spaces.) Are you sure one of your project co-admins didn't do this? Do any have read/write (uploading) access to the site? If so, you might want to have a discussion. -rt_/) Date: Thu, 11 Jul 2013 20:33:23 -0400 (EDT) From: PAUL SHEATS Owner <paul.sheats@q.com> Subject: [FreeHelp] Links I did not create To: freepages-help@rootsweb.com Message-ID: <1531352731.1980660.1373589203418.JavaMail.root@md09.quartz.synacor.com> Content-Type: text/plain; charset=utf-8 Hi all, I just discovered that a link is appearing on my home page that I did not create. Did Rootsweb Free pages create this link automatically, or did something else create it? My home page is here: http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20p roject%20-%20home.htm Near the top, in RED, it says "Click here to see current special deals on DNA testing!". The link I am wondering about is on "DNA testing". Any ideas? Thanks. Paul
I use Libre Office, basically Open Office. It works very well but it still adds a lot of unnecessary "stuff". Not as bad as MS Office, but......... On 07/12/2013 01:22 PM, JFlorian wrote: > No, but I will-- thanks! > > Judy > > On Fri, Jul 12, 2013 at 1:05 PM, Jill Muir <jill@shottle.plus.com> wrote: > >> That hurts me to think of you hand coding all those Judy. Have you tried >> the spreadsheet on Open Office? >> http://freedownloads.us.com/products/openoffice2/suite.php?pk=11153 >> >> My brother has this and he swears by it. >> >> Jill > > ------------------------------- > To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > -- “Only two things are infinite, the universe and human stupidity, and I’m not sure about the former.” -Albert Einstein "A great moral force is a bayonet on a gun and a web-belt full of cartridges." -Colonel John S. Poland, U. S. Army - 1894 "In all border lands a certain class of men have to be killed to insure the welfare and safety of the peaceably inclined." - Judge William L. Kuykendall - 1917 _ _... ..._ _ _._ ._ ..... ._.. ... .._
Hi Nick, There are many people who don't have Excel or Office Suite, or know how to use Excel. I'll be hand-numbering until I get a gift of the program. Judy On Fri, Jul 12, 2013 at 4:16 AM, Nick Reddan <nickred@webone.com.au> wrote: > Judy > > Numbering rows is easiest in Excel. We have had threads about > converting Excel tables to HTML based around the HTML for a cell value > in say A2 using a formula like ="<td>"&if(len(A2)=0," ",A2)&"</td>" > > Copying a table in Word and pasting in Excel converts it to a Excel then > you can use formulae to create the HTML. > > See: > http://members.iinet.net.au/~nickred/temp/little_table.xls > > > Regards > > > Nick
Unless I misunderstood your question, I disagree that Ancestry inserted the link. First, Ancestry would keep their inserted data with their banner. None of my freepages have a link inserted by ancestry, except the banner. The line is *Click **here*<http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm> * to see current special deals on DNA testing! -- The link is on the word "here". **There is NO link on the words "DNA Testing".* * * Second, if you View Source, the link was inserted in MS Word starting here (minus the dots): <....p class=MsoNormal><....b style='mso-bidi-font-weight:normal'><span style='font-family:"Verdana","sans-serif";mso-bidi-font-family:Arial; color:red'>Click </span></b><a href=" http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm "><b style='mso-bidi-font-weight:normal'><span style='font-family:"Verdana","sans-serif"; mso-bidi-font-family:Arial;color:red'>here</span></b></a><b style='mso-bidi-font-weight: normal'><span style='font-family:"Verdana","sans-serif";mso-bidi-font-family: Arial;color:red'> to see current special deals on DNA testing!<o:p></o:p></span></b></p> The link goes to here on your site: http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm Those percent 20 in your file name reflects a space between words. It makes shorter links if you use underscore or hyphen between words. Judy On Thu, Jul 11, 2013 at 8:33 PM, PAUL SHEATS Owner <paul.sheats@q.com>wrote: > Hi all, > > I just discovered that a link is appearing on my home page that I did not > create. Did Rootsweb Free pages create this link automatically, or did > something else create it? > > My home page is here: > http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20home.htm > > Near the top, in RED, it says "Click here to see current special deals on > DNA testing!". The link I am wondering about is on "DNA testing". > > Any ideas? > > Thanks. > Paul > > ------------------------------- > To unsubscribe from the list, please send an email to > FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without > the quotes in the subject and the body of the message > -- -- WASHINGTON COUNTY PA WEBSITES::: http://freepages.misc.rootsweb.com/~florian/ http://freepages.school-alumni.rootsweb.com/~florian/the-rockdoctor/ Coordinator of the Washington County PAGenWeb: http://www.rootsweb.com/~pawashin/
Hi all, I just discovered that a link is appearing on my home page that I did not create. Did Rootsweb Free pages create this link automatically, or did something else create it? My home page is here: http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20home.htm Near the top, in RED, it says "Click here to see current special deals on DNA testing!". The link I am wondering about is on "DNA testing". Any ideas? Thanks. Paul
Here's a technique that may help in converting MS Word tables into HTML (for Front Page) without excessive code. It relies on the HTML tags for tables and their rows and cells. 1. Start with the table in Word. You will use commands from Word's table menu, inserting rows and columns. 2. Insert a row above the table and a column on its left. 3. In the blank top row, enter <.table> (without the dot). This tag will open the table in HTML. 4. For the column headings row, type this into the blank top left cell <.tr><th>. For all rows below that, type or copy-and-paste <.tr><.td> This opens a HTML row and then a cell. 5. Insert a column between each column holding data. For the top row, type (or copy-and-paste) <./th><th>; for succeeding rows, <./td><.td>. This closes one cell and opens another. 6. In the column to the right of the data, enter <./th><./tr> for the top row and </td><./tr> for the others. This closes the last cell and the table row. 7. Below the table data, enter <./table> to close the table. 8. Save as a plain text file -- example "mytable.txt". Do not choose CSV format. Close Word. 9. Open FP, right-click the filename and select "Rename". Change the filename extension from "txt" to "htm". You'll get a warning about changing filename extensions; don't let it bother you. 10 Open the file in FP for editing and/or formatting. Add <.head> and <.body> tags as needed. Comment: With all the inserted columns, your data may appear "squished" in Word. Pay no attention, this will resolve itself at the end. -rt_/) Date: Wed, 10 Jul 2013 15:24:02 +0100 From: Valerie lirakis <valerie.lirakis@googlemail.com> Subject: [FreeHelp] Converting word tables into FP To: freepages-help@rootsweb.com Message-ID: <CACixnKT9Z1ZtT+zg4m4ZqtpMCoiDvVWAXjGGVvhP=YrjoS_-Aw@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 I'm attempting to get rid of excess code in my web page http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/a ppendix_edgworth.htm I've followed the online tutorial but it doesn't appear to be working. When I copy the table into notepad the data shows as a vertical column (is this correct?). Would appreciate help on this. Valerie Lirakis
Yes, They did and may have different ones and may even have more from time to time. Thanks, David C Abernathy Email disclaimers ---------------------------------------------------------------------------- This message represents the official view of the voices in my head. ---------------------------------------------------------------------------- http://www.SchmeckAbernathy.com == All outgoing and incoming mail is scanned by F-Prot Antivirus == -----Original Message----- From: freepages-help-bounces@rootsweb.com [mailto:freepages-help-bounces@rootsweb.com] On Behalf Of PAUL SHEATS Owner Sent: Thursday, July 11, 2013 5:33 PM To: freepages-help@rootsweb.com Subject: [FreeHelp] Links I did not create Hi all, I just discovered that a link is appearing on my home page that I did not create. Did Rootsweb Free pages create this link automatically, or did something else create it? My home page is here: http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20p roject%20-%20home.htm Near the top, in RED, it says "Click here to see current special deals on DNA testing!". The link I am wondering about is on "DNA testing". Any ideas? Thanks. Paul ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message
Thanks to all who replied. Pat, I used your online tutorial, but seemed to come unstuck when I pasted my table from Notepad to Excel, and then inserted extra columns. Could this be because my original table is in 3 blocks of two columns to fit on an A4 page? (please see my web page http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/appendix_edgworth.htm to see what I mean.) Judy, thanks for your detailed reply, which I will certainly try if all else fails. However, I have two other web pages of tables with nearly 640 rows in total, so doing it the way you suggest would be a daunting task. David, I did use an MS Word document, which I then copied onto a web page, hence the excess coding. Valerie On 11 July 2013 08:00, <freepages-help-request@rootsweb.com> wrote: > > > When replying to a digest message, quote only the specific message to > which you are replying, removing the rest of the digest from your reply. > Remember to change the subject of your reply so that it coincides with the > message subject to which you are replying. > ***FREEPAGES HELP & FAQ*** > <http://helpdesk.rootsweb.com/FAQ/fpindex.html> > > > Today's Topics: > > 1. Converting word tables into FP (Valerie lirakis) > 2. Re: Converting word tables into FP (David Abernathy) > 3. Re: Converting word tables into FP (Pat Geary) > 4. Re: Converting word tables into FP (JFlorian) > 5. Re: Converting word tables into FP (JFlorian) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 10 Jul 2013 15:24:02 +0100 > From: Valerie lirakis <valerie.lirakis@googlemail.com> > Subject: [FreeHelp] Converting word tables into FP > To: freepages-help@rootsweb.com > Message-ID: > <CACixnKT9Z1ZtT+zg4m4ZqtpMCoiDvVWAXjGGVvhP= > YrjoS_-Aw@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I'm attempting to get rid of excess code in my web page > > http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/appendix_edgworth.htm > > I've followed the online tutorial but it doesn't appear to be working. When > I copy the table into notepad the data shows as a vertical column (is this > correct?). > > Would appreciate help on this. > > Valerie Lirakis > > > ------------------------------ > > Message: 2 > Date: Wed, 10 Jul 2013 08:13:32 -0700 > From: "David Abernathy" <davea@schmeckabernathy.com> > Subject: Re: [FreeHelp] Converting word tables into FP > To: <freepages-help@rootsweb.com> > Message-ID: <001b01ce7d80$0bf38e40$23daaac0$@schmeckabernathy.com> > Content-Type: text/plain; charset="iso-8859-1" > > Valerie, > What program did you use to make this web page? > > With all of the coding that appears when I use the "View Source", I would > say that you used MS Word. > > Also, when you pasted it into Notepad, did you copy from your original > source or from the web page viewing it with a browser? > When Copying from a browser all you get is the data and NO coding. Try > right > clicking the webpage and select "View source. Now you will see all of the > coding and the data. It will also include the coding that Ancestry adds, so > this needs to be stripped before reloading to Ancestry. > > Thanks, > David C Abernathy > Email disclaimers > > ---------------------------------------------------------------------------- > This message represents the official view of the voices in my head. > > ---------------------------------------------------------------------------- > http://www.SchmeckAbernathy.com > == All outgoing and incoming mail is scanned by F-Prot Antivirus? == > > -----Original Message----- > From: freepages-help-bounces@rootsweb.com > [mailto:freepages-help-bounces@rootsweb.com] On Behalf Of Valerie lirakis > Sent: Wednesday, July 10, 2013 7:24 AM > To: freepages-help@rootsweb.com > Subject: [FreeHelp] Converting word tables into FP > > I'm attempting to get rid of excess code in my web page > > http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/a > ppendix_edgworth.htm > > I've followed the online tutorial but it doesn't appear to be working. When > I copy the table into notepad the data shows as a vertical column (is this > correct?). > > Would appreciate help on this. > > Valerie Lirakis > > ------------------------------- > To unsubscribe from the list, please send an email to > FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without > the > quotes in the subject and the body of the message > > > > > ------------------------------ > > Message: 3 > Date: Wed, 10 Jul 2013 13:03:52 -0400 > From: Pat Geary <pat@the-gearys.com> > Subject: Re: [FreeHelp] Converting word tables into FP > To: freepages-help@rootsweb.com > Message-ID: <201307101816.r6AIGRvX025731@mail.rootsweb.com> > Content-Type: text/plain; charset="us-ascii"; format=flowed > > At 10:24 AM 7/10/2013, you wrote: > >I'm attempting to get rid of excess code in my web page > > > http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/appendix_edgworth.htm > > > >I've followed the online tutorial but it doesn't appear to be working. > When > >I copy the table into notepad the data shows as a vertical column (is this > >correct?). > > > >Would appreciate help on this. > > Valerie, have you tried this one > > http://freepages.genealogy.rootsweb.ancestry.com/~gearyfamily/frontpage/excel-tables-in-frontpage2.htm > > pat > > ------------------------------ > > Message: 4 > Date: Wed, 10 Jul 2013 17:18:27 -0400 > From: JFlorian <cageycat@gmail.com> > Subject: Re: [FreeHelp] Converting word tables into FP > To: freepages-help@rootsweb.com > Message-ID: > < > CAE5hz-AamYvf7zsnq_-4Yjbdcx5ZH3Cv7rGhy67ppBNnBZE6HA@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Valerie, > > MSo or MS Word code is easiest to deal with by opening the View HTML tab in > Frontpage, and first looking at the code. If you don't use Find/Replace, > you'll need to hand copy everything back into EACH row/column because > Notepad will strip out <p codes or br codes that Frontpage needs to > 'convert text to table'. So here's how to save time/efforts.... > > In your Head section, remove the table.MsoNormalTable from the comment line > to end. > > Leave in any scripts you need, or for example, your on-site search coding. > > Remove the <!--mstheme--><link rel etc etc > > Remove RW top banner beginning with <....body topmargin="70"><...div id=" > RootsBanner-SearchWrapper"> > > Scroll down and remove the RW bottom banner... make sure to leave the > close' /html tag > > Next, identify the beginning tag lines for 'open table', 'open row' etc. > Identify the piece for each column width. So if you have 5 columns, > you'll be changing 5 but keeping the width number(s) the same. Next, use > Find for the existing code (copy the line into Find)... then type into > Replace the "open" th tag and column width... Hit Replace ALL or do one at > a time. Let's say your column width is 20percent... replace all will > replace all of the same number... That will keep your column widths AND the > data you have --- no copying the data back in. > > Re-do for the next column... changing the percent as needed. > > Remove all the <...span> codes that MS Word inserts. > > Look for anything else starting with MS, MSo or MS theme and remove them or > use Find/Replace All. > > Look at the Font codes next. MS Word inserts a Font tag on almost every > line. Replace those with nothing, not even a space... in Replace. > Re-insert your Font tag into CSS or as a one time tag for body (if that is > still html acceptable standards?). > > Do the same for Font Color. > Same with center tags, etc. > So you'll be replacing many of these...: <.....span style="font-family: > Book Antiqua; color: #FFFFFF"><....font size="2"> </font></span></p> > Just take them out, and put font family, font size, font color into CSS. > > Move the <...table class="MsoNormalTable" border="0" cellpadding="0" > width=" > 931" left-margin=5.05cm style="border:4px double #C0C0C0; width: 698.1pt; > border-collapse: collapse; margin-left: 4.65pt" id="table1" > bgcolor="#808080"> > and those padding codes all into to CSS... and delete all those lines, like > above, from your html coding. > > You'll need to keep looking through the lines, identifying anything else MS > generated, things I might not have mentioned above. > > Again, Find/Replace is much better than hand-copying every cell of data and > pasting it into a 'good' table. I have done it both ways and Find/Replace > is SO much easier! > > One caution: I often copied a long line of MS code to a fresh Notepad... > just in case I had to put it back in. After doing a Find/Replace, look at > the Design View to see how your table looks... If a problem, either look > for an additional code that needs removed, or put back the old code > temporarily till you figure out what is wrong. Or, see next item below... > > On my Frontpage, I also need to insert 'a space' code into blank cells, to > make Frontpage render the cell borders if no data. So if in Design View you > see missing cell borders, put in Find this: > <...tr><.../tr> (without dots, and nothing between the end><beginning > brackets > In Replace put <...tr>... <...br><.../tr> (without dots) ampersand > with nbsp; > That will show Frontpage there is supposed to be 'data' e.g. just a holding > space. > > When you think you are done, look through the code again. Make sure all the > open and close tags are correct. > > Hope these tips help. > > Judy > > > ------------------------------ > > Message: 5 > Date: Wed, 10 Jul 2013 17:24:30 -0400 > From: JFlorian <cageycat@gmail.com> > Subject: Re: [FreeHelp] Converting word tables into FP > To: freepages-help@rootsweb.com > Message-ID: > < > CAE5hz-BK4T9LDC-D83i6xBr_5bN6g+W9OnaFwKoEtPSkzveRoA@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Ooops.... error on this::: In Replace put > <...tr>... <...br><.../tr> (without > dots) ampersand with nbsp; > > Ignore where I have <...br> It is supposed to be the 'space' tag which is > ampersand with nbsp; > > Also, look for long lines or repeats of ampersand with nbsp; > You won't need most of those; most can be deleted. Use Center or Left Right > tags instead of ampersand with nbsp; (made by hitting space bar in Word) > > Judy > > > ------------------------------ > > To contact the FREEPAGES-HELP list administrator, send an email to > FREEPAGES-HELP-admin@rootsweb.com. > > To post a message to the FREEPAGES-HELP mailing list, send an email to > FREEPAGES-HELP@rootsweb.com. > > __________________________________________________________ > To unsubscribe from the list, please send an email to > FREEPAGES-HELP-request@rootsweb.com > with the word "unsubscribe" without the quotes in the subject and the body > of the > email with no additional text. > > > End of FREEPAGES-HELP Digest, Vol 8, Issue 92 > ********************************************* >
On Thu, Jul 11, 2013 at 5:55 AM, Valerie lirakis < valerie.lirakis@googlemail.com> wrote: Judy, thanks for your detailed reply, which I will certainly try if all else fails. However, I have two other web pages of tables with nearly 640 rows in total, so doing it the way you suggest would be a daunting task. ========== LOL ! Yeppers! It was the most painful' "Never Use MS Word for a Webpage" lesson I ever learned, especially on super long tables. BUT... Find//Replace was better than Copy/Paste to get Cell Data back into their cells! Another bad lesson: Manually inserting Row Number on a table with hundreds of numbers----argggh, similar to:: pull out my thick hair strand by strand! Never again. Judy
If you want to edit the code directly Notepad is definitely an option, for the experienced person. I believe that a better option is a dedicated HTML editor. They tend to offer a lot of options to make it easier. There are many out there, some for free. The one I use is named Bluefish, don't ask me why it's named that. [ http://bluefish.openoffice.nl/index.html ] It offers a lot of great tools for working with HTML. If you want to give it a try you can download the Windows version at http://www.bennewitz.com/bluefish/stable/binaries/win32/Bluefish-2.2.4-setup.exe. Just scroll down to where it says Bluefish-2.2.4-setup.exe if it doesn't ask what to do with the file. I will be very happy to help you learn how to use it once you have it installed. On 07/11/2013 04:55 AM, Valerie lirakis wrote: > Thanks to all who replied. > > Pat, I used your online tutorial, but seemed to come unstuck when I pasted > my table from Notepad to Excel, and then inserted extra columns. Could this > be because my original table is in 3 blocks of two columns to fit on an A4 > page? (please see my web page > http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/appendix_edgworth.htm > to > see what I mean.) > > Judy, thanks for your detailed reply, which I will certainly try if all > else fails. However, I have two other web pages of tables with nearly 640 > rows in total, so doing it the way you suggest would be a daunting task. > > David, I did use an MS Word document, which I then copied onto a web page, > hence the excess coding. > > Valerie -- “Only two things are infinite, the universe and human stupidity, and I’m not sure about the former.” -Albert Einstein "A great moral force is a bayonet on a gun and a web-belt full of cartridges." -Colonel John S. Poland, U. S. Army - 1894 "In all border lands a certain class of men have to be killed to insure the welfare and safety of the peaceably inclined." - Judge William L. Kuykendall - 1917 _ _... ..._ _ _._ ._ ..... ._.. ... .._
Ooops.... error on this::: In Replace put <...tr>... <...br><.../tr> (without dots) ampersand with nbsp; Ignore where I have <...br> It is supposed to be the 'space' tag which is ampersand with nbsp; Also, look for long lines or repeats of ampersand with nbsp; You won't need most of those; most can be deleted. Use Center or Left Right tags instead of ampersand with nbsp; (made by hitting space bar in Word) Judy
Valerie, MSo or MS Word code is easiest to deal with by opening the View HTML tab in Frontpage, and first looking at the code. If you don't use Find/Replace, you'll need to hand copy everything back into EACH row/column because Notepad will strip out <p codes or br codes that Frontpage needs to 'convert text to table'. So here's how to save time/efforts.... In your Head section, remove the table.MsoNormalTable from the comment line to end. Leave in any scripts you need, or for example, your on-site search coding. Remove the <!--mstheme--><link rel etc etc Remove RW top banner beginning with <....body topmargin="70"><...div id=" RootsBanner-SearchWrapper"> Scroll down and remove the RW bottom banner... make sure to leave the close' /html tag Next, identify the beginning tag lines for 'open table', 'open row' etc. Identify the piece for each column width. So if you have 5 columns, you'll be changing 5 but keeping the width number(s) the same. Next, use Find for the existing code (copy the line into Find)... then type into Replace the "open" th tag and column width... Hit Replace ALL or do one at a time. Let's say your column width is 20percent... replace all will replace all of the same number... That will keep your column widths AND the data you have --- no copying the data back in. Re-do for the next column... changing the percent as needed. Remove all the <...span> codes that MS Word inserts. Look for anything else starting with MS, MSo or MS theme and remove them or use Find/Replace All. Look at the Font codes next. MS Word inserts a Font tag on almost every line. Replace those with nothing, not even a space... in Replace. Re-insert your Font tag into CSS or as a one time tag for body (if that is still html acceptable standards?). Do the same for Font Color. Same with center tags, etc. So you'll be replacing many of these...: <.....span style="font-family: Book Antiqua; color: #FFFFFF"><....font size="2"> </font></span></p> Just take them out, and put font family, font size, font color into CSS. Move the <...table class="MsoNormalTable" border="0" cellpadding="0" width=" 931" left-margin=5.05cm style="border:4px double #C0C0C0; width: 698.1pt; border-collapse: collapse; margin-left: 4.65pt" id="table1" bgcolor="#808080"> and those padding codes all into to CSS... and delete all those lines, like above, from your html coding. You'll need to keep looking through the lines, identifying anything else MS generated, things I might not have mentioned above. Again, Find/Replace is much better than hand-copying every cell of data and pasting it into a 'good' table. I have done it both ways and Find/Replace is SO much easier! One caution: I often copied a long line of MS code to a fresh Notepad... just in case I had to put it back in. After doing a Find/Replace, look at the Design View to see how your table looks... If a problem, either look for an additional code that needs removed, or put back the old code temporarily till you figure out what is wrong. Or, see next item below... On my Frontpage, I also need to insert 'a space' code into blank cells, to make Frontpage render the cell borders if no data. So if in Design View you see missing cell borders, put in Find this: <...tr><.../tr> (without dots, and nothing between the end><beginning brackets In Replace put <...tr>... <...br><.../tr> (without dots) ampersand with nbsp; That will show Frontpage there is supposed to be 'data' e.g. just a holding space. When you think you are done, look through the code again. Make sure all the open and close tags are correct. Hope these tips help. Judy
I'm attempting to get rid of excess code in my web page http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/appendix_edgworth.htm I've followed the online tutorial but it doesn't appear to be working. When I copy the table into notepad the data shows as a vertical column (is this correct?). Would appreciate help on this. Valerie Lirakis
At 10:24 AM 7/10/2013, you wrote: >I'm attempting to get rid of excess code in my web page >http://freepages.genealogy.rootsweb.ancestry.com/~boltongenealogy/edgworth/appendix_edgworth.htm > >I've followed the online tutorial but it doesn't appear to be working. When >I copy the table into notepad the data shows as a vertical column (is this >correct?). > >Would appreciate help on this. Valerie, have you tried this one http://freepages.genealogy.rootsweb.ancestry.com/~gearyfamily/frontpage/excel-tables-in-frontpage2.htm pat