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:
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.
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 |