How can I load Manufacturers + Manufacturer Parts + Sites in on parts?

Hi,

I have tried to load Manufacturer in on Parts. But Agile will not accept my load sheet.

Which type of load should I choose? Level template, Parent-Child Template or Standard, No template.

I have never tried to load anything else than attributes on the title block. How do I get access to load in the other Tabs?

BR, Janne.

Agile User Asked on August 15, 2019 in Product Collaboration.
Add Comment
2 Answer(s)

Hi Janne,

If you want to load manufacturer using SDK then here is my code

First you have to load item or part

IItem itemObj7 = (IItem)AgileUtility.iAgileSession.getObject(ItemConstants.CLASS_PARTS_CLASS, “Item name”);

then you have to load manufacturer table on that part

ITable tab7 =itemObj7.getTable(ItemConstants.TABLE_MANUFACTURERS);

then using loop iterate each and every row of manufacturer and access there attribute

 

for (Iterator iterator10 = tab7.iterator(); iterator10.hasNext();)
{
partsetflag = true;
IRow manurow1 = (IRow) iterator10.next();
String mfrname = manurow1.getCell(ItemConstants.ATT_MANUFACTURERS_MFR_NAME).toString();
String MFRPART = manurow1.getCell(ItemConstants.ATT_MANUFACTURERS_MFR_PART_NUMBER).toString();
String MfrReach = manurow1.getCell(ItemConstants.ATT_MANUFACTURERS_MFR_PART_LIST20).toString();
System.out.println(mfrname+” “+MFRPART + ” “+MfrReach);
if(MfrReach.equalsIgnoreCase(“No”) || MfrReach.equals(“”))
{
System.out.println(“null found for “+MFRPART);
partsetflag = false;
break;

}
}

if you want to access page two attribute or load manufacturer object then

IManufacturer mfr1 = (IManufacturer)AgileUtility.iAgileSession.getObject(IManufacturer.OBJECT_TYPE, mfrname );
System.out.println(“Manufacturer : ” + mfr1.getName());
MName = mfr1.getName();

String lovvalue = mfr.getValue(ManufacturerConstants.ATT_PAGE_TWO_MULTILIST01).toString();
mfr1.setValue(ManufacturerConstants.ATT_GENERAL_INFO_LIFECYCLE_PHASE, “Debarred”);

 

Similarly for manufacturer parts :-

 

IManufacturerPart mfrPartObj =(IManufacturerPart) AgileUtility.iAgileSession.getObject(ManufacturerPartConstants.CLASS_MANUFACTURER_PART, MFRPART );

String MPDesc = mfrPart1.getValue(
ManufacturerPartConstants.ATT_GENERAL_INFO_MANUFACTURER_PART_NUMBER)
.toString();

Hopefully it will help you.

 

Thanks

Priyanka

Agile User Answered on August 16, 2019.
Add Comment

Hi Janne,

 

I’ve been thinking about this issue. It might be related with a privilege to modify released parts (you might want to review it).

Also, are you using import and load data to a specific change, i.e. including redlines?

 

BR,

Dorota 🙂

Agile User Answered on October 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.