This PST file is used to bulk import data you have supplied into our provisioning system to aid a more streamlined delivery process. It is split into 5 tabs, all colour coded:
Red = Mandatory/Required,
Orange = If Available,
Green = Nice to Have.
1. Groups Sheet
Purpose: Defines each customer location or site group. If a new group is required on Unity, please complete this tab
Key Fields Explained:
β’ GroupID β Unique identifier used to link data across all sheets.
β’ Group Name β The friendly name of the group or site.
β’ Domain β Domain used for service configuration.
β’ Calling Line ID Group Number β Outbound CLI for the group.
β’ SLC / Contact Details / Address β Used for service records and support reference.
β’ Notes β Optional extra information.
π 2. Numbers Sheet
β’ Purpose: Lists the number ranges allocated to each group. If you are porting any numbers to Redcentric, enter the start and end for each range. The format is E164 (drop the 0 and add 44).
Key Fields:
β’ GroupID β Must match a GroupID from the Groups sheet.
β’ From / To (E164) β Start and end of allocated number range.
β’ Type β Identifies whether numbers are new, ported, DDI ranges, etc.
3. Services Sheet
Purpose: Defines services that will be provisioned at group level.
Examples include: Hunt Groups, Auto Attendants, Voice Portal
Key Fields:
β’ Service Type & Name β Identifies the service being created.
β’ CLID Names β Outbound CLI presentation.
β’ New / Ported Numbers β Numbers linked to the service.
β’ Extension β Internal extension.
β’ Group Policy & Enhancements β Specifies behaviours and optional packs.
π 4. CallCentres Sheet
Purpose: Used only for call centre services (Basic/Standard/Supervisor/Premium).
Fields mirror the Services sheet, but specific to Call Centre provisioning.
π 5. Users Sheet
Purpose: Defines all end-users, their numbers, devices, service packs, and features.
Key Fields:
β’ GroupID β Assigns users to sites.
β’ First/Last Name & CLID Names β User identity and outbound CLI.
β’ UserID / Email / Mobile β Identity and login details.
β’ Ported/New/Alternate Numbers β Number assignment.
β’ Extension & Department β Internal configuration.
β’ NCOSLevel β Call restrictions.
β’ Passwords / Passcodes β Optional or autogenerated if blank.
β’ Features β VoiceMail, Call Waiting, CFA, Akixi, Call Recording, CLI Policies.
β’ Device Type β Device provisioning.
β’ Location & Location Profile β Emergency location/feature settings.
βοΈ How to Use the Template Successfully
1. Start with Groups β These IDs must exist before referencing them anywhere else.
2. Add Number Ranges β Ensure numbers do not overlap and are in E164 format.
3. Define Services β Hunt groups, auto attendants, or call centres.
4. Add Users Last β Assign numbers, devices, and service packs.
5. Do Not Modify the Settings Sheet β It is used by the system for validation.
________________________________________
π‘ Tips for Accurate Submission
β’ Ensure all GroupIDs match across sheets.
β’ Keep number formats consistent (always E164).
β’ Leave passwords/passcodes blank if you want them auto-generated.
β’ Use the Notes fields to add any special instructions.