@davesexcel said: Thanks, I think I understand the concept, from excel vba we are opening sketchup and passing on a variable that a plugin will recognize to run the plugin? I think Jim explained it better and more detailed.

Hi Jim, essentially, yes what you described at the end of your reply is correct. I would like the ability to reorder and rename dynamic parameters of dynamic components, as well as all of their nested children parameters and so on. Regarding your previous question, a master template in this context is the way that I've been building my DCs to this point. I'll build a functioning component, and then save off each part so that I can create variants, and still have all the same parameters. So as an example, lets say I've built a window that cuts into a surface, and showcases a single hung window. I've been saving off the window child component, creating a casement version, and swapping then back and forth to ensure they work flawlessly, and minimize the file size of the component. I can attach an example when I get back to a computer. The fact I said I'd be needing to make constant revisions may be an exaggeration, but my view is this: I'll be overhauling the use of SketchUp in the office to a more standardized system, and as users begin to adopt DCs and they become more useful, I may need to add features that I did not plan out or set aside in the first roll out of DCs. Adding new features shouldn't be too difficult, but seeing as how the order of the exposed parameters is reliant on alphabetical order in the DC options dialog, I don't see any other way to re-order them other than either manually renaming all the params through parent and child level components, or coming up with something more clever. Hopefully that makes sense, let me know if anything isnt clear. Thanks! Sent from my VS987 using Tapatalk

Exactly Dan, that was one of my mistakes. Finally I got it by myself, and now I understand the basics. Thank you in any case.

Angle snapping works for rotational tools or tool states. Length snapping would work for linear tool states.

additional observation: If onKeyDown or onKeyUp returns true then onCancel is not triggered. It is blocked by onKeyDown/onKeyUp as well.

For architects rendering output is needed, but sketchup output might be also worthy. I want my trees to project shadows, so I can study the project. There is also the fact that cast shadows from a 2d face me component, isn't compatible with renderers and sometimes you get thin flat shadows as shadows don't face sun. In my proposed solution the 2nd model can be a fairly rough 3d which casts 3d shadows that work. You can check a bit more about it here: http://sketchucation.com/forums/viewtopic.php?f=40%26amp;t=64471%26amp;p=591460%26amp;hilit=2.5d+components#p591460

What motivates me with programming plugins is that it allows me to be creative and create something that never existed before.

Thank you Masters. I have another problem: I wrote code to make BOM base on ComponentReport of TIG. Then I place data on a html datatable.So I have to replace all "\n" by "<br>" like this: des=c.definition.description des=des.gsub("\n","<br>") Then the datatable looks good. Then I save data in a .xlsx file. Still look good when openned in Excel. But when I inserted it to LayOut, it create "x000D" before every new line in cell. Please help me how to solve this. Thanks a lottt.

Wow, I got it to work!! require 'win32ole' xl = WIN32OLE;;connect('Excel.Application') xl.visible=1 worksheet = xl.Worksheets(1)

~ (1) Only write to paths that the user has write permissions on. @davesexcel said: # Puts in SketchUp install directory by default This path is a binary program path and the normal user does not have write permissions there. This is not the default path for Ruby when SketchUp v13+ is running. After SketchUp loads Ruby and it's API, it sets the working directory to the User's "Documents" directory. SketchUp 2013 and higher: Dir.pwd %(green)[#=> C:/Users/Dan/Documents] SketchUp 8 and earlier just left the current working directory in SketchUp's program path (which was a bad thing.) (2) In code when you are doing a write then read, you need to wait until the file is finished being written, and the OS file system advertises that it is "ready" and available. (ie, the old file handle is closed.) The Ruby standard File class has some class methods to help you determine if paths are readable or writable by the current user, and whether the OS reports if the file is finished being written (ie, does it exist yet?) def image_from_model( write_path = 'S;/Stairs/Stair Pics/', keys = { ;filename => 'write_image.jpeg', ;width => 500, ;height => 400, ;antialias => false, ;compression => 0.5, ;transparent => false } ) return false unless File.writable?(write_path) image_path = File.join( write_path, keys[;filename] ) keys[;filename]= image_path model = Sketchup.active_model view = model.active_view view.zoom_extents Kernel.sleep(2.0) # wait for view to redraw view.write_image(keys) @tid = UI.start_timer(0.5,true) { if File.exist?(image_path) UI.stop_timer(@tid) insert_to_excel(image_path) end } end def insert_to_excel() xl = WIN32OLE.new('Excel.Application') xl.visible=1 wb = xl.Workbooks.Open('C;\TestFolder\Test2.xlsx') worksheet = wb.Worksheets('Sheet1') worksheet2 = wb.Worksheets('Sheet2') worksheet.Range('a1').Value=12 worksheet.Range('a1;b4').Value #-----Pictures Insert Code--------------- pic = worksheet2.Pictures.Insert('S;/Stairs/Stair Pics/write_image.jpeg') range = worksheet2.Range('A1;F15') pic.ShapeRange.LockAspectRatio = false pic.Top = range.Top pic.Left = range.Left pic.Width = range.Width pic.Height = range.Height # write done message to SketchUp console; put "Finished inserting image in Excel." end

