1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Script Release: Update Table_to_3DPoints_forum_V03

Discussion in 'Alibre Script' started by idslk, Jul 25, 2020.

  1. idslk

    idslk Alibre Super User

    Edit: Update to V03:
    # V03 does no longer create copies of points, instead it changes their coordinate values
    # the ee-parameter get the name of the point and an extension for the axis
    # table cells now can also contain formulas

    Hello colleagues,

    if you have a table like that:
    upload_2020-7-25_15-18-2.png
    and you want to get the coordinates to be reference points in your design,
    you can use the appended script (Table_to_3DPoints_forum_V01.py)
    If you start the script in a fresh design (no matter of assembly or part),
    you will be promted to select a spreadsheet file in xlsx format.
    upload_2020-7-25_15-18-42.png
    A demo data file is appended to this post (coordinate_table.xlsx as a zip file because xlsx is not in upload selection...)
    If you cancel the loading process, you will be informed in the console:
    upload_2020-7-25_15-18-57.png
    If you proceed with a valid solution, you will get the following in formation in the console:
    upload_2020-7-25_15-19-12.png
    and the results in the design
    upload_2020-7-25_15-19-43.png
    and explorer window
    upload_2020-7-25_15-19-29.png
    If you start the script a second time with the same spreadsheet file
    or with a spreadsheet file which contains points with same names,
    the script will add the information "-copy" to the "new" point name.
    You will get regarding informations in the console:
    upload_2020-7-25_15-19-58.png
    and explorer window
    upload_2020-7-25_15-20-12.png
    of course the new points will also be created in the design.
    The format of the spreadsheet table has to be the same as in the demo data!
    Ofcourse you can add more points with different names.
    The names should contain only valid characters for alibre!
    The units of the x,y,z coordinates should match your design units!
    "And as ever": Use at your own risk!

    Regards
    Stefan
     

    Attached Files:

    Last edited: Jul 31, 2020
    GIOV, MKR and Eddy So like this.
  2. Lew_Merrick

    Lew_Merrick Alibre Super User

    Hi Stefan -- I have run into thus and second this as a Request to Alibre to update the forum! -- Lew
     
  3. GIOV

    GIOV Alibre Super User

    Hi Stefan,
    Thanks very much for the tool's scrip. I will run a complex 3D ref Point that I have and I will do the comparison with Alibre Points and Splines (That doesn't has for assemble WorkSpace!) that takes more than 30 minutes in the 3D point set. Also will be great if the script do a continuous connection with the spreadsheet so the feasibility to update directly the reference points and therefore the 2D&3D curve from any point changes of the spreadsheet like the Alibre Design Add-in or GP(Variables)or AlibreOOConnect. It may be that I'm asking a lot...
    Thanks in advance!
    GIOV

    Edited: Alibre Points and Spline, takes
     
    Last edited: Jul 25, 2020
  4. GIOV

    GIOV Alibre Super User

    Hi Stefan,
    You scrips run faster than Alibre Points & Spline. It Takes only 1 minute in all points instead of more than half hours in my set of points.
    Big achievement.
    upload_2020-7-25_21-17-29.png
     
  5. GIOV

    GIOV Alibre Super User

    upload_2020-7-25_21-45-18.png
     
    MKR likes this.
  6. idslk

    idslk Alibre Super User

    Hello @GIOV ,

    i've updated the script as described in the start post on top of the thread.
    After reading in the attached table, the EE Editor looks now like:
    upload_2020-7-31_17-17-30.png
    if you run the script a second(or third...) time, the points with a same name will get a coordinate update from the tabel data, the points with new names will get added.
    It's not an active link to the table, but i hope it points in the right direction:)

    Regards
    Stefan
     
  7. GIOV

    GIOV Alibre Super User

    Yes Stefan, You run in absolute right direction:)
     
  8. GIOV

    GIOV Alibre Super User

    Stefan,
    Big,biggggg achievement!!
    Congrats!
    GIOV

    upload_2020-7-31_21-17-53.png
    upload_2020-7-31_21-30-16.png
    upload_2020-7-31_21-38-38.png
     
    Last edited: Aug 1, 2020
  9. GIOV

    GIOV Alibre Super User

    To be honest Andy gave the basis for this achievement whit its WizoScript.
    Thanks Andy too!
    Regards,
    GIOV

    Edited.
     
    Last edited: Aug 1, 2020
  10. GIOV

    GIOV Alibre Super User

    Hi Stefan,
    I running your script in my 64 laptop but I have other one that is 32 bits with old AD version & WizoScript 4.10 build 760:
    Can you translate the scrip Table_to_3DPoints_forum_V03 to this old WizoScript version?
    upload_2020-8-2_17-2-59.png
    Thanks very much in advance,
    GIOV

    Edited
     
  11. idslk

    idslk Alibre Super User

    Hello Giovanni,

    i haven't used WizoScript. If you try to run the script on your old machine, which error is thrown?

    Regards
    Stefan
     
  12. Lew_Merrick

    Lew_Merrick Alibre Super User

    Hi Giov -- I suspect that your issue lies with the "difference" (ass-you-me'd on my part) between WizoScript and AlibreScript. Andy Ayres was the person behind WizoScript (thanks Andy) and Alibre is the group behind (with Andy's assistance, I am sure) AlibreScript. ??? -- Lew
     
  13. GIOV

    GIOV Alibre Super User

    Hi Stefan,
    Here are two screen pic that show the existing issue:
    Before run
    upload_2020-8-3_9-1-21.png

    After 5 attempts to run it:

    Traceback (most recent call last):
    File "<string>", line 15, in <module>
    NameError: name 'CurrentPart' is not defined
    >>>
    upload_2020-8-3_9-3-31.png
    I hope you find the solution.
    Thanks in advance!
    GIOV
     
  14. GIOV

    GIOV Alibre Super User

    Hi Stefan,
    For your knowledge,your CubicSpline script run in WizoScript 4.10.
    I loaded the WizoTool 4.10 in resource, so you are able to download it.
    Thanks in advance,
    GIOV
     
  15. idslk

    idslk Alibre Super User

    Hello Giovanni,
    as far as AlibreScript has gotten a few updates after the WizoScript times, i have to see if there is an "easy" way...(parts maybe work, assemblies need more tweak...)
    Andy has removed it from the net with full intention...
    There has been a post in the past, where he points to this.
    So i won't install or use it.
    Regards
    Stefan
     
  16. GIOV

    GIOV Alibre Super User

    Thanks so much for your effort!

    Regarding to these topic; I understand Andy did the Wizotool with the focus in small business service and the agreement give clearly that is Free when the company size is less than 10 people. My company run with myself and my wife so I am in the rang to used this as free without obligation to keep the Alibre maintenance. Otherwise enter to a monopoly and is clear not the "Alibre"" Liber" service philosophy to give support to small business specially in this time. So I think in Alibre resource is right to have this zipped Wizotool.
    Andy write in python: Free language by Guido van Rossum. Andy only develop the plug-translation between the language and Alibre software.Is not the full owner. He gives a service, Great service, but it is a service like Guido.
    If Alibre staff don't take off the resource this means they agree with my point of view. "Si autem e contrario ipsi turpe"

    https://www.python.org/

    However feel free to do not download it and keep your effort in solve the issue with your side.

    Thanks in Advance!
    GIOV
    Edited
     
    Last edited: Aug 5, 2020
  17. GIOV

    GIOV Alibre Super User

    Well if Andy is still giving assistance to AlibreScript will be great that the last Wizotool 4.10 (run in 32 bits) as Alibre Source may be able to run 2D &3D Point. If not anyway thank very much for the effort and achievements especially to Stefan, Andy and AD.
    =If(Wizotool 4.10,Wizotool 4.10, AlibreScript).
    Regards,
    GIOV
     
  18. Lew_Merrick

    Lew_Merrick Alibre Super User

    Hi Giov -- I "feel" (but do not know) that Andy is still involved. We do need to ensure that an appropriate base for his "statue" in the "Alibre Hall of Heroes" is waiting the "statue's arrival!" -- Lew
     

Share This Page