7 Replies Latest reply on Aug 19, 2015 8:03 AM by Craig Schultz

Part number variable matched to file name

Wayne Easton Aug 17, 2015 12:00 PM

We are about to go live with our EPDM implementation and I think I may need to change something. Currently we have a Part number variable which is populated using a serial number. The file name is matched to the part number.

I would like to change this around and rather use a serial number to control the file name and then populate the part number field with the file name (excluding the extension.) I can not figure out how to get the part number field to look at the file name for its value.

Should I leave it as it is or would the idea of driving from file name be better practice?

What worries me is that I noticed that I can edit the part number field in the data card after the file as been created which means I can end up with duplicate part numbers if a user manually edits the value in the part number field. I can not get duplicate file names as the "Do not allow duplicate file names" setting has been turned on.

Thanks

Re: Part number variable matched to file name

Jeff Sweeney Aug 18, 2015 8:26 AM (in response to Wayne Easton)

Why the need for redundancy? Choose one, either the file name or a variable as the document unique identifier. If you do both, you have to keep them in sync -and that is difficult.
Like Show 0 Likes(0)

Actions
- Re: Part number variable matched to file name
  
  Wayne Easton Aug 18, 2015 8:48 AM (in response to Jeff Sweeney)
  
  I would like the filename to be the unique identifier but I can't figure out how to create a field on the data card which looks this up. Do I have to create a "FileName" variable in order for this to be added to the data card?
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Part number variable matched to file name
    
    Jeff Sweeney Aug 18, 2015 8:57 AM (in response to Wayne Easton)
    
    Does the file name need to be on the card? The guy just clicked on the file name two seconds ago to bring the card up, he knows the file name. If you want it on the card would a static text field work? They can be always up to date.
    
    Like Show 0 Likes(0)
    
    Actions
Re: Part number variable matched to file name

Craig Schultz Aug 18, 2015 5:00 PM (in response to Wayne Easton)

In your data card for parts and assemblies.....
Like Show 0 Likes(0)

Actions
- Re: Part number variable matched to file name
  
  Jeff Sweeney Aug 18, 2015 7:07 PM (in response to Craig Schultz)
  
  ...as long as you never rename your files.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Part number variable matched to file name
    
    Craig Schultz Aug 19, 2015 8:03 AM (in response to Jeff Sweeney)
    
    If it's not a serial number we don't care because it's just R&D/idea time. When it goes to the floor they get serial numbers. If they need to be renamed after getting a number, it's copy tree time.
    
    Like Show 0 Likes(0)
    
    Actions
Re: Part number variable matched to file name

Casey Bergman Aug 18, 2015 5:28 PM (in response to Wayne Easton)

I commonly use the string; $PRP:"SW-File Name" in our part number field to get the file name as the property. You might try this in your template and it will automatically fill it in.
Like Show 1 Likes(1)

Actions

Go to original post