Overview
The Upload Center generates column headers for a template to be filled out in a worksheet (ie. Excel or Google Sheets). Each Citywide module has various upload types to choose from. Some templates, such as the Asset Sync, can be customized but others require a specific set of column header fields to be completed within the application. The template must be exported and then copied back into the system exactly as is.
For step-by-step instructions on using the Upload Center, click here
|
Upload Type |
Description |
Customize |
|
Additions |
Complete additions/betterments in bulk. |
|
|
ARO Additions |
Complete additions/betterments in bulk for assets flagged with an asset retirement obligation (ARO). |
|
|
ARO Identification |
Bulk import valuation details including general ledger codes for assets that have been identified as requiring an ARO. Note: In the upload process for this template, there is NO approve/reject step. Changes are applied immediately once the upload has been submitted. |
Yes |
|
ARO/ARC Writedowns |
Complete ARO or ARC writedown adjustments in bulk for assets with an asset retirement obligation completed on them. |
|
|
Asset Sync |
Add or modify information in bulk, such as name, replacement cost, condition assessments, etc. Note: In the upload process for this template, there is NO approve/reject step. Changes are applied immediately once the upload has been submitted. |
Yes |
|
Asset Usages |
Attach current mileage reading and date by Asset ID and include Import ID as needed for multiple assets. |
Yes |
|
Fuel & Costs |
Attach fuel units, costs, and readings to multiple assets. |
|
|
Full Disposals (ARO) |
Complete full disposals on the ARO only in bulk. Asset remains in-service. |
|
|
Full Disposals (Asset) |
Complete full disposals on assets in bulk. |
|
|
Internal Transfers |
Complete internal transfers in bulk. |
Yes |
|
Lifecycle Event Definitions |
Import descriptions, event triggers, costs, etc. to lifecycle events. |
|
|
Lifecycle Quantities |
Update lifecycle quantities in bulk. |
Yes |
|
New Acquisitions |
Bulk import multiple new assets. |
Yes |
|
New Acquisitions - Non PSAB |
Bulk import multiple new assets as excluded from PSAB reporting. When using this template, the in-service date, historical cost, and/or estimated useful life fields if unknown can be left blank. These assets will be excluded from financial reporting. |
Yes |
|
Partial Disposals |
Complete partial disposals in bulk. |
|
|
Profile Sync |
Add or modify information collected within a profile. |
Yes |
|
Profiles |
Bulk edit profile group, lifecycle EUL, etc., on multiple profiles. |
Yes |
|
Schedule Lifecycle Events |
Schedule lifecycle events for existing assets. |
Yes |
|
WIP Transfer as Additions |
Complete WIP transfer as additions in bulk. Use this option when a WIP asset is being transferred to service as additions to multiple existing assets. The WIP asset ID as well as the asset ID for the receiving assets are required. |
|
|
WIP Transfers to Service |
Complete WIP transfer to service in bulk. User this option when a WIP asset is being transferred to service as multiple new assets. |
Yes |
|
Writedowns |
Complete writedowns on assets in bulk. |
|
|
Upload Type |
Description |
Customize |
|
Building Permit Types Other Permit Types Licence Types |
Upload various permit or licence types required (ie. single family dwelling, addition/renovation, fireworks or burn permits, animal licence, etc.) |
Yes Yes Yes |
|
Building Permits Other Permits Licences |
Upload existing list of permits or licences along with their application details. |
Yes Yes Yes |
|
Development Classes Development Services |
Organize Development Charges by class and services. To be included in various permit types as needed. |
Yes Yes |
|
Inspection Types Inspections |
Upload inspection types and details. Upload existing inspections and details into Citywide. Can upload completed or to be scheduled inspections. |
Yes No |
| Document Types | Upload a list of document types and details. | No |
|
Work Fields |
Upload a list of permit or licence attributes to be included in the permit or licence application. |
Yes |
|
Application Types |
Used in the Planning module, upload various application types |
Yes |
|
Work Fields |
Upload a list of work fields | Yes |
|
Upload Type |
Description |
Customize |
|
Areas Communities |
Grouping and classifying properties |
No |
|
Classifications |
Upload asset data within Citywide by grouping similar assets together for labeling, filtering and reporting purposes |
Yes |
|
Contacts/Customers |
Upload Customer or Contact information |
Yes |
|
Customer-Property Links |
Import ID links between Customers and Properties |
Yes |
|
General Ledger Codes |
List of general ledger codes to upload into Citywide |
Yes |
|
Properties |
Upload Property details |
Yes |
|
Property Uses |
Can include descriptions and/or property use codes |
No |
|
Roles |
Bulk add names of user roles and specify which Citywide module the role applies to |
No |
|
Users |
Bulk add list of users into Citywide |
No |
|
Zoning |
Add Zoning codes and/or descriptions as required |
No |
