Document Index by Tag (SDI Report by Tag)

Carl Mueller
June 11, 2024
2 min read
Product Updates

A few weeks back we spoke on the topic of document indexing by tag in DocBoss. Here’s an updated article on a related topic.

Our new output format lists the units on a project and cross-references the documents each unit is linked to. Users can create reports showing the status of linked documents for each unit.

Sometimes we are trying to generate a document index by equipment:

2023-12-20_13-50-07.png

This option for SDI Report templates combines the list of equipment units with card metadata in a pivot-style output by doc code.

List of equipment units

On the Index template, in order to include the equipment units, use the variable options from the <Start_AllUnits>/<End_AllUnits> arrays (under the TYPE=CoverPage tab in the XLS Template Variables document).

See below:

2023-12-14_17-37-40.png

Grouping

Optionally, the parameter GroupBy=FIELD can be included in <Start_AllUnits> to group data from multiple units into a single field (list) output (ie. |GroupBy=Tag).

Doc code list and card meta-data

Variables for doc code list and card cross-reference metadata should be included between the arrays <CStart_DocumentCodesCount> / <CEnd_DocumentCodesCount>, which must be placed in a separate column at the start and at the end of the list of variables.

2023-12-20_17-31-54.png

Doc codes

Project document codes can be listed horizontally using the available DocumentCodesCount variables:

2023-12-18_13-53-20.png

For example, if you wish to show the doc codes and the doc code names the variables should be included in the column header.

2023-12-20_18-09-22.png

Card metadata

Card cross-reference metadata variables can be added using the following format:

<AllUnits.DocCodeCards.<DocumentCodesCount.Index>.*****> (where ***** should be replaced by a cover page variable).

Most variables are supported, but if there are no results, check the list of available variables listed on the TYPE=Index tab in the Pivot Output – Units to Codes section.

If multiple cards match the code to unit matrix, the data will output in a card status, the variables should be placed on the same line as the AllUnits variables.

2023-12-20_18-26-18.png

This layout will show the status of each card cross-referenced with each equipment unit.

Ready to leave the
clerical grind behind?

DocBoss is the only true document control system for
suppliers. Book a quick demo to see how we help process
equipment suppliers make more profit with less pain.

Related Resources