Import jobs from Spectrum as Traqspera jobs.
If you want to import service work orders, follow the steps
in Sync Service Work Orders as Jobs before proceeding. Otherwise, ensure
the application setting Sync Service Work Orders is disabled
before running your first job sync.
Note: Spectrum jobs are only imported if they have both one active phase code and one
cost type activated/toggled on in the Cost Type/Phase Type Setup page.
- If you do not want all jobs syncing in or are
running a multi-entity Spectrum (where multiple
companies are in the same Spectrum company code),
configure the Job Allow List or Job Deny
List to limit the job sync operation.Important: Do not use both lists at the same time.
- Navigate to Settings & Permissions > Import Configuration > Job Allow/Deny List.
- Enter one or more combinations of the following code types to check
for:
-
Cost Center
-
Division Code
-
Job Number
-
- Navigate to Settings & Permissions > Import Configuration > General and enable the setting Spectrum Add New Phase Codes to All Cost Types.
- Navigate to Settings & Permissions > Timesheet > Clocking and enable the setting Use Sub Jobs on Clocking.
- Depending on your needs, you may also need to adjust these
additional settings:
-
If you use cost centers, navigate to set Settings > Settings & Permissions > Import Configuration and set Job Category Mapping Field to Cost Center.Note: If you do not use cost centers, ensure this is left as Division as further setup may be required. Always check to see if they use multiple job cost departments and these link to specific division codes using the section Job Category Department Override.
-
If you want to use estimated or projected job hours, set Estimated Job Hours. Once set, phase codes on the Jobs page will display either Projected Hours or Estimated Hours from Spectrum.
-
- If you do not want certain phase codes imported, follow these steps to deny
them.
- Navigate to Settings & Permissions > Import Configuration > Phase Deny List.
- Select Add Phase Deny List to enter a single phase or a phase/cost center combination. Select Save.
- Select Mass Add Phase to add a group of phases. Use Add By Range to add all of the phases on the range you have set in sequence (easiest for companies with simple phase numbering scheme). Use Add From List to choose specific phases to deny from a multiselect field. Select Save.
- Run the Cost Type
Sync (no jobs or phases will be imported yet).
- Navigate to Serrings > Settings & Permissions > Cost Type/Phase Type Setup.
- Select Sync Cost
Types.cost types will be imported, but no jobs or phases will be imported yet.
- Enable the Cost Types you wish to show the
relevant phase codes for on timesheets, equipment entry, or expenses by
toggling the buttons on this page.Important: Toggling cost type(s) automatically begins a job sync. If you do not want jobs and work orders to sync yet, skip this step.
- If Cost Type descriptions aren't automatically populated, please contact support to ensure your MSSQL version is 7.0 or later.
- Navigate to Jobs > Job List.
- Select Sync Spectrum Jobs.
- Select Sync Jobs.Once synced, the Last Successful Sync time updates.
- Ensure the imported work orders and jobs are correct.
- If work orders and/or jobs did not import, you can try the following
- Navigate to Settings > Settings & Permissions > Sync Troubleshooting > Jobs/Phases.
- Check Sync Logs for details on any sync failures.