Link for downloading airfoil coordinates - airfoiltools.com/ Link for downloading the special file for importing the coordinates - mechstuff.com/how-to-import-airfoil-coordinates-from-excel-to-catia/ Keep learning ;)
Thank you very much. There is a very important detail not precise in the video: THE Generative Xls file MUST BE in the same emplacement as the CATIA file. If not, the macro will display an error and fail to import points to CATIA. This happened to me, I have understood the problem later. I share the idea with whose are concerned by this problem.
This tutorial is great and it worked for my R21 catia release, but in R28 version is not working. After i click "ok" in macro, it shows up a table writing: "Microsoft Visual Basic for Aplication License information for this component not found. You do not have an appropriate license to use this functionality in the design environment." Please do you know which license is required for this operation ?
I want to trim a specified portion of the imported airfoil in Catia but the trim option seems not working(nor the eraser)....any idea what to do as I need to put a stepping on the aerofoil for analysis
Dear Jay, I have a problem: on the aforementioned website to have the coordinates of the airfoils, the X and Y coordinates are coming together, in the same cell (example: 100.957,-0.9587). How do you make the coordinates come in different cells? Thanks in advance for your time.
I am trying to import this airfoil to ansys from catia after did some modification, should I fill the profile and import these as an surface to ansys to do make cfd analysis??
Yes.. Exactly! Extrude the profile and export it to ANSYS if you want to simulate a 3D wing OR just the fill the profile to make it as surface for carrying out a 2D simulation.
Sir I am create a part in part design but this part I want to transfer to DMU kinematics but the part are not transfer . when I open DMU kinematics New Page are open and I see the windows options that time this part are see but that part I am not worked
@@РусланПагоня Hi, I found out that "type mismatch" error is linked to the fact that the "." operator in the numbers impact the fact that the cells are considered as text and not as numbers. To avoid that just select all the list and click on the warning sign + click on convert to number. Then launch the macro, it now shoul dbe working. Hope i helped you.
Hi! I had this problem too, i make some movement like the: reopen Catia file na save him, after that i convert text to columns wizard. After that i have another problem with "type mismatch".
I know I'm late, I leave this here for the future. Just found the solution to that. You probably are not inside the part. You have to have the part open in catia. Check if for example you have the product open (instead of the part).
Hello, when you click on any airfoil, you'll see an option named - "Send to airfoil plotter" on the right side. After that, click on download "CSV file of coordinates" There you go :D
Hello, that's an error related to Excel/MS Office. I am sorry, but I haven't come across it ever. Try re-installing your MS Office (if you have downloaded it or using pirated version). Else you can look about it here - stackoverflow.com/questions/30539623/excel-giving-system-error-h80004005-2147467259-unspecified-error-message#:~:text=I%27m%20almost%20100,think%20it%20worked!
@Farhan @Ratna The macro code you are talking about is a separate Excel file you need to download. You can download it from my blog, I have given the link in the description.
Link for downloading airfoil coordinates - airfoiltools.com/
Link for downloading the special file for importing the coordinates - mechstuff.com/how-to-import-airfoil-coordinates-from-excel-to-catia/
Keep learning ;)
Thank you very much. There is a very important detail not precise in the video: THE Generative Xls file MUST BE in the same emplacement as the CATIA file. If not, the macro will display an error and fail to import points to CATIA. This happened to me, I have understood the problem later. I share the idea with whose are concerned by this problem.
Hi , and how do i do that ?
Can you please elaborate on the location of the file?
This tutorial is great and it worked for my R21 catia release, but in R28 version is not working. After i click "ok" in macro, it shows up a table writing:
"Microsoft Visual Basic for Aplication
License information for this component not found. You do not have an appropriate license to use this functionality in the design environment."
Please do you know which license is required for this operation ?
WOW ! You are monster ! Awesome work , Thanks a lot ! I have CATIA v5 R30. All works perfect !!!
thx so much awesome explanation! I was using spline and linking all of the points before watching this video :D
I m getting object doesn't support this property or method,what to do?
same here
@@karnirathore9853 something is off about this tutorial. some steps were skipped
I got the same error.
I closed the product file and opened a part file and then it worked fine for me...
is there a way to commect all the points with lines instead of sp;ine?
I want to trim a specified portion of the imported airfoil in Catia but the trim option seems not working(nor the eraser)....any idea what to do as I need to put a stepping on the aerofoil for analysis
Can you show me how to create a marco and then put the command into CATIA, please?
Dear Jay, I have a problem: on the aforementioned website to have the coordinates of the airfoils, the X and Y coordinates are coming together, in the same cell (example: 100.957,-0.9587). How do you make the coordinates come in different cells? Thanks in advance for your time.
You can check how to split values in Excel
Is there a way to modify the script and allow for more than just 500 points to import at once? I am looking to import around 350,000 points
Perhaps. I am not sure. You can try and let us all know:)
Sir how can I important the airfoil as an angle with respect to y axis?
you can use airfoil plotter in airfoiltools for define twist angle
I am trying to import this airfoil to ansys from catia after did some modification, should I fill the profile and import these as an surface to ansys to do make cfd analysis??
Yes.. Exactly! Extrude the profile and export it to ANSYS if you want to simulate a 3D wing OR just the fill the profile to make it as surface for carrying out a 2D simulation.
How do you get to see these points after running macros?
Sir I am create a part in part design but this part I want to transfer to DMU kinematics but the part are not transfer . when I open DMU kinematics New Page are open and I see the windows options that time this part are see but that part I am not worked
I have been getting a "type mismatch" error in the exel , no idea What's refering to
Hi! Now you now the solution?
@@РусланПагоня Hi, I found out that "type mismatch" error is linked to the fact that the "." operator in the numbers impact the fact that the cells are considered as text and not as numbers. To avoid that just select all the list and click on the warning sign + click on convert to number. Then launch the macro, it now shoul dbe working. Hope i helped you.
@@mastertiti2759 I can't check it now, but I really thankful to you!
When I run Macros, a 'Microsoft Visual Basic' dialog box with a message "Object doesn't support this property or method". Can anyone help???
Hi! I had this problem too, i make some movement like the: reopen Catia file na save him, after that i convert text to columns wizard. After that i have another problem with "type mismatch".
@@РусланПагоня Did you manage to solve it finally?
I know I'm late, I leave this here for the future.
Just found the solution to that. You probably are not inside the part. You have to have the part open in catia. Check if for example you have the product open (instead of the part).
I had the same issue.
Closed the product file and opened a product file. Then it worked fine for me...
hello, im face an issue. I am able to import the geometry to catia V5 but not the points along with spline. pls help
Me too. I solved by viewing Macros again and choosing CreationSpline instead of Main
@@meryemtemiz2151 it says object doesnot support this property...im in part design
@@meryemtemiz2151 it says object doesnot support this property...im in part design
i would like to know how you do a solid in the last part of the video ???
Hello Riad, you asked & here it is - th-cam.com/video/8nNGjFvoQK8/w-d-xo.html :)
@@MechStuff thank u very much. U're the best
In naca profile tools where is the option to download the coordinates
Hello, when you click on any airfoil, you'll see an option named - "Send to airfoil plotter" on the right side.
After that, click on download "CSV file of coordinates"
There you go :D
@@MechStuff that was big help for me thanks bro
How to export 3d coordinates?
Hello, I don't think that its quite possible.
You will have to extract coordinates at multiple locations/sections.
How to get coordinate
airfoiltools com
Here is the one I used in the video - airfoiltools.com/airfoil/details?airfoil=naca2411-il
sir can you help me please, for the "2" option i cant put curve in catia, it says "System Error & H80004005 (-2147467259). Unspecified error"
Hello, that's an error related to Excel/MS Office. I am sorry, but I haven't come across it ever. Try re-installing your MS Office (if you have downloaded it or using pirated version). Else you can look about it here -
stackoverflow.com/questions/30539623/excel-giving-system-error-h80004005-2147467259-unspecified-error-message#:~:text=I%27m%20almost%20100,think%20it%20worked!
@@MechStuff i have found the solution sir,its cuzc of the point is like in the same line, i just need to lessen the number of coordinates
I do not have any macron code written in my excel then what should i do
Sorry, I didn't quite exactly get your problem :(
@@MechStuff How to get the codes? that you used, same question
@Farhan @Ratna The macro code you are talking about is a separate Excel file you need to download. You can download it from my blog, I have given the link in the description.
sir in my excel it is shoing subscript out of range in excel and my program is not running in catia ? what to do sir
Bro did you get any solution
@@vishwasshetty4858 yes bro i had generated using macro in catia see my video