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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11132131