Jump to content

Get actual amount of Symbols in Record Field


Bogdan Ciocan

Recommended Posts

Hello,

 

with new Worksheet Functions in VW 2022 i hoped to extract the actual amount of Objects, in may case Symbols from a project, in a record field, but not necessarily.

What I'm trying to do is to write these amounts back to an excel worksheet via ODBC.

Has anyone done this before or do you have any idea on how i could do this?

 

Thank you,

Best regards

Bogdan

Link to comment

I don't think you need any of the new functions to do this. =Count should be able to do what you want.

 

=COUNT(((T=SYMBOL))). Will return the total number of symbols placed in the drawing area of the file.

 

=COUNT(((S='Symbol-1'))) Will return the number of symbols named 'Symbol-1'

 

I don't have any idea about doing the OBDC export. If you are on Mac, I am not sure the OBDC of Mac Excel works with VW. You might be able to use the Data Manager to store the values into a record attached to a proxy object (maybe a locus on a layer reserved for this purpose) with a record attached that could update the OBDC file.

Link to comment

Hi @Pat Stanford,

 

the reason is to compare the used Symbols ( in our case Materials ) from a Project with the available amount within a specific period of time from our warehouse.

But I'm not able to send the actual count of Symbols to Excel, other then data form record format.

I know that the values form record format are defaults, but at the moment i don't see another way.

 

image.thumb.png.a428cdb037eba4948262e57c621a4ec5.png

image.png.745d673bbf7c8344638e553a8d2ef017.pngimage.png.6f5b380262eb489a6fcd6b751574e0fc.png

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...