What's new

Script Release: Update Table_to_3DPoints_forum_V03

idslk

Alibre Super User
I've tried it both ways, headers, no headers, same results.
First Row is a Header
First Column has to be filled with Pointnames.
Everything as it is in the provided demo table...

Regards
Stefan
 

Attachments

  • 1376002_plotting_3.zip
    6.6 KB · Views: 10

laverne3ca

Senior Member
First Row is a Header
First Column has to be filled with Pointnames.
Everything as it is in the provided demo table...

Regards
Stefan
I think I see where I went wrong, the Pointnames must be capitalized, at least when I changed them on my file it worked.
Thanks for the help!
 

idslk

Alibre Super User
Hello laverne3ca,

i'm glad to hear that it works for you now, but for the comleteness: It is not necessary to uppercase names, at least there has to be a column with names.
If there are no names, it will be not possible to do a correct update, if you change the point values in your table and let the script run again to change your design to the new values for the "same" points.

Regards
Stefan
 

GIOV

Alibre Super User
Hi Stefan,
Your script Update Table_to_3DPoints V03 doesn't run into my ADV23.
What I doing wrong?
This added script ran great until AD22.
Thanks in advance!
GIOV
 
Last edited:

idslk

Alibre Super User
What I doing wrong?
i really don't know...
You've posted no error messages or anything else to examine...
Here at my computer (tested right now) the script runs fine on Alibre V23 (Build 23055)

Regards
Stefan
 

GIOV

Alibre Super User
Hi Stefan,
Thanks for your answer.
I hope you have not been affected by the floods in Germany due to the heavy rain.

Here is the message:

Alibre Script build 343305
IronPython 2.7.10.0 Interactive Console
For documentation visit http://docs.python.org/2.7
The complete standard library is available

Console commands available:
history : Prints history of entered commands
cls : Clears the screen
help : Shows the list of console commands
run : Executes the current script
run arg1 arg2 : Executes the current script, pass arguments
run "scriptname" : Executes a specific script
run "scriptname" arg1 arg2 : Executes a specific script, pass arguments

>>>
Header found. Start creating 3D-Points.
Header: Name x y z
Create new Point
Adjusting Point parameter names...
Create new Point
Adjusting Point parameter names...
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
x adjusted, y adjusted, z adjusted
Create new Point
Adjusting Point parameter names...
Traceback (most recent call last):
File "<string>", line 76, in <module>
File "<string>", line 57, in points
EnvironmentError: System.Runtime.InteropServices.COMException (0x80040213): Invalid name given for Parameter.
at com.alibre.automation.AlibreParameter.set_Name(String value)
at CallSite.Target(Closure , CallSite , Object , Object )
at Microsoft.Scripting.Interpreter.DynamicInstruction`3.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.LightLambda.Run5[T0,T1,T2,T3,T4,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4)
at Microsoft.Scripting.Interpreter.DynamicInstruction`7.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.LightLambda.Run2[T0,T1,TRet](T0 arg0, T1 arg1)
at IronPython.Compiler.PythonScriptCode.RunWorker(CodeContext ctx)
at Microsoft.Scripting.Hosting.ScriptSource.Execute(ScriptScope scope)
at AlibreScript.UI.IronTextBoxControl.#P2b(Object #Dp)
Here is a Screen-pic of the typical points that I have in my excel which ran well in the last ADV22.. measures in mm.
upload_2021-7-16_9-1-54.png
The assemble only gives the point that was identified:
upload_2021-7-16_9-4-33.png
 

GIOV

Alibre Super User
Hi Stefan,
I suspect that my issue is that, the version V02 was a statics point so each point not necessary to be identified, but the V03 is editable point, so each point must identify. So I will put to every point identification as example Gunwale_Fr1.. Etc
 

GIOV

