Jump to content

Socket report by device


t-bud

Recommended Posts

Is there a way to create a report that will list all devices, and what is connected to each socket of that Device?  

 

I know I can do a Circuit report sorted by Source Device, but I would like a way to be able to get over information from the Device that is not included in the Circuit Record.

 

Or maybe a way to map information from source devices into user fields in Circuit record

Link to comment

Looking to create a report that would show each device, listing each socket in the device(connected or not), and if there is a connection, information from the circuit that is connected to the socket.

 

Below is an illustration of report columns.

 

Device.name | Device.model | socket.name | socket.signal | circuit.number | circuit.cable | circuit.cable length

 

Does that make sense?

 

What I am trying to do is create a report that will allow me to quickly see what is connected to each device, where ports may be available, and create panel labels listing what is connected to each socket.

Link to comment
  • 2 weeks later...
  • 3 months later...
  • Vectorworks, Inc Employee

What we are asking for here is to link up data from more than one table.  In SQL this is called a JOIN. Vectorworks can't do a JOIN right now.

 

I agree completely that reports like these would be very useful. I will make a bid for this, but I also want it done right. So please be patient. It will happen. The more voices are heard here asking for this the better.

 

Thanks everyone!

 

Conrad

  • Like 1
Link to comment
  • 3 years later...

@t-bud Found the solution for our scenario. In the cable pull report, you can add a new column and insert a custom function. Then use the OBJECTDATA function to get whatever field you want from either the source or destination device. The format is like this: =OBJECTDATA('eval circuit source device', 'Device', 'fieldname')

 

For example, if you want to put together the make and model into one cell for the source and another cell for the destination, you would use the following code for the source:

=CONCAT(OBJECTDATA('eval circuit source device', 'Device', 'make'), ' ', OBJECTDATA('eval circuit source device', 'Device', 'model'))

 

and the following code for destination:

=CONCAT(OBJECTDATA('eval circuit destination device', 'Device', 'make'), ' ', OBJECTDATA('eval circuit destination device', 'Device', 'model'))

  • Like 2
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...