Autocad Values To Revit Topography

[okutany]

Hello everybody, 

I am trying to export autocad datas to revit to create topography in revit. However I always have "no points were found in the file revit" error. I attached .csv file I exported from AutoCAD by dataextraction. Can you help me please?

Edit: I also attached ss if you can't see same excel table in any case. This is how my excel file looks like.

[barthbradley]

your csv file is not formatted correctly.  Needs to be x, y, z values separated by commas.   

BTW: this is the toposurface that I get from your data.  I'm sure this can't be right.  You sure about your data? 

...my guess is that your DATAEXTRACTION included other elements.  I would suggest doing another.  

[RDAOU]

@okutany 

Based on the Excel image you have posted, it looks like you are using European system settings where the delimiter in the CSV is a semicolon to avoid conflict with the comma used as decimal separator

• Before you export from Autocad, you should change the decimal symbol and digit groupings ...you can do that under File >> Options >> Advanced tab >> Editing options and clear the Use system separators check box.
• Then use a period/point for Decimal separator and blank for Thousands separator. Alternatively you can change the system separators again should you prefer.

For the semicolon delimiter in the .csv, either change it in the export settings to use UFT8 with comma delimiter OR if you want to keep these setting, open the CSV in notepad++ and use Find/Replace ; with ,

Should look something like the following

[okutany]

I see what I did wrong. The file format must be .csv but I exported as xls. Also, I did flatten and moved all coordinates close to 0,0. By this I got rid of big values such as 444000,124000 x,y coordinates. Finally UTF-8 with commas is the last operation to import correctly into Revit. Thank you all for you help.

[RDAOU]

@okutany 

Big values are not necessarily an issue as long as they fall within the 20 miles limit. The issue is more related to the .csv file and the mix up between comma and semicolon and the decimal and the comma. 

Using move to relocate the points just to get rid of big values is actually bad. If the points are too far outside the 20 miles limit, you do not move them, you re-reference them to a different/closer grid.