Help:How to Convert a Microsoft Office Document into Wiki Format

From FamilySearch Wiki

(Difference between revisions)
m (rearranged word order)
m (standardized format)
Line 1: Line 1:
Some contributors wish to import information from existing documents or spreadsheets. This is especially helpful when trying to import tables, or keep current formatting from pre-existing documents or spreadsheets. The process is time-intensive and advanced. Before following these steps, consider if it may take less time to re-create a table than to import an existing one. To create a wiki page from a Microsoft Office document, do the following:<u></u>  
+
Some contributors wish to import information from existing documents or spreadsheets. This is especially helpful when trying to import tables, or keep current formatting from pre-existing documents or spreadsheets. The process is time-intensive and advanced. Before following these steps, consider if it may take less time to re-create a table than to import an existing one. To create a wiki page from a ''Microsoft Office'' document, do the following:<u></u>  
  
#'''(On your computer:) '''Download and install [http://download.openoffice.org/ Open Office]. This is free, but usually takes a few minutes (depending on the speed of your Internet connection).  
+
#'''(On your computer:) '''Download and install [http://download.openoffice.org/ ''Open Office'']. This is free, but usually takes a few minutes (depending on the speed of your Internet connection).  
#Once Open Office is installed on your computer, open the following Open Office program by clicking on your Start button, then Programs/All Programs, and click on OpenOffice at the bottom of the list of the programs:<br>  
+
#Once ''Open Office'' is installed on your computer, open the following ''Open Office'' program by clicking on your '''Start''' button, then '''Programs/All Programs''', and click on '''OpenOffice''' at the bottom of the list of the programs:<br>  
#*to import a Microsoft Office document or HTML file, open Open Office ''Writer''  
+
#*to import a ''Microsoft Office'' document or HTML file, open ''Open Office'' ''Writer''  
#Once the program is open (''Writer'' for Word documents or HTML files), open your document in the program by clicking "File," then "Open," and locate the&nbsp;the document you want to copy text from on your computer or storage device.  
+
#Once the program is open (''Writer'' for ''Word'' documents or HTML files), open your document in the program by clicking '''File''', then '''Open''', and locate the&nbsp;the document you want to copy text from on your computer or storage device.  
#Once the document is open in the Open Office program,&nbsp;click '''File''' on the menu,&nbsp;and then click '''Export'''.  
+
#Once the document is open in the ''Open Office'' program,&nbsp;click the '''File''' menu,&nbsp;and then click '''Export'''.  
 
#The "Export" window will appear. First type a name for the file in the export window. Next, in the "File Format" dropdown,&nbsp;select '''MediaWiki'''.  
 
#The "Export" window will appear. First type a name for the file in the export window. Next, in the "File Format" dropdown,&nbsp;select '''MediaWiki'''.  
 
#At the top of the "Export" window, choose a folder in which you want to save the file,&nbsp;and click '''Save'''.&nbsp;Remember where you saved the file. You may want to write down the location you saved the file.  
 
#At the top of the "Export" window, choose a folder in which you want to save the file,&nbsp;and click '''Save'''.&nbsp;Remember where you saved the file. You may want to write down the location you saved the file.  
#A text document (.txt) will be created in the location you&nbsp;specified in step 6.&nbsp;Locate&nbsp;the document you just created. Open that document by double clicking on it. It will open in NotePad or another text editor.  
+
#A text document (.txt) will be created in the location you&nbsp;specified in step 6.&nbsp;Locate&nbsp;the document you just created. Open that document by double clicking on it. It will open in ''NotePad'' or another text editor.  
#'''(Online at Wiki.FamilySearch.org:) '''Open the page in which you wish to import the document&nbsp; or create a new page, and open the edit box by clicking on the "Edit" option for that page or article.&nbsp;This will open the editing window. At the top of the editing window&nbsp;is a tan colored bar containing several icons (see below):[[Image:Editor Toolbar.png|Image:Editor_Toolbar.png]]  
+
#'''(Online at Wiki.FamilySearch.org:) '''Open the page in which you wish to import the document&nbsp; or create a new page, and open the edit box by clicking on the '''Edit''' option for that page or article.&nbsp;This will open the editing window. At the top of the editing window&nbsp;is a tan colored bar containing several icons (see below):[[Image:Editor Toolbar.png|Image:Editor_Toolbar.png]]  
#Click on the "Wikitext" button on the editor toolbar, in the lefthand corner of the toolbar (see below):&nbsp;[[Image:Editor ToolbarWT.png|Image:Editor_ToolbarWT.png]]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Note: You do not need&nbsp;to do this if you have the [[Help:FCK Editor|rich text editor]] disabled in your preferences].  
+
#Click on the '''Wikitext''' button on the editor toolbar, in the lefthand corner of the toolbar (see below):&nbsp;[[Image:Editor ToolbarWT.png|Image:Editor_ToolbarWT.png]]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Note: You do not need&nbsp;to do this if you have the [[Help:FCK Editor|rich text editor]] disabled in your preferences].  
#'''(On your computer:)&nbsp;'''Select all of&nbsp;the&nbsp;contents&nbsp;in the text document by holding down the "Ctrl" key while tapping the "A" key once. Copy the highlighted text by holding down the "Ctrl" key while tapping the "C" key once.  
+
#'''(On your computer:)&nbsp;'''Select all of&nbsp;the&nbsp;contents&nbsp;in the text document by holding down the '''Ctrl''' key while pressing the '''A''' key once. Copy the highlighted text by holding down the '''Ctrl''' key while pressing the '''C''' key once.  
 
