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,
UID
ibm11132131