Packages Dashboard

Owned by Matt Tate
Last updated: Oct 23, 2023 by Conk Buckley
18 min read

The Packages Dashboard is a filtered list of project packages that can be sorted, filtered, edited, and some columns can be totaled.  A "Default" report includes summary details described below, but you can create your own report(s) to display the data, calculated fields, editable fields needed for your company. The Default report provides the ability to open and delete packages, set the Required date for each package, change the package Status, open package attachments, and create .MAJ or .PCF file attachments. Note: For correct dates, verify that your computer's time zone is correct.

 

Default Report

The Default report is available out-of-the-box. Custom reports can be created and will display in the Report drop-down. See the Package Dashboard Reports example in the Reports (Admin) article for more information.

Columns

  1. Package Number and Package Name - Open a package by clicking the Package Number or Package Name link. Opening the package will display the package tabs that enable you to work with the package (Ex. Viewer, Cut Lists, Tasks, etc). The Package Number and Package Name were assigned to the package when it is created and can be edited by opening the package, clicking the Properties tab, and then editing the Name or Number fields. The Package Description, Category, Estimated Hours, Start Date, and Required Date can also be edited in the Properties tab for the package. A Package is created in the:

    1. Models > Viewer page

    2. Projects > Deliverables page

    3. Packages Dashboard page when the New Package is used

  2. Model - The name and link to the model from which the package was created.

  3. Description - The Description of the package if entered.

  4. Required - The Required date on the Default report is the date that the package materials are required to be on-site for the Field Phase Start Date. The Required date can be edited in-grid, or on the Package Properties tab, or on the Packages Schedule.

  5. # Assemblies - The number of assemblies in the package.

  6. # Parts - The number of loose parts (not found in assemblies) in the package.

  7. # Total Parts - The total number of parts including loose parts and those in assemblies.

  8. # Tasks - If a Task Workflow has been applied to a package, the # Tasks indicates the number of tasks that have been created for the package. See the Task Workflows (Admin) article for more information.

  9. % Complete - % Complete is calculated differently depending on whether the package includes tasks or not.

    1. Package includes tasks - When a package has tasks associated with its child assemblies or parts, the completeness of the tasks is used to calculate the % complete for the package.

    2. Package does not include tasks - When the package does not have tasks, the % Complete calculation is based on the packages' tracking status percentages. See the Tracking Statuses (Admin) article for information about how to setup % complete values.

  10. Estimated Hours - Estimate Hours are manually entered when the package is created, except when the package is created from the Projects > Deliverables page. Estimated Hours can be edited in-grid. The editable Estimated Hours field uses the STRATUS.Package.HoursEstimatedShop property in both default and custom reports.

  11. Actual Hours - Actual Hours are manually entered when the package Tracking Status changes and the Update Tracking Status dialog displays. Actual Hours can be applied to a Part, Assembly, or Package and the tracking log hours now bubble up to the package level. For example:

    If a part and assembly belong to a package and actual hours are entered:

    Part = 1; Part = 1.5; Part = 3; Part = -2
    Assembly = 5; Assembly = 7
    Package = 10
    Packages Dashboard = 35.5

    If part and assembly are in two different Package Categories and actual hours are entered:

    Part = 1; Part = 1.5; Part = 3; Part = -2
    Assembly = 5; Assembly = 7
    Package = 10
    Packages Dashboard for both packages = 35.5

  12. Division - The Division can be entered when the package Tracking Status changes and the Update Tracking Status dialog displays. The Division can be edited in-grid.

    1. The default settings for Division when creating a New Package, under Packages Dashboard and clicking the New Package button, will be the user’s last setting for Division.

       

  13. Status - The Tracking Status can be changed (in-grid) by clicking the Status link which will display the Update Tracking Status dialog.

     

    1. The default settings for Status when creating a New Package, under Packages Dashboard and clicking the New Package button, will be the user’s last setting for Status.

  14. Job (MAJ) - A download button and create date will display if a .MAJ has been generated by clicking the MAJ button under the Output column. Click the download icon

    and your web browser will prompt you to save the file. A .MAJ file includes fabricated and non-fabricated items included in the package.

     

  15. Attachments

    1. The Upload Attachments button

      can be used to locate and upload attachments to any package on the Packages Dashboard.

    2. Click the Open Attachments button

      to select and open any attachment.

       

  16. Toggle Archive Status - Use the Toggle Archive Status to archive selected packages. By default, the Toggle Archive Status button will only be permissioned (visible) to users who have the Project Admin role. When clicked, the Toggle Package Archive Status prompt will display.

     

  17. Delete - Click the Delete icon 

    to delete the package. All parts and assemblies will be disassociated from the package.

  18. Output - For published Fabrication drawings, you can generate .MAJ or .PCF file and then download from the Download Link. Note: If you receive an error attempting to generate an output file, see the Fabrication Job issue creating MAJ or PCF files from the Packages Dashboard article.

    1. For information on automatically generating a .MAJ see the Generate Automated .MAJ CamDuct Cut List File article.

    2. For information on automatically generating a .PCF file, see the Generate Automated .PCF PypeServer Cut List File article.

    3. Custom Data Fields - STRATUS custom data fields can be included in a .MAJ file.

      1. A custom data field is published and edited.

      2. A MAJ file can be generated and opened with edited custom field on parts:

  19. Totals - By default, numeric columns (Integer and Decimal which includes # Assemblies, # Parts, # Total Parts, Tasks, Estimated Hours, and Actual Hours) are totaled. In addition, Feet Inch totals can be added to a custom report by configuring the report’s Total Values setting to Yes for the target columns. See the Package Dashboard Reports example in the Reports (Admin) article for more information. 

    1. When Show Entries is not All, which limits the number of packages that display, then a subset of packages can display. In this case a subtotal (150.29’) followed by the total for all packages (24226.2’) will display.

Filter and Sort the Dashboard

Filters

Filter the dashboard by one or more of the following:

  • Filter by one Project or All Projects.

  • Filter by one Model or All Models.

  • Filter by one or more Divisions (defaults to ALL Divisions).

  • Filter by one or more Statuses (defaults to ALL Statuses).

  • Filter by one or more company package Categories (defaults to ALL Categories).

  • Filter by using the Search option which searches the package by name, number, model, required, Division, or tracking status. In addition, if search criteria is entered while the Packages Dashboard is loading, any packages matching the criteria will immediately display at the top of the table.

  • Filter the dashboard content by clicking a Filters button in the column header

    and then selecting the option(s).

     

When a filter criteria finds no results the following message will display:

  1. Assemblies > Dashboard

     

  2. Packages > Dashboard

     

To filter to packages that do not have a Required Date:

  1. Click the Filter button. A filter will display.

     

  2. Click the red x for both fields. Empty Required Dates will display.

     

Date Window Filter

When enabled the date window filter will filter the dashboard data table to items whose date is a specified number of days before and after the current date. This tool is targeted at those who prefer to view packages within a consistent date range window every time the page is loaded. These settings will persist on the Packages Dashboard, Schedule, and Status Board until they are changed on any page or turned off.

To use the Date Window filter:

  1. The Date Window filter is off by default.

     

  2. Click the Date Window filter button to display the dialog.

     

  3. Click the gear icon to display configuration options.

    1. Include empty dates

      1. Checked - When checked if an item’s date field is Empty, it will display in the data table.

      2. Unchecked - When unchecked if an item’s date field is Empty, it will not display in the data table.

    2. Count Days as

      1. Business - For the business day calculation, weekends are excluded while public holidays are included as a business day.

      2. Calendar - For the calendar day calculation, all days are included.

  4. To configure the date window:

    1. Date drop-down - The Date drop-down displays all planning date fields located under Packages > Properties > Planning. Note: The Default is the Required date which also displays on the Packages > Dashboard default report. Select one date field.

    2. To select the number of days prior to today, click the number and either enter a number or use the up/down arrow to change the value. The exact date the number references will display (hover text) as the number value changes. In this example, 10 days (business days) prior to today is 6/7/2022.

       

    3. To select the number of days after today, click the number and either enter a number or use the up/down arrow to change the value. The exact date the number references will display (hover text) as the number value changes. In this example, 15 days (business days) after today is 7/12/2022.

       

  5. When done, the data table will filter to display only items that meet the criteria. Once set, these settings will continue to be used until they are changed.

     

Sort

Users can manually sort a column heading by clicking the Sort button which will override the existing primary sort. See the Sort and Filter Data Tables FAQ for more information.

  • Click Sort button - Any sort button has 3 states:

    • Click 1 - sorts the column in ascending order.

    • Click 2 - sorts the column in descending order.

    • Click 3 - sets the table back to the default sort order according to either the pre-defined table sort order (if one exists) or the sort order specified by the report’s sort index settings.

  • Default Reports - Default reports for the following dashboards include a default sort order. After a user manually changes the sort order for a dashboard, that sort order will override the default sort order and will continue to be the primary sort on that table for that user until the user changes it.

    • Packages Dashboard - Required date

    • Assemblies Dashboard - Assembly Name

    • Container Dashboard

      • Report - Container Type

      • Details Report - Item Type

  • Custom Reports (Sort Index) - Report designers can specify a Sort Index for custom reports under Admin > Company > Reports > Report Fields. When a custom report is first loaded by a user, the Sort Index with the lowest number will be the primary sort. The next lowest index number will be a secondary sort when the primary sort includes identical values. Ex. If the table displays states, cities, and zip codes where state is sort index 1, city is sort index 2, and zip code is sort index 3, then, the primary sort will be state, the secondary sort will be cities which will be sorted alphabetically, and zip codes will be the third sort when there is more than one city.

    • Note: After a user manually changes the sort order for a dashboard, that sort order will override the default sort order and will continue to be the primary sort on that table for that user until the user changes it. The lowest sort index will become the secondary sort, and so on.

  • Reset Sorting - Another way to sets the table back to the default sort order is to click the Reset sorting button.

Display Active or Archived Packages

Once archived:

  1. The package will not display on the Packages Dashboard unless the Archived tab is selected. Use the Status "Active" or "Archived" filter in the Package dashboard.

     

  2. If an archived package is opened, only the Properties tab will display and all Properties will be disabled, except the ability to uncheck the Archived option.

     

  3. An archived package will display in the Models > Viewer under Display Modes and Filters where the Archived lable displays along with a hyperlink to the Package’s Properties page.

     

  4. Also on the Models > Viewer, with the Actions > Packages panel open, when an archived package is clicked it will display the Archived label and include a link to the package.

Cached Calculated Values

Calculated field values are automatically cached and purged for each package. Package Dashboard cached values are automatically purged when:

  • any type of update changes values, such as editing parts in a package or assembly

  • using a field that is a total value from all parts in the package

  • a Field references a Part property, or another Field value and they are modified

Clear Cached Calculated Field Values and Reload Data Table

The Clear Cached Calculated Field Values and Reload Data Table button forces calculated values to be refreshed. This button should only be needed as a backup as the Packages Dashboard will detect when calculated fields need to be refreshed.

Paging

The Packages Dashboard uses Paging to load the data table. When the Packages Dashboard initially loads, all Package Names and non-calculated fields will load first. Calculated data will continue to load and replace skeleton placeholders on the dashboard until all data is populated. The benefit is that while data is populating, functions like sorting, filtering, package links, generate MAJ, update Status, and edit fields are available. When a non-calculated column is used as a filter, packages at the top of the newly filtered dashboard will begin to load. Totals will continue to update as row values are calculated. The data table loading indicator (red bar) will display until all data displays in the data table.

New Package

The New Package button is primarily used for non-modeled Field Requests. By creating a package and then attaching a sketch or document to the package, the normal package workflow can be used to track the package and assembly through the project. See the Field Requests article for more information.

New Package Prerequisites

Before creating a New Package when the "Add Assemblies and Parts" checkbox is checked, verify the following in the Models > Viewer. If unchecked, the prerequisites can be ignored.

  1. Company Filter – Verify that the Company filter that will be selected works.

  2. Package Category – Verify that the parts being added to the package are not already included in the same package category. Note: If any part/assembly is already included in the selected Package Category, the part/assembly will not be added to the package and you will not receive a confirmation notification.  See the Package Categories (Admin) article for more information.

  3. Tracking Status – Verify that the filtered parts are in a "Can Package" tracking status. See the Tracking Statuses (Admin) article for more information.

  4. Area – Verify that the target Area is included under Admin > Projects > Areas.  See the Areas (Admin) article for more information.

Create New Package

To create a new package from the Packages Dashboard:

  1. Click the New Package button. The New Package dialog will display.

     

    1. Category - Select the Package Category. In this example, the resulting package will be hangers for a specific area and the selected Package Category does not include assemblies. As a result, if these hangers are part of an assembly, the assemblies will not be included in the package.  See the Package Categories (Admin) article for more information.  Note: If any part/assembly is already included in the selected Package Category, the part/assembly will not be added to the package and you will not receive a confirmation notification.

    2. Name - In the Models > Viewer, the Name data can be automatically populated by clicking a part. When creating a Package in the Packages Dashboard, a part is not selected so you will need to enter data now or at a later time. Some fields which are not part specific, like Project Name, will automatically populate based on your Naming and Numbering settings. See the Naming and Numbering (Admin) article for more information. 

    3. Status – Set the Tracking Status the package will be in once created.

    4. Division - Set the package Division (if any) once it is created.

    5. Description – Include a Description to clarify the package if needed.

    6. Hours Estimated – Enter Hours Estimated, if necessary.

    7. Required Date – Enter a Required Date to communicate with the project manager and shop.

    8. Add Assemblies and Parts checkbox - Check the Add Assemblies and Parts checkbox to automatically add parts/assemblies that meet the Filter and Area selections below.

      1. Filter – Select the single Filter to be used to isolate the parts/assemblies. See the Filters (Admin) article for more information.

      2. Area – Select the single Area the package will include. See the Areas (Admin) article for more information. Below is an example of the Areas drop-down list.

         

  2. Click the Create Package button and the package will display on the Packages Dashboard and will include any entered Data and the number of Parts and Total Parts that were added to the package. No assemblies were added since the selected Package Category ignored assemblies.

Download CSV or Excel

The Packages Dashboard for a project and model can be downloaded to a CSV file or an Excel file.

Import CSV

A CSV file can be imported to either create new packages or update existing packages. This feature could be used in various scheduling scenarios where packages with start dates and other fields could be imported into STRATUS from a Project Scheduling tool that can output to CSV format.

Note: When importing a file back into STRATUS: 1) only a CSV file can be imported back into STRATUS, and 2) the Package Dashboard must be filtered to one project and one model for the Import CSV button to be enabled.

