To provide information for review or for a company that you hire to dispose of assets,
you can use the integration framework applications to export a data file with information about
assets that you are planning to dispose of.
Before you begin
Before you attempt to export a file, check that the following tasks are completed:
- JMS queues are configured. You can use either continuous queue or sequential queue, depending on
your business process.
- The external system for asset disposal integration is enabled.
- The publish channel is enabled.
About this task
The following procedure explains how to export asset disposal data.
Procedure
- Click .
- On the record list, select the TAMITEXTSYS external
system.
- On the Publish Channels tab of the External Systems application, select the
ITASSETDISPOSAL publish channel and click Data
Export.
- In the Export Condition field in the Data
Export window, enter an SQL statement that is appropriate for the Maximo® database that you use. This statement specifies the export
condition.
Typically conditions filter by location, by site ID, and by status, as shown in the following
example.
location = 'DISPOSAL' and siteid = 'BEDFORD' and status not in ('DECOMMISSIONED','DISPOSED')
The
SQL statement must use the database names for attributes as shown in the field help. To view the
field help, position the cursor in a field and press Alt+F1. The field help displays the database
table and column (attribute) in the following format:
ASSET.SITEID, where
SITEID is the attribute name.
- Click OK to export the asset data.
What to do next
The location to which the file is exported depends on the global directory set for the
system and on the filedir parameter for the endpoint of the external system. If
no global directory is set, look in the root of the application server folder. If no
filedir parameter is set for the external system, look in the
flatfiles sub-directory. For example,
C:\bea\user_projects\domains\maximo_database\flatfiles\TAMITEXTSYS_ITASSETDISPOSALInterface_1236264695765361846.dat
Another way to locate the file is to search the operating system file structure for
TAMITEXTSYS_ITASSETDISPOSALInterface*.dat.