Using Cascading Metadata with your project
To use Cascading Metadata on your project, you’ll need to create a hierarchy template: a spreadsheet saved in .csv format.
In this spreadsheet, the column headers reflect the document fields with which you want to associate Cascading Metadata. The rows show the values that will become available with each attribute selection the user makes.
You must use the database field name for column headings. If you have re-labeled fields then be sure to enter the original database field names in the import file. eg:
Document Type = doctype
VDR Code = vdrcode
Select List 1 = selectList1
Setup Cascading Metadata
- You’ll need to speak with your Aconex Representative to help set this up initially.
- Work out how you want a user’s selection in each document attribute field to impact the options available in other fields.
- Create a spreadsheet like the one shown above, with a column for each field. Enter the values that will be available in each field in the rows.
- Save the spreadsheet in .csv format. Click on File > Save As... and in the Format field choose Comma Separated Values (.csv).
- Send the initial file to your Aconex Representative for loading. After the initial setup, and you make changes, you can send your updated file to the Service Desk for loading.
- the values you enter into your template match the values in use on the project exactly
- you repeat the parent values (shown on the left in the image above) for every child value (shown on the right) in the template.
- you configure one import file for each hierarchy.
- you do not use the same field in more than one hierarchy.
Update your Cascading Metadata
Update values in your existing cascading metadata file, and values in your project Document Fields (make sure the spelling and formatting is exact). If you don't have an existing cascading metadata file, you'll need to speak to your Aconex Representative to assist you with the initial setup. Service Desk do not keep copies of your cascading metadata files.
Save the spreadsheet in .csv format. Click on File > Save As... and in the Format field choose Comma Separated Values (.csv).
Send the saved file AND previously loaded metadata spreadsheet, to the Aconex Service Desk or your Aconex representative, to have them apply it to your project. If the new metadata upload fails, Service Desk will use the previous file to revert back to the previous cascading file. You’ll need to make the required changes and resend the file(s).
- If you have multiple cascades applied to your project, make sure you indicate this when you send through any updates. You'll need to supply us with ALL spreadsheets for all cascades on your project.