Creating an Excel workbook template
You can use Maximo Data Loader to create an Excel worksheet template from an object structure in Maximo® Civil Infrastructure.
You can export all of the attributes in a Maximo
object structure, or you can export the attributes in any query template that was created for the
object structure. For example, if you customize a Maximo Civil Infrastructure application and add new fields to a
table, you can create a query template and then use Maximo Data Loader to create an Excel workbook template. The
Excel workbook template contains the additional fields that you added to the application. You can
then populate the additional fields in the Excel workbook and then use Maximo Data Loader to load the data, including for the
additional fields, into Maximo Civil Infrastructure.
For each template that you export, Maximo Data Loader creates one or more worksheets in the
workbook. The worksheet template that is created contains the object name and the primary keys and
attribute details for the objects in the object structure. Cell C1 of each worksheet is set to the
query operation.
You can use Maximo Data Loader with the
worksheet template to query a Maximo Civil Infrastructure
server and create a new worksheet that contains the returned data. You can then edit the data in the
new worksheet, if required, and use Maximo Data Loader to import the data into the same or a different Maximo Civil Infrastructure instance.