Use MXLoader to load contract

Forums MxLoader Use MXLoader to load contract

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #20099
    tduong
    Participant

    Hi there,

    I am trying to load contract data into Maximo using mxloader but having no luck so far.

    Have anyone done this can help me on how to setup a proper object structure and template?

    Thanks!

    #20100
    AL
    Participant

    I attached a sample sheet for your reference it’s Purchase contract

    MXLOADER:
    <table border=”0″ width=”1326″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”mso-width-source: userset; mso-width-alt: 2656; width: 50pt;” width=”66″ /> <col style=”mso-width-source: userset; mso-width-alt: 8512; width: 160pt;” width=”213″ /> <col style=”mso-width-source: userset; mso-width-alt: 4832; width: 91pt;” width=”121″ /> <col style=”width: 76pt;” span=”3″ width=”101″ /> <col style=”mso-width-source: userset; mso-width-alt: 4192; width: 79pt;” width=”105″ /> <col style=”mso-width-source: userset; mso-width-alt: 2464; width: 46pt;” width=”62″ /> <col style=”mso-width-source: userset; mso-width-alt: 2080; width: 39pt;” width=”52″ /> <col style=”width: 76pt;” span=”4″ width=”101″ /> </colgroup>
    <tbody>
    <tr style=”height: 15.0pt;”>
    <td class=”xl66″ style=”height: 15.0pt; width: 50pt;” width=”66″ height=”20″>MXL_PC</td>
    <td class=”xl66″ style=”border-left: none; width: 160pt;” width=”213″>PURCHVIEW</td>
    <td class=”xl66″ style=”border-left: none; width: 91pt;” width=”121″>Sync-AddChange</td>
    <td class=”xl66″ style=”border-left: none; width: 76pt;” width=”101″></td>
    <td class=”xl66″ style=”border-left: none; width: 76pt;” width=”101″></td>
    <td class=”xl66″ style=”border-left: none; width: 76pt;” width=”101″></td>
    <td class=”xl66″ style=”border-left: none; width: 79pt;” width=”105″></td>
    <td class=”xl66″ style=”border-left: none; width: 46pt;” width=”62″></td>
    <td class=”xl66″ style=”border-left: none; width: 39pt;” width=”52″></td>
    <td class=”xl66″ style=”border-left: none; width: 76pt;” width=”101″></td>
    <td class=”xl66″ style=”border-left: none; width: 76pt;” width=”101″></td>
    <td class=”xl66″ style=”border-left: none; width: 76pt;” width=”101″></td>
    <td class=”xl66″ style=”border-left: none; width: 76pt;” width=”101″></td>
    </tr>
    <tr style=”height: 45.0pt;”>
    <td class=”xl67″ style=”height: 45.0pt; border-top: none; width: 50pt;” width=”66″ height=”60″>CONTRACTNUM</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 160pt;” width=”213″>DESCRIPTION</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 91pt;” width=”121″>CONTRACTTYPE</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 76pt;” width=”101″>STARTDATE</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 76pt;” width=”101″>ENDDATE</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 76pt;” width=”101″>TKNUM</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 79pt;” width=”105″>VENDORREFNUM</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 46pt;” width=”62″>VENDOR</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 39pt;” width=”52″>ORGID</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 76pt;” width=”101″>DOCLINKS.URLTYPE</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 76pt;” width=”101″>DOCLINKS.DOCTYPE</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 76pt;” width=”101″>DOCLINKS.DESCRIPTION</td>
    <td class=”xl67″ style=”border-top: none; border-left: none; width: 76pt;” width=”101″>DOCLINKS.DOCUMENTDATA</td>
    </tr>
    </tbody>
    </table>
    Object Structure : MXL_PC

     
    <table border=”0″ width=”893″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”mso-width-source: userset; mso-width-alt: 4132; width: 85pt;” width=”113″ /> <col style=”mso-width-source: userset; mso-width-alt: 3510; width: 72pt;” width=”96″ /> <col style=”mso-width-source: userset; mso-width-alt: 7168; width: 147pt;” width=”196″ /> <col style=”mso-width-source: userset; mso-width-alt: 4132; width: 85pt;” width=”113″ /> <col style=”mso-width-source: userset; mso-width-alt: 3291; width: 68pt;” width=”90″ /> <col style=”mso-width-source: userset; mso-width-alt: 3328; width: 68pt;” width=”91″ /> <col style=”mso-width-source: userset; mso-width-alt: 7094; width: 146pt;” width=”194″ /> </colgroup>
    <tbody>
    <tr style=”height: 15.75pt;”>
    <td class=”xl64″ style=”height: 15.75pt; width: 85pt;” width=”113″ height=”21″>Object</td>
    <td class=”xl64″ style=”width: 72pt;” width=”96″>Parent Object</td>
    <td class=”xl64″ style=”width: 147pt;” width=”196″>Object Location Path</td>
    <td class=”xl64″ style=”width: 85pt;” width=”113″>Relationship</td>
    <td class=”xl64″ style=”width: 68pt;” width=”90″>Object Order</td>
    <td class=”xl64″ style=”width: 68pt;” width=”91″>User Defined</td>
    <td class=”xl64″ style=”width: 146pt;” width=”194″>Exclude Attributes Mode</td>
    </tr>
    <tr style=”height: 15.75pt;”>
    <td style=”height: 15.75pt;” height=”21″>PURCHVIEW</td>
    <td></td>
    <td>PURCHVIEW</td>
    <td></td>
    <td class=”xl63″ align=”right”>1</td>
    <td>Y</td>
    <td>N</td>
    </tr>
    <tr style=”height: 15.75pt;”>
    <td style=”height: 15.75pt;” height=”21″>CONTRACTLINE</td>
    <td>PURCHVIEW</td>
    <td>PURCHVIEW/CONTRACTLINE</td>
    <td>CONTRACTLINE</td>
    <td class=”xl63″ align=”right”>1</td>
    <td>Y</td>
    <td>N</td>
    </tr>
    <tr style=”height: 15.75pt;”>
    <td style=”height: 15.75pt;” height=”21″>CONTRACTTERM</td>
    <td>PURCHVIEW</td>
    <td>PURCHVIEW/CONTRACTTERM</td>
    <td>CONTRACTTERM</td>
    <td class=”xl63″ align=”right”>2</td>
    <td>Y</td>
    <td>N</td>
    </tr>
    <tr style=”height: 15.75pt;”>
    <td style=”height: 15.75pt;” height=”21″>CONTRACTAUTH</td>
    <td>PURCHVIEW</td>
    <td>PURCHVIEW/CONTRACTAUTH</td>
    <td>CONTRACTAUTH</td>
    <td class=”xl63″ align=”right”>3</td>
    <td>Y</td>
    <td>N</td>
    </tr>
    <tr style=”height: 15.75pt;”>
    <td style=”height: 15.75pt;” height=”21″>DOCLINKS</td>
    <td>PURCHVIEW</td>
    <td>PURCHVIEW/DOCLINKS</td>
    <td>DOCLINKS</td>
    <td class=”xl63″ align=”right”>4</td>
    <td>Y</td>
    <td>N</td>
    </tr>
    </tbody>
    </table>
     
    <table border=”0″ width=”1326″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”mso-width-source: userset; mso-width-alt: 2656; width: 50pt;” width=”66″ /> <col style=”mso-width-source: userset; mso-width-alt: 4192; width: 79pt;” width=”105″ /> <col style=”mso-width-source: userset; mso-width-alt: 2464; width: 46pt;” width=”62″ /> <col style=”mso-width-source: userset; mso-width-alt: 2080; width: 39pt;” width=”52″ /> <col style=”width: 76pt;” span=”4″ width=”101″ /> </colgroup>
    <tbody>
    <tr style=”height: 15.0pt;”>
    <td class=”xl64″ style=”height: 15.0pt; width: 50pt;” width=”66″ height=”20″></td>
    <td class=”xl64″ style=”width: 160pt;” width=”213″></td>
    <td class=”xl64″ style=”width: 91pt;” width=”121″></td>
    <td class=”xl64″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl64″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl64″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl64″ style=”width: 79pt;” width=”105″></td>
    <td class=”xl64″ style=”width: 46pt;” width=”62″></td>
    <td class=”xl64″ style=”width: 39pt;” width=”52″></td>
    <td class=”xl64″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl64″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl64″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl64″ style=”width: 76pt;” width=”101″></td>
    </tr>
    <tr style=”height: 45.0pt;”>
    <td class=”xl65″ style=”height: 45.0pt; width: 50pt;” width=”66″ height=”60″></td>
    <td class=”xl65″ style=”width: 160pt;” width=”213″></td>
    <td class=”xl65″ style=”width: 91pt;” width=”121″></td>
    <td class=”xl65″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl65″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl65″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl65″ style=”width: 79pt;” width=”105″></td>
    <td class=”xl65″ style=”width: 46pt;” width=”62″></td>
    <td class=”xl65″ style=”width: 39pt;” width=”52″></td>
    <td class=”xl65″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl65″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl65″ style=”width: 76pt;” width=”101″></td>
    <td class=”xl65″ style=”width: 76pt;” width=”101″></td>
    </tr>
    </tbody>
    </table>

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
You must be logged in to reply to this topic.
Scroll to top