J. Miller

I was afraid you were going to say that. I need to write a comma based text export so that a rental inventory database program can read all the elements from the VectorWorks file. I can only write (2) fields (quantity & ItemID) to this file. I am working with many types of symbols including Spotlight items. Most of the symbols have 1 data field, but many require multiple fields. Spotlight instruments will need multiple fields (body type, lens type, bulb type, etc). Other objects required a part number & a group of associated hardware. I'm wondering if it would be possible to have one record with multiple fields (qty-1, id-1, qty-2, id-2, etc) that i can attach that would write only (2) fields of output to satisfy the Database requirements. Sounds like a Vectorscript (that would need to be user updated) to me. Any thoughts? I'm ok with scripts & worksheets just looking for a guru to steer me in the right direction before I pull all of my hair out going down the wrong path. I guess some would say that's the fun of VS. Jeff

I have a group of Record formats (R2Q-1, R2Q-2, etc), all with the same field information (qty, Part Name) The symbol set i am working with needs more than one record attached to them ex (RQ-1 = (1) Bolt type, RQ-2 = (2)Washers, R2Q-3 = (1) Nut Type). I would like to create a worksheet that will list all of the Records attached (Column 1'R2Q-1 thru 'R2Q-x'.'qty', Column 2 'R2Q-1'.'name' thru 'R2Q-x'.'name', etc) in the same works sheet to get the total count of all parts associated with the symbol. What is the proper syntax to make this column work? Is this even possible? TIA, Jeff Miller

I wound up using ForEachObjetcInList as Kevin mentioned. It seems to work fine... so far. Thanks, Jeff

Hey Matt, I'm working on the same situation right now. What did you come up with. I also need to add rather a certain record is also attached to that symbol definition TIA Jeff Miller

Hello, Is anyone currently using the R2 Inventory software? Has anyone successfully accessed it through Vectorworks? I would be interested in hearing how complex this is, and the pros & cons of it all? Jeff

I have a set of symbols that use a record. Is there a way to interactively link this list worksheet of symbols to a file that can be edited in Excel and the updated in Vectorworks. I am not familiar with ODBC nor do I own any database management software. i am hoping to keep this simple. Any help or pointers would be appreciated. Jeff

That seemed to work. removing the broken menu items, saving the workspace, and re-editing the workspace did not work. I even closed and re-opened VW between edits. I had to use a different workspace and re-edit from there. Seems weird. Thanks for your help. Jeff

Using the "Spotlight" workspace it works fine. I am using a custom Workspace. Odd?? Jeff

I realize that. When I right click on a lighting instrument and click the "Focus Instrument" in the menu, Nothing happens. No dialog box opens showing the focus points to select for the lightning device. Jeff

Just in 2d right now. I can focus the instrument by setting the OIP "focus" Field. It responds just fine. Its the right click action that does nothing. The dialog box to select a focus position doesn't open or run. Jeff

I am trying to use the right click tool "Focus Instruments". It does nothing now. It used to work, not sure if its a SP2 problem or not. I am using a clean document and default VW Symbols. "Focus at next Click" also doesn't work. I can select a focus point and right click to select fixtures associated with the focus point. Anyone else having this problem with VW2014 SP2? TIA Jeff Miller

Thanks for all the input. I give this a shot. Providing an offset parameter is another way, its just not as robust. Jeff

so when or where in the script can i determine the existing difference between the two Control points (prior to the user move)so that I can store this information in a field for later use vsoStateGetParamChng( objectHan , widgID, paramIndex ,oldValue) returns an "unknown" when a control Point is moved. Jeff

I want to move another control point if the control point in question is moved by the user. (Similar to a dimension, moving the text in relation to the dimension line, but allowing the user to place text where they want it. So it (the text) would have to change each time the user moves the control point (dimension line) in question. I need to determine the offset distance between the two control points prior to movement and relocate the second control point (the text) after the movement based on the original offset distance. I am hoping the vsoStateGetParamChng function will work for me. Jeff

Hello, I am trying to determine if a user has moved a certain Control point. When would I collect the original position location of the control point (prior to user movement) and where would I collect the new position of the control point (after the user has moved it). this is an event enabled PIO. Thanks, Jeff Miller

Pardon my ignorance. This is my 1st attempt with a 3D path object and the double click edit mode. Where would one place the setPolyPt3D() call to actually move the user placed position to a position I want it to be at, So that when the pio is double click again the points display the actual current position of the pio and not the positions that the user clicked? Is there an example floating around that I could get a look at? Jeff

I can get it to draw correctly, but is there a way to re-set the poly point vertex of the pio to the end result of the pio? If the user double clicks on the object again the edit points are shown at the begining and end of the path pio. Jeff

you could try "closepoly:" prior to creating the poly. That has helped me sometimes Jeff

Hello, I am attempting to update / edit a custom 3D path in an event enabled PIO. I have allowed the user to have access to edit the path thru a double click on the PIO. When the user is done with the edit, I need to make sure the new path is correct and make adjustments to it. I am using BeginPoly3D; Add3DPt(p1.x , p1.y , p1.z); Add3DPt(p1.x , p2.y , p2.z); EndPoly3D; newPathHan := LNewobj; boo:= SetCustomObjectPath(pathhan, newPathHan); message('New Path ', boo); {p1.x twice is correct, i need to keep the "X" position the same in both points} but it fails. Is there a particular place in the PIO i need to place this so that it will actually reset the path PIO points? Thanks, Jeff Miller

Thanks for all the Information! Jeff

"Visual basic seems to work on Mac Excel 2011. I run Parallels for the times I absolutely need windows, which is pretty rare. It allows you to run windows software and mac software at the same time" So is this a Mac machine you are starting with or a PC? Kind of a newbie to the other side. What machine are you using? I am using a handful of excel VBA files for business use. If its a Mac what are the base parameters I should look for for a new purchase? Jeff

would be nice to see x64 bit version Jeff

So I am considering moving from PC to Mac. What things should I look for in buying a desktop from Apple? I still need to use the Microsoft Office Applications though. Does Excel for Mac support Visual Basic again? Should I consider a dual boot machine? Will my copy of Vector Works work on a Mac? I am a preferred Subscriber. Granted I will have to download the new software, but will my license allow me to do that? TIA Jeff Miller

Thanks for the reply. If only it had been that easy, but it didn't work. I guess plan B will be to add a refresh button to the pio Jeff

I don't know how many times i have done a quick click on a tool bar only to have it pull itself out of docking mode. Sure would be nice to have an option to "lock tool positions" once the user is happy with the placement. Of course this can always be unlocked too. Jeff Miller