Alibre Super User
Hi Stefan,
Glad you are not affected by the floods.
Yesss,
It is confirmed:
In the last version of the script, each point must be identified! because with V01 run without problems. Measures this time is in m. but excel input in mm. So before run Stefan script: Properties >Units>m. Ok.
upload_2021-7-16_11-24-47.png
upload_2021-7-16_11-26-51.png
 
Last edited:

galaxyngc1672

New Member
I thought I would share what I was able to create using this script. I create a loft from all the points to create complex cooling channel geometry.
 

Attachments

  • Loft.png
    Loft.png
    85.6 KB · Views: 37
  • Thunderchild.png
    Thunderchild.png
    240.5 KB · Views: 37

laverne3ca

Senior Member
Problem again. Once again I get the error, "No Header found. Terminate loading!" As far as I can tell, I have the format of the .xlsx file correct, I just can't see what I'm doing wrong!

I set up the file the way I think is correct but no luck! I'm using Libreoffice and saving the xlsx file but I used it the last time I used the script. Even added a Z 0 column, no difference.
xlsx.jpg


Alibre Design™ Expert
Version: V26 64-bit [Build 26040]
 

Attachments

  • Untitled 1.zip
    17.9 KB · Views: 3
Last edited:

idslk

Alibre Super User
You've used at "A1" "NAME" instead of "Name" and you have to have a "Z" coordinate even it is "0" (It's about 3D-Points... :) )
1673048590055.png

Regards
Stefan
 

laverne3ca

Senior Member
Thanks Stefan, still no joy, I changed capitalization on the Name, added Z coordinates (0) and opened in a 3D workspace but still get an error

Alibre Script build 346060
IronPython 2.7.10.0 Interactive Console
For documentation visit http://docs.python.org/2.7
The complete standard library is available

Console commands available:
history : Prints history of entered commands
cls : Clears the screen
help : Shows the list of console commands
run : Executes the current script
run arg1 arg2 : Executes the current script, pass arguments
run "scriptname" : Executes a specific script
run "scriptname" arg1 arg2 : Executes a specific script, pass arguments

>>>
Header found. Start creating 3D-Points.
Header: Name X Y Z
Create new Point
Adjusting Point parameter names...
Create new Point
Adjusting Point parameter names...
Create new Point
.
.
.
.
Adjusting Point parameter names...
Create new Point
Adjusting Point parameter names...
Create new Point
Adjusting Point parameter names...
Traceback (most recent call last):
File "<string>", line 72, in <module>
SystemError: Object reference not set to an instance of an object.
 

Attachments

  • Untitled 1.zip
    19 KB · Views: 2

idslk

Alibre Super User
Thanks Stefan, still no joy, I changed capitalization on the Name, added Z coordinates (0) and opened in a 3D workspace but still get an error
I've tried with your original file and got the same error.
Then i opened the file, marked only the filed cells, copied them and inserted them into a new file and used this as data for the script:
1673080826320.png

It seems that there is "something" in your file that makes openpyxl think there is more data than what is visible...
(I've also used LibreOffice)

Regards
Stefan
 

Attachments

  • Untitled5.zip
    18.7 KB · Views: 2

laverne3ca

Senior Member
Really strange, I ran your file and didn't get an error message but also didn't get points displayed.
I did a complete shut down of all running programs and a restart with no change.
I ran the file from the project earlier in this thread and got the same results.
There have been no hardware changes in the computer.


Alibre Script build 346060
IronPython 2.7.10.0 Interactive Console
For documentation visit http://docs.python.org/2.7
The complete standard library is available

Console commands available:
history : Prints history of entered commands
cls : Clears the screen
help : Shows the list of console commands
run : Executes the current script
run arg1 arg2 : Executes the current script, pass arguments
run "scriptname" : Executes a specific script
run "scriptname" arg1 arg2 : Executes a specific script, pass arguments

>>>
Header found. Start creating 3D-Points.
Header: Name X Y Z
Create new Point
Adjusting Point parameter names...
Create new Point
Adjusting Point parameter names...
.
.
.
.
>>>
 
Top