Rename a WT part using Import from Spreadhseet

Athmanand,

if you want to write custom utility then below are some sample API which u need to use

public static void renameWTPart(String[] array) {
// Read csv file to get the original number, new number and name,
  String orgNumber = array[1];
  String oldName = array[2];
  String newNumber = array[3];
  String newName = array[4];
  WTPartMaster partMaster = null;
  WTPartMaster dupMaster = null;


  String message;
  try {
  // Search for existing part
  partMaster = (WTPartMaster) getWTPartMaster(orgNumber);
  if (partMaster == null) {
  message = "ERROR: Can not find WTPart: " + orgNumber;
  addToLogs(message, logFile);
  // If we always return true then the load will continue
  return;
  }
  //search for with new WTPart number incase if part already exist
  dupMaster = (WTPartMaster) getWTPartMaster(newNumber);
  if (dupMaster != null) {
  message = "ERROR: WTPart already exists in database: " + newNumber;
  addToLogs(message, logFile);
  // If we always return true then the load will continue
  return;
  }


  try {
  // change WTPart identiry i.e. rename
  WTPartMasterIdentity partIdentity = (WTPartMasterIdentity) partMaster.getIdentificationObject();
  orgNumber = partIdentity.getNumber();
  partIdentity.setNumber(newNumber);
  partIdentity.setName(newName);
  IdentityHelper.service.changeIdentity(partMaster, partIdentity);
  PersistenceHelper.manager.refresh(partMaster);
  message = "SUCCESS: Renamed successfully: " + orgNumber + " to " + newNumber;
  addToLogs(message, logFile);
  }// try
  catch (WTException ex) {
  message = "FAIL: Rename error: " + orgNumber + " to " + newNumber + ": " + ex;
  addToLogs(message, logFile);
  // If we always return true then the load will continue
  return;
  }
  }// try
  catch (Exception ex) {
  message = "FAIL: Rename error: " + orgNumber + " to " + newNumber + ": " + ex;
  addToLogs(message, logFile);
  }// catch


  }

  public static WTPartMaster getWTPartMaster(String orgNumber) {


  WTPartMaster wtPartMaster = null;
  QuerySpec qs = null;
  try {
  qs = new QuerySpec(WTPartMaster.class);
  SearchCondition sc1 = new SearchCondition(WTPartMaster.class, "number", "=", orgNumber);
  qs.appendWhere(sc1);
  QueryResult qr = PersistenceHelper.manager.find(qs);
  if (qr.size() > 0) {
  wtPartMaster = (WTPartMaster) qr.nextElement()
  } catch (WTException ex) {
  ex.printStackTrace();
  }
  return wtPartMaster;
  }

Hope it helps !!!

Thanks

Shreyas

I believe the import from spreadsheet will rename objects but also iterates them.