AnsweredAssumed Answered

Macro: Add a custom property & link it to a current custom property

Question asked by Cad Admin on Sep 22, 2016
Latest reply on Sep 22, 2016 by Christian Chu

Like • Show 0 Likes0
Comment • 9

I have a assembly package i need to add/update some variables...

Generally i would run a macro to add the variables using...

AddCustProp "---", swCustomInfoType_e.swCustomInfoText, "---"

But now i want to link a new variable to an existing one.

Example. My current variable is "DRAWNBY", my new end customer is "NAME OF DESIGNER". I want to link their "NAME OF DESIGNER" variable to my original "DRAWNBY" variable.

Manually in the property manager i can just add $PRP:"DRAWNBY" & it works, but not in the macro.

Whats can i do it through this method, what would be a way to accomplish it...did i miss anything?

Cad Admin Sep 22, 2016 11:40 AM

Correct Answer

Figured it out

AddCustProp "NAME OF DESIGNER", swCustomInfoType_e.swCustomInfoText, (Chr(36) & "PRP" & Chr(58) & Chr(34) & "DRAWNBY" & Chr(34))

See the reply in context

No one else had this question

Outcomes

JOHN GEORGE Sep 22, 2016 10:23 AM

Look at this discussion and you can modify to match your needs

Hope this helps

Actions

Cad Admin @ JOHN GEORGE on Sep 22, 2016 10:37 AM

John,

I have no problem adding predefined custom properties. My issue is the "value/text expression" for a new property i want to equal an already existing one. Manually within the model i would generally input the new variable value of $PRP:"old value" and it worked fine.

Now I'm trying to do the same thing through a macro (have about 16 properties to link) and the macro doesn't like the "$PRP:"old value" in the code.

Actions

John Stoltzfus @ Cad Admin on Sep 22, 2016 10:54 AM

The macro reads all your current custom properties if you want it to or just the ones you need to change and compiles it in an excel file in the search columns you specified, then you could add the "New" custom property in a new column and do the =D2..... once the new custom property is listed in the excel file you can force write it back to the part or assembly...

Actions

JOHN GEORGE @ Cad Admin on Sep 22, 2016 11:42 AM

I am not sure about "$PRP:DRAWNBY"

If you want to get that property, that should have given with a value

In your case, you are trying to just replace only the property name, not the value (if I am correct)

You can modify that code from Ioannis Skarlatakis and should work, I think

Actions

Cad Admin @ JOHN GEORGE on Sep 22, 2016 11:49 AM

John,

I've used the excel from Ioannis Skarlatakis before. Works great. My application i have a set of drawings that are already done. My sales guy informed me that the deliverable to our NEW customer is that it be on their forms and populate their titleblocks and so on. My best solution is to Batch swap out the forms and run a macro to create the defined variables and link them to our original ones. I don't want to replace ours as our design is sold to MANY customers.

As always thanks for the help and solutions...

Actions

John Stoltzfus Sep 22, 2016 10:26 AM

Try the attached macro written by Markku Lehtola - it is an Excel file so you should easily be able to add a column and write it back to the files that you want to change....

Attachments

SW_Import_Export Properties-Default.xls239.5 KB

Actions

Christian Chu Sep 22, 2016 10:53 AM

Seems like there is a syntax error in your code (double quote) for drawnby

Actions

Cad Admin Sep 22, 2016 11:40 AM

Figured it out

AddCustProp "NAME OF DESIGNER", swCustomInfoType_e.swCustomInfoText, (Chr(36) & "PRP" & Chr(58) & Chr(34) & "DRAWNBY" & Chr(34))

Actions

Christian Chu @ Cad Admin on Sep 22, 2016 11:57 AM

Bingo !

Actions

9 Replies

JOHN GEORGE Sep 22, 2016 10:23 AM
Mark Correct
Correct Answer
Look at this discussion and you can modify to match your needs
Hope this helps
Like • Show 1 Like1
Actions
- Cad Admin @ JOHN GEORGE on Sep 22, 2016 10:37 AM
  Mark Correct
  Correct Answer
  John,
  I have no problem adding predefined custom properties. My issue is the "value/text expression" for a new property i want to equal an already existing one. Manually within the model i would generally input the new variable value of $PRP:"old value" and it worked fine.
  
  Now I'm trying to do the same thing through a macro (have about 16 properties to link) and the macro doesn't like the "$PRP:"old value" in the code.
  Like • Show 1 Like1
  Actions
  - John Stoltzfus @ Cad Admin on Sep 22, 2016 10:54 AM
    Mark Correct
    Correct Answer
    The macro reads all your current custom properties if you want it to or just the ones you need to change and compiles it in an excel file in the search columns you specified, then you could add the "New" custom property in a new column and do the =D2..... once the new custom property is listed in the excel file you can force write it back to the part or assembly...
    Like • Show 0 Likes0
    Actions
  - JOHN GEORGE @ Cad Admin on Sep 22, 2016 11:42 AM
    Mark Correct
    Correct Answer
    I am not sure about "$PRP:DRAWNBY"
    If you want to get that property, that should have given with a value
    In your case, you are trying to just replace only the property name, not the value (if I am correct)
    You can modify that code from Ioannis Skarlatakis and should work, I think
    Like • Show 1 Like1
    Actions
    - Cad Admin @ JOHN GEORGE on Sep 22, 2016 11:49 AM
      Mark Correct
      Correct Answer
      John,
      
      I've used the excel from Ioannis Skarlatakis before. Works great. My application i have a set of drawings that are already done. My sales guy informed me that the deliverable to our NEW customer is that it be on their forms and populate their titleblocks and so on. My best solution is to Batch swap out the forms and run a macro to create the defined variables and link them to our original ones. I don't want to replace ours as our design is sold to MANY customers.
      
      As always thanks for the help and solutions...
      Like • Show 1 Like1
      Actions
John Stoltzfus Sep 22, 2016 10:26 AM
Mark Correct
Correct Answer
Try the attached macro written by Markku Lehtola - it is an Excel file so you should easily be able to add a column and write it back to the files that you want to change....
Attachments
- SW_Import_Export Properties-Default.xls239.5 KB
Like • Show 1 Like1
Actions
Christian Chu Sep 22, 2016 10:53 AM
Mark Correct
Correct Answer
Seems like there is a syntax error in your code (double quote) for drawnby
Like • Show 1 Like1
Actions
Cad Admin Sep 22, 2016 11:40 AM
Unmark Correct
Correct Answer
Figured it out

AddCustProp "NAME OF DESIGNER", swCustomInfoType_e.swCustomInfoText, (Chr(36) & "PRP" & Chr(58) & Chr(34) & "DRAWNBY" & Chr(34))
Like • Show 2 Likes2
Actions
- Christian Chu @ Cad Admin on Sep 22, 2016 11:57 AM
  Mark Correct
  Correct Answer
  Bingo !
  Like • Show 3 Likes3
  Actions

Macro: Add a custom property & link it to a current custom property

Outcomes

Attachments

Related Content

Recommended Content