Hello!
I'm the SW admin at my company and need some help with data collection from SW files.
I'm new to the GitHub world and a non-coder/non-VBA person, but I am "medium-advanced" with SW, Excel, and Power Query.
I found your Excel macro for GETSWPRP and SETSWPRP using SW Document Manager API libraries to be very useful.
However, the data in our SW files is messy - a majority of our files have configurations with unique names, and, unfortunately, the configuration-specific custom properties tabs are where the engineers have been entering custom properties.
I will be implementing PDM soon, but need to clean this data (~6500 .sldprt/.sldasm/.slddrw files in total) before dropping it into PDM.
I'm looking for something similar to your GETSWPRP function that would list all of the configurations and all of the custom properties in each configuration for each file.
It would be ideal if it could do this all at once, rather than having to name each config within each GETSWPRP function.
If it is too difficult to happen all in one shot, I can wrangle the data with PQ after it is collected.
Hello! I'm the SW admin at my company and need some help with data collection from SW files. I'm new to the GitHub world and a non-coder/non-VBA person, but I am "medium-advanced" with SW, Excel, and Power Query.
I found your Excel macro for GETSWPRP and SETSWPRP using SW Document Manager API libraries to be very useful. However, the data in our SW files is messy - a majority of our files have configurations with unique names, and, unfortunately, the configuration-specific custom properties tabs are where the engineers have been entering custom properties. I will be implementing PDM soon, but need to clean this data (~6500 .sldprt/.sldasm/.slddrw files in total) before dropping it into PDM.
I'm looking for something similar to your GETSWPRP function that would list all of the configurations and all of the custom properties in each configuration for each file. It would be ideal if it could do this all at once, rather than having to name each config within each GETSWPRP function. If it is too difficult to happen all in one shot, I can wrangle the data with PQ after it is collected.
Cheers!