sketchucation logo sketchucation
    • Login
    ℹ️ Licensed Extensions | FredoBatch, ElevationProfile, FredoSketch, LayOps, MatSim and Pic2Shape will require license from Sept 1st More Info

    Export For CAM software

    Scheduled Pinned Locked Moved Extensions & Applications Discussions
    extensions
    51 Posts 14 Posters 15.8k Views 14 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • TIGT Offline
      TIG Moderator
      last edited by

      The instance should hold various attributes values, the dictionary can be named whatever the creator called it - e.g. 'product_info'.
      The DC's options/attributes are found in a special 'dynamic_attributes' dictionary.
      The code at the end of the link I posted is specifically made to show you how to extract such info from a model / instance etc...

      TIG

      1 Reply Last reply Reply Quote 0
      • Y Offline
        yvan
        last edited by

        The geometries should also be exported as follow:

        1. Create a dynamic component with attributes to be exported in the csv file.

        http://www.catalystinteriors.com.au/images/stories/sketchup/01.png

        1. Select primary face in all components to be machined. (components such as hardware are excluded if no face is selected). Only one face per component can be selected.

        http://www.catalystinteriors.com.au/images/stories/sketchup/02.png

        1. Tooling is set by placing geometries in specific layers. For example vertical drilling with a 5mm bit would be associated with the dxf layer called “DV_5”; Routing offset for external shape with DXF layer “ROX_9” (9 for a 9mm router bit.) any combination of machining can be accomplished by linking tooling “strategies” in the CAM software with DXF layers created by Sketchup.

        http://www.catalystinteriors.com.au/images/stories/sketchup/03.png

        1. When the model is ready all “primary” faces are exported as DXF polylines in a specified folder together with the csv file.

        http://www.catalystinteriors.com.au/images/stories/sketchup/04.png

        1. The csv file is then used to automate the import in the CAM software (Enroute, Aspan etc...)

        http://www.catalystinteriors.com.au/images/stories/sketchup/05.png

        Catalyst Interiors Pty. Ltd. - shopfitters Adelaide South Australia

        1 Reply Last reply Reply Quote 0
        • S Offline
          sketchdata
          last edited by

          I use a script to export the Entity Information, Attributes, and Outline (BOM Structure) from the SUP drawing into CSV files. But the CSVs are not "flat files", they use the EntityID to link records between each file after they have been imported into a database. I have attached samples of the files, perhaps the Data functions inside OpenOffice can help "flatten" the attribute information? or they could be imported into an OpenOffice Base ".odb" database, then you could write queries? Not sure if OpenOffice can link to the .csv files like MS Access does, and then you wouldn't have to re-import each time? Anyways, the script is very BETA at this point.


          Sample Data Files

          1 Reply Last reply Reply Quote 0
          • T Offline
            t.larcombe
            last edited by

            not sure if this will be of much help. I have used sketchup for CNC work and some of the plugins such as stl or dxf converters are good such as the one here
            [url]
            http://www.guitar-list.com/.../convert-sketchup-skp-files-dxf-or-stl
            [/url]
            but i also use mesh lab software. I only use this for smallish models and prototypes so I am not sure how well it will work for you but try it

            favicon

            (meshlab.sourceforge.net)

            exporting from sketchup as a collada file and them messing about with it in meshlab, it does seem to work but needs experimenting with depending on what you are doing

            1 Reply Last reply Reply Quote 0
            • D Offline
              dedmin
              last edited by

              @sketchdata said:

              I use a script to export the Entity Information, Attributes, and Outline (BOM Structure) from the SUP drawing into CSV files. But the CSVs are not "flat files", they use the EntityID to link records between each file after they have been imported into a database. I have attached samples of the files, perhaps the Data functions inside OpenOffice can help "flatten" the attribute information? or they could be imported into an OpenOffice Base ".odb" database, then you could write queries? Not sure if OpenOffice can link to the .csv files like MS Access does, and then you wouldn't have to re-import each time? Anyways, the script is very BETA at this point.

              Why it is so hard to just export component's options? All this data is so messy - seems easy to me just to write by hand what I need!

              1 Reply Last reply Reply Quote 0
              • D Offline
                dedmin
                last edited by

                http://sites.google.com/site/sketchuptogcode/

                1 Reply Last reply Reply Quote 0
                • M Offline
                  marcomartim
                  last edited by

                  Because, instead of exporting, not seeking to make the process within CAM SketchUp?

                  In this forum there is an excellent plugim to 2.5D (to generate GCode)
                  http://www.phlatforum.com/

                  There are already other plugim for developing 3D

                  1 Reply Last reply Reply Quote 0
                  • S Offline
                    sketchdata
                    last edited by

                    Here is a video on the SketchUp reporting solution we have been working on.
                    http://www.youtube.com/watch?v=M2Y53vgqSQs

                    1 Reply Last reply Reply Quote 0
                    • D Offline
                      dedmin
                      last edited by

                      Just a sample how simple things can be made complicated! Really scaring! 😒

                      1 Reply Last reply Reply Quote 0
                      • S Offline
                        sketchdata
                        last edited by

                        I'm guessing you don't like the reports?

                        1 Reply Last reply Reply Quote 0
                        • D Offline
                          dedmin
                          last edited by

                          @sketchdata said:

                          I'm guessing you don't like the reports?

                          In my previous posts I outlined what I thinks is a good use of the dynamic components data. We can put one data for panels, another for hardware and etc. Export this as csv and combine as You wish in Excell or Calc. So far seems impossible to do in SketchUP - and especially if there are non english characters.
                          Something You can do in CAD with BOM - You can choose what to include in the BOM, have different templates, put custom data and etc.

                          1 Reply Last reply Reply Quote 0
                          • S Offline
                            sketchdata
                            last edited by

                            I hope I understand your reporting concerns, I think your looking for the following? What if we put the different part types on their own layers, example cut parts on a "CUT PART" layer, Hardware on "HARDWARE" layer, and if all the entities on that layer share the same attributes. Then as the report prints, the rows could be grouped together by layer and the column headers could change to match the attribute names for entities in that group? then export the report to Excel? The non-english issue is interesting, I will see if I can determine language on the client machine, and have the report translate the attribute names.

                            1 Reply Last reply Reply Quote 0
                            • D Offline
                              dedmin
                              last edited by

                              @sketchdata said:

                              I hope I understand your reporting concerns, I think your looking for the following? What if we put the different part types on their own layers, example cut parts on a "CUT PART" layer, Hardware on "HARDWARE" layer, and if all the entities on that layer share the same attributes. Then as the report prints, the rows could be grouped together by layer and the column headers could change to match the attribute names for entities in that group? then export the report to Excel? The non-english issue is interesting, I will see if I can determine language on the client machine, and have the report translate the attribute names.

                              Yes, that is exactly my point! Because the info that one needs is different for different parts. For example - for the purchased legs we need the supplayer, the material(color),the price and maybe the height of the legs. And the attributes gives Us the freedom to put this data, but so far there is no way to use it for reporting. And even there is no need to export all at once - just the parts with identical attributes - and then we can put this data on a separate sheets or in the same sheet and etc. This also works with the free version - the supplayer puts the attributes that the customer can see and fill and then can send back as an order.

                              http://forums.sketchucation.com/download/file.php?id=52143&t=1

                              http://forums.sketchucation.com/download/file.php?id=52144&t=1

                              1 Reply Last reply Reply Quote 0
                              • S Offline
                                sketchdata
                                last edited by

                                I will work up a report that groups/totals like parts based on their dynamic attributes, and then the report can be exported to Excel. Since SketchUp stores the measurements in Inches, we had to add a conversion to the Model Units (mm, fraction, decimal) when displaying the data on the reports. I'm still thinking about the Language conversion issue, we need to convert the column headers and the attribute names to your local language? Do the attribute values need to be converted too? What language would you like it converted to if I can produce a sample spreadsheet?

                                1 Reply Last reply Reply Quote 0
                                • D Offline
                                  dedmin
                                  last edited by

                                  These are sample files. A SketchUP's component with name and attributes in Bulgarian language and Excell table from this attributes.
                                  Clipboard01.jpg
                                  Clipboard02.jpg
                                  I don't know,but seems that SketchUP recognizes different languages in attributes and correctly displays them.


                                  Panel.skp


                                  Cutlist.xls

                                  1 Reply Last reply Reply Quote 0
                                  • S Offline
                                    sketchdata
                                    last edited by

                                    When I open up the "Component Options" dialog in my SketchUp I still see the Bulgarian, but when I open the "Component Attributes" I see English LenX,LenY,LenZ. So I created a report to group and sum qty on components that have the exact same attribute values and then used the "Display Label" as the column header, which is not the internal attribute name, but the name that displays on the "Component Options" dialog. I attached a sample SKP which has copies of your part with different sizes so I could test the report quantity column, also attached is a PDF and Excel file of the report. Please let me know if this helps, or if I'm way off. Thanks...


                                    Panel_Test.skp


                                    Panel_Test.pdf


                                    Panel_Test.xls

                                    1 Reply Last reply Reply Quote 0
                                    • D Offline
                                      dedmin
                                      last edited by

                                      Yes, that is! SketchUP doesn't allow non English characters for attributes, but no problems with attributes labels - and that visible information is really valuable for the report - what You see is what You want on the report! Not how it is with the generate report - a bunch of useless information! This way You really control what info and how to export! Thanks!

                                      1 Reply Last reply Reply Quote 0
                                      • B Offline
                                        Bertier
                                        last edited by

                                        interesting subject.

                                        keep me posted, what about French accents ? !

                                        keep up the good work

                                        1 Reply Last reply Reply Quote 0
                                        • pilouP Offline
                                          pilou
                                          last edited by

                                          Numerous progs have some trouble with accents! 😮
                                          In the path's folders, files'names or even in the prog it self!

                                          For example Zbrush can't have a French Interface due the French accents! 😢
                                          Because it was not managed from the beginning, now it's to late! 😮

                                          So don't take names files or path folder with accent when you write in French 😉

                                          Frenchy Pilou
                                          Is beautiful that please without concept!
                                          My Little site :)

                                          1 Reply Last reply Reply Quote 0
                                          • P Offline
                                            paulhankin
                                            last edited by

                                            @dedmin said:

                                            Fully agree with You!! I wonder why nobody did this already - there are so many fellow woodworkers ready to pay for this!! But when You export a 5mm circle from SketchUP as .dxf it is not a circle anymore - that is why I asked above if this is a problem with CAM?

                                            What it could is when exported convert all circles to a high segment polygon,via a input box

                                            Ie a circle that has 10 edges could be converted to a circle with 100 edges giving the appearance of a more precise circle
                                            depending on the tolerance of a hole. and insert a cross hair in the centre to denote the centre of the circle of a standardised size say 5x5mm or an input box could include this feature to choose.

                                            This then could have an option to convert all holes in model , voila problem sorted

                                            obviously this would only work on flattened geometry for export to 2d cad cutting , say laser cutting

                                            What do you think?

                                            Thanks

                                            Paul

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 1 / 3
                                            • First post
                                              Last post
                                            Buy SketchPlus
                                            Buy SUbD
                                            Buy WrapR
                                            Buy eBook
                                            Buy Modelur
                                            Buy Vertex Tools
                                            Buy SketchCuisine
                                            Buy FormFonts

                                            Advertisement