Unfortunately v2017 changes the way references can be got and reused. A few pointers... Use: entities = model.**active_**entities Also you can 'grep' to filter many kinds of 'collections' thus: puts face = entities.grep(Sketchup::Face)[0] return nil unless face The 'face' reference is lost in v2017 after the 'explode', instead consider this... group.explode puts face = group2.explode.grep(Sketchup::Face)[0] Now 'face' is a different, but valid, reference... I added the 'puts' to print the references in the Ruby Console. In < v2017 they should be the same, but in v2017 they will differ. This issue has meant that many authors have had to recode some of their plugins to accommodate the changes...

@dan rathbun said: I looked in my 2016 Plugins folder and found what I had working last June 2016. It seems to work for me on SU2016. Thanks Dan. I have come up with a different solution to what I was attempting and it works with all versions.

I did a search in the MS Excel Dev forum on "+SaveAs +xlsm +UndefinedConversionError", and got 947 hits. (You can browse those yourself.) https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=exceldev%26amp;filter=alltypes%26amp;brandIgnore=True%26amp;sort=relevancedesc%26amp;filter=alltypes%26amp;searchTerm=%2BSaveAs+%2Bxlsm+%2BUndefinedConversionError At this point I would double-check that any macros in the Workbook do not have errors, that could give the file export routine issues.

OH! I see your booboo: inputbox always returns an array (except when the user cancels it returns false. So always check the result boolean-wise.) input = UI.inputbox prompts, defaults,list, "File Name" return unless input j = input[0]

@sdmitch said: I have tried using .clone and .dup but neither remedy the problem. Any guidance will be greatly appreciated. These two methods are Ruby Core functions that rely upon specific Ruby housekeeping methods to do the copying. The SketchUp API has not set up these "housekeeping" methods, so doing this will not work. They have only in a few places "mimicked" a clone method (mostly in the Geom classes,) and a partial cloning in Group#copy. (It does not copy over attributes and other parameters.)

ALL of SketchUp's internal database lengths are stored in inches, irrespective of the units you use. In the API there are the numeric and length classes. So if you have an input value that defaults to a 'length' - e.g. 9.feet, or any other units format - then it is always 'stored' and 'processed' in inches [9*12=108"]. However, this is flexible as the user can input in any units provided they use a units suffix: however how it's displayed in the input-box depends on the current model info > units settings... Otherwise you need to default to a string value and then reverse-engineer that - e.g. h="9" [read from the input[1]] which you then reset for later use as a parallel value hft=h.to_f.feet So the input is always taken as a decimal-feet value, but then used in inches internally...

Try adding: Sketchup.active_model.active_view.invalidate ???

Assuming you have no more need of the group or its contents use: wandgroep.erase! See here: http://ruby.sketchup.com/Sketchup/Drawingelement.html#erase%21-instance_method BUT if you want to explode it and put its contents into the group's previous context, use: wandgroep.explode See here: http://ruby.sketchup.com/Sketchup/Group.html#explode-instance_method

I tried by change name of load_plugin.rb to z_load_plugin.rb but it seems not solve my problem

The program I used as a model when starting used that method. However as I added more functions it became almost impossible to find how to get out to the end of the mouse click down def. Keith