topic Re: importing .csv in Fusion Design, Validate & Document Forum

importing .csv

davidperry3 — Mon, 15 Dec 2014 19:54:48 GMT

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

Re: importing .csv

innovatenate — Mon, 15 Dec 2014 21:02:16 GMT

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,

Re: importing .csv

mike.alcazaren.Autodesk — Thu, 30 Apr 2015 19:13:10 GMT

This was great! Thanks for the share!

I created a .docx workflow for this.

Re: importing .csv

davebYYPCU — Thu, 22 Oct 2015 10:27:37 GMT

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.

Re: importing .csv

mike.alcazaren.Autodesk — Thu, 22 Oct 2015 15:02:25 GMT

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

Re: importing .csv

davebYYPCU — Thu, 22 Oct 2015 23:35:02 GMT

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.

Re: importing .csv

Anonymous — Wed, 16 Nov 2016 14:39:24 GMT

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"

Re: importing .csv

naptalene — Thu, 15 Dec 2016 07:55:38 GMT

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.

Re: importação de CSV

Anonymous — Sun, 26 Nov 2017 21:46:16 GMT

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.

Re: importação de CSV

philwmcintosh — Wed, 16 Dec 2020 02:32:30 GMT

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