Loading data for Maximo Health and Predict - Utilities

Steps

Complete the following steps:

1. Create and configure a data load user.
   1. Create a user in IBM Maximo Application Suite that uses the local work type and has entitlement and access for Maximo Health and Predict - Utilities. For more information, see User management.
   2. As an application administrator, log in to Health and Predict – Utilities and click the Application administration page.
   3. In the Security Groups application, open the HEALTHINTEGRATION security group and in the More Actions menu, click Authorize Group Reassignment.
   4. Select your administrative user and then click OK.
   5. On the Users tab, select the data load user that you created in step 1.1 and then click OK.
   6. Save the group.
   7. In the Users application, locate and open the record for the data load user.
   8. In the Default Insert Site field and the Storeroom Site for Self-Service Requisition field, specify a site.
   9. Save the user.
   10. Return to the Start Center and in the Go To section, click Administration.
   11. On the API Keys tab, click Add API Key.
   12. Select the data load user and then click Add. Copy and store that API key.
2. Create and configure the apikey.policyxml file.
   1. Create a apikey.policyxml file that contains the following content. Replace the {apikey} variable with the data loader user’s API key.

      <?xml version="1.0" encoding="UTF-8"?>
      <policies>
      <policy policyType="UserDefined" policyName="apikey" policyTemplate="UserDefined">
      <apikey>{apikey}</apikey>
      </policy>
      </policies>
   2. Save the apikey.policyxml file to a local folder that is named apikey.
   3. Compress the apikey folder. For example, you might use the following command: 

      zip -r apikey.zip apikey
   4. In the IBM App Connect dashboard, click the wrench icon and then click the create icon to create a configuration.
   5.  In the Type field, select Policy Project.
   6. Specify a name.
   7. Upload the compressed folder that you created in step 2.3 and then click Create.
3. Optional: Update the user and password for the integration server user.
   1. Create a setdbparms.txt file that contains the following content. Replace the {username} and {password} variables with the new username and password.
       

      local::basicAuthOverride {username} {password}
   2. In the IBM App Connect dashboard, click the wrench icon and for the ibm-hputilities-****-users configuration, click the three-dot menu and then click Update.
   3. Click the upload icon and upload the setdbparms.txt file.
   4. Click Update.
4. Prepare the csv files. For more information, see the Preparing the csv files section of this article.
5. Create an integration server.
   1. In the IBM App Connect dashboard, click the create server icon.
   2. In the Select the type of integration you would like to run field, select Quick start toolkit integration, and then click Next.
   3. In the drop-down menu, select the ibm-mas-hputilities-**-data-loader bar file and then click Next.
   4. Select the following seven default configurations and the new configuration that you created in step 2.  The * variable is string that is retrieved from the Red Hat OpenShift cluster domain URL.
      ibm-hputilities-**-keystore.p12
      ibm-hputilities-**-healthurl
      ibm-hputilities-**-https
      ibm-hputilities-**-https-server-conf or ibm-hputilities-**-serverconf-830 in v8.7 or ibm-hputilities-string-sts-serverconf since v8.8
      ibm-hputilities-**-store-password
      ibm-hputilities-**-users
      ibm-hputilities-**-truststore.jks or ibm-hputilities-**-trustcert-830 in v8.7 or ibm-hputilities-string-sts-trustcert since v8.8
   5. Click Next and specify a name.
   6. For the transport type, change the value to https.
   7. Select the version for your IBM App Connect license, 11.0.0.11-r1 in version 8.4, 11.0.0.12-r1 in version 8.5, 12.0.1.0-r3 in version 8.6, 12.0.2.0-r2 in version 8.7, 12.0.4.0-r2 in version 8.8.
   8. Make sure the Replicas is set to 1.
   9. On the YAML Editor tab, update resources.
      At least specify 500m for cpu requests, 500Mi for memory requests and 1 for the cpu limits, 2Gi for the memory limits.
      Modify the value pre-requirement as needed for your data volume.
   10. Click Create. Wait a few minutes.
   11. In Red Hat OpenShift Web Console, click Networking > Routes and open the https route for the integration server. If you do not have access, contact your application administrator. Or since v8.6, in the IBM App Connect dashboard, click the three dots on integration server card, click Edit. Click YAML editor, find the https endpoint uri value under metadata -> status -> endpoints
   12. Add '/manage' to the end of the URI.
   13. Paste that new route URI into a browser. The data loader opens.
6. Load the data. One tab exists for each data type. Use the .csv files that you prepared in step 4.
   1. As the data loader user, log in to the data loader by using the URI that was created in step 5.12. 
   2. Use the csv file input field to load the csv files for the data type. Load one file at a time in the following order: Classification, domain, meter, location, asset, reading, location system, hierarchy location, map container configuration. Ensure that each file is finished loading before you upload the next file. 
      
      For some data types, you must specify an organization ID and a site ID. If you do not have these values, contact your administrator. Ensure that application users can access the site.
      
      As the data is loaded, you can review the three logs. The Output log contains the response from the application. The error log contains the error messages. The integration server log contains the system-level messages. You can refresh and download the logs to see whether there are any errors.
      
      For smaller volumes of data, you can enable properties=* in the header to directly check detail response to see whether data is successfully imported. For location, asset, reading, or hierarchy location csv files, you can edit the batch size if you have some issues during the data loading.

Preparing the csv files

Classification csv files

The files must at least include CLASSIFICATIONID, ASSETATTRID, DATATYPE, and UNIT columns. Each row in the files contains the details for a specification for the classification. Each asset type can have its own attributes defined as specifications in the application as needed. To use the Maximo Health and Predict – Utilities default models, you must create a FEEDER classification that has numberOfCustomers specification, have Feeder and numberOfCustomers specification defined for each classification for each asset type, and have a Subtype specification specified for the CIRCUITBREAKER classification that can store the subtype information for assets. Examples of sub types are air blast circuit breaker and oil circuit breaker.

