IBM Support

Loading only LOCATIONS table using MIF.

Technical Blog Post


Abstract

Loading only LOCATIONS table using MIF.

Body

Please creates an Object Structure with LOCATIONS object only.

You can duplicate an out of the box MXOPERLOC and delete un-wanted

objects. Please use the attached flat file as a data sample.

 


EXTSYS1,LOCATIONS,AddChange
AUTOWOGEN,BILLTOADDRESSCODE,BILLTOLABORCODE,CALNUM,CHANGEBY,CHANGEDATE,CHILDREN,CONTROLACC,CURVARACC,DESCRIPTION,LONGDESC,DISABLED,EXTERNALREFID,FAILURECODE,GISPARAM1,GISPARAM2,GISPARAM3,GLACCOUNT,GROUPNAME,HASCHILDREN,HASPARENT,HIERARCHYPATH,INTLABREC,INVCOSTADJACC,INVOICEVARACC,INVOWNER,ISDEFAULT,ISREPAIRFACILITY,ITEMNUM,ITEMSETID,LOCATION,LOCATIONSID,LOCPRIORITY,OLDCONTROLACC,OLDINVCOSTADJACC,OLDSHRINKAGEACC,ORGID,OWNERSYSID,PARENT,PLUSCDUEDATE,PLUSCLOOP,PLUSCPMEXTDATE,PURCHVARACC,RECEIPTVARACC,SADDRESSCODE,SENDERSYSID,SERVICEADDRESSCODE,SHIFTNUM,SHIPTOADDRESSCODE,SHIPTOLABORCODE,SHRINKAGEACC,SITEID,SOURCESYSID,STATUS,STATUSDATE,STATUSIFACE,SYSTEMID,TOOLCONTROLACC,TYPE,USEINPOPR,WARRANTYEXPDATE
0,,,,MAXADMIN,2014-11-11T13:22:13-05:00,0,,,Address Unit #2001 Oak St. - W560,,0,,,,,,6290-300-???,,0,1,,,,,,0,0,,SET1,TEST,81,,,,,EAGLENA,,BLK2000,,0,0,,,,MX,,,,,,BEDFORD,,ACTIVE,2014-11-11T13:22:06-05:00,0,GEO,,OPERATING,0,

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11132131