This page describes how to import the POIs spreadsheet into PBase.

Steps:

(1) Open up spreadsheet {J_POIs_May2024}

(2) Highlight the cells from A1 to the bottom-right etc

(3) CTRL-C to copy

(4) Go to Tablesgenerator { https://www.tablesgenerator.com/html_tables }

(5) If there's table data existing, select "File...New Table" then select the defaults which appear ("Create")

(6) With cell A1 highlighted, paste (CTRL-V)

(7) Select the check-box above row #1 to highlight all the data

(8) Select "Table, Clear Formatting."

(9) Select a font size from the font-size drop-down under the "Help" menu, all the data should adjust to the selected size

(10) Unselect the data, then select the column headings (Row 1) row alone (Shift-Right Arrow)

(11) Center & bold the headings, then click in another box to deselect everything

(12) Under the table, click "Generate" on the left, then "Copy to Clipboard" on the right

(13) Paste the data into a blank TXT or HTML editor (preferably Arachnophilia)

(14) Delete the "maps link" line entry near the top of the code (reference SS1)

(15) Perform the following global search & replace actions to combine the Maps Link with the GPS coordinates & make the coordinates a clickable link:

(note, you can copy-paste this into Notepad but you need to remove the 'leading space' in front of http, and make sure 'td class' matches also, reference SS2, SS3 and SS4)

	Find:   <td class="tg-z9od"> http://maps 
	Replace:<td class="tg-z9od"><a href=" http://maps 
(basically simply insert the pink text

	Find:   <td class="tg-z9od"> https://tinyurl 
	Replace:<td class="tg-z9od"><a href=" https://tinyurl 

	Find:   </td>
    <td class="tg-z9od">3
	Replace: " target="_blank">3

(16) Scroll through the code to make sure there are no broken links

(17) Save as a file with a name such as "tmp1.html" then open this file to make sure everything is ok

(18) Once code is OK, copy & paste into PBase