Jump to content

Pat Stanford

Moderator
  • Posts

    12,530
  • Joined

  • Last visited

Everything posted by Pat Stanford

  1. To amplify on what Tom says, all data in a Worksheet Database Row has to live somewhere. That somewhere can be a Record.Field combination or as part of some calculation. You can't just type text into a Database cell that is not linked to something to store it. Databases are dynamic. When you add or subtract objects in the file the order of the objects in the database can change. So you must store the text in a Record.Field so it will be "connected" to the object and display on the proper row of the database as things change. You can either use the Plant User Fields, or you can create your own Custom Record and use a field in that for your notes. HTH
  2. If you create a database of Materials instead of Objects then you should be able to get the record data from the Materials. Worksheets are not really able to get information about Contained or Container objects (Parents or Children) directly. Only about the object specified directly by the criteria. The possible work around would be to use Worksheet Scripts to get the data.
  3. @Ryan Russell I wrote this up a few months ago for another user. It might be applicable to your question and @klinzey's comment about Python.
  4. The 12" Truss is using the VW standard of the bottom of the bottom chord being at the insertion point. The 16" truss is using the center of the truss as the insertion point. Edit the 16" Truss Symbol and move it up 8" and you will have a symbol that will work like the 12"
  5. There appears to be a problem with the VSEL criteria. In a worksheet the VSEL returns as TRUE for a selected object. Inside the Marionette it does not seem to return any items. Could you expand your criteria to be SEL & Type is Symbol and get it to do what you want? @Marissa Farrell Can you comment on using VSEL criteria inside a Marionette Menu Command?
  6. My guess is that you have the Update Viewports option selected in the Publish command. So it doesn't matter if you have already made bitmaps, the update of the viewports will still take as long. If the above is not the case, then it sounds like something else is wrong. and as Jeff says, without a file to look at it is all guesses.
  7. Or if you want them all in a single database you can get fancy. But then you will also have to use fancy IF formulas also. And you will lose the 2-way ability to change the object from the worksheet, but I think the VALUE command already does that. Here is the revised formula for Columns A and B. Col A =IF(Style.'Name'<>'', Style.'Name', SYMBOLNAME) Col B =IF(OBJECTTYPE=15, 1, VALUE(OBJECTDATA('INVENTORY PART PARAM', 'Curtain', 1, 5))) Col A shows the SoftGoods name there is one, if not, it shows the Symbol Name. Col B checks if the object is a symbol and if so it sets the count to 1 otherwise it uses the original formula. And I recommend that you dump this test file, or at least the worksheet you have been using. There is something really funky about the cell formatting that is causing problems.
  8. I don't think you can use the SEL or VSEL criteria and also use a Marionette object in the drawing. In order to run the Marionette, you have to select it. This means that you will not have anything else selected on the active Layer. SEL and VSEL could be used if you wanted to make a Marionette Menu Command, but as a tool they won't work.
  9. I know that worksheet functions work in Data Tags when surrounded like: #WS_SomeWorksheetFunction(XXXXX)# It can be more complicated than a single function so you can get two values and multiply them and return the value as a string or something similar. Or use nested IF functions if necessary. But between the #WS_ and the ending # all of the "terminology" must be worksheet terminalogy only. You can't mix Data Tag functions into the middle of a worksheet function. So you would have to use 'Record'.'Field' and not #'Record'#.#'Field'# I believe that WS functions can be used in other dynamic text locations as well, but they may be much less useful. The 1:1 relationship between a Data Tag and an object in the drawing basically acts the same as the 1:1 relationship in a Worksheet Database Subrow. This means that you can access the data associated with that specific object. Other object types that use Dynamic Text probably don't have the 1:1 relationship with an object so many of the WS functions will not operate properly. But that last paragraph is almost entirely a guess on my part. Or at least I can't remember the results of any tests I have run to prove it right or wrong.
  10. Another way to think about the Ternary (@ Colon) operators is: Display the stuff before the @ If the stuff in the middle evaluates to false then display the stuff after the colon.
  11. @Stephen Smart Please make sure you send the file to VW Tech Support as a bug so it can get logged and potentially fixed in the future.
  12. What you want to do does not match up well with what I understand is the VW licensing policy. The simplest, but most expensive, option would be to purchase an additional license for each of the laptops. The better option would be to contact VW customer support or technical support directly and see what they suggest. The forum is for user to user support and since what you want does not work with what I know about the policy, it is unlikely that anyone here will be able to provide you with a solution.
  13. I agree with @Tom W. Make sure your layer names are in an ANY block instead of an ALL block.
  14. The @Colon syntax is for data tags (and probably other objects using the # Dynamic text) only. I probably would have used the @WS_IF versions also for myself, but for this specific application not having to do WS calculations seemed like the better way.
  15. This is a perfect case for the Data Tag version of If/Then, also referred to the trinary operator. Put the result if true before an @ sign and the result if false after a colon (:) and put the test value in the middle. So something like: 'OBS'@#WinDoor 6.0#.#Opaque Glass#:'' Since 'Opaque Glass' as a field is already defined as a Boolean (true/false) you don't need to do any type of comparison, you can just use the value. The part after the colon is two single quotes next to each other. Note that you can't put any spaces between the @ and the Colon and whatever comes before and after them.
  16. Please copy those objects that are showing the problem to a new file. If the problem exists in that new file, then please post it here. It is very hard to diagnose this kind of problem from just an image. But if I had to guess, it is that the hatches are not set up properly.
  17. It looks like VW can not SUMmarize based on an image. Add another column with a formula of =SymbolName and SUMmarize on that. If you don't want the Symbol Name to show, you can set the column width to Zero to hide it.
  18. I agree with Raymond. I don't think there is a way to do it automatically. I posted a wish a long time ago for a setting for Class to be By Parent. Since this is in a PIO what about not using the symbol, but just storing it in the object and exploding a copy so you can set the class to what you want. If someone later ungroups you will have a problem, but at least you could get your object to look correct with correct classing. But you would also lose the ability to report on those contained symbols.
  19. For a VS version try using a DynArray of Char instead of a string. It will give you the same functionality, but allow your up to 32,XXX chars.
  20. What lines are you talking about? I don't see anything that looks like it should not be part of the drawing.
  21. If that does not do it, please post the file so we can take a look at what is happening.
  22. I think if you SUMmarize column A and then Sum Values in column B you should get what you want.
  23. The worksheet version of the script has to run for every object that meets the criteria, so making it as compact as possible is important. What happens if you remove the if...elif nesting and the GetParamStr sections and make three different versions of the script, one for each of the nVariables?
  24. You need to enter the serial number because it is stored in your preferences in your users folder. You should not need to get a complete second license, but you may need to have your wife Log Out or at least quit VW prior to your using it and vice versa.
×
×
  • Create New...