usare openoffice per design tables

[cacciatorino]

on the American forum of swx I came across a macro that promises to use openoffice to excel post to drive models through spreadsheets.

Unfortunately it seems that it does not work on my 2009, it serves 2010 I believe:
http://spn.office-on-the.net/spn-designtable_en.htm

 

[re_solidworks]

mah, I try to go on the safe or at least certified by the swx. there are malfunctions with excel that is tested by them.. .

 

[cacciatorino]

I attach an openoffice set-up for those who want to see it. I think it serves the macro mentioned at the first link to edit the various configurations.

p.s. works with swx 2009 and ooo 3.2.0.

 

[sniveri]

the site has been moved:
http://www.spn-technologies.fi/designtable_en.htm

 

[lelepanz]

Good. I'll take a look! :

 

[cacciatorino]

http://www.spn-technologies.fi/spn-configurationdesigner_en.htma new release has been released, which among the various improvements also allows to work on models containing a single configuration, ie it can be used as an internal spreadsheet, instead of the equation editor.

 

[reggio]

...interessante... ma io non sono riuscito a capire come fare x averlo...
ho lanciato il setup, ma ora se preso "s" si apre il micro menù.... ??? e mò???

installing spn-configurationdesigner to solidworks
for easier usage spn-configurationdesigner can be installed to solidworks for example this
way:
– open model to solidworks
– make sure that nothing is selected on solidworks
– click s-button on your keyboard
– when menu opens up, right click on it and choose "customize menu"
– now add new macro button and attach macro:
c:\program files\spn-configurationdesigner\spn-configurationdesigner.dll
to created button (there is also bitmap for macro button in same folder).
creating spn-configurationdesigner spreadsheet
– press s-button and select the macro button you have created
– spn-configurationdesigner window opens up
– select options if needed
– click "insert spreadsheet" -button and application fills the table to openoffice.org
– during inserting spreadsheet is embedded to model and model is saved
updating spn-configurationdesigner spreadsheet
– push s-button on your keyboard
– click the macro button you created
– spn-configurationdesigner window opens and if you have selected "autoupdate
spreadsheet" then the application fills data from your model to spreadsheet.
– when you have made the changes you can click "update to model"-button and then your
new values are inserted to configurations in model, spreadsheet is embedded and model is
saved.
warning!
– do not use formulas in driving cells if you have checked option "autoupdate spreadsheet"
– do not delete the "family"-cell from the design table!

 

[sniveri]

...interessante... ma io non sono riuscito a capire come fare x averlo...
ho lanciato il setup, ma ora se preso "s" si apre il micro menù.... ??? e mò???

installing spn-configurationdesigner to solidworks
for easier usage spn-configurationdesigner can be installed to solidworks for example this
way:
– open model to solidworks
– make sure that nothing is selected on solidworks
– click s-button on your keyboard
– when menu opens up, right click on it and choose "customize menu"
– now add new macro button and attach macro:
c:\program files\spn-configurationdesigner\spn-configurationdesigner.dll
to created button (there is also bitmap for macro button in same folder).
creating spn-configurationdesigner spreadsheet
– press s-button and select the macro button you have created
– spn-configurationdesigner window opens up
– select options if needed
– click "insert spreadsheet" -button and application fills the table to openoffice.org
– during inserting spreadsheet is embedded to model and model is saved
updating spn-configurationdesigner spreadsheet
– push s-button on your keyboard
– click the macro button you created
– spn-configurationdesigner window opens and if you have selected "autoupdate
spreadsheet" then the application fills data from your model to spreadsheet.
– when you have made the changes you can click "update to model"-button and then your
new values are inserted to configurations in model, spreadsheet is embedded and model is
saved.
warning!
– do not use formulas in driving cells if you have checked option "autoupdate spreadsheet"
– do not delete the "family"-cell from the design table!

sorry about posting in english..

when you have installed this software start solidworks. open up for example part and click "s"-button on your keyboard when nothing is selected in sw. small menu is displayed in sw, click right button on your mouse on that small menu and "customize"- option should be available. now link new macro button to menu from "commands"-> "macro" ->"new macro button". in this window you should be allowed to show macro from "c:\program files\spn-configurationdesigner\spn-configurationdesigner.dll"

hope this helps!

 

[cacciatorino]

... interesting... but I couldn't figure out how to make x have it. . .
I launched the setup, but now if taken "s" opens the micro menu...????? What about me? ?

Actually, after installing the software, you should create a macro launch button that goes to the request. see if the attached image can help you.

the fact of pressing the "s" button to launch the command I think refers to the fact of launching the macro from the "spn tool", a set of instructions created by the developer (additional) that speed the use of swx. If you don't have the spn tools you have to launch the program as a macro, from the special box you created.

 

[cacciatorino]

sorry about posting in english..

hi samu, nice to meet you here. i apologize to have not tested yet your soft, but i was really busy in the last weeks. neverthless, i want to thank you to have modified the program as requested!

regards.

 

[lelepanz]

I just tested this pome right.
it has simplified because now to start just click dx in the model view.
It's beastly. :

among other things to me that o2003 and sw2010 x64 and win7x64 could not automatically create data tables, this has solved this problem at the moment.
Thanks samu. ;-)
emanuele

 

[sniveri]

nice to hear that it works. keep me informed if there is problems

 

[lelepanz]

exit the new version . http://www.spn-technologies.fi/spn-configurationdesigner_en.php

 

[cacciatorino]

spn-configurationdesigner is now a partner product of solidworks corp.:
http://www.solidworks.com/sw/products/details.htm?productid=4230

 

[lelepanz]

It was hard, but she did it.
Samu compliments.
I hope I helped you. :

 

[controllofiamma]

I go on the happy list thanking samu who did a great job

it is a wonder

 

[sniveri]

thank you all for your continous interestment and helping me out on my projects also if you have some free time take a look what else is at the sites. maybe something special could be offered for cad3d.it users

 

[sniveri]

new user interface cooked up. same kind of graphics added to other apps too. enjoy!