File Configuration

A CSV file that will be imported using the Import CSV button can be created in several different ways. In the examples below, the 2 packages already exist.

To Configure the file Format and Field Values

  1. Create a file in one of two ways:

    1. Create a new file - Create a new file with the required field headers and then add any optional fields below.

      1. Package Number (Required)

      2. Package Name (Required)

      3. Id (Required) - This field is required to be in the file, but should be left blank for new rows.

      4. With only the required fields a comma-delimited CSV file might look like this where row 2 is a package that will be imported.

    2. Download an Existing CSV File or Excel File - Click the CSV or Excel button. The file will download the field headers and data associated with the selected Packages Dashboard Report. In the example below, the Default report was selected and includes 4 rows of data.

      1. Open the File in Excel. The following fields display.

      2. Open the File in Notepad or Notepad++. The following fields display.

         

  2. Optional Fields
    The following optional fields can be added to the file. Optional fields that include data will update the package during the Import CSV process. Fields that do not include data will be ignored. The Field header name used in the CSV file will depend on the report format specified in the package dashboard, otherwise the STRATUS.Package.* name will always work. See the Header section of the Report Fields topic for more information.

    1. Description - The Description field is optional.

    2. STRATUS.Package.StartDT - The STRATUS.Package.StartDT will only be updated if it is a valid date-time value (Ex. 03/24/21).

    3. STRATUS.Package.Required or the Header name specified in the report format - The RequiredDT will only be updated if it is a valid date-time value (Ex. 03/24/21).

    4. STRATUS.Package.HoursEstimatedShop or the Header name specified in the report format - The HoursEstimated value must be a valid number or will be set to zero.

    5. STRATUS.Field.* or the Header name specified in the report format - Any STRATUS.Field.* value that is editable can be updated. Note: If the editable field is defined as a date-time format, a valid date-time value must be entered (Ex. 03/24/21).

    6. STRATUS.Package.CategoryName - If the STRATUS.Package.CategoryName field is not included, the Package Category named Default will be applied to new imported packages. Note: In this scenario, a Package Category named Default must exist. Out-of-the-box the Default Package Category does exist but it can be deleted or renamed.

    7. STRATUS.Package.Notes

      1. Existing Notes - Existing Notes will not be removed.

      2. Duplicate Note - If a duplicate Note is found, the newest Note will not be added to the Packages Dashboard during the Import process.

      3. Multiple Notes - Multiple Notes should be entered using a semicolon as a separator between notes.

  3. Ignored Fields
    The following fields will always be ignored by the Import CSV process and will never be used to update a package.

    1. Model

    2. #Assemblies

    3. #Parts

    4. #Total Parts

    5. #Tasks

    6. %Complete

    7. Actual Hours

    8. Division

    9. Status (Active or Archived)

    10. Tracking Status - Like other new packages, any new package included in the import file will be assigned the first available “Applies to Package” tracking status.

    11. Category - Category data is only used when constructing NEW packages, cannot modify this property.

    12. Category Abbreviation - Category Abbreviation data is only used when constructing NEW packages, cannot modify this property.

