Difference between revisions of "Help:How to Convert a Microsoft Office Document into Wiki Format"

From FamilySearch Wiki
Jump to: navigation, search
(Adjusted for clarity)
Line 1: Line 1:
To create a wiki page from a Microsoft Office document, do the following:  
+
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. To create a wiki page from a Microsoft Office document, do the following:<u></u>
  
#Download and install [http://download.openoffice.org/ Open Office]. This takes about five minutes and is free.  
+
#'''(On your computer:) '''Download and install [http://download.openoffice.org/ Open Office]. This takes about five minutes and is free.
#Open your document in the appropriate Open Office tool (for example: Writer for Word documents or HTML files, Calc for Excel spreadsheets).  
+
#Open one of the following Open Office programs by clicking on your Start button, then Programs/All Programs, and click on OpenOffice at the bottom of the list of programs: to import a Microsoft Office document or HTML file, open Open Office ''Writer''; to import an Excel spreadsheet, open Open Office ''Calc''.
#On the menu, click '''File''', and then click '''Export'''.  
+
#Open your document in the appropriate Open Office program (''Writer'' for Word documents or HTML files, ''Calc'' for Excel spreadsheets) by clicking File, Open, and locate the your document or spreadsheet on your computer or storage device.
#The Save window will appear. In the Files of Type dropdown, choose '''MediaWiki'''.  
+
#Once the document is open in the Open Office program,&nbsp;click '''File''' on the menu,&nbsp;and then click '''Export'''.  
#Choose a folder in which you want to save the file.
+
#The Save window will appear. First type a name for the file. Next, in the "Files of Type" dropdown, choose '''MediaWiki'''.  
#Click '''Save'''. A text docment (.txt) will be created. Open that document in NotePad or another text editor.  
+
#Choose a folder in which you want to save the file,&nbsp;and click '''Save'''.&nbsp;Remember where you saved the file.
#In FamilySearch Wiki, choose&nbsp;to create a document.
+
#A text docment (.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.
#On the editor toolbar, click the '''Wikitext''' button (you do not need ot do this if you have the rich text editor disabled in your preferences).  
+
#'''(Online at Wiki.FamilySearch.org:) '''Open the page in which you wish to import the document or spreadsheet, or create a new page, and open the edit box by clicking on the "Edit" tab.&nbsp;  
 +
#On the editor toolbar in the lefthand corner, click the '''Wikitext''' button&nbsp;(you do not need&nbsp;to do this if you have the [[Help:FCK Editor|rich text editor]] disabled in your preferences).  
 
#Copy the&nbsp;contents of the text document, and then paste them into the wiki authoring window.<!-- Tidy found serious XHTML errors -->&nbsp; (See the "Special Instructions" section below for additional help regarding tables.)  
 
#Copy the&nbsp;contents of the text document, and then paste them into the wiki authoring window.<!-- Tidy found serious XHTML errors -->&nbsp; (See the "Special Instructions" section below for additional help regarding tables.)  
 
#At the bottom of the screen, click '''Save Page'''.
 
#At the bottom of the screen, click '''Save Page'''.
  
<br>'''Special Instructions'''  
+
<u>Online at WikiFamilySearch.org:<br></u>'''Special Instructions'''  
  
 
To format a table after pasting the text:  
 
To format a table after pasting the text:  
Line 19: Line 20:
 
#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.
  
<!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors --> <!-- Tidy found serious XHTML errors -->  
+
<!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors --><!-- Tidy found serious XHTML errors -->
 
<!-- Tidy found serious XHTML errors -->
 
<!-- Tidy found serious XHTML errors -->

Revision as of 18:46, 2 June 2008

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. To create a wiki page from a Microsoft Office document, do the following:

  1. (On your computer:) Download and install Open Office. This takes about five minutes and is free.
  2. Open one of the following Open Office programs by clicking on your Start button, then Programs/All Programs, and click on OpenOffice at the bottom of the list of programs: to import a Microsoft Office document or HTML file, open Open Office Writer; to import an Excel spreadsheet, open Open Office Calc.
  3. Open your document in the appropriate Open Office program (Writer for Word documents or HTML files, Calc for Excel spreadsheets) by clicking File, Open, and locate the your document or spreadsheet on your computer or storage device.
  4. Once the document is open in the Open Office program, click File on the menu, and then click Export.
  5. The Save window will appear. First type a name for the file. Next, in the "Files of Type" dropdown, choose MediaWiki.
  6. Choose a folder in which you want to save the file, and click Save. Remember where you saved the file.
  7. A text docment (.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 spreadsheet, or create a new page, and open the edit box by clicking on the "Edit" tab. 
  9. On the editor toolbar in the lefthand corner, click the Wikitext button (you do not need to do this if you have the rich text editor disabled in your preferences).
  10. Copy the contents of the text document, and then paste them into the wiki authoring window.  (See the "Special Instructions" section below for additional help regarding tables.)
  11. At the bottom of the screen, click Save Page.

Online at WikiFamilySearch.org:
Special Instructions

To format a table after pasting the text:

  1. Search the document for this line: {| class="prettytable"
    The line will appear once for each table that is in the document.
  2. 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.