#'''(Online at FamilySearch.org:)''' Paste the copied text into the wiki authoring window in&nbsp;the location you want the&nbsp;text or table to appear by placing your cursor in the appropriate location in the body of the text, and&nbsp;left clicking with your mouse to indicate where the text or table should appear.  
 
#'''(Online at FamilySearch.org:)''' Paste the copied text into the wiki authoring window in&nbsp;the location you want the&nbsp;text or table to appear by placing your cursor in the appropriate location in the body of the text, and&nbsp;left clicking with your mouse to indicate where the text or table should appear.  
#While holding down&nbsp;the&nbsp;"Ctrl" button on the keyboard, tap the "V" key on the keyboard.&nbsp;(See the "Special Instructions" section below for additional help regarding tables.)  
+
#While holding down&nbsp;the '''Ctrl''' button on the keyboard, press the '''V''' key on the keyboard.&nbsp;(See the "Special Instructions" section below for additional help regarding tables.)  
#After pasting the text into the editing window, scroll down to the bottom of the screen, and click '''Save Page'''. The formatted text and/or tables will appear on the Wiki page.
+
#After pasting the text into the editing window, scroll down to the bottom of the screen, and click '''Save page'''. The formatted text and/or tables will appear on the Wiki page.
  
 
<u><br></u>'''Special Instructions'''  
 
<u><br></u>'''Special Instructions'''  
Line 21: Line 21:
  
 
#Click edit to edit the page.  
 
#Click edit to edit the page.  
#Click on "Wikitext" in the lefthand corner of the editor toolbar.  
+
#Click the '''Wikitext''' button in the lefthand corner of the editor toolbar.  
 
#Search the document for each occurance of this line: '''{| class="prettytable"<br>'''The line will appear once for each table that is in the document. This will widen the table and add a border.  
 
#Search the document for each occurance of this line: '''{| class="prettytable"<br>'''The line will appear once for each table that is in the document. This will widen the table and add a border.  
 
#Change the line to read as follows: '''{| width="75%" border="1"<br>'''Note: You can change the percentage value for "width" to make your table wider or narrower.
 
#Change the line to read as follows: '''{| width="75%" border="1"<br>'''Note: You can change the percentage value for "width" to make your table wider or narrower.
  
 
[[Category:Help|{{PAGENAME}}]]
 
[[Category:Help|{{PAGENAME}}]]

Revision as of 22:28, 16 April 2010

Some contributors wish to import information from existing documents or spreadsheets. This is especially helpful when trying to import tables, or keep current formatting from pre-existing documents or spreadsheets. The process is time-intensive and advanced. Before following these steps, consider if it may take less time to re-create a table than to import an existing one. To create a wiki page from a Microsoft Office document, do the following:

  1. (On your computer:) Download and install Open Office. This is free, but usually takes a few minutes (depending on the speed of your Internet connection).
  2. Once Open Office is installed on your computer, open the following Open Office program by clicking on your Start button, then Programs/All Programs, and click on OpenOffice at the bottom of the list of the programs:
    • to import a Microsoft Office document or HTML file, open Open Office Writer
  3. Once the program is open (Writer for Word documents or HTML files), open your document in the program by clicking File, then Open, and locate the the document you want to copy text from on your computer or storage device.
  4. Once the document is open in the Open Office program, click the File menu, and then click Export.
  5. The "Export" window will appear. First type a name for the file in the export window. Next, in the "File Format" dropdown, select MediaWiki.
  6. At the top of the "Export" window, choose a folder in which you want to save the file, and click Save. Remember where you saved the file. You may want to write down the location you saved the file.
  7. A text document (.txt) will be created in the location you specified in step 6. Locate the document you just created. Open that document by double clicking on it. It will open in NotePad or another text editor.
  8. (Online at Wiki.FamilySearch.org:) Open the page in which you wish to import the document  or create a new page, and open the edit box by clicking on the Edit option for that page or article. This will open the editing window. At the top of the editing window is a tan colored bar containing several icons (see below):Image:Editor_Toolbar.png
  9. Click on the Wikitext button on the editor toolbar, in the lefthand corner of the toolbar (see below): Image:Editor_ToolbarWT.png                                                       [Note: You do not need to do this if you have the rich text editor disabled in your preferences].
  10. (On your computer:) Select all of the contents in the text document by holding down the Ctrl key while pressing the A key once. Copy the highlighted text by holding down the Ctrl key while pressing the C key once.
  11. (Online at FamilySearch.org:) Paste the copied text into the wiki authoring window in the location you want the text or table to appear by placing your cursor in the appropriate location in the body of the text, and left clicking with your mouse to indicate where the text or table should appear.
  12. While holding down the Ctrl button on the keyboard, press the V key on the keyboard. (See the "Special Instructions" section below for additional help regarding tables.)
  13. After pasting the text into the editing window, scroll down to the bottom of the screen, and click Save page. The formatted text and/or tables will appear on the Wiki page.


Special Instructions

To format a table after pasting the text:

  1. Click edit to edit the page.
  2. Click the Wikitext button in the lefthand corner of the editor toolbar.
  3. Search the document for each occurance of this line: {| class="prettytable"
    The line will appear once for each table that is in the document. This will widen the table and add a border.
  4. Change the line to read as follows: {| width="75%" border="1"
    Note: You can change the percentage value for "width" to make your table wider or narrower.