Layout table connect to model ..confusion
-
I have already asked for this argument, but frankly I'm confused and I could not do anything!
you can direct me a way to make sure that by inserting a table (if possible) in the layout can automatically change the components and at the same time update the table
-
You cannot have a table [like a spreadsheet] in a Layout page that links back into the SKP.
You can have a table in a Layout page that's inserted as an RTF file, which itself has a linked file inserted that's a TSV file.
If the TSV file changes you can simply update the RTF and the Layout page's insert will update too.
Editing the RTF inside Layout will break any linking - so you must always use 'Edit in MSWORD' to update it.
You can readily export data from your SKP into a TSV file, using some Ruby code.
That TSV file could then be linked into an RTF file, which in turn can be linked into a Layout page...
You can change a TSV file by editing it in Excel.
The TSV file's data could then read back into a SKP, using some Ruby code - updating the SKP's contents to match.
BUT there's no way you can edit the TSV via Layout AND/OR get it to somehow magically change the SKP, there just is not the process to do that in that direction...Rather think of a TSV Ruby-SKP-Export/Excel-Edit/Ruby-SKP-Import as a way of getting dta out and back in to a SKP and Layout as a way of reporting it on a page - the RTF+Linked-TSV inserted into a Layout Page CAN give an up to date report, subject to a manual update of the linked RTF and its own linked TSV...
[NOTE: when I say TSV I mean text files of Tab Separated Variables, you can use CSV files - Comma Separated Variables, but whilst these look the same in Excel these do format nicely in a linked RTF situation...]
-
mmh ok very hard ! but i can't obtain weight or area attribute of my component....
-
Of course you can extract whatever properties you want - either using a Ruby to get a DC's attributes or calculate things from other groups/components.
What is this 'volume' or 'weight' attribute of which you speak ?
If it's part of a DC you can get it with some simple Ruby digging...
You could then have the data posted in the SKP as a Text-block on screen...
OR
You could then export this data as a TSV file [updating it if it already exists], this in turn is already linked into a RTF file, which is in turn inserted in a Layout page...
BUT you can't go in the other direction, changing things in Layout won't ripple back up the chain to the SKP!Perhaps if you could spell out simply the steps by step you want to do we could advise on the best method - currently I don't believe that our thinking is starting off from the right place...
It might not even be a Layout specific issue...
You could also perhaps post a simple SKP... and ask how a certain aspect of it is 'uncovered'...
-
OK THANKS FOR YOUR PATIENCE! weight i am interested is of the component.
an 'else that I can not do is how i link a single cell of my linked file to my real table thath i will put in layout. i use openoffice.ex: in description i want link from my linked file the value cell of x then value of y and then value of description...
-
IF I understand you... you use OpenOffice for making RTF and spreadsheets etc.
You can NOT save_as your spreadsheet info directly as a TSV file from OpenOffice, BUT you can save_as CSV, and then when prompted change it's field delimeter to TAB rather than a comma !
So you CAN insert the .CSV [now actually TAB separated!] file into your RTF file.
I.E. you CAN insert it 'as a File' into an OpenOffice RTF file, BUT unlike with Microsoft Office's 'Word' you cannot 'link' the inserted File, once it's been inserted it's then in the RTF as text, without any linking back to the original !
So you'll have to manually update the RTF by re-inserting the File over the top of the text made from the previous insertion...
IF that RTF is saved and then inserted into a Layout page, it can be updated OK later e.g. if the RTF has been changed outside of Layout, BUT not if you've never edited it within Layout [because editing it that way will break any linking between Layout and the RTF file].As I explained before... this linking is in one direction and it can't affect the SKP at all, or any other files potentially linked back up the chain
-
I have tried a little doing something like this on the Mac but it doesn't work for me. However in the last post TIG, it seems that the update would not be automatic anyway. Do I understand that correctly? In that case a method that I have used is print or save the excel file to a pdf file that has been inserted in LO. update the pdf by over-writing to the same file and LO will update. But as I understand it the holy grail is to have auto update from SU to Excel to LO. You can probably script some of the process.
Now I wonder if anyone knows why inserted graphics are not at proper size, or is there some rule they follow?
Advertisement