Create a report layout using the offline template builder
Export and Import your Data Model
First, you need some data to work with. To do this you’ll export the Data Model from Aconex, and import it into the BI Publisher template builder.
- From the custom reports tab, hover over your report and click the ellipsis menu.
- Click Export to XML and save the XML file to your computer. Note: This function is only exporting the Data Model (subject areas and attributes) used in the report.
Layouts designed in the online editor cannot be exported or used in the plugin. Similarly, layouts created with the plugin cannot be modified in the online editor.
Export to XML shows the subject area metadata only when there’s data to be retrieved in the respective module.
For example, there are documents in the document register, but none of them are attached in workflows.
For a data model created with Document as main subject area and Document Workflow Steps as the supporting subject area, the exported XML file will show the Document subject area metadata but not the Document Workflow Steps metadata.
Once a doc is attached in any workflow then the exported XML will return the workflow step metadata as well along with Doc metadata.
Open Microsoft Word and begin a new blank document (or open an existing template). Click the BI Publisher tab.
You’ll see that most icons in the tab are greyed out. This is because the data model has not yet been imported.
The BI Publisher plugin can also be used in Microsoft Excel, but we recommend using Word.
- Click Sample XML and select the XML file containing your Data Model, that you exported from Aconex in the previous steps.
- You’ll receive a confirmation that the Data loaded successfully.
Now the icons in the Insert panel (that were previously greyed out) are now available to use. We can begin building the layout for our report.
Create a report layout
Select a component to build your layout. To demonstrate, let’s insert a table using the Table Wizard.
For the full list of available components, see Using Layout Components in the Offline Template Builder.
Make sure you use the insert options within the BI Publisher tab. If you insert a regular table using the standard Word formatting options, your layout will fail to import into Aconex.
- Click Next.
- Select the Data Model to use in your table. In this example, we chose workflow steps as the main subject area, so let’s select that and click Next.
- Select the columns to display in the table. Double click on an attribute to include it, or use the arrow buttons. You can also change the ordering of the fields.
- Configure grouping for your table and click Next. For example, you may want to group by Workflow number, to keep relevant data together.
- Apply sorting for your table and click Finish.
Your table should look similar to the example below.
The top row of the table contains the column headings, and in the second row, are the data fields (attributes) that will display down the page.
This example is grouped by Workflow No.
You may see an F character on the far left, and an E on the far right of your table. These are special fields that allow the template to import into Aconex. Make sure you leave these in position whenever you modify your table layout.
Use the standard Word formatting tools to adjust the look of your table (such as font, alignment, and color). If your table is too large to fit the page width, you can click the Web Layout view and scroll to view the table as needed.
Now is a good time to preview your table, to get an idea of how it will display. In the Preview panel, click DOCX to preview in Word.
Save your layout as an RTF file when prompted. Make sure you give the file an appropriate name and save it in a safe location. This filename will be the name of the layout, once it’s imported into Aconex.
Fine-tune your layout
Now, we can make some adjustments to the layout. Edit headings, add columns, format data fields, and apply custom formulas (advanced users).
Edit column headers
Click into a heading cell and change its name to suit your requirements.
Add or Remove columns
Right-click your table and select either Insert or Delete to add or remove columns.
Add data columns
Click into a newly added cell and select Field from the top Inset menu. Select a data field and click Insert.
Format data fields
Right-click on a data field and select BI Publisher > Properties. For example, you may want to format all date fields to ‘YYYY/MM/dd’.
Optional: Insert a custom calculated field
Advanced users can use SQL or XSL code to create custom fields in your report layouts. In this example, we’ll create a custom field named ‘Next Due’ that adds four days onto the date_in field.
To achieve this, we first need to insert any data Field. Then we’ll repurpose it as a ‘Next Due’ field with custom code.
- Click your mouse in the table cell where you want to place the custom field, then click Field from the insert panel. Insert any field from this list (it doesn’t matter which field is inserted as we are going to customize it’s display name and calculation)
- Right-click on the data field you inserted and select BI Publisher > Properties. Give your field a new label in Text to display. In this example, we’ll name the field ‘Next Due’.
- Click the Advanced tab, and enter your formula in the Code field. (you’ll need to remove any text that was already entered there)
- Click OK. Your field will be inserted into your layout where you can apply formatting as required.
Finalize your Template
Once you’re happy with the look of your template, make sure you Save, and then take another peek using the Preview option.
Make sure you save as a .RTF file.
Validate your template to check for errors. ‘No error found’ means your template file should successfully import into Aconex.
Import and View
Now, in Aconex, select your saved report and choose Import Layout from the ellipsis menu. Select your saved .rtf template file and you’ll receive confirmation that your layout was imported successfully.
If you’ve previously imported this layout into Aconex, you’ll first need to delete the older version in Aconex before you import the updated one. Layouts can be deleted using the Add/Edit Layout option.
When saving the .RTF layout template do not use special characters in the file name.
Aconex doesn’t support importing .RTF layouts with special characters in the file name (e.g. RFI_sent&received.rtf). Make sure you avoid special characters or you’ll get an ‘unable to import layout’ error message.