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.
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
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 🙂