DEVELOPERS FORUM - Loading Part AML relationships using Batch Loader

aravinth_r - Wednesday, May 2, 2012 7:21 AM:

I am trying to use Batch Loader for loading Part AML relationships. My file content looks like below:

PLMNUMBER|MANUPARTNAME
WT-002-100153|C1825C333KDRACTU
WT-002-100153|1825AC333KAT3A
WT-002-100154|GRM033R61A104ME15D
WT-002-100155|GRM033R71A103KA01D

I choose the AML for loading this data using the Wizard as follows:

<Item type='Part AML' action='add'>
  <source_id>
    <Item type='Part' action='get' select='id'>
      <keyed_name>@1</keyed_name>
    </Item>
  </source_id>
  <related_id>
    <Item type='Manufacturer Part' action='get' select='id'>
      <keyed_name>@2</keyed_name>
    </Item>
  </related_id>
</Item>

When I load this data, I get the following error:

[4:39:53 PM - Worker process for lines up to 100 (Thread #1)]: #1 - Failed to process row WT-002-100153|C1825C333KDRACTU
[4:39:53 PM - Worker process for lines up to 100 (Thread #1)]:     Code: SOAP-ENV:Server
[4:39:53 PM - Worker process for lines up to 100 (Thread #1)]:     Message: ID must be specified
[4:39:53 PM - Worker process for lines up to 100 (Thread #1)]:     Details: ID must be specified

Same error comes for all the rows. What is the reason behind this error? Should i mention the id of the parts instead of the name of the part?

Thanks in advance!

Regards, Aravinth

Brian - Wednesday, May 2, 2012 7:30 AM:

Hi Aravinth,

Replace the <keyed_name> tags with <item_number> in both cases and I think you will find it works.

Cheers,

Brian.

aravinth_r - Wednesday, May 2, 2012 7:50 AM:

Hi Brian,

I used like what you have suggested. Still i get the same problem.

<Item type='Part AML' action='add'>
  <source_id>
    <Item type='Part' action='get' select='id'>
      <item_number>@1</item_number>
    </Item>
  </source_id>
  <related_id>
    <Item type='Manufacturer Part' action='get' select='id'>
      <item_number>@2</item_number>
    </Item>
  </related_id>
</Item>

Error:

[5:16:18 PM - Worker process for lines up to 100 (Thread #1)]: #1 - Failed to process row WT-002-100153|KEMET|C1825C333KDRACTU
[5:16:18 PM - Worker process for lines up to 100 (Thread #1)]:     Code: SOAP-ENV:Server
[5:16:18 PM - Worker process for lines up to 100 (Thread #1)]:     Message: ID must be specified
[5:16:18 PM - Worker process for lines up to 100 (Thread #1)]:     Details: ID must be specified

Please let me know why this happens

Regards, Aravinth

aravinth_r - Wednesday, May 2, 2012 8:56 AM:

Hi Brian,

One more thing I wanted to say is, for the Manufacturer Part, I have made the item_number property and the manufacturer property as unique so that the combination of item_number and manufacturer will be unique. During the load I give only the item_number and not the manufacturer. In fact I dont see a field in wizard mapping user interface of Batch loader to which I can map the manufactuer. Will that be a reason why the Batch loader is not able to find the ID of the Manufacturer Part.

Please help.

Regards, Aravinth

Brian - Wednesday, May 2, 2012 10:52 AM:

Hi Aravinth,

It looks like you have changed your data table to be: Part number, Manufacturer, Manufacturer Part

but you have not updated your input AML to select the correct parameter to substitute for the Manufacturer Part.

<Item type='Part AML' action='add'>
  <source_id>
    <Item type='Part' action='get' select='id'>
      <item_number>@1</item_number>
    </Item>
  </source_id>
  <related_id>
    <Item type='Manufacturer Part' action='get' select='id'>
      <item_number>@2</item_number>             <<<<<< this parameter number should be the same position in the file that the Manufacturer part is.
    </Item>
  </related_id>
</Item>

The Manufacturer being unique should not matter since you only need the item_number to find the record.

I tried to apply the basic AML via the NASH script and substituting real values for the <item_number> in both cases and it worked for me.

Cheers,

Brian.

aravinth_r - Thursday, May 3, 2012 7:57 AM:

Hi Brian,

Please find attached the screenshot of my Batch loader screen when it fails. I have given the data file with two columns only and it has been mapped properly to the part and manufacturer part. But still it fails saying ID must be specified. Please throw me some light why this is failing.

Regards, Aravinth

Brian - Monday, May 7, 2012 5:23 PM:

Hi Aravinth,

The screen shot did not appear.

If you are still having problems with this please send me an email direct to [email protected] with the screen shot and a file with a couple of lines of parts/manufacturer parts.

cheers,

Brian.

Brian - Wednesday, May 9, 2012 2:19 AM:

Hi Aravinth,

I am not sure what is happening here. I have imported your parts and MFG Parts into a clean database then run the batch loader against the file you sent me to load the Part AML. This loaded all 391 part relationships with no errors.

Can you try to load just one (1) Part AML relationship via the NASH script or the AML studio?

This may give a better error message to tell you what is going wrong.

Let me know how you go.

Cheers,

Brian.