t-bud Posted September 17, 2020 Share Posted September 17, 2020 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 Quote Link to comment
Vectorworks, Inc Employee Conrad Preen Posted September 17, 2020 Vectorworks, Inc Employee Share Posted September 17, 2020 Is there any way you could give me a rough sketch of what you want? Conrad Quote Link to comment
t-bud Posted September 17, 2020 Author Share Posted September 17, 2020 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. Quote Link to comment
Vectorworks, Inc Employee Conrad Preen Posted September 17, 2020 Vectorworks, Inc Employee Share Posted September 17, 2020 Sounds a bit like a Circuit report with the columns re-arranged and sorted differently. Let's both have a go at it and see if we can get what you want. I'll send you something to look at in the next day or two. Conrad Quote Link to comment
julian_e Posted September 30, 2020 Share Posted September 30, 2020 Hi There, i am looking for the same thing. Are there any news ? regads Julian Quote Link to comment
t-bud Posted January 19, 2021 Author Share Posted January 19, 2021 Conrad, Have not been successful with this report. Have you had any luck? Quote Link to comment
Vectorworks, Inc Employee Conrad Preen Posted January 20, 2021 Vectorworks, Inc Employee Share Posted January 20, 2021 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 1 Quote Link to comment
scobb Posted December 16, 2024 Share Posted December 16, 2024 Any updates on this? I'd like to do this was well. We would like to include make and model on cable pull reports. Quote Link to comment
scobb Posted December 17, 2024 Share Posted December 17, 2024 @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')) 2 Quote Link to comment
Recommended Posts
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.