Article - CS31708

What are the minimum access rights needed to allow a user to create and update parts using the action "Import From Spreadsheet" in Windchill PDMLink

Modified: 09-Nov-2025   


Applies To

  • Windchill PDMLink 9.1 to 13.1
  • Windchill Supplier Management 11.0 to 13.1

Description

  • Failed to update parts using Import From Spreadsheet
  • What access control permissions needed to Import From Spreadsheet
  • What are the minimum access rights needed to allow a user to create / update and parts using the action Import From Spreadsheet
  • Import from Spreadsheet action is updating BOM and Parts when users do not have Modify or Revise permissions
  • Users are not able to import product structure using Import From Spreadsheet
  • Is it possible to set permissions for a regular User to be able to Import From Spreadsheet without having Product Manager rights?
  • Import BOM from spreadsheet preview shows blank after validation step
  • What access control permissions needed to use Import From Spreadsheet action for Non Admin users
  • When user of Sourcing Administrator group tries to load the AML link data via Import from spreadsheet gives a error "User need to have modify permission to part to make changes"
  • User is in Member role cannot upload data by Import From Spreadsheet
  • When importing a spreadsheet, Validate Spreadsheet passes validation, but the spreadsheet does not import.
  • Import From Spreadsheet results in the error: 
"Attention: Secured action. You do not have the necessary authorization for the this operation. Contact your administrator if you believe you have received this message in error."
  • The following error is thrown in the Method Server log:
ERROR : wt.access.evaluation.report - "<user>" does not have Create permission for "Import Job - 0" in Administrative Domain "<domain>"
  • Import From Spreadsheet results error:
Sheet 1 "WTPart-Sheet":
Type: : Error
Row: : <number>
Description: : null
  • Method Server logs:
DEBUG [DataSource Task Executor-139] com.ptc.windchill.ixb.importer.part.PartSheetImporter <user> - Found part master 328094-401, GASKET
2020-11-20 02:28:29,389 DEBUG [DataSource Task Executor-139] com.ptc.windchill.ixb.importer.ImportHndHelper <user> - Ufid object id = wt.part.WTPartMaster:155975246, Ufid guid = 158374154-1028822927778-4354748-191-120-145-161, Ufid domain id = <hostname>, Part object id (long) = 155975246
2020-11-20 02:28:29,397 DEBUG [DataSource Task Executor-139] com.ptc.windchill.ixb.importer.StandardImportService <user> - StandardImportService -> doSameTypeSheetImport() : ImportSheetType :part
java.lang.NullPointerException
       at com.ptc.windchill.ixb.importer.part.PartSheetImporter.updateVersionInfoElement(PartSheetImporter.java:514)
       at com.ptc.windchill.ixb.importer.part.PartSheetImporter.updatedDocWithActor(PartSheetImporter.java:432)
       at com.ptc.windchill.ixb.importer.part.PartSheetImporter.getExistingPart(PartSheetImporter.java:395)
at com.ptc.windchill.ixb.importer.part.PartSheetImporter.validateSheetTypeAttributes(PartSheetImporter.java:639
This is a printer-friendly version of Article 31708 and may be out of date. For the latest version click CS31708