AStein Posted April 4, 2021 Share Posted April 4, 2021 Hey guys I'm trying to make a layout datum in excel (basically X/Y columns in feet and whole inches) which used to be a very simple affair. Hoist report --> copy paste to excel and bob's your uncle. Now it looks like the hoist report function has been deleted in 2021?! OK, so I created a report for objects with a hoist record and that worked. But now when I copy paste to excel it pastes, not in feet and inches, but as a decimal string. It's displaying correctly in worksheets, but copy-pastes as a decimal in excel and google sheets. Very frustrating. Bonus topic: Am I missing something with the 2021 hoist stuff in general? It seems worse. More steps, less options, It lags my very fast system, which never happened with hoist in 2020 and there's some OIP stuff missing that I used to use. What's going on here? Quote Link to comment
Pat Stanford Posted April 5, 2021 Share Posted April 5, 2021 I don't have a good workaround for you. I believe that in VW2020, the data from the hoist object was a string while in VW2021 the value is being returned as a number. VW knows how to display that number as Feet & Inches but when you transfer it to Excel, Excel does not. It looks like there is a formatted text version of the origin fields. Try using these instead of the formulas you are currently using. 'BrxHoist'.'OriginX_formated' 'BrxHoist'.'OriginY_formated' HTH. Quote Link to comment
AStein Posted April 6, 2021 Author Share Posted April 6, 2021 Thanks Pat. I couldn't get that to work the way I wanted, but I did find a workaround that might be a little more friendly to people like me (Knuckle-dragging riggers). I'll detail it here in case someone else runs into this issue. Also I appreciate your time. I see you solving problems all over this forum! Make a backup file in case you're polluting other departments with our whole inch "precision" First: File --> Document Settings --> Units "Decimal Precision" Dropdown menu: select "1" Hit "OK" Next: Spotlight --> Reports --> Create report Objects with Hoist record Add: "Origin X(formatted)" and "Origin Y(formatted)" Click on one of your adds and then click "Format Field" "Number Format" dropdown menu: Select "Text" Do this for both adds Now you can copy-paste into excel It's a pretty quick fix but damn... Quote Link to comment
Vectorworks, Inc Employee jcogdell Posted April 6, 2021 Vectorworks, Inc Employee Share Posted April 6, 2021 @AStein Have you tried the new export excel worksheet option instead of copy and pasting? the Export Worksheet command is in the worksheets file menu, it will export your worksheet without you needing to change the fields format to text. Quote Link to comment
AStein Posted May 11, 2021 Author Share Posted May 11, 2021 @jcogdell I have, thank you. Formatting the VW sheet as a text string rather than an actual number seems to be the ticket. I really hope VW is talking to someone about the new hoist tool. Most people in my circle have abandoned it and installed the legacy hoist tool as a workaround. 1 Quote Link to comment
Projx_CA Posted August 5, 2021 Share Posted August 5, 2021 On 5/11/2021 at 8:25 AM, AStein said: I really hope VW is talking to someone about the new hoist tool. Most people in my circle have abandoned it and installed the legacy hoist tool as a workaround. Finally getting back to Vectorworks after a pandemic hiatus, and I fully agree with this statement. Really shouldn't have to write or modify VectorSctpts to restore what was a well functioning tool. Quote Link to comment
RRATHOR Posted November 14, 2022 Share Posted November 14, 2022 Hey gents, had this exact same issue. And yes, as a 6 year member of service select, for use with rigging and Braceworks license holder (in other words I’ve spent a lot of money with VW and used it a lot) I share the grievances with the new work flows of the new hoist tool. Seems the integration department is lacking on real world knowledge of what a “professional production rigger” does and how we actually use the program, because normal flow operations have become increasingly difficult, and my team has either defaulted to using the legacy hoists as well, or adding a ton of custom data tags and reports to be able to get a return on our information or properly display our data to other departments and ourselves. Okay the fix we found for this- In the worksheet window, File>export worksheet change the format to csv this gets feet and inch dimensions as an export. ***** We tried everything involving changing the format of the cells to text etc but somehow the data inside the worksheet is in decimal form and converts only in the display. The csv file fixed it for us. 1 Quote Link to comment
Vectorworks, Inc Employee jcogdell Posted November 15, 2022 Vectorworks, Inc Employee Share Posted November 15, 2022 I just tested this using 2023, using the Hoist report command and the worksheet export excel function, and as long as you change your document units to feet and inches with no fractions or decimal places before creating the report it will display correctly in Excel top image is the Spotlight hoist report and bottom is the Excel sheet that was exported using the worksheets export to excel command 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.