Problem with import of CSV.file to make topo

Problem with import of CSV.file to make topo

Even91
Explorer Explorer
1,113 Views
8 Replies
Message 1 of 9

Problem with import of CSV.file to make topo

Even91
Explorer
Explorer

Hei.

 

I am having a problem to import CSV.file to make a toposurface of it.

Have tried some of the suggestions on the forum but nothing seems to work out for me.

for example dot to comma

What can i try?

 

CSV.file atteched here.

0 Likes
Accepted solutions (1)
1,114 Views
8 Replies
Replies (8)
Message 2 of 9

jay_colcombe
Mentor
Mentor

You possible need to review the file as there are semicolons and Numbers as Text

 

jay_colcombe_0-1696495356650.png

 

It needs to look like this

 

jay_colcombe_1-1696496222352.png

How are you creating the CSV?

 

 

Jay Colcombe

Autodesk Certified Instructor
Revit Architecture & Structure Certified Professional
AutoCAD Certified Professional
B.Sc. Hons Civil & Structural Engineering

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
0 Likes
Message 3 of 9

Even91
Explorer
Explorer

hey and thanks.

Do not know why you get it as there, but mine is like this.

Have used both dot and comma

 

Even91_0-1696496005895.png

 

0 Likes
Message 4 of 9

jay_colcombe
Mentor
Mentor

Can you send this file please

Jay Colcombe

Autodesk Certified Instructor
Revit Architecture & Structure Certified Professional
AutoCAD Certified Professional
B.Sc. Hons Civil & Structural Engineering

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
0 Likes
Message 5 of 9

Even91
Explorer
Explorer

The file is attached. 

0 Likes
Message 6 of 9

jay_colcombe
Mentor
Mentor

I opened a Blank Excel Sheet, Data Tab> From Text/CSV > Semicolon  Saved it out and deleted the header row

 

jay_colcombe_0-1696499255466.png

 

Looking down the list some of these number do not look right but is allowed me to import it into Revit but killed my Laptop and hung which i was expecting due to the variations in values in the columns but it did come in eventually

 

jay_colcombe_1-1696500498111.png

 

Jay Colcombe

Autodesk Certified Instructor
Revit Architecture & Structure Certified Professional
AutoCAD Certified Professional
B.Sc. Hons Civil & Structural Engineering

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
0 Likes
Message 7 of 9

Even91
Explorer
Explorer

I tried the same as you now, but got the same result as before

0 Likes
Message 8 of 9

jay_colcombe
Mentor
Mentor
Accepted solution

There is definitely something not right as i cannot repeat your images with that file and you can not follow my process.

 

Here is the file i can create a Topo with (this was generated from your file as above)

 

 

Jay Colcombe

Autodesk Certified Instructor
Revit Architecture & Structure Certified Professional
AutoCAD Certified Professional
B.Sc. Hons Civil & Structural Engineering

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
0 Likes
Message 9 of 9

Even91
Explorer
Explorer

Thanks.

 

Had to manually make the x,y,z cordination in one coloumn on several rows and replace ";" with ",".

Worked fine with a new file.

 

Even91_0-1696569893933.png

 

0 Likes