Import Process

For this example, to import a CSV file with one new package the following CSV file will be used. For additional packages, add rows to the file. The CSV file can be imported many times and only the new or updated information will be imported.

  1. If an Excel file was used to edit field values in the previous section, save the file as a CSV file format.

  2. Enable / Disable Import CSV button - On the Packages Dashboard, the Import CSV button will remain disabled until one project and one model have been selected. Neither ALL PROJECTS nor ALL MODELS can be selected.

  3. Click the Import CSV button.

     

  4. The Import Packages dialog will display. Click the Browse button and locate the CSV file.

     

  5. The Upload Packages CSV File dialog will display. Click the Upload button.

     

  6. Once the file has uploaded the Close button will be active. Click the Close button.

     

  7. The Import packages dialog will display again, this time with the CSV file ready to be imported. Click the Import button.

     

  8. Once the file has imported, the following message will display. Click the OK button.

     

  9. After the Packages Dashboard refreshes:

    1. Packages Dashboard - The new package will display on the Packages Dashboard. Some of the data entered in the CSV file are highlighted on this page.

       

    2. Package’s Properties - The STRATUS.Package.StartDT and STRATUS.Package.CategoryName fields display on the Package’s Properties tab along with the other CSV field data.

       

    3. Package’s Notes - The STRATUS.Package.Notes field displays on the Package’s Notes tab.

       

  10. Note: Like all packages, when a package is created via the Import CSV process, it will:

    1. Display as an Activity under Admin > Company > Activities.

    2. Display as a Notification.

Videos

See the Packages Module Overview webinar CSG Webinar: STRATUS In-Depth Series, The Packages Module for more information.

STRATUS 07-25-19 Implementation Webinar - (Package Dashboard Configuration 26:01)













© Copyright 2022 GTP Services, LLC All rights reserved. | About | Contact