How to publish a new business on the Lomita Website business page

1. Edit the Excel spreadsheet - edit or add a new business

	a. ALL CAPITAL LETTERS
	b. USE THE PHONE FORMAT: 310-123-4567.  If none available, use NONE
	c. USE A BUSINESS TYPE AS FOUND ON THE SPREADSHEET - if possible
	d. USE STREET NAMES AS FOUND ON THE SPREADSHEET (so sort works correctly) if possible
	e. ADDRESS RESTRICTIONS:
		- Suites always start with # (even for alphabetic suites)
			ex.  2049 PACIFIC COAST HWY #B
		- half addresses - put a space between the whole number and 1/2   
			ex. 12345 1/2
		- No periods in the street address
		- Drop N/E/S/W before street ( Lomita isn't that big )
			ex. "25622 N WALNUT AVE"  should be "25622 WALNUT AVE"
		
2. Sort the spreadsheet
	a. select the cell above row number 1, to the left of column heading A - selects the whole document
	b. Data > Sort > 
		Sortby Column A (Ascending)
		Check Header row
		OK

3. Save the spreadsheet as businesses.XLS for future use
	a. FILE > Save

4. Save the spreadsheet as a Tab-separated text file
	a. File > SaveAs
	b. select   Save as type:  Text (Tab delimited) (*.txt)
	c. File name:  businesses.txt
	d. Save In: should be the directory containing your original spreadsheet
	e. Save
		The selected file type does not...  OK
		businesses.txt may contain...    YES
	f. File > Exit
		Do you want to save...  NO
	
5. RUN THE DOCUMENT FORMATTER
	a. double-click the doit.bat icon

	*****************************************************************
	***                                                           ***
	***  PROCESS LOMITA BUSINESS LIST FOR WEBSITE PUBLICATION     ***
	***                                                           ***
	*****************************************************************
	INPUT FILE:  businesses.txt
	OUTPUT FILE: businesses.htm
	Input file found.  OK
	Process incoming for double quotes and delimiters
	Filter out Excel headings...
	Split Address into components...
	Rearrange input file so sort keys on business names...
	Sorting...
	Restore column order
	Append address to end of working-copy lines...
	Processing sort key. Remove suite from street address..
	Add suite number to end of each working-copy line...
	Create HTML Page
	Copy template header...
	Format input data...
	Copy template header
	Cleanup...
	DONE.  Output is businesses.htm.  

	Ready to open and verify businesses.htm [Y]?  <Enter>

	
	b. The new webpage should appear

		If "To help protect your security,..." appears above the city logo, 
		left-click the white 'Click here for options' line, select ALLOW BLOCKED CONTENT, select YES

	c. Sort by each of the four columns - both forward and backward.

	d. Make a note of any errors

	e. Close the browser or tab that you've been reviewing


	f. If errors were found, go back to step 1.

	g. If no errors were found, upload to the website

		Ready to upload this file to the public website? [N]?  Y