Jump to content
Stuborg

Revealing hidden Record Formats

Recommended Posts

Hi guys & gals,

 

I would like to "reveal" the hidden record format associated with the Door Tool - so I can then connect the record format to a PageMaker database via ODBC (which in turn is connected to an Excel file that others on my network can access as it is dynamically updated by the file Im working on).

 

While I appreciate that the schedules can be generated within Vectorworks on worksheets, I want these to dynamically update the remote database (instead of copying to/from the worksheet overtime I make a change).

 

I have tried to find solutions here on the forum but cannot seem to find what I am looking for. I have not much experience with Vectorscript of Python (but suspect the answer lies there somewhere).

 

I did read that exporting the file as a script enables you to see how the door object is created (along with hidden record format parameters) and named within the resultant code (refer to screenshot attached) - but this is not much use to me.

 

Any suggestions?

Screen Shot 2018-05-16 at 16.59.08.png

Share this post


Link to post

The door record isn't hidden, and you should be able to access it as-is.  You can see all the fields when you run the Create Report command.

Share this post


Link to post

Hi Joshua,

 

Many thanks for your response - and yes I appreciate that the Door record can be accessed via the "Create Report" drop down. And this is fine if you want to generate a worksheet with the relevant data.

 

What I am seeking is an option where I can pair each data field to a corresponding data column in a database (as I used to be able to do when generating my own record formats - see screenshot attached) - it seems this connectivity is no longer possible when the PIO has a record format that is no longer accessible through the resource browser.

 

Perhaps I am missing something with the worksheet commands (i.e. linking worksheet cells dynamically to an external database through ODBC - but I have no clue how this can be done).

 

Any thoughts?

Screen Shot 2018-05-17 at 09.29.26.png

Share this post


Link to post

For plug-in objects, you need to access the connection interface through the database menus, not the Resource Manager.

 

Select Tools>Database>Record Format Connection…  There you will see a list of all the record formats in the drawing, just like the report dialog.  Editing a format here will raise the Edit Record Format dialog.

  • Like 1

Share this post


Link to post

Joshua,

 

Many thanks for your response. I see what you mean.

 

Seems I will need to dabble a bit with these options to get it working for me. I have worksheets and doors set up on a file already - so I'm guessing I'll need to map each database column to the record format field as usual - hopefully I won't need to start afresh and re-insert all doors.

 

Many thanks for your help. I'll post again once I figure it out.

  • Like 1

Share this post


Link to post

Right update time -

 

I have been playing with the Door Tool and have established a connection between its Record Format and the database using "Record Format Connection" as per Joshua's earlier suggestion. I can add or delete doors which get added to or removed from the database when I select the required checkboxes in "Connection Options" and have mapped any of the required fields to corresponding database records and that all seems great.

 

However....a few things:

 

1. When I have both check boxes ticked in "Connection Options" Vectorworks tells me that it will add a row to the database when I drop a new door into the drawing - thats all great. However the Door Tool requires two clicks to drop the door and determine its position and swing - so Vectorworks thinks you have now dropped a second door which adds two doors for the price of one into the database - not helpful.

 

2. When a door is dropped into a drawing then dragged into a wall - Vectorworks thinks you are deleting the door and a database row is subsequently removed from the database - again not helpful.

 

3. If I wish to create a database connection to a drawing with doors already set up and installed in walls - I do not see how I can populate a database based on the information already in the drawing (obviously I map the records I want to link to the database etc.) - but I cannot see where the current data exists - I would then like this data to link to the database and delete rows if I choose to delete doors etc.. - is this possible??

 

I'm probably not explaining very well. All of this was tested using a very basic file with a square plan wall tool and dropping a few doors into the drawing.

 

Any assistance on this would be great - we have a number of projects that would greatly benefit from this functionality and drawings that are already populated with doors generated by the Door Tool PIO - it would take far too long to delete each door and connect each one to the database.

 

Many thanks in advance!

Share this post


Link to post
On 5/24/2018 at 3:46 PM, Stuborg said:

2. When a door is dropped into a drawing then dragged into a wall - Vectorworks thinks you are deleting the door and a database row is subsequently removed from the database - again not helpful.

 

Any component that can be hosted into a wall is actually being duplicated inside while the original is removed. This sounds very unlogical but I don't know the reason behind it. That might be causing that row being removed.

Share this post


Link to post
Posted (edited)

Hi all,

 

Just returning to the above issue.

 

I am still encountering an issue where once the door tool is selected and dropped with one click into the drawing - Vectorworks adds a new database row (ODBC) for that door - thats all fine. However the door tool requires a second click to flip the door's location which results in a second row being added to the database.....not helpful.

 

Has anyone a workaround for this or any thoughts?

 

Thanks!

Edited by Stuborg

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×