Imported CSV Points twisted and changed from original data set

[Anonymous]

i found the information about scripts and add-ins concerning spline creation, tried it, the data points from Excel 2016 were changed both in number value and quadrant value. what should have been a hastily sketched closed spline circle was a twisted array of points with different locations. i tried a different spreadsheet from LibreOffice, the import worked but the exact same twisted spline. i tried a changed script so only points were imported. points only but in the same twisted pattern. I found an airfoil set of points and strangely, they imported correctly. How do i get fusion 360 to correctly arrange the data points? i have many screenshots if that will help. . .thanks dan

[davebYYPCU]

Airfoil data normally has a zero value for the plane it is imported to,

I would check the data in the csv, see if it is planar or not, has three columns of data, if it is a two column data file you could resonable expect your result

other than that it would normally plot points in order of the file.

some things to check.

[Anonymous]

thank you for your help:

i include two screenshots: 1 showing 3 data columns and the second showing airfoil download location. the 3 columns should produce a roughly circular shape, but don't. why does the airfoil import correctly and the 3 columns do not? the exact same three data columns were imported into another spreadsheet, imported into the spline script and produced the twisted result. what is the next step you suggest in problems solving?

[davebYYPCU]

No screenshots, yet.

[Anonymous]

I include three screenshots (this time): 1 showing spline curve around origin testing 4 quadrants and indicating dimensions for import. 2nd screenshot shows Excel and 3 columns of data with twisted import shape that should be an offset of original spline curve around origin- larger by 1 in., but the number "1" indicator shows the 1st coordinate set "-1.027, 1.297" is not correct and is listed in the measure tool with the incorrectly imported coordinates. the third screenshot shows i was looking for answers in the community under "importing csv" and found a file to test, an airfoil that was made with Excel. this test shows i was aware of how to import 3 columns and i found the airfoil imported correctly. After noticing the airfoil was correct, i thought using a different spreadsheet might indicate whether excel or fusion 360 with MY version of Excel, might be creating a problem importing data and displaying correctly. I used LibreOffice Calc sheet, copied 3 columns from Excel, imported using the ImportSplineCSV tool and the result was an exact replica of the twisted spline from Excel. The question remains: why did the airfoil import correctly, and the Excel and LibreOffice Calc spreadsheets not import correctly. Thank you for your interest. dan

[davebYYPCU]

I agree that the first point is not where it should be,

however plotting those listed points is correctly orientated,

I can see that the lines of data - line 2 to 5 imported correctly and the data is in error.  Line 4, is negative x, and following the lower of those top two curves,

orientate correctly for the first 5 lines I stopped checking about here.

Can't answer for the first point, but I would check all the values are in the right order,

might be a start

[Anonymous]

the first screenshot- [2017-02-28_17h50_46.png] shows a new sketch: a 1 in. square and a 1 in. circle as preliminary reference. Also on the right is a spreadsheetimage: spline test 1in. box_Excel with four points- one in each quadrant at 1in. x and 1in. y. The next screenshot shows what happens when i save as .csv file- I'm required to agree to something i may not fully understand. The third screenshot [2017-02-28_17h57_31.png] shows the Excel spreadsheet next to the original 1in. square  and 1in. circle. Overlaid, is a series of 4 points, (INSIDE the square)  demonstrating a problem with importing spline points with my Excel into Fusion 360, that is why I included the airfoil import test information as it indicates correct spline import using an Excel spreadsheet. I question why someone else can present an Excel file that imports correctly on my computer, and i cannot import correctly a .csv file whether i use Excel or LibreOffice Calc spreadsheet.

Thank you for your interest, dan