So I am making a hardware library for work from the files we download from McMaster-Carr and other sources.

We are changing the file names of hardware to make more sense in our library, IE from the part number: 9657K268 to a description: .029 x 3_16 x 1_2 SPRING.

We kept the configuration name as the part number, 9657K268.

We changed the description for use in the BOM to match the file name, .029 x 3/16 x 1/2 SPRING, (we used slashes here where we had to use underscores for the file name).

We changed the part number displayed when used in a BOM to a user specific name that includes the source, in this case McMASTER 9657K268.

But I still want to be able to know the part number and be able to search for it.

I thought I could use the description since it is shown and searchable.

It worked for the part files, but we ran into some troubles with the drawing files.

Does anyone have any suggestions on how I can get the drawing file to read the configuration value 9657K268 as opposed to the formula \$PRPSHEET:"Description"?

The formula outputs the value in the drawing file, but not in Windows Explorer.

I was trying to make it so I could just run a Task Scheduler to add the Custom Properties Description = \$PRP:"SW-Configuration Name" for the part files and Description = \$PRPSHEET:"Description" for the drawing files.