Worksheet to add records that contain an attachment

You can use Maximo Data Loader to add records that contain a file attachment to Maximo® Civil Infrastructure.

To load attachments, a worksheet must have values for the attributes that are described in the following table:

Table 1. Attributes that are required to load attachments
Attribute Description
DOCUMENT The name of the document.
DESCRIPTION The description of document.
DOCTYPE The type of document, which can be any type from the MAXIMO.DOCTYPES table, for example, Images or Attachments.
URLTYPE The type of URL. Normally, this attribute has a value of FILE.
OWNERTABLE The object type, for example, ASSET, INCIDENT, or TICKET
DOCUMENTDATA

The path to the attachment in based4 encoded format. You must prefix that path with the FileEnc:/ string to indicate that the file must be encoded. For example:

FileEnc:/C:\maxloader\demo\attachments\DefectDialog.pdf or

FileEnc://maxloader/demo/attachments/DefectDialog.pdf

You must upload each file to the directory on the Docker or OpenShift® file system that you specify for this attribute.

The example worksheet in the table adds defect records that contain attachments.

Table 2. Example worksheet to add defect records that contain attachments
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ
MCIDEFECT INCIDENT Sync-AddChange                                                              
ASSETNUM CLASS CLASSSTRUCTUREID DESCRIPTION HASMARKUP LOCATION OWNER PLUSGISDEFECT PLUSXDEFCATEGORY PLUSXDEFCAUSE PLUSXDEFPOSITION PLUSXDEFRATINGCLASS PLUSXDEFSCORE PLUSXDEFTYPE STATUS TICKETID DOCLINKS. ADDINFO DOCLINKS. CHANGEBY DOCLINKS. CHANGEDATE DOCLINKS. COPYLINKTOWO DOCLINKS. CREATEBY DOCLINKS. CREATEDATE DOCLINKS. DESCRIPTION DOCLINKS. DOCINFOID DOCLINKS. DOCTYPE DOCLINKS. DOCUMENT DOCLINKS. DOCUMENTDATA DOCLINKS. GETLATESTVERSION DOCLINKS. OWNERTABLE DOCLINKS. PRINTTHRULINK DOCLINKS. SHOW DOCLINKS. UPLOAD DOCLINKS. URLNAME DOCLINKS. URLTYPE DOCLINKS. WEBURL DOCLINKS. OWNERID
BR1 DEFECT 1430_DCI Summary of DOCLINK1 defect false   MAXADMIN true CONCRETE STRUCTURE CRACKS FOUNDATION FAILURE CS   1334_DCI 2 CRACKS CS QUEUED DOCLINK1             Bridge defect   Images BRIDGE DEFECT /maxloader/data/attachments/BridgeDefect.jpg TRUE INCIDENT TRUE FALSE FALSE   FILE    
BR1 DEFECT 1430_DCI Summary of DOCLINK1 defect false   MAXADMIN true CONCRETE STRUCTURE CRACKS FOUNDATION FAILURE CS   1334_DCI 2 CRACKS CS QUEUED DOCLINK1             Maxloader document   Attachments MAXLOADER DOCUMENT /maxloader/data/attachments/Maxloader.pdf TRUE INCIDENT TRUE FALSE FALSE   FILE