BimlFlex Excel Add-in is the tool modelers and developers use to interact with the solution metadata. BimlFlex Excel Add-in connects to the BimlFlex metadata database.
To install BimlFlex and the Excel Add-in refer to the installation and setup documentation
The BimlFlex Excel ribbon and tab is located at the top right hand side of the standard Excel UI. This is where the UI for BimlFlex is located.
The BimlFlex Excel Add-in Ribbon tab is made up of 5 main groups:
- Metadata Tools
- Retrieve Metadata
- Publish Metadata
- Status (hidden when everything is ok)
Metadata Tools is as section containing tools and functionality that allows high level control over metadata. Importing metadata, connecting to various metadata sources or generating overview documentation of metadata.
Retrieve Metadata is about getting the metadata from the metadata database (the BimlFlex Database) and bringing that metadata into Excel.
Publish Metadata allows Excel to save changed metadata back to the metadata database.
Other and Status sections apply to when BimlFlex Excel Add-in is inspecting the metadata. When an issue is encountered, the Status section will display any validation messages.
The BimlFlex Add-in displays the metadata in a set of Excel sheets. These are normal Excel sheets. To navigate between them, click the sheet tab at the bottom of the Excel window.
Getting Started Sheet
- Data Type Mappings
Each sheet contains columns and rows of metadata used to define entities and relationships. Managing the metadata and building the DataWarehouse is covered in the Implementation Guides and Configurations documentation.
The Metadata specification is detailed in the Metadata Reference documentation
The metadata data connection button in BimlFlex Excel is located on the far left and is the starting point for connecting to a given metadata database. This button opens a pane in Excel for connecting to a metadata database.
The validation list is a pane in BimlFlex Excel Add-in where any issues with metadata are displayed in a list along the side of the screen. The issues shown on this list are generated by the validation rules in the BimlFlex bundle.
BimlFlex Excel Add-in provides a metadata import function to add metadata into a project from a source that provides metadata information.
More information about the metadata import tool is found in the documentation
The Auto Freeze function freeze the left hand side and top of the sheet in Excel. By default the frozen area are the relevant columns of a metadata sheet.
Get Current Sheet
Get current sheet will take the currently selected sheet in excel and retrieve the relevant metadata from the BimlFlex metadata database.
Get All Entities
Get all entities will go through each of the metadata spreadsheets and retrieve the current version of the metadata for each one.
Get All Settings
Get all settings will get all the
- Data Type Mappings
metadata for the current customer.
Set Current Sheet
Set Current Sheet will take the currently selected sheet in Excel and publish the relevant metadata changes to the BimlFlex metadata database.
Set All Entities
Set All Entities will go through each of the metadata spreadsheets and publish the current version of the metadata for each one.
Set All Settings
Set All Settings will publish the Configurations, Data Type Mappings and Versions metadata sheets to the metadata database
Clicking the About button will display to the user a drop-down box that shows two more options. The options are About and Help
Help will redirect the user to the Varigence support website, where they can access articles and forum information on the use of the various products in the Varigence suite.
About will show various product information that relates to the customer and some support options should a user experience issues with a particular version of BimlFlex Excel Add-in.
Here you can view
- product name
- licensed user
- product key
Change Product Key will allow updating and chaign of the current product key.
Copy Product Information copies product information to the clipboard. This allows a quick way to share information about the version of BimlFlex Excel Add-in if required.
Copy Machine Code button will copy a code that is unique to the current machine. machine code is used to generate static product activation keys for machines not normally connected to the Internet.
The suspend processing button will pause BimlFlex Excel Add-in processing of the metadata through the Bundle. To start processing metadata, press this button again.
This function is useful in situations when larger quantities of metadata are changed and validation is applied later.