CLASSIFICATIONID,ASSETATTRID,DATATYPE,UNIT
CircuitBreaker,numberOfCustomers,NUMERIC,
CircuitBreaker,Feeder,ALN,
CircuitBreaker,Subtype,ALN,
DistributionTransformer,numberOfCustomers,NUMERIC,
DistributionTransformer,Feeder,ALN,
InstrumentTransformer,numberOfCustomers,NUMERIC,
InstrumentTransformer,Feeder,ALN,
SubstationTransformer,numberOfCustomers,NUMERIC,
SubstationTransformer,Feeder,ALN,
Switchgear,numberOfCustomers,NUMERIC,
Switchgear,Feeder,ALN,
Feeder,numberOfCustomers,NUMERIC,
Substation,numberOfCustomers,NUMERIC,

HIERARCHYPATH,CLASSIFICATIONID,ASSETATTRID,DATATYPE,UNIT
APMEU,APMEU,,,
APMEU \ CIRCUITBREAKER,CIRCUITBREAKER,numberOfCustomers,NUMERIC,
APMEU \ CIRCUITBREAKER,CIRCUITBREAKER,Feeder,ALN,
APMEU \ FEEDER,FEEDER,numberOfCustomers,NUMERIC,

The files must at least include DOMAINID, DOMAINTYPE, MAXTYPE, LENGTH, DESCRIPTION, and DOMAIN columns. Each row in the files contains information to create a new domain. The DOMAIN column uses “;” to separate domain values. The only supported domain type is ALN.

For the default Maximo Health and Predict – Utilities models, A, B, C, D, and E is mapped to a score for each contributor to a characteristic meter.

The following text is an example of a domain csv file.

DOMAINID,DOMAINTYPE,MAXTYPE,LENGTH,DESCRIPTION,DOMAIN
CONDITION,ALN,UPPER,50,,"A;B;C;D;E"

The previous example, the text would be parsed to the following text:

[{

        "domainid": "CONDITION",
        "domaintype": "ALN",
        "length": 50,
        "maxtype": "UPPER",
        "_action": "AddChange",
        "domain": [
            {
                "value": "A"
            },
            {
                "value": "B"
            },
            {
                "value": "C"
            },
            {
                "value": "D"
            },
            {
                "value": "E"
            }
        ]
    }]

DOMAINID,VALUE,MAXVALUE,DESCRIPTION
ASSETTYPE,DISTRIBUTION_TRANSFORMER,AHUTILITIES,Distribution Transformer
ASSETTYPE,SUBSTATION_TRANSFORMER,AHUTILITIES,Substation Transformer
ASSETTYPE,INSTRUMENT_TRANSFORMER,AHUTILITIES,Instrument Transformer
ASSETTYPE,SWITCHGEAR,AHUTILITIES,Switchgear
ASSETTYPE,UNDERGROUND_TRANSMISSION_MANHOLE,AHUTILITIES,Underground Transmission Manhole
ASSETTYPE,METAL_SUPPORT_STRUCTURE,AHUTILITIES,Metal Support Structure
ASSETTYPE,OVERHEAD_TRANSMISSION_WIRE,AHUTILITIES,Overhead Transmission Wire
ASSETTYPE,OIL_CIRCUIT_BREAKER,AHUTILITIES,Oil Circuit Breaker
ASSETTYPE,AIR_BLAST_CIRCUIT_BREAKER,AHUTILITIES,Air Blast Circuit Breaker
ASSETTYPE,AIR_MAGNETIC_CIRCUIT_BREAKER,AHUTILITIES,Air Magnetic Circuit Breaker
ASSETTYPE,VACUUM_CIRCUIT_BREAKER,AHUTILITIES,Vacuum Circuit Breaker
ASSETTYPE,SF6_CIRCUIT_BREAKER,AHUTILITIES,SF6 Circuit Breaker
ASSETTYPE,WOOD_POWER_POLE,AHUTILITIES,Wood Power Pole
ASSETTYPE,MASS_IMPREGNATED_(MI)_CABLES,AHUTILITIES,Mass Impregnated (MI) Cables
ASSETTYPE,HIGH_PRESSURE_FLUID_FILLED_PIPE_TYPE_(HPFF)_CABLES,AHUTILITIES,High Pressure Fluid Filled Pipe Type (HPFF) Cables
ASSETTYPE,SELF_CONTAINED_FLUID_FILLED_(SCFF)_CABLES,AHUTILITIES,Self Contained Fluid Filled (SCFF) Cables
ASSETTYPE,SELF_CONTAINED_GAS_FILLED_(SCGF)_SUBMARINE_CABLES,AHUTILITIES,Self Contained Gas Filled (SCGF) Submarine Cables
ASSETTYPE,EXTRUDED_CROSS_LINKED_POLYETHYLENE_(XLPE)_CABLES,AHUTILITIES,Extruded Cross Linked Polyethylene (XLPE) Cables

The files can include GROUPNAME, METERNAME, METERTYPE, DOMAINID, and DESCRIPTION columns. GROUPNAME is the meter group name to group meters. Only characteristic and gauge meters are supported. For characteristic meters, you must specify a DOMAINID value.

In the following example, the content is parsed to create the defined meters and a meter group for each asset type to use such as CB_MG and ST_MG. Those meters' readings can be used in the out of the box HPU models, details can be found in corresponding cfg file, for example:  IBM-Circuit-Breakers-Air-Blast-<version>.cfg.

GROUPNAME,METERNAME,METERTYPE,DOMAINID,DESCRIPTION
CB_MG,TIME-TRA,CHARACTERISTIC,CONDITION,Time/Travel
CB_MG,TANK-MECH,CHARACTERISTIC,CONDITION,Tank and Mechanism Box
CB_MG,STOR-ENER,CHARACTERISTIC,CONDITION,Stored Energy
…….
ST_MG,DGA-CH4,GAUGE,,DGA CH4
ST_MG,DGA-C2H4,GAUGE,,DGA C2H4
ST_MG,DGA-C2H2,GAUGE,,DGA C2H2
…….

• Functional location

If you are using functional locations instead of assets, review the Asset csv files section. Functional location csv files use the same requirements as asset csv files. The only difference is that functional location csv files must not use the ASSETNUM column. Ignore General location and Asset csv files section.

