Layout make table with bom
-
subscribed... very interested in any further developments.
currently i use a ruby written by daiku to export my timber list to excel.
i haven't had need (yet) of placing this in a LO drawing... but can see the use of the functionality. -
Another even simpler idea
Export the data from the SKP, doing all of the calcs/number-formatting/etc in Ruby, saving it in TSV format - Tab Separated Variable list - BUT suffixed as .txt...
Then Insert that .txt File into your .rtf file - it needs to be as a 'Link' [NOT simply Inserted] so it updates as the .txt file is changed...
Then in Layout you can Insert the .rtf file as explained earlier and it'll auto-update as Layout opens, or you can also update it from within the SKP as desired, provided that it's never manually edited in Layout which breaks the linking... -
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?
-
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 -
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....
-
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...
-
do you seemy problem?
-
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?
-
Well, it's a LayOut topic so I suppose it's SU Pro...
-
Good point, Csaba. Still, I'm getting confused on what the OP wants and his last post seems more cryptic than his first
-
excuse me i use pro version.
-
@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...
-
Thanks TIG.
-
how i add attribute as a weight?
-
@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.
-
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.
-
you can copy and paste excel tables straight into layout.
-
Yeah, but they're ugly.
-
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.
-
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.
Advertisement