Create New Community Record

Objectives

Setting up a new community record in FullCount and updating applicable documents about the new community

Prerequisites

Access to production database

Access to FullCount google map (requires google account)

Access to Community Abbreviations knowledge base article

Instructions

1. Download script create_new_community.txt from http://sourcecontrol.fullcount.net/repos/database/trunk/processes/implementation/create_new_community.txt.
2. Open script using SQLDeveloper or similar software.
3. Open connection to production database using fc_obj_owner user.
4. Update most recent community id with new community id. This will be the next increment of 10. If the current value is 1000, the next value to use is 1010. Use a find and replace to update all scripts.
5. Update community name in first insert script.
6. Update username suffix on create user profiles and kb username on create community script. In the script, all suffixes are single-quoted to allow for an easy find and replace. For example, if the previous community suffix was 'abc' and the new community suffix was 'def', replace 'abc' with 'def' in the script.
7. Run scripts in order.
8. Commit scripts run to the database.
9. Update excel spreadsheet Username Community Suffixes.xlxs located at J:\FullCount\FC - Implementations. If a community is internet independent, use the blue font. If the community is internet dependent, use the green font color. Place name of new community as the next line in the spreadsheet.
10. Open up FullCount back office and log in using one of the new users created.
11. Update community information (address, city, state, zip, phone, time zone) and save.
12. Add community to FullCount google maps located at https://mapsengine.google.com/map/edit?mid=z9C3xMDtjBlk.kKjU-iOfNlWw. Communities who are remotely hosted should have a red marker. Communities who are centrally hosted should have a blue marker. The username for the google account is support@fullcount.net. Password is located in Websites keepass.
13. Add community to knowledge base article, Community Names and Abbreviations, with community name and suffix. Community names are listed in alphabetical order.
14. Add kb user to help.fullcount.net. Query to get username and password at bottom of create_new_community.txt. Email will be <Username>noreply@fullcount.net
15. Update community record in Tracker with DB Community ID and billing abbreviation.
16. Update process record in Tracker with billing abbreviation, community code in resident portal URL, and implementer who requested the task.
17. Contact implementer to let them know the community has been set up.