Script Release: Update Table_to_3DPoints_forum_V03

[laverne3ca]

As per the top post, you need to have a header line as line 1. Both your files are missing this.

I've tried it both ways, headers, no headers, same results.

 

[idslk]

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

 

[laverne3ca]

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]

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]

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

 

[idslk]

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]

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.

The assemble only gives the point that was identified:

 

[idslk]

I hope you have not been affected by the floods in Germany due to the heavy rain.

Thankfully not.

Would you mind uploading the table file?

Regards
Stefan

 

[GIOV]

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

 

[idslk]

I suspect that my issue is that

Than every thing is ok for me...

Regards
Stefan

 

[GIOV]

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.

 

[GIOV]

Thanks Stefan!

 

[galaxyngc1672]

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.

 

[laverne3ca]

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.



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

 

[idslk]

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... )


Regards
Stefan

 

[laverne3ca]

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.

 

[idslk]

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:


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

 

[laverne3ca]

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...
.
.
.
.
>>>

 

[laverne3ca]

Deleted, copy.

 

[idslk]

didn't get points displayed.

have you checked your view stettings?


Regards
Stefan