• General location

For general locations, simply use the LOCATION, TYPE, and DESCRIPTION columns. To support the latest map features, ensure all assets have a location, and when you create the asset csv files, specify the location value in the LOCATION column.

 The following text is an example of a general location csv file.

LOCATION,TYPE,DESCRIPTION
BRK_268370,OPERATING,BRK_268370
BRK_268371,OPERATING,BRK_268371

Ensure that your container locations have geometry data. Container location csv files can include LOCATION, CLASSIFICATIONID, TYPE, DESCRIPTION, SPEC. NUMBEROFCUSTOMERS, and GEOMETRY columns. Locations that have geometry can be used as a container and parent in a location system.

If a HIERARCHYPATH value is specified in the classifications.csv file, specify the HIERARCHYPATH in the location.csv file. The SPEC. columns contain the specification attribute’s value. If you add more SPEC. columns, ensure that the columns are also added to the classification.csv file. GEOMETRY column is loaded as the geometry attribute of the location.

 The following text is an example of a container location csv file.

LOCATION,CLASSIFICATIONID,TYPE,DESCRIPTION,SPEC.NUMBEROFCUSTOMERS,GEOMETRY
COMLK,FEEDER,OPERATING,COMLK,0,"POLYGON ((-83.48133860972912 42.581114411992516, -83.48133117942749 42.58101667688922, -83.48130482472425 42.58092226931847, -83.48127621676625 42.58085027828392, -83.48124100306251 42.58078103437583, -83.48123001180615 42.58076383488359, -83.48118196590751 42.58070279133058, -83.48116783039059 42.580688066609504, -83.48110879867401 42.58063756928109, -83.4810920621165 42.580625885193946, -83.48102431313775 42.58058787467413, -83.48100561871618 42.580579680233846, -83.4809317560305 42.580555617245594, -83.480911822161 42.5805512273599, -83.48083468427 42.58054203663035, -83.480814277 42.5805416200001, -83.48074636360067 42.58054006552121, -83.480725959 42.580539648999995, -83.48064850763024 42.58054568413756, -83.48062841383899 42.580549256359795, -83.48055362807251 42.58057028554655, -83.48053461728381 42.580577709233744, -83.48046537109569 42.580612924329834, -83.48044817388349 42.58062391419384, -83.48038712836589 42.58067196190288, -83.4803724056094 42.5806860956094, -83.48032190670733 42.58074512948487, -83.48027110444946 42.5808127566858, -83.48022298529581 42.580898149348556, -83.48019245002028 42.58099128879641, -83.48018067207639 42.58108859573262, -83.4801790541069 42.581128183363404, -83.48017869058982 42.58113707770929, -83.48018611809584 42.581234813025084, -83.48021247009865 42.58132922134965, -83.48025673390555 42.58141667462401, -83.48031720848327 42.58149381206789, -83.4803915698277 42.581557669332575, -83.48047696027409 42.58160579241919, -83.48057009831544 42.58163633198451, -83.4806674047091 42.581648114410164, -83.4808255907092 42.581651646410165, -83.48092332602498 42.581644218904145, -83.48101773434955 42.58161786690134, -83.48110518762391 42.58157360309444, -83.48118232506779 42.581513128516725, -83.48124618233247 42.581438767172294, -83.48129430541908 42.581353376725914, -83.48132484498441 42.58126023868455, -83.48133662741007 42.58116293229091, -83.48133699172902 42.581154000996946, -83.48133860972912 42.581114411992516))"
COMLK9020,FEEDER,OPERATING,COMLK9020,0,"POLYGON ((-83.481628998 42.590682089, -83.48162604700889 42.59073633181308, -83.4816193906402 42.590779634161, -83.48160591410368 42.59083225900384, -83.4814364941004 42.59138916788421, -83.48142904176625 42.591408256716285, -83.48139386999217 42.59147743194936, -83.48138283680615 42.59149470011661, -83.48133484542936 42.59155568449425, -83.48132065539059 42.5915704683907, -83.48126168869277 42.59162091831747, -83.4812448871165 42.59163264980626, -83.48117721115479 42.59167062651976, -83.48115844371618 42.59167885476636, -83.48108465923983 42.591702898842804, -83.481064647161 42.591707307640306, -83.48098758966606 42.59171649507931, -83.480967102 42.591716915000106, -83.48088973276278 42.59171089273354, -83.48086955683898 42.591707307640306, -83.4807948491159 42.5916863071005, -83.4807757602838 42.59167885476636, -83.48070658505074 42.591643682992284, -83.48068931688348 42.59163264980626, -83.48062833250584 42.59158465842946, -83.4806135486094 42.5915704683907, -83.48056309868264 42.59151150169288, -83.48055136719384 42.59149470011661, -83.48051339048034 42.5914270241549, -83.48050516223374 42.591408256716285, -83.4804811181573 42.591334472239936, -83.48047670935979 42.59131446016111, -83.48035003348396 42.590709513084576, -83.48033770084851 42.590622718991604, -83.48010804992656 42.58731478951712, -83.48010409992655 42.58721870051712, -83.48002190563648 42.585410510514706, -83.48002123369466 42.58539860275534, -83.47974643742141 42.58129516720756, -83.47974552621167 42.58128477691548, -83.47972405121168 42.58100659191548, -83.47953529698115 42.57910498678514, -83.47746892123365 42.56982016471628, -83.47744291136517 42.569737933741855, -83.4774404683597 42.569726368161106, -83.47743100073083 42.56964064295818, -83.4774308609999 42.5696288230001, -83.47743829944632 42.569542897940146, -83.4774404683597 42.5695312778391, -83.47746452702607 42.56944845497397, -83.47746892123365 42.56943748128392, -83.47750867555891 42.5693609434499, -83.47751512619375 42.56935103788359, -83.4775690484415 42.56928372638671, -83.47757730760931 42.569275269609506, -83.47764332557779 42.56921977119284, -83.4776530758834 42.56921308819395, -83.47772865253908 42.569171535630524, -83.47773951928372 42.56916688323385, -83.47782175025816 42.56914087336537, -83.47806072169013 42.56907846089588, -83.47807180176517 42.56907569824499, -83.47808967283899 42.5690718023599, -83.47815752412342 42.56906307750523, -83.47816893026436 42.56906252955331, -83.478187218 42.5690621950001, -83.47920593134998 42.56904531632088, -83.47922937724614 42.56904526314481, -83.47937250924615 42.56904829514481, -83.47942011276758 42.569051580944326, -83.47946982905941 42.56905996620922, -83.47951587686485 42.56907247585934, -83.47956300198804 42.56909039917111, -83.47960572448613 42.56911165193301, -83.47964844744862 42.569138424508814, -83.47968620283775 42.56916760365077, -83.47972288182007 42.569202196635544, -83.47975421918177 42.56923818081949, -83.47978344463118 42.56927926482424, -83.47980715968824 42.56932067119816, -83.47982780848712 42.56936666738761, -83.47984298988318 42.569411904727794, -83.47985426850977 42.56946104549419, -83.47986033283229 42.56950837535501, -83.4802123084428 42.57323401511627, -83.48126527337728 42.58103751245659, -83.48127114340178 42.581136211201546, -83.48162707859942 42.59063832010144, -83.481628998 42.590682089))"
Substation_NIXON,SUBSTATION,OPERATING,Substation NIXON,,"MULTIPOLYGON (((-83.425546765 42.6480248230001, -83.425435675 42.6462215390001, -83.431074541 42.6462237580001, -83.4312676389999 42.648989483, -83.434267979 42.649171536, -83.435369282 42.650506039, -83.437913295 42.6505352980001, -83.4400399209999 42.649473287, -83.443356802 42.6494630030001, -83.443378927 42.6449941060001, -83.4446187249999 42.644657126, -83.4442758229999 42.6440465490001, -83.4435989259999 42.6439427220001, -83.443422298 42.644391522, -83.441836122 42.6442692860001, -83.441126583 42.6443329780001, -83.439701607 42.6438861350001, -83.437948583 42.6445216060001, -83.43560689 42.644450154, -83.433460844 42.643256599, -83.432049762 42.640504445, -83.432558667 42.6393070870001, -83.436761597 42.637250824, -83.4346864189999 42.634763558, -83.434880485 42.6301045540001, -83.432776716 42.6267715660001, -83.427135425 42.626882381, -83.430332886 42.623934956, -83.429631134 42.615403906, -83.428321718 42.61524869, -83.428074507 42.612370787, -83.423559365 42.612511125, -83.423620009 42.614393056, -83.422349832 42.6144763450001, -83.421925742 42.615832633, -83.4208995019999 42.615837271, -83.419703593 42.6158099560001, -83.418046622 42.615903073, -83.416691945 42.6160498960001, -83.414417284 42.6121337960001, -83.4153547399999 42.6118698970001, -83.415704892 42.612238114, -83.418656099 42.6122401110001, -83.418462039 42.609616004, -83.4167093569999 42.6082193120001, -83.417829532 42.607012329, -83.4178939339999 42.6050373, -83.415624919 42.60331697, -83.4132929209999 42.603525791, -83.413322667 42.6051235630001, -83.413458389 42.6066471170001, -83.412864597 42.606042722, -83.412083922 42.604570833, -83.408306324 42.603173096, -83.408623481 42.6025367670001, -83.4107892769999 42.6024434180001, -83.4109475499999 42.5994435550001, -83.4081423759999 42.600165841, -83.404092699 42.5993725770001, -83.403610299 42.600700536, -83.401913662 42.5996375410001, -83.399951957 42.598962257, -83.4000763499999 42.5973820660001, -83.39813639 42.597194481, -83.3980807579999 42.5946902790001, -83.397558687 42.5939599660001, -83.392410179 42.595035137, -83.395570587 42.6000428230001, -83.394432248 42.60090927, -83.3921965329999 42.6008314170001, -83.392131064 42.6023790040001, -83.390850587 42.6040823220001, -83.387802433 42.6055609690001, -83.3762464289999 42.6073411180001, -83.375239677 42.6084467370001, -83.373789393 42.608281753, -83.3742183639999 42.609893335, -83.375829487 42.61045589, -83.374574735 42.613209865, -83.376760626 42.614468414, -83.376634252 42.6182725850001, -83.380253242 42.619275514, -83.3847043709999 42.6232907560001, -83.383883742 42.624499821, -83.381777611 42.622127634, -83.3795918439999 42.6206967640001, -83.376551041 42.6211400990001, -83.373769312 42.6206349870001, -83.373233155 42.618287932, -83.3747703289999 42.6167378980001, -83.3753679009999 42.6148429960001, -83.373330633 42.6141349160001, -83.369494026 42.6141337510001, -83.3669793619999 42.612504093, -83.357602544 42.617468296, -83.358384614 42.6196303020001, -83.362116366 42.620231387, -83.363146822 42.621239201, -83.3627328219999 42.6225510080001, -83.363072098 42.6243796160001, -83.361920072 42.624352727, -83.361703934 42.623363919, -83.360895478 42.6227430380001, -83.359678871 42.6228320820001, -83.35830614 42.622388873, -83.356781992 42.620840881, -83.355695716 42.6211166210001, -83.354530063 42.6214124950001, -83.353445339 42.621687814, -83.353031387 42.6223355130001, -83.352418585 42.623294318, -83.351420451 42.6248559530001, -83.35044214 42.6249504850001, -83.349395374 42.627099023, -83.352218778 42.626636623, -83.354262394 42.6253483340001, -83.354802214 42.6248129840001, -83.355900086 42.6249461740001, -83.3611606649999 42.6249076300001, -83.3662315239999 42.625818817, -83.3656364829999 42.6267152890001, -83.360395592 42.6255945440001, -83.360547343 42.6262294580001, -83.364392828 42.6274351210001, -83.362320064 42.628943151, -83.362388391 42.630134066, -83.365226475 42.6288641250001, -83.366915901 42.6299729150001, -83.367011769 42.630359351, -83.3648814649999 42.6313521820001, -83.3662939719999 42.6322660880001, -83.368609911 42.6321519140001, -83.370339101 42.632066636, -83.370619642 42.6330809410001, -83.371592505 42.634167081, -83.371643573 42.6388244950001, -83.371644924 42.639979983, -83.372355821 42.6402183340001, -83.372338337 42.6420368510001, -83.3751654709999 42.64196946, -83.3751084 42.644718696, -83.377292411 42.645993893, -83.374940387 42.6495913730001, -83.367749674 42.6498299150001, -83.364379462 42.650425969, -83.361414397 42.6509502800001, -83.361368806 42.652014411, -83.3579416269999 42.65378537, -83.356605584 42.6533233760001, -83.356384147 42.6504776740001, -83.35253457 42.650514382, -83.351374955 42.650695141, -83.35140425 42.6533174320001, -83.350838521 42.6539709910001, -83.348501316 42.655409579, -83.348663232 42.662208569, -83.3519299879999 42.663793927, -83.3524408339999 42.663951098, -83.3525011149999 42.667277739, -83.353133247 42.6669628380001, -83.353140792 42.6641664460001, -83.3542972 42.664522215, -83.3558111259999 42.6638758780001, -83.3592755729999 42.6646265110001, -83.360083249 42.6650136310001, -83.364047811 42.662066053, -83.365503635 42.6624071350001, -83.3657621309999 42.6634983920001, -83.368089809 42.6648630820001, -83.368824449 42.664552568, -83.367354177 42.6613035880001, -83.3700747999999 42.6586640780001, -83.373117523 42.658222934, -83.377214054 42.658440926, -83.380384711 42.6589035060001, -83.38051619 42.6597255950001, -83.3770767089999 42.6603624890001, -83.373940375 42.662841701, -83.37553101 42.6626111940001, -83.3762654559999 42.669561447, -83.376847369 42.675067245, -83.379339111 42.6751442730001, -83.380070559 42.675237345, -83.381193642 42.675081806, -83.383227502 42.6746229, -83.3838808419999 42.675094013, -83.387900717 42.674887481, -83.392547903 42.675060581, -83.392791894 42.6760926970001, -83.3924564179999 42.6783752330001, -83.397605956 42.6808194210001, -83.398536367 42.681968355, -83.401021005 42.681937427, -83.40061157 42.680324823, -83.406470005 42.6801246730001, -83.4066472119999 42.6805452200001, -83.4074869679999 42.6809231730001, -83.408677478 42.6810033260001, -83.409250131 42.681580212, -83.416921443 42.6813118100001, -83.4183391019999 42.6836367550001, -83.4190546149999 42.683117022, -83.418109745 42.6809901730001, -83.4191198249999 42.6791105660001, -83.41789427 42.6770213350001, -83.4175872279999 42.675234958, -83.418514191 42.67393359, -83.417363697 42.6734929530001, -83.4177942169999 42.673042394, -83.417540665 42.6694071700001, -83.419218722 42.669352772, -83.419084389 42.6676653280001, -83.417424168 42.6677368470001, -83.406411382 42.668018046, -83.406099817 42.663148173, -83.416551339 42.6630442040001, -83.416952793 42.6636551440001, -83.417767383 42.663673762, -83.4189163039999 42.6631269040001, -83.431614403 42.6628609430001, -83.431265304 42.661059569, -83.433868785 42.6610590330001, -83.435492094 42.655889147, -83.434125135 42.6535237910001, -83.433214768 42.652902731, -83.430975857 42.6522850600001, -83.428855593 42.6522652940001, -83.427792054 42.653721386, -83.422608446 42.653176242, -83.421556751 42.6513954390001, -83.419556359 42.65054451, -83.419229125 42.648231175, -83.4247935289999 42.6479596040001, -83.425546765 42.6480248230001), (-83.391021651 42.646457115, -83.389055545 42.6464934200001, -83.386438595 42.643951525, -83.383702985 42.643271541, -83.38238387 42.6415524660001, -83.383509235 42.639405466, -83.3825403289999 42.637870691, -83.3835169979999 42.6373500440001, -83.386239745 42.6397329500001, -83.3863407969999 42.6411007930001, -83.387327849 42.642680001, -83.388460355 42.6427061800001, -83.388467267 42.641605127, -83.3903321129999 42.640670893, -83.3916799209999 42.641594706, -83.3918519379999 42.6450906750001, -83.391021651 42.646457115), (-83.392237397 42.6309477710001, -83.3917133849999 42.634086358, -83.38953421 42.6367846740001, -83.384627236 42.636024924, -83.374904801 42.632716063, -83.367953222 42.6278705, -83.370328817 42.624387219, -83.372089084 42.624604366, -83.376895234 42.6247307290001, -83.379141706 42.62702146, -83.380269244 42.6280978410001, -83.384196528 42.6277162280001, -83.385542857 42.6286663400001, -83.390719974 42.629836251, -83.392237397 42.6309477710001)), ((-83.42813124 42.648131467, -83.42813728 42.647367134, -83.426749028 42.647598309, -83.425546765 42.6480248230001, -83.42813124 42.648131467)))"
Substation_LILY,SUBSTATION,OPERATING,Substation LILY,,"POLYGON ((-83.4107892769999 42.6024434180001, -83.408623481 42.6025367670001, -83.408306324 42.603173096, -83.412083922 42.604570833, -83.412864597 42.606042722, -83.413458389 42.6066471170001, -83.413322667 42.6051235630001, -83.4132929209999 42.603525791, -83.415624919 42.60331697, -83.418750234 42.599574497, -83.4172581719999 42.5989921250001, -83.416957188 42.596935241, -83.4114251349999 42.5965225210001, -83.410697565 42.595409327, -83.409600838 42.595228945, -83.4086941739999 42.5954825630001, -83.4068759799999 42.5949879190001, -83.406005221 42.597280138, -83.402891541 42.5961359, -83.402222329 42.5936414290001, -83.400579452 42.592816994, -83.400662887 42.5916032100001, -83.4023157669999 42.5921895000001, -83.405505923 42.58921166, -83.410911373 42.589550257, -83.4177130309999 42.5904449600001, -83.421439092 42.5907736840001, -83.4231443909999 42.59092409, -83.4246049779999 42.5915773660001, -83.4239409529999 42.5948851650001, -83.4249052879999 42.5961718660001, -83.425503363 42.5989959510001, -83.426333245 42.599312818, -83.424684752 42.5996488050001, -83.4244939719999 42.601217348, -83.429931806 42.6029603920001, -83.432135847 42.6023500970001, -83.4346190379999 42.6016624420001, -83.434956928 42.601085411, -83.437054095 42.600346589, -83.437036424 42.5947485500001, -83.437614783 42.594391585, -83.438350059 42.5947783620001, -83.4408003729999 42.5945004660001, -83.440678845 42.592245662, -83.438566449 42.591840201, -83.436233955 42.5920733070001, -83.435456191 42.5917268790001, -83.436175893 42.591142339, -83.435493395 42.585834984, -83.435361498 42.5838390490001, -83.431010454 42.583092461, -83.429758723 42.5815835980001, -83.4205742789999 42.579662453, -83.418769708 42.577909522, -83.417237262 42.577134287, -83.417840725 42.57617659, -83.41983024 42.5764996460001, -83.4271141099999 42.5774523270001, -83.4292284219999 42.578360328, -83.4296044279999 42.577321839, -83.430008824 42.576387835, -83.427178192 42.576102221, -83.426122716 42.576299303, -83.421249426 42.5759669550001, -83.421192897 42.574933672, -83.4206127479999 42.5749618290001, -83.4206753989999 42.5739994510001, -83.420371014 42.5684005630001, -83.4184212059999 42.5688290630001, -83.4164171739999 42.569032486, -83.415570922 42.5689761360001, -83.414953466 42.569038655, -83.414297462 42.5693138300001, -83.4116746939999 42.5691782310001, -83.411275238 42.5677224040001, -83.41462398 42.5650900750001, -83.414937416 42.562369839, -83.426006402 42.559969079, -83.42991885 42.557164399, -83.422565365 42.557492396, -83.417818762 42.5591955630001, -83.415742128 42.559505603, -83.414356757 42.559565961, -83.414121186 42.558944061, -83.415920507 42.558812866, -83.415527351 42.5577618730001, -83.411276632 42.5573111350001, -83.4084884649999 42.5576947280001, -83.408072471 42.556978498, -83.411585587 42.5560226440001, -83.414145623 42.5557286810001, -83.41315071 42.555008645, -83.412955161 42.554414803, -83.4129450629999 42.552578742, -83.413635319 42.5521082760001, -83.413275782 42.551159941, -83.413094751 42.550475287, -83.4123548269999 42.5502764390001, -83.412310443 42.549270592, -83.412626801 42.5484451560001, -83.4067333849999 42.5481723230001, -83.400129009 42.544156215, -83.400002823 42.5477629980001, -83.3984019919999 42.55077979, -83.394684401 42.549811655, -83.391673345 42.549027408, -83.390160481 42.54972925, -83.385159201 42.549830226, -83.384429245 42.550299377, -83.3850452679999 42.551758439, -83.384535989 42.5519140910001, -83.384095313 42.5510670240001, -83.384014137 42.549468502, -83.386834102 42.5475848070001, -83.386374186 42.5463328290001, -83.3860804779999 42.5474462350001, -83.3834618349999 42.5491473870001, -83.383522569 42.5505252090001, -83.3829482309999 42.5505681170001, -83.3822676779999 42.5506172440001, -83.382322631 42.5531841540001, -83.38297722 42.553260918, -83.3829465109999 42.5546587630001, -83.382083581 42.554693349, -83.380888584 42.5540062010001, -83.3767005669999 42.5547938130001, -83.377099548 42.552098562, -83.379776385 42.549800782, -83.3813375569999 42.5472494410001, -83.382497426 42.5439612930001, -83.381171008 42.543986858, -83.381135101 42.5430854780001, -83.3802440269999 42.5431029630001, -83.379434332 42.5431205260001, -83.3771908849999 42.5457767990001, -83.3773629899999 42.5485470770001, -83.379234364 42.548830362, -83.379044821 42.549411143, -83.377308785 42.550687485, -83.37378267 42.550629906, -83.371737298 42.5529718010001, -83.3720406849999 42.556669829, -83.372388803 42.557034457, -83.375459182 42.5569595700001, -83.375560975 42.5615458350001, -83.375669058 42.563812898, -83.371906505 42.5643223230001, -83.3723696019999 42.5710004110001, -83.3666944729999 42.5731888940001, -83.363208129 42.5783813790001, -83.3628501319999 42.579177133, -83.365076705 42.5795606200001, -83.365523777 42.578429134, -83.369602953 42.5762772190001, -83.3750145879999 42.576771486, -83.377316445 42.5812452660001, -83.377085688 42.5831553680001, -83.38115787 42.586142685, -83.3842319139999 42.585886664, -83.389272733 42.586988761, -83.391408072 42.587455543, -83.393855515 42.5910221090001, -83.394355043 42.5917666290001, -83.392230802 42.593297717, -83.392410179 42.595035137, -83.397558687 42.5939599660001, -83.3980807579999 42.5946902790001, -83.39813639 42.597194481, -83.4000763499999 42.5973820660001, -83.402319419 42.5975989180001, -83.404092699 42.5993725770001, -83.4081423759999 42.600165841, -83.4109475499999 42.5994435550001, -83.4107892769999 42.6024434180001), (-83.3882015729999 42.5807976420001, -83.385422257 42.5816910610001, -83.381283125 42.580563759, -83.379514415 42.5776127030001, -83.380605595 42.575391032, -83.386288039 42.5753753500001, -83.389995992 42.5737298280001, -83.395807393 42.57301678, -83.3988819429999 42.573382333, -83.407416182 42.5730997470001, -83.410212153 42.572979735, -83.412915732 42.5717658630001, -83.4162582119999 42.572498868, -83.4172747119999 42.5732524950001, -83.413008679 42.575701161, -83.410645156 42.578221419, -83.403204483 42.577216234, -83.399140684 42.5795064480001, -83.391829958 42.576191286, -83.391549904 42.5799239180001, -83.388842801 42.5786023260001, -83.386248844 42.578652827, -83.386006 42.5796786070001, -83.3882015729999 42.5807976420001), (-83.394103339 42.5669388160001, -83.396599024 42.565113222, -83.403223713 42.5663146300001, -83.402720959 42.567429648, -83.394073192 42.568416046, -83.394103339 42.5669388160001), (-83.381784535 42.568751078, -83.381367385 42.5676453560001, -83.3892546769999 42.5664454110001, -83.3896103 42.568215217, -83.381784535 42.568751078), (-83.386202808 42.571505616, -83.382333386 42.5710844640001, -83.3824751189999 42.5700931800001, -83.387723023 42.569735838, -83.389815149 42.569234641, -83.390000594 42.5701574730001, -83.386202808 42.571505616))"
Substation_COMLK,SUBSTATION,OPERATING,Substation COMLK,,"POLYGON ((-83.488609868 42.6183164300001, -83.4913460179999 42.618526171, -83.4929353379999 42.620677062, -83.494192326 42.6246856970001, -83.502259008 42.6268828930001, -83.50610046 42.6279289710001, -83.506647513 42.6265799970001, -83.506472483 42.6247039040001, -83.507273754 42.6238225610001, -83.507360864 42.622601049, -83.510018201 42.62175139, -83.510594455 42.6196045520001, -83.510167082 42.6171389850001, -83.515930602 42.617673788, -83.516392343 42.6198796640001, -83.5208615239999 42.619501186, -83.520696355 42.615588358, -83.522799893 42.6154438560001, -83.52627116 42.617403086, -83.525534662 42.618864806, -83.536574872 42.6180339480001, -83.5362112719999 42.6122917880001, -83.534576506 42.6046721020001, -83.5325232279999 42.603856745, -83.529309418 42.6041166260001, -83.526584794 42.601470336, -83.52885227 42.5968036, -83.529187701 42.594152783, -83.525058418 42.591255538, -83.51844066 42.5891289480001, -83.512493139 42.590704058, -83.5110970109999 42.5902329960001, -83.510848792 42.589759665, -83.509783135 42.587727457, -83.5127151299999 42.585205504, -83.52028502 42.582883462, -83.523312252 42.5791096570001, -83.5191444069999 42.5692215970001, -83.515209458 42.5660361980001, -83.5090307899999 42.5632004440001, -83.511736511 42.5608764610001, -83.513465256 42.5588520040001, -83.518763623 42.5585283710001, -83.518618251 42.5577512830001, -83.5180474219999 42.5561709890001, -83.513392768 42.556680268, -83.510819413 42.557881508, -83.508321859 42.5569653200001, -83.5109655059999 42.5547353330001, -83.512759798 42.5543744500001, -83.513132545 42.5477256990001, -83.495347651 42.554244941, -83.4949586819999 42.556677639, -83.4929077799999 42.5562057500001, -83.490024315 42.557833067, -83.487023925 42.559458711, -83.4829512489999 42.559701648, -83.48008013 42.5589462880001, -83.4755037689999 42.5596782910001, -83.4751561579999 42.5579304010001, -83.4782954409999 42.5568564210001, -83.483601777 42.556402801, -83.486280511 42.5571299530001, -83.488100232 42.555837818, -83.487122834 42.5524408260001, -83.482653888 42.5506315220001, -83.4794797169999 42.5504794120001, -83.478751656 42.5504445130001, -83.477943352 42.549697402, -83.477830996 42.5485030290001, -83.4746013119999 42.5486453190001, -83.4748466739999 42.5529732090001, -83.472723775 42.553026957, -83.472450286 42.5535642350001, -83.471305194 42.5560682350001, -83.4640099059999 42.5601952150001, -83.46414569 42.5670872100001, -83.461260605 42.5674514150001, -83.461256269 42.569906546, -83.4603531339999 42.5699100640001, -83.460139999 42.5689889810001, -83.459362331 42.568910439, -83.4591075279999 42.5641372650001, -83.452709923 42.564445957, -83.449661277 42.5664271110001, -83.4512076889999 42.570261714, -83.450828099 42.571745332, -83.454963922 42.5723392460001, -83.45820495 42.5750820420001, -83.455558286 42.5806003000001, -83.4573481629999 42.5809981900001, -83.460703539 42.5809783760001, -83.461673111 42.5817152970001, -83.466726783 42.581185234, -83.4670410749999 42.582956229, -83.470570336 42.5836418820001, -83.4707069249999 42.5853817140001, -83.471025254 42.5870574370001, -83.469402084 42.5873071020001, -83.468036846 42.585989286, -83.465910767 42.585917737, -83.4622607649999 42.588386299, -83.461396038 42.5905837010001, -83.4603802139999 42.590966081, -83.4596938669999 42.5849198610001, -83.458343438 42.584031327, -83.4546221369999 42.58587828, -83.449467077 42.587287501, -83.448463365 42.5865973800001, -83.446870378 42.5868950830001, -83.446045289 42.5881340500001, -83.449143217 42.5888772710001, -83.449116018 42.591093507, -83.451823382 42.5911546500001, -83.451941214 42.5922061410001, -83.4490619059999 42.5947393590001, -83.447223988 42.5996102390001, -83.448331239 42.5999193260001, -83.456936247 42.599374534, -83.467759544 42.6001868930001, -83.4735425549999 42.6037293630001, -83.470251339 42.6063933510001, -83.472027343 42.6102947090001, -83.471409842 42.6119732980001, -83.469993131 42.612680503, -83.471924881 42.6162303890001, -83.483045921 42.616408747, -83.487458402 42.6164792160001, -83.488609868 42.6183164300001), (-83.486465568 42.584485349, -83.484980623 42.5841652710001, -83.484488561 42.5817216740001, -83.4856517269999 42.5804082810001, -83.490673298 42.5806157170001, -83.492227224 42.57969361, -83.493381707 42.579661151, -83.4930297069999 42.5809442080001, -83.499694367 42.5804484810001, -83.5004305959999 42.5833617260001, -83.493199843 42.585049208, -83.487745882 42.5862970690001, -83.486465568 42.584485349), (-83.480850878 42.590308077, -83.476568814 42.5903279930001, -83.476416297 42.5877501900001, -83.473010742 42.586625166, -83.471675749 42.5829958800001, -83.4798767619999 42.580453268, -83.479941076 42.5813340080001, -83.4803097669999 42.586382519, -83.477564066 42.5872084010001, -83.480472535 42.588611122, -83.480850878 42.590308077))"

