Add/Change action

Forums MxLoader NextGen Beta Add/Change action

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #19958
    ruud66
    Participant

    Hi Bruno.

    I tried to perform a simple update on PERSON record. I.e. Query the existing record of 1 person, change his LASTNAME and use AddChange to update the name. I get the error below. Seems like AddChange acts similar to Sync-Add ? Do we need a ChangeOnly action?
    <table style=”border-collapse: collapse; width: 653pt;” border=”0″ width=”869″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”width: 109pt;” span=”3″ width=”145″ /> <col style=”mso-width-source: userset; mso-width-alt: 15872; width: 326pt;” width=”434″ /> </colgroup>
    <tbody>
    <tr style=”height: 15.0pt;”>
    <td class=”xl65″ style=”height: 15.0pt; width: 109pt;” width=”145″ height=”20″>VIPERSON</td>
    <td class=”xl65″ style=”width: 109pt;” width=”145″>PERSON</td>
    <td class=”xl65″ style=”width: 109pt;” width=”145″>AddChange</td>
    <td class=”xl65″ style=”width: 326pt;” width=”434″></td>
    </tr>
    <tr style=”height: 15.0pt;”>
    <td class=”xl68″ style=”height: 15.0pt; width: 109pt;” width=”145″ height=”20″>PERSONID</td>
    <td class=”xl66″ style=”width: 109pt;” width=”145″>FIRSTNAME</td>
    <td class=”xl66″ style=”width: 109pt;” width=”145″>LASTNAME</td>
    <td class=”xl66″ style=”width: 326pt;” width=”434″>[RESULT]</td>
    </tr>
    <tr style=”height: 15.0pt;”>
    <td class=”xl67″ style=”height: 15.0pt;” height=”20″>12345</td>
    <td class=”xl67″>John</td>
    <td class=”xl67″>Doe with change</td>
    <td class=”xl69″>BMXAA4129E – The record for Person=12345 already exists.</td>
    </tr>
    </tbody>
    </table>
    Thanks for your great efforts over the years!

    #19972
    badbilly
    Participant

    Hi,

    I came across the same issue with Add-Change for MXASSET [adding and updating ASSETSPEC records].

    BMXAA4129E – The record for Site=TEST, Asset=E9003945 already exists. This validation error is thrown when an attempt is made to insert a new record with a unique key value that already exists in the database. Ensure that the key value for the given record is unique.

    The same data set works fine in Mxloader 6.2.

    Apologies for negative feedback – i very much appreciate all the effort you have put into Mxloader!

    Regards,

    Bill

     

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