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

    Layout make table with bom

    Scheduled Pinned Locked Moved LayOut Discussions
    layout
    27 Posts 8 Posters 5.5k Views 8 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.
    • Dave RD Offline
      Dave R
      last edited by

      That's an interesting idea but I just tried that with a simple TXT file inserted into an RTF file as an object and then inserted the RTF file into LO. A text box is created but there's nothing in it. Text typed directly into the RTF file will appear but not the object. What did I miss?

      Etaoin Shrdlu

      %

      (THERE'S NO PLACE LIKE)

      G28 X0.0 Y0.0 Z0.0

      M30

      %

      1 Reply Last reply Reply Quote 0
      • TIGT Offline
        TIG Moderator
        last edited by

        Insert into the RTF as a File [Linked] NOT an Object.
        Here's an example doing it successfully with .TXT or .TSV files linked into a .RTF, which is in turn linked into a Layout Page insert.
        You'll need to relink the various files because the paths will be wrong on your PC!
        TSVTextTest.zip

        TIG

        1 Reply Last reply Reply Quote 0
        • J Offline
          jim78b
          last edited by

          ok thanks to all,i say it is very complex for me! for reply all, i am in sketchup, 1. i shall give attributes it is my primary difficult, i give it as inmy table below. qty description etc...how i can it?i want put inattributes ex description:sheet 100x100 x5 but this measurea are attributes....

          then export to aformatted text order as my table below....


          in this figure i try to make attributes for my table but i can t set automaic the quantity of objects how i can do it?how i can calcute weight? and export to a rtf file ?

          1 Reply Last reply Reply Quote 0
          • Dave RD Offline
            Dave R
            last edited by

            TIG, your examples work quite nicely but I don't see File>Insert as Link... in my version of Word. I found the way to update the links under Edit>Links...

            Etaoin Shrdlu

            %

            (THERE'S NO PLACE LIKE)

            G28 X0.0 Y0.0 Z0.0

            M30

            %

            1 Reply Last reply Reply Quote 0
            • J Offline
              jim78b
              last edited by

              do you seemy problem?

              1 Reply Last reply Reply Quote 0
              • Dave RD Offline
                Dave R
                last edited by

                I don't really understand what you've written. Now it looks like you are talking about Dynamic Components instead of LayOut. Are you using the free version of SketchUp or the pro version?

                Etaoin Shrdlu

                %

                (THERE'S NO PLACE LIKE)

                G28 X0.0 Y0.0 Z0.0

                M30

                %

                1 Reply Last reply Reply Quote 0
                • GaieusG Offline
                  Gaieus
                  last edited by

                  Well, it's a LayOut topic so I suppose it's SU Pro...

                  Gai...

                  1 Reply Last reply Reply Quote 0
                  • Dave RD Offline
                    Dave R
                    last edited by

                    Good point, Csaba. Still, I'm getting confused on what the OP wants and his last post seems more cryptic than his first

                    Etaoin Shrdlu

                    %

                    (THERE'S NO PLACE LIKE)

                    G28 X0.0 Y0.0 Z0.0

                    M30

                    %

                    1 Reply Last reply Reply Quote 0
                    • J Offline
                      jim78b
                      last edited by

                      excuse me i use pro version.

                      1 Reply Last reply Reply Quote 0
                      • TIGT Offline
                        TIG Moderator
                        last edited by

                        @dave r said:

                        TIG, your examples work quite nicely but I don't see File>Insert as Link... in my version of Word. I found the way to update the links under Edit>Links...
                        Insert > File > . > Insert as Link [it's a drop-down from the 'Insert' button]...might be different on other versions of Word...
                        Capture.PNG

                        TIG

                        1 Reply Last reply Reply Quote 0
                        • Dave RD Offline
                          Dave R
                          last edited by

                          Thanks TIG.

                          Etaoin Shrdlu

                          %

                          (THERE'S NO PLACE LIKE)

                          G28 X0.0 Y0.0 Z0.0

                          M30

                          %

                          1 Reply Last reply Reply Quote 0
                          • J Offline
                            jim78b
                            last edited by

                            how i add attribute as a weight?

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

                              @dave r said:

                              Yes, you can make that table. Start in Excel to make the table, copy it to word and save it as RTF. Then you can insert the RTF file into LayOut. The borders/lines may be a challenge because the RTF file doesn't do a good job of saving borders.

                              I've found a way to bring the files in by their tab lengths, without bringing in the borders, which I was having trouble with.

                              In my case I'm taking an excel file and copying and pasting the table into Word. I then select the entire table and click on the developer tab that lights up in the main bar. There is a button there that converts the table to text! Save the word file as RTF and link inside layout for a relatively seamless workflow.

                              1 Reply Last reply Reply Quote 0
                              • Dave RD Offline
                                Dave R
                                last edited by

                                Although I don't use the Developer tab, I do much the same. I copy the table from Excel into Word, convert table to tab-separated text and save as RTF. Actually there's often a bit of editing in word for formatting and setting tabs and so on. I did two of those today, in fact.

                                Etaoin Shrdlu

                                %

                                (THERE'S NO PLACE LIKE)

                                G28 X0.0 Y0.0 Z0.0

                                M30

                                %

                                1 Reply Last reply Reply Quote 0
                                • KrisidiousK Offline
                                  Krisidious
                                  last edited by

                                  you can copy and paste excel tables straight into layout.

                                  By: Kristoff Rand
                                  Home DesignerUnique House Plans

                                  1 Reply Last reply Reply Quote 0
                                  • Dave RD Offline
                                    Dave R
                                    last edited by

                                    Yeah, but they're ugly.

                                    Etaoin Shrdlu

                                    %

                                    (THERE'S NO PLACE LIKE)

                                    G28 X0.0 Y0.0 Z0.0

                                    M30

                                    %

                                    1 Reply Last reply Reply Quote 0
                                    • KrisidiousK Offline
                                      Krisidious
                                      last edited by

                                      They look just like that...

                                      @dave r said:

                                      Yes, you can make that table. Start in Excel to make the table, copy it to word and save it as RTF. Then you can insert the RTF file into LayOut. The borders/lines may be a challenge because the RTF file doesn't do a good job of saving borders.

                                      table.JPG

                                      By: Kristoff Rand
                                      Home DesignerUnique House Plans

                                      1 Reply Last reply Reply Quote 0
                                      • pbacotP Offline
                                        pbacot
                                        last edited by

                                        I'm not finding anything you guys have in Word on a Mac (insert button with link submenu?) If I choose insert file and pick a box in the open dialog "insert as link" I get an error not valid file name....

                                        Anyway is LO reference supposed to be able to update when you update the Excel this way (rtf)? or do you also have to do something with the rtf file?

                                        I use an alternate method myself.
                                        I update the excel then print to pdf, Iinsert pdf to LO.
                                        Later if I change the excel file, I print to pdf and over-write the same pdf file
                                        The LO file can then update ther reference. Is this more steps?? If you use macs the print to pdf will use the excel name so you don't even have to worry about the name--if you are in the right folder.

                                        Regarding OP I think the missing step is using ruby to export the information about his DC to the csv file. Just guessing.

                                        MacOSX MojaveSketchUp Pro v19 Twilight v2 Thea v3 PowerCADD

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

                                        Advertisement