Reply

XLS-linked variables + automatic update

Hello,

i've a parametric geometry with variables linked into an Excel sheet.

My workflow follows the help file:
(1) Open the XLS
(2) Open SE

Automatic update is active.

But the geometry does not update according to the new values in the XLS. Once i use the "Update Now!" function (wich is deeply hidden in the variable table) or edit the XLS while the drawing is loaded the update is performed. But it's not intended to use a manual update when auto update is active nor re-edit the Excel sheet.

Where is my mistake?

Thank you!

Best regards,
Robert Goldbach
10 REPLIES

Re: XLS-linked variables + automatic update

Robert,
Sorry it took a while to get back to you.
You are pushing the limits of the capability that we expose to 2D Drafting.
In Solid Edge Draft there is a command for Update All.
This is the hook to update the links relative to an external source.
I'll see about having this added command to 2D Drafting.
Here is a workaround that should force the update.
File Open will force the update.
Document transition should also force an update.
Here is what to do. Create another blank Draft file.
Anytime you make a change to the XLS, switch 2D Drafting from your working
document to the blank document and then back again.
This should force variable table to update.
Let me know if this does not work.
Regards,
Rick B.

Re: XLS-linked variables + automatic update


Sorry it took a while to get back to you.


No problem, some tasks need more time to find a suitable way to solve them

You are pushing the limits of the capability that we expose to 2D Drafting.


That's how evolution works ;-)

I'll see about having this added command to 2D Drafting.

Here is a workaround
Let me know if this does not work.


Thank you, i'll try it and leave report.

Best regards,
Robert

Re: XLS-linked variables + automatic update

Robert,

In Solid Edge Draft there is a command for Update All.
This is the hook to update the links relative to an external source.
I'll see about having this added command to 2D Drafting.

Regards,
Rick B.


I may be misunderstanding what you are saying but the "Update All" command is available in 2D Drafting, but only in model view, not work view.

Ed

Re: XLS-linked variables + automatic update

but the "Update All" command is available in 2D Drafting, but only in model view, not work view.


But where can i find this command? The command finder doesnt show any activity for "Update All". For other commands it works fine.

Create another blank Draft file.
Anytime you make a change to the XLS, switch 2D Drafting from your working
document to the blank document and then back again.
This should force variable table to update.


Seems not to work...
So i've to use the "Update Now!" command from the Edit Links dialog (due the dual monitor desktop it's not critical, but draw and variable table and Excel... i wish i had a triple monitor system...). Is it possible to script that command into the tool bar (like in Autocad or similiar programs)?

Best regards,
Robert

Re: XLS-linked variables + automatic update

Robert,
I was confusing two different workflows.
You were saying variables and I was thinking property text.
I can create geometry and dimension the geometry.
I can link the dimension in the variable table to cells in a spreadsheet.
The Rule for that dimension will show 'Paste Link'.
With both the draft document open and the spreadsheet open,
I can change the values in the spreadsheet and drive the dimensions which
drive the shape of the geometry.
Make sure your dimensions are driving dimensions.
Rick B.

Re: XLS-linked variables + automatic update

Robert,
I was confusing two different workflows.
You were saying variables and I was thinking property text.

No problem. Maybe i didn't explained well enough, i'm not native english, so i'm sorry for my bad english.
The background, why i ask so many questions: I'm trying to find a suitable workaround for some special cases when our other tools are too low-end, while slowly forcing the company to leave the ages of "white-out aided design" behind. Clearly i'd need a parametric full-3D-system for our special parts (mostly some crude cylindrical intersections, a pain with non-parametric 2D).... but impossible to convince them.

I can create geometry and dimension the geometry.
I can link the dimension in the variable table to cells in a spreadsheet.
The Rule for that dimension will show 'Paste Link'.
With both the draft document open and the spreadsheet open,
I can change the values in the spreadsheet and drive the dimensions which
drive the shape of the geometry.
Make sure your dimensions are driving dimensions.


Check.
Now let the form (the Excel Sheet) filled out by your customer or your salesman or whoever collected the data. Then open the XLS, then the drawing.
The drawing (your template) shows your basic geometry. The dimensions are not corrosponding to your XLS, you have to force the update ("Update Now!")

Best regards,
Robert

Re: XLS-linked variables + automatic update

Robert,
I believe I have an answer to your broblem.
As long as you initially have both the drawing and the spreadsheet open,
the links can be resolves as they are added to variable table.
Also asl long as both are open, changes you mak in the spreadsheet will
drive the drwaing.
I assume you are using Paste Link on a dimension in the variable table to
initially create the link to the spreadsheet.
Now, when you want to go back and modify the drawing by making changes to
the spreadsheet do the following:
Open the drawing. Do not open the spreadsheet.
You need to open the Links dialog again.
You can do this by right mouse click on one of the dimensions that are
linked to the spreadsheet.
Click on Edit Links to open the 'Links' dialog.
Or Click on the application button at the top left.
Move the curcor down to Manage, move the cursor to the right and then click
on Edit links.
Click on the worksheet in the list that is driving your drawing.
Click on open source. This opens the spreadsheet and opens the link between
Solid Edge and the spreadsheet.
You can now again drivew the drawing from the spreadsheet.
Regards,
Rick B.

Re: XLS-linked variables + automatic update

I assume you are using Paste Link on a dimension in the variable table to initially create the link to the spreadsheet.


Yes, i did so.


This opens the spreadsheet and opens the link between
Solid Edge and the spreadsheet.
You can now again drivew the drawing from the spreadsheet.


Same problem, the geometry doesn't auto-update without any edits to the XSL when Excel gets launched by SE. I have to re-enter all the values to get them drive the geometry.

Seems, that the only working way is the "Update Now!"-Button.

Ok, last question: is there a way to get easier access to the "Update Now!"-command, i.e. put it in the toolbar somehow?

Thank you very much!

Best regards,
Robert

Re: XLS-linked variables + automatic update

The only way to get to Update Now is through the dialog.
You can access the dialog through Manage - Edit Links or through the
variable table.
Regards,
Rick B.
"goldbach@schaefer-stahlbeton.de"
wrote in
message
news:goldbachschaefer-stahlbeton.de.4puzoo@noreply.bbsnotes.ugs.com...
>
> Ricky Black;201299 Wrote:
>> I assume you are using Paste Link on a dimension in the variable table
>> to initially create the link to the spreadsheet.

>
> Yes, i did so.
>
>>
>> This opens the spreadsheet and opens the link between
>> Solid Edge and the spreadsheet.
>> You can now again drivew the drawing from the spreadsheet.

>
> Same problem, the geometry doesn't auto-update without any edits to the
> XSL when Excel gets launched by SE. I have to re-enter all the values to
> get them drive the geometry.
>
> Seems, that the only working way is the "Update Now!"-Button.
>
> Ok, last question: is there a way to get easier access to the "Update
> Now!"-command, i.e. put it in the toolbar somehow?
>
> Thank you very much!
>
> Best regards,
> Robert
>
>
> --
> goldbach@schaefer-stahlbeton.de
> ------------------------------------------------------------------------
> goldbach@schaefer-stahlbeton.de's Profile:
> http://bbsnotes.ugs.com/vbulletin/member.php?userid=298682
> View this thread: http://bbsnotes.ugs.com/vbulletin/showthread.php?t=44662
>