Import Data

Import Data

Single Job Import

This screens provides a method for importing job details when you need a new job immediately imported and cannot wait for the overnight process to update the job list.

To add a new job:
  1. Enter the job number in the field
  2. Click SEARCH
The system will confirm the job exists and load the list of phase codes for the job.
If everything looks correct then click START IMPORT.

The new job will now be available in the system.

System Import Logs

This screen show the system import logs.

Data is imported in 6 steps.  Progress is shown as the process proceeds.
  1. Get Job Summary
  2. Get Time Cards
  3. Get Phase Codes
  4. Get Job Dates
  5. Get Jobs
  6. Get Employees
The import log displays the imports that have been done over the last 8 weeks.

The status code will show if the import process was successful or if there is an error code for a particular process.

    • Related Articles

    • Export Data

      General This process will export data from the database and provide it in another format for upload into your accounting system. The steps to export are: Select the week ending date that you wish to export. You can select one of the last 4 weeks. ...

    • Release Notes - March 2024

      A number of enhancements are now available. Job Cost Analysis Screen When syncing data, Spectrum will ignore any changes to phase codes set to "C" Complete Status. Spectrum does not allow any changes to a phase code cost or hours once the status is ...

    • Release Notes - November 2020

      We posted an update today with the following features/changes: Phase Code Screen - New Screen This new screen pulls all the phases codes for actives jobs onto one screen. This allows you to separate all phase codes by trade or other criteria such as ...

    • Release Notes - April 2023

      This release has a number of changes inside the functioning of the system. Automatic Overnight Updates The system will now update overnight automatically. This means there is no need to import the payroll weekly. The IMPORT button is now grayed out ...

    • Master Resource Loading

      This screen will rollup all the labor requirements across the entire business. For this screen to provide good forecast information, the individual jobs need to have reasonably accurate job start/finish dates. If you are using Work Groups, then the ...