Batch Custom Properties Program

Discussion created by Fifi Riri on Feb 23, 2019
Latest reply on Jan 24, 2020 by Ue Press Tools Pvt Ue

Like • Show 14 Likes14
Comment • 68

Here is a stand-alone application to display and edit the custom properties and configuration custom properties of a list of files.

As of version 0.25, it can run in 2 modes: Fast and Slow

The Fast mode uses SolidWorks Document Manager library to avoid opening each files and speeding up the process.

If you don’t have one yet, follow this link to request your SwDocManager license key (it's free):

https://www.javelin-tech.com/blog/2017/04/solidworks-document-manager-api-key/

Then place it in the text file that will be created in the same folder as the program.

The Slow mode uses SolidWorks to open each files to get or set the custom properties.

It's more like a test mode, to see how the application works while waiting for the SwDocManager license key.

It should work like the Fast mode, albeit with all the issues of opening files with SolidWorks.

Functions:

- change a custom property value in a file by editing its cell

- change a custom property value in all the files by defining the column’s rule, then apply it by right-clicking the column header

- add or remove a custom property by right-clicking the column header

- save the columns’ name and rules for next use

-----------------------------------------------------------------------

Message was edited on the 28/02/2019 - Version 0.2:

- Add support for Cut List Items Custom Properties

- Add support for Drawings Custom Properties

- Update Custom Properties writing function

- Fix some bugs

- Add help file

Message was edited on the 02/03/2019 - Version 0.21:

- Add options to remove all columns after selected column

- Fix some bugs

Message was edited on the 04/07/2019 - Version 0.22:

- Fix crash during columns loading

Message was edited on the 07/07/2019 - Version 0.23:

- Add option to only show saved columns

- Fix crash during refresh if a column was sorted

Message was edited on the 08/07/2019 - Version 0.24:

- Use Ookii.Dialogs.dll for Browse dialog

- Add menu to apply the rule of each columns

Message was edited on the 18/10/2019 - Version 0.25:

- Add Slow mode that uses SolidWorks instead of SolidWorks Document Manager library

- Add a button to load all the files of an assembly

- Replaced Ookii.Dialogs.dll by an integrated custom dialog

- Add rule to replace part of the Custom Properties text by another (use: <Replace(oldText,newText)>)

Message was edited on the 29/10/2019 - Version 0.26:

- Fix bug in the Replace rule function that prevented custom properties to be created.

Message was edited on the 13/11/2019 - Version 0.27:

- Match parts custom property name and column name with Case insensitive

Message was edited on the 16/11/2019 - Version 0.28:

- Fix bug where some custom properties couldn't be updated if the rows where re-ordered

- Fix bug where pasting in multiple columns wouldn't work if the columns where re-ordered

Message was edited on the 23/01/2020 - Version 0.29:

- Add text box to highlight rows

- Add buttons to export/import a spreadsheet

- Add option to delete all properties except the saved ones

- Add option to create blank saved properties

Attachments

BatchCustomProp029.zip912.9 KB
Batch Custom Properties - Help.pdf267.5 KB

Outcomes

Deepak Gupta Feb 23, 2019 12:18 PM

Fifi Riri wrote:

Here is a stand-alone application to display and edit the custom properties and configuration custom properties of a list of files.

It uses SolidWorks Document Manager library to avoid opening each files and speeding up the process.

Thank a lot Fifi for sharing the tool and codes

Actions

Fifi Riri @ Deepak Gupta on Feb 25, 2019 3:06 AM

No problem.

Have you had time to test it? I would love to read your comments.

I'm open to suggestion to improve it.

Actions

John Stoltzfus Feb 25, 2019 6:41 AM

Fifi Riri

I can't open the rar files? Can you upload in a different format??

Actions

Robert Conklin Feb 25, 2019 10:28 AM

Fifi Riri Thank You. Very Nice!

Am looking forward for your improvements. And an expanded help file.

Actions

Fifi Riri @ Robert Conklin on Feb 25, 2019 11:34 AM

Thank you for the feedback.

I will try to do an help file.

Right now I'm working on incorporating the cut list items custom prop

Actions

Fifi Riri @ Robert Conklin on Feb 27, 2019 3:26 PM

Help file added with the new version 0.2 in the top post. Enjoy.

Actions

Robert Conklin @ Fifi Riri on Feb 27, 2019 4:33 PM

Again

Fifi Riri Thank You. Very Nice!

Actions

M. Dimmers Apr 30, 2019 5:38 AM

Fifi,

Looks great, it is just what we need,

Got a problem though, it seems to work but nothing shows.

When i open the Log.txt file this is what I see:

Document Manager API Error. Probable causes: - invalid license number - project not compiled for x64 CPU

Now I've tried changing the License Number but than i get a pop-up screen saying it ain't right. So could it be it's not compiled for x64?

TIA

Richard

Actions

Robert Conklin @ M. Dimmers on Apr 30, 2019 11:53 AM

Just to let all know.

Yesterday I just got a new Lic Man Key from Solidworks for my recently up graded Solidworks product.

I moved up to 2018 SP5 from 2017 SP5

All running on a 64bit CPU & i7 system and the

"Batch CustomProperties V0.21" program runs just fine, No problem.

Actions

Christian Chu Apr 30, 2019 12:11 PM

Thanks for sharing - it's awesome !!!

Actions

Tom Strohscher May 29, 2019 8:00 AM

I broke your program.

I started to look at some records and changed a couple of descriptions.

I think I moved a column when it crashed.

It did not change any of my data.

When I open the application and click on the search button I get this error.

Log attached.

Attachments

Log.txt.zip143 bytes

Actions

Tom Strohscher @ Tom Strohscher on May 29, 2019 8:04 AM

I corrected my problem by not reloading the saved columns

Actions

Fifi Riri @ Tom Strohscher on May 29, 2019 8:35 AM

Glad you could find a work around.

If you got the problem again, please send me the user.config file, it should be in:

C:\Users\<username>\AppData\Local\Microsoft\BatchCustomProp.exe_Url\

and I will see what I can do.

Actions

Wesley Shafer @ Fifi Riri on Jul 3, 2019 1:21 PM

Thanks for the program Fifi Riri

I ran into the same issue as Tom Strohscher above. Anytime I refresh an error as occurred. Then again I may not be setting the program up correctly. I have the headings I want.

I just can't figure out how to change the custom properties of those headings. For instance I want to change the Customer name and order number of those three parts I'm testing. Our typical project is 500 - 1500 parts to propagate.

Thanks again

Actions

Fifi Riri @ Wesley Shafer on Jul 3, 2019 1:35 PM

Could you attach a test file where this problem occurs.

Actions

Wesley Shafer @ Fifi Riri on Jul 3, 2019 1:49 PM

Fifi Riri

Here is what I changed

Here is the error

Files attached

Thanks again

Actions

Wesley Shafer @ Fifi Riri on Jul 3, 2019 1:53 PM

Fifi Riri

Here is what I changed

Here is the error

Files attached

edit: It wouldn't allow me to upload the user file

Thanks again

Attachments

150-VA001199-3001.SLDPRT.zip192.7 KB
Log.txt.zip816 bytes

Actions

Fifi Riri @ Wesley Shafer on Jul 3, 2019 2:32 PM

I can't reproduce the error:

I can update the customer property both by editing the individual cell or by applying the rule on the column.

When does the error occurs for you?

Maybe there is an error because of the columns reordering, try it again without reordering.

Actions

Wesley Shafer @ Fifi Riri on Jul 3, 2019 2:40 PM

Maybe that is where I'm confused. I'm not sure I'm using it correctly. What do you mean without reordering? I added the custom properties we use. Can you screenshot what you changed?

Every time I click refresh the Weight and a second Item_Number column appears the Type row above date goes back to text. I typically delete those because we don't need that.

I guess my question is what/where needs to be changed for the custom properties to propagate to all the files loaded?

Thanks again

Actions

Fifi Riri @ Wesley Shafer on Jul 3, 2019 2:50 PM

First keep it simple: don't delete the columns.

Then to apply the same name to all files: Enter "test" in the rule row of the "customer" column, then right-click the column and select apply.

if that doesn't work: try to replace the customer name in each individual cells of the column

Actions

Fifi Riri @ Wesley Shafer on Jul 3, 2019 2:54 PM

Also: check if the files are not in read only and try to run the program as administrator

Actions

Wesley Shafer @ Fifi Riri on Jul 3, 2019 3:01 PM

For some reason I was thinking that all the properties would change at once. Once I clicked apply to each column they changed like they should

Is there a way to save all the rules? Many of the fields are repeatable like Drawn_By. Or is that something you just fill out each time?

Thank you again for the help.

Actions

Fifi Riri @ Wesley Shafer on Jul 3, 2019 3:12 PM

Wait it works now? so how did you get the error?

To save the rules click on Option > Save current columns

Actions

68 Replies

1 2 3FirstPrevious

Deepak Gupta Feb 23, 2019 12:18 PM
Fifi Riri wrote:

Here is a stand-alone application to display and edit the custom properties and configuration custom properties of a list of files.

It uses SolidWorks Document Manager library to avoid opening each files and speeding up the process.

Thank a lot Fifi for sharing the tool and codes
Like • Show 3 Likes3
Actions
Fifi Riri @ Deepak Gupta on Feb 25, 2019 3:06 AM
No problem.
Have you had time to test it? I would love to read your comments.
I'm open to suggestion to improve it.
Like • Show 3 Likes3
Actions
John Stoltzfus Feb 25, 2019 6:41 AM
Fifi Riri

I can't open the rar files? Can you upload in a different format??
Like • Show 3 Likes3
Actions
Ruben Balderrama @ John Stoltzfus on Feb 25, 2019 6:57 AM
Done
Attachments
- BatchCustomProp - Program.zip22.0 KB
- BatchCustomProp - Sources.zip105.6 KB
Like • Show 5 Likes5
Actions
John Stoltzfus @ Ruben Balderrama on Feb 25, 2019 7:17 AM
Ruben Balderrama - Thank you
Like • Show 4 Likes4
Actions
Robert Conklin Feb 25, 2019 10:28 AM
Fifi Riri Thank You. Very Nice!
Am looking forward for your improvements. And an expanded help file.
Like • Show 5 Likes5
Actions
Fifi Riri @ Robert Conklin on Feb 25, 2019 11:34 AM
Thank you for the feedback.
I will try to do an help file.
Right now I'm working on incorporating the cut list items custom prop
Like • Show 4 Likes4
Actions
Fifi Riri @ Robert Conklin on Feb 27, 2019 3:26 PM
Help file added with the new version 0.2 in the top post. Enjoy.
Like • Show 5 Likes5
Actions
Robert Conklin @ Fifi Riri on Feb 27, 2019 4:33 PM
Again
Fifi Riri Thank You. Very Nice!
Like • Show 3 Likes3
Actions
M. Dimmers Apr 30, 2019 5:38 AM
Fifi,
Looks great, it is just what we need,
Got a problem though, it seems to work but nothing shows.
When i open the Log.txt file this is what I see:
Document Manager API Error. Probable causes: - invalid license number - project not compiled for x64 CPU
Now I've tried changing the License Number but than i get a pop-up screen saying it ain't right. So could it be it's not compiled for x64?
TIA
Richard
Like • Show 2 Likes2
Actions
Robert Conklin @ M. Dimmers on Apr 30, 2019 11:53 AM
Just to let all know.
Yesterday I just got a new Lic Man Key from Solidworks for my recently up graded Solidworks product.
I moved up to 2018 SP5 from 2017 SP5
All running on a 64bit CPU & i7 system and the
"Batch CustomProperties V0.21" program runs just fine, No problem.
Like • Show 3 Likes3
Actions
Christian Chu Apr 30, 2019 12:11 PM
Thanks for sharing - it's awesome !!!
Like • Show 6 Likes6
Actions
Tom Strohscher May 29, 2019 8:00 AM
I broke your program.
I started to look at some records and changed a couple of descriptions.
I think I moved a column when it crashed.
It did not change any of my data.
When I open the application and click on the search button I get this error.
Log attached.
Attachments
- Log.txt.zip143 bytes
Like • Show 1 Like1
Actions
Tom Strohscher @ Tom Strohscher on May 29, 2019 8:04 AM
I corrected my problem by not reloading the saved columns
Like • Show 4 Likes4
Actions
Fifi Riri @ Tom Strohscher on May 29, 2019 8:35 AM
Glad you could find a work around.
If you got the problem again, please send me the user.config file, it should be in:
C:\Users\<username>\AppData\Local\Microsoft\BatchCustomProp.exe_Url\
and I will see what I can do.
Like • Show 3 Likes3
Actions
Wesley Shafer @ Fifi Riri on Jul 3, 2019 1:21 PM
Thanks for the program Fifi Riri

I ran into the same issue as Tom Strohscher above. Anytime I refresh an error as occurred. Then again I may not be setting the program up correctly. I have the headings I want.

I just can't figure out how to change the custom properties of those headings. For instance I want to change the Customer name and order number of those three parts I'm testing. Our typical project is 500 - 1500 parts to propagate.
Thanks again
Like • Show 1 Like1
Actions
Fifi Riri @ Wesley Shafer on Jul 3, 2019 1:35 PM
Could you attach a test file where this problem occurs.
Like • Show 1 Like1
Actions
Wesley Shafer @ Fifi Riri on Jul 3, 2019 1:49 PM
Fifi Riri

Here is what I changed

Here is the error

Files attached

Thanks again
Like • Show 0 Likes0
Actions
Wesley Shafer @ Fifi Riri on Jul 3, 2019 1:53 PM
Fifi Riri

Here is what I changed

Here is the error

Files attached

edit: It wouldn't allow me to upload the user file

Thanks again
Attachments
- 150-VA001199-3001.SLDPRT.zip192.7 KB
- Log.txt.zip816 bytes
Like • Show 0 Likes0
Actions
Fifi Riri @ Wesley Shafer on Jul 3, 2019 2:32 PM
I can't reproduce the error:
I can update the customer property both by editing the individual cell or by applying the rule on the column.
When does the error occurs for you?
Maybe there is an error because of the columns reordering, try it again without reordering.
Like • Show 1 Like1
Actions
Wesley Shafer @ Fifi Riri on Jul 3, 2019 2:40 PM
Maybe that is where I'm confused. I'm not sure I'm using it correctly. What do you mean without reordering? I added the custom properties we use. Can you screenshot what you changed?

Every time I click refresh the Weight and a second Item_Number column appears the Type row above date goes back to text. I typically delete those because we don't need that.

I guess my question is what/where needs to be changed for the custom properties to propagate to all the files loaded?

Thanks again
Like • Show 1 Like1
Actions
Fifi Riri @ Wesley Shafer on Jul 3, 2019 2:50 PM
First keep it simple: don't delete the columns.
Then to apply the same name to all files: Enter "test" in the rule row of the "customer" column, then right-click the column and select apply.

if that doesn't work: try to replace the customer name in each individual cells of the column
Like • Show 1 Like1
Actions
Fifi Riri @ Wesley Shafer on Jul 3, 2019 2:54 PM
Also: check if the files are not in read only and try to run the program as administrator
Like • Show 0 Likes0
Actions
Wesley Shafer @ Fifi Riri on Jul 3, 2019 3:01 PM
For some reason I was thinking that all the properties would change at once. Once I clicked apply to each column they changed like they should

Is there a way to save all the rules? Many of the fields are repeatable like Drawn_By. Or is that something you just fill out each time?

Thank you again for the help.
Like • Show 0 Likes0
Actions
Fifi Riri @ Wesley Shafer on Jul 3, 2019 3:12 PM
Wait it works now? so how did you get the error?

To save the rules click on Option > Save current columns
Like • Show 0 Likes0
Actions

Batch Custom Properties Program

Attachments

Outcomes

Attachments

Attachments

Attachments

Related Content

Recommended Content

Incoming Links