importing .csv

importing .csv

davidperry3
Contributor Contributor
7,495 Views
9 Replies
Message 1 of 10

importing .csv

davidperry3
Contributor
Contributor

When i try to import a .csv file it says fit points less than one. what is the fix? these are airfoil data points.

Accepted solutions (1)
7,496 Views
9 Replies
Replies (9)
Message 2 of 10

innovatenate
Autodesk Support
Autodesk Support
Accepted solution

All the CSV file should have in it is X, Y, and Z coordinates. Try using something like the attached file.

 

 

Hope that helps....

 

Thanks,

 

 

 




Nathan Chandler
Principal Specialist
Message 3 of 10

mike.alcazaren.Autodesk
Alumni
Alumni

This was great!  Thanks for the share!

 

I created a .docx workflow for this.

Message 4 of 10

davebYYPCU
Consultant
Consultant

I too have a use for airfoil data drawn splines, so far not been able to sucessfully run the import script

 

my own data has the "points lenght less than one error," (spelling corrected),

 

I am unable to import either of the thread's attached airfoil points csv files,

using a saved copy of Airfoil1.csv gives "type error: x must be a number".  I searched this file for the "x", and it does not appear in Excel's search result,

 

I even cleaned the N63412 file to just data points, didn't import correctly.

Very new to Fusion, Any help appreciated. 

0 Likes
Message 5 of 10

mike.alcazaren.Autodesk
Alumni
Alumni

Hi @davebYYPCU

 

Have you tried making sure that the excel data is in number format, and not text data?

 

Here's a screencast in action. http://autode.sk/1T8S4Im

 

Attached are two .csv files (P51 mustang and satellite geometry) that I've used succesfully on my machine.

 

Cheers,

 

Mike

 

 

 

Message 6 of 10

davebYYPCU
Consultant
Consultant

Thanks Mike,

 

Was my handling of the import wizard in Excell, your reply prompted me to make my own csv file as a test and it worked sucessfully,

it was a data format problem, my previous attempts only managed to convert the numbers to text, which was not obvious to me.  Don't use Excell much at all.

 

My data files are XY only, I added the Z column, and this will work for me.

All good, thanks.

Message 7 of 10

Anonymous
Not applicable

I am also having problems importing a csv file, I have three columns X Y Z, when running the script ImportSplineCSV the following error comes up "fit points lenth less than 1"

0 Likes
Message 8 of 10

naptalene
Observer
Observer

FWIW,

 

I had this error as well.

I was using Numbers on OSX  to add the Z "0" value to the downloaded airfoil and couldn't get it to import as described.

The CSV format exported from Numbers added in semi-colons instead of commas between the X,Y&Z values.

I manually converted these to comma's and the import was perfect.

 

Is there a setting/format to choose when exporting CSV files?

Is there a script that will use the version with ";" seperatorsand not require manual editing?

 

Thanks.

0 Likes
Message 9 of 10

Anonymous
Not applicable

The values ​​must be in the format 9.999999,9.999999,9.9999999 and should be in a single column in excel.

The format of the column should be General.

Then just import with the ImportSplineCSV application from Fusion 360.

Message 10 of 10

philwmcintosh
Enthusiast
Enthusiast

I have 3 columns (XY&Z) and it works just fine

0 Likes