The goal for me is to avoid going through catia's surface workshops (FreeStyle, GSD, DSE...) and to be able to send the point cloud directly from excel to Catia and directly obtain curves or a 3D model.
The manual operation of drawing the curves on the cloud is time-consuming and the quality is not optimal. I wonder if any of you have any ideas or know of a script (macro) that will allow you to do this.
Thank you in advance.
Hello @ Chaymae Garrouj
I can't help you with your Problem but out of pure curiosity how do you generate points in excel.
I guess you define each point XYZ in relation to a coordinate system. So how do you tell Excel in a cell that "such and such a point at such and such a value" knowing that it's easy to give several dozen pieces of information in a single cell.
Subsidiary questions where do you get the information on a point.
I ask the question because we regularly have questions about point clouds in the context of reverse engineering.
Kind regards
Hello @zozo_mp,
The point cloud is obtained through a 3D laser measurement.
For the cloud, if it's large, you can go through LTF viewer (3 coordinates -> 3 columns) (then export them to excel)
Kind regards.
@eng_sam
Thank you, I will fall asleep more educated tonight. ;-)
In Solidworks there are additional functions or parts of programs that allow you to integrate the stitches directly without going through excel.
It's curious that Catia 300 times more sophisticated than SW doesn't have such a tool ;-)
Kind regards
@zozo_mp
On Catia, there is a DSE (Digitized Shape Editor) workbench that allows you to import a cloud in different formats. (.pts...) then work it (meshing). Except that for the application I need, this operation is very time-consuming.
I don't want to work the whole cloud, I'd like to send the cloud directly and have the model on catia
Kind regards.
Hello, you will find the items under the CATIA installation folder
C:\Program Files\Dassault Systèmes\B27\win_b64\code\command
Edit B.. it's the installed version (B27 for me)
And videos on Youtube
https://www.youtube.com/watch?v=rANeR6cTJW8
Edit ; The files you have to copy were not very clear on the image
GenerateProcessIDSample.CATScript
GSD_PointSplineLoftFromExcel.xls
Hello @franck.ceroux
Thank you very much for your answer, I have the impression that your method will work, I will keep you informed after the test.
Just to make sure I've understood everything because I'm not good at info, I have to copy these files where please?
And with that I will be able to have a 3d model directly from the points on excel?
Thank you in advance.
Kind regards.
Locally on "my documents for example" it's to avoid modifying the Dassault sources if you have the writing rights under "C"
This macro directly creates the points and then the curve(s) in CATIA.
You have to enter the point values in the order for the curve to create correctly, it must be feasible from your metrology source, you must surely be able to sort the different scans that will correspond to the curves
the first column X then Y then Z
Hello @franck.ceroux
Indeed your method has helped me a lot, it's the first time I've discovered it.
Now I just need to know how to choose the coordinates of my curves in order to have the right splines (because I only have a point cloud).
Thank you very much.
Yours sincerely.