Maintenance required - Friday August 7th 10:00 pm (UTC – Coordinated Universal Time)

Support Central will be briefly offline on Friday August 7th at 10:00 pm (UTC) while we make improvements and upgrades to this site.

You are here

Create a Report Layout with the Offline Template Builder

Design your report offline using the BI Publisher plugin for Microsoft Office.

Use the Oracle BI Publisher plugin in Microsoft Word to create a customized layout for your report. The plugin allows users who are familiar with either Word or Excel to easily produce a report layout for importing into Aconex. This is useful if your organization already uses predefined report templates that have been created with Microsoft Office applications. Advanced users can also use XSL or SQL code for displaying customized data. 

Before you begin:

The plugin only supports Microsoft Office for Windows computers. If you are unable to use the plugin, you’ll need to use the online editor to design your layout.

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.

  1. From the custom reports tab, hover over your report and click the ellipsis menu.
  2. 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. 
Export custom report data to XML

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.

  1. 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.
click BI Publisher

The BI Publisher plugin can also be used in Microsoft Excel, but we recommend using Word.

  1. Click Sample XML and select the XML file containing your Data Model, that you exported from Aconex in the previous steps.
click sample xml
  1. 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.

insert menu

Create a report layout

  1. You can choose any method to build your layout.  To demonstrate, let’s insert a table using the Table Wizard.
click table wizard

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.

  1. Click Next.
click next
  1. 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.
chose the data model and click next
  1. 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.
select fields
  1. Configure grouping for your table and click Next.  For example, you may want to group by Workflow number, to keep relevant data together.  
select group
  1. 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. 

table example

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.  

web layout

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.

preview layout

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.

rename headings

Add or Remove columns

Right-click in your table and select either Insert or Delete to add or remove columns.

insert column

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’.

field properties
apply date format

Add data columns

Click into a newly added cell and select Field from the top Inset menu.  Select a data field and click Insert.

insert field

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.

Looking for more formulas? See Apply advanced formula calculations in BI Publisher.

  1. Click your mouse in the table cell where you want to place the custom field, then click Conditional Format from the insert panel.
  2. Click the Advanced tab, and enter your formula in the Code field.
  3. Give your field a name and click OK. Your field will be inserted into your layout where you can apply formatting as required.
conditional format
custom formula

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.

validate template

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 imported successfully.

import layout

If you have 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 from the Add/Edit Layout screen.

Click on the report title to view and share your new report.

Was this article helpful?

Thanks. A ticket has been opened with the Support Central team.