User:Caileigholdroyd/Sandbox/Creating Pages in Excel

Video Instructions
Video

Basic Insturctions
1. Find out what you want the pages to look like. Make a mock up in a sandbox or copy a version of a page you already like. 2. Find out the areas that you will need to be auto-filled (Page Titles, Town/County/Country/Jurisdictional Levels, Histories, etc) 3. Create a Google Form asking the areas you want in Step 2.
 * Here is an example of some you areas you might gather. 

4. Click "View in Sheets" on the Google Form under "Responses" to create or view where the gathered information will go. 5. Create some extra columns to concatenate and create references, page names, and the page code. 6. Begin concatenating the gathered data. To learn a little about concatenate, watch this video.

Whole Page Code
Here is an example of how it might look in one cell:

=CONCATENATE("

Guía para la investigación genealógica del Muncipio de ",F37,": registros de nacimiento, matrimonios, defunciones, censos, registros parroquiales y registros militares.

Historia
",G37,AQ37,"

Cementerios
",H37,"

Citas
",F37,", ",E37,", ",D37,", ",C37,", ",B37,", Spain Genealogy ")

As you can see, the letter number combinations are the cells that you gathered the information from.

Reference Code
=CONCATENATE(" ")

Lower Jurisdictions (not linked)
=CONCATENATE("",E6," ",E7," ",E8," ",E9," ",E10," ",E11," ",E12," ",E13,"</li> ",E14,"</li> ",E15,"</li> ",E16,"</li> ",E17,"</li> ",E18,"</li> ",E19,"</li>")

FS Historical Records Links
=CONCATENATE("*",O62," at FamilySearch — How to Use this Collection; index and images")

Other Websites
=CONCATENATE("*",R75," [",T75," ",F75,"] at " ,D75," — index & images, ($)")

Page Name
=CONCATENATE(F37,", ",E37,", ",D37,", ",C37,", ",B37," - Genealogía")

7. Now you should have two columns at the end of the spreadsheet. A column for page titles, and a column for the wiki text. 8. Copy those two columns and open up a new excel or google sheets (both can be used to create a CSV file). 9. Make a header row with the left column called "Title" and the right column called "Free Text". Paste the two columns under those headers. 10. Now you'll need to text replace some things before you can download the file as a CSV. If there are any diacritics that are in the file, they'll need to be text replaced into wiki text code. The table below has some that are common. If you're not sure, just attempt to text replace them all. It doesn't hurt the file if they don't exist.

These are called Unicode characters. You can find more here.

</li> with nothing

11. Now clean up any extra spaces by highlighting all your columns with text in it and going to data > data cleanup > Trim Whitespace. 12. Double check your free text cells and make sure everything is consistently formatted and text replace or clean up any other problems you find 13. Download the file as a CSV 14. Sign in to the Wiki and click "Admin Links" 15. Scroll to the bottom of the page and click "Import CSV" 16. Choose your recently created CSV as the file 17. Leave the Encoding type as UTF-8 18. Usually choose to Overwrite existing content 19. Put whatever you want as the summary of the import and click "Import" 20. Check your pages that they are formatting the way you want. If they aren't, you can go back to your CSV file and edit any spaces/wrong coding if it's consistent across all your pages and you can re upload the CSV file, or just use the wiki text replace for other simple fixes.