For the default Maximo Health and Predict – Utilities models, you have to use a FEEDER classification to load feeder data as a location into the application as showed in upper example, COMLK,COMLK9020 feeder. Each asset classification has a feeder specification to indicate which feeder the asset is located in. SPEC.NUMBEROFCUSTOMERS is required for both feeder location data and asset data for criticality scoring.

The files can include ASSETNUM, CLASSIFICATIONID, GROUPNAME, LOCATION, INSTALLDATE, STATUS, STATUSDATE, DESCRIPTION,  SPEC.NUMBEROFCUSTOMERS, SPEC.FEEDER, SPEC.SUBTYPE, and GEOMETRY columns. Create one asset csv file for each asset type.

If a HIERARCHYPATH value is specified in the classifications.csv file, specify the HIERARCHYPATH in the asset.csv file. The SPEC. columns contain the specification attribute’s value. If you add more SPEC. columns, ensure that the columns are also added to the classification.csv file.

GROUPNAME is the meter group name defined for this asset type. If you specify a GROUPNAME value, those meters are added under the group to specific assets. The LOCATION column is used defined the location the asset is at. The INSTALLDATE value is when the asset was installed. Ensure that you use the yyyy-mm-dd format. The STATUS value is the current status of the asset. The STATUSDATE value is the date when the status last changed. Ensure that you use the yyyy-mm-dd format. The DESCRIPTION value is the description for the asset.

For the default Maximo Health and Predict – Utilities models, you must define some SPEC.NUMBEROFCUSTOMERS and SPEC.FEEDER values for asset data. The SPEC.FEEDER value must match the value in the location.csv file and the related feeder's SPEC.NUMBEROFCUSTOMER value must be bigger than the asset's SPEC.NUMBEROFCUSTOMER value. If you want to use the model for the end of life curve, for each asset type, you must have at least six assets that are in a DECOMMISSIONED status and that have a corresponding status date. Ensure that you specify the location value for the asset.

The following text is an example of an asset csv file.

ASSETNUM,CLASSIFICATIONID,GROUPNAME,LOCATION,INSTALLDATE,STATUS,STATUSDATE,DESCRIPTION,SPEC.NUMBEROFCUSTOMERS,SPEC.FEEDER,SPEC.SUBTYPE,GEOMETRY
BRK_268370,CIRCUITBREAKER,CB_MG,BRK_268370,2003-03-28,OPERATING,,brk_268370,0,LILY 9120,Air Blast Circuit Breaker,POINT (-83.4094060 42.5653861)
BRK_268371,CIRCUITBREAKER,CB_MG,BRK_268371,2003-03-28,OPERATING,,brk_268371,0,LILY 9120,Oil Circuit Breaker,POINT (-83.4094069 42.5653666)

ASSETNUM,CLASSIFICATIONID,ASSETTYPE,GROUPNAME,LOCATION,INSTALLDATE,STATUS,STATUSDATE,DESCRIPTION,SPEC.NUMBEROFCUSTOMERS,SPEC.FEEDER,SPEC.SUBTYPE,GEOMETRY
BRK_268370,CIRCUITBREAKER,AIR_BLAST_CIRCUIT_BREAKER,CB_MG,BRK_268370,2003-03-28,OPERATING,,brk_268370,0,LILY 9120,Air Blast Circuit Breaker,POINT (-83.4094060 42.5653861)
BRK_268371,CIRCUITBREAKER,OIL_CIRCUIT_BREAKER,CB_MG,BRK_268371,2003-03-28,OPERATING,,brk_268371,0,LILY 9120,Oil Circuit Breaker,POINT (-83.4094069 42.5653666)

Asset meter reading csv files contain ASSETNUM, METER, TIMESTAMP, and VALUE columns. Location meter reading csv files contain LOCATION, METER, TIMESTAMP, and VALUE columns. If you are using functional locations, prepare the meter reading data in a location meter reading csv file.

Ensure that the TIMESTAMP values use the 2021-04-14T13:52:10+00:00 format.

The following text is an example of an asset meter reading csv file.

ASSETNUM,METER,TIMESTAMP,VALUE
BRK_272545,TIME-TRA,2021-04-14T13:52:10+00:00,B
BRK_272545,TANK-MECH,2021-04-14T13:52:10+00:00,B
BRK_272545,STOR-ENER,2021-04-14T13:52:10+00:00,A

LOCATION,METER,TIMESTAMP,VALUE
ST_1393137,B-CONDIT,2021-04-14T13:52:10+00:00,D
ST_1393137,WINDDT,2021-04-14T13:52:10+00:00,D
ST_1393137,ST-THERM,2021-04-14T13:52:10+00:00,D

SYSTEMID,DESCRIPTION,ADDRESS,NETWORK,PRIMARYSYSTEM,USAGE
CONTAINMENT,,false,false,true,CONTAINMENT
SAMPLENET1,,false,true,false,NETWORK

LOCATION,PARENT,SYSTEMID
REGION1,,CONTAINMENT
SUBSTATION_LILY,REGION1,CONTAINMENT
LILY 9038,SUBSTATION_LILY,CONTAINMENT
SUBSTATION_NIXON,REGION1,CONTAINMENT
NIXON9141,SUBSTATION_NIXON,CONTAINMENT

LOCATION,MAPWIDTHUPPER,MAPWIDTHLOWER,SYSTEMID
Substation_NIXON,3000,60,CONTAINMENT
Substation_LILY,3000,60,CONTAINMENT
Substation_COMLK,3000,60,CONTAINMENT
COMLK,60,8,CONTAINMENT