.csv not imported

.csv not imported

pics.munmun
Collaborator Collaborator
2,162 Views
10 Replies
Message 1 of 11

.csv not imported

pics.munmun
Collaborator
Collaborator

picsmunmun_0-1624861147635.png

I am importing an .xsv file in civil 3d. I have checked corresponding .txt file. It does not contain any blank lines. still i am not able to import it. I have autocad file where each point is a block and i used dataextraction command to extract block position x, position y and position z to csv format. But i cannot. May i knoe, what is the issue. Thank you in advance. 

0 Likes
Accepted solutions (3)
2,163 Views
10 Replies
Replies (10)
Message 2 of 11

Pointdump
Consultant
Consultant

Hi @pics.munmun,
Please post your point file.
Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2027
0 Likes
Message 3 of 11

Anonymous
Not applicable
Accepted solution

do you have the file open in a editor like excel?  point files will not import when open in another application.

Message 4 of 11

AllenJessup
Mentor
Mentor

If you can't post the entire file as @Pointdump asked. Please post a file with a few representative blocks.

Allen Jessup
CAD Manager - Designer
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

0 Likes
Message 5 of 11

tcorey
Mentor
Mentor

It looks like you have not set the Point File Format to match the incoming point file. In your screenshot, see the box where you can select Point File Format? This must match your incoming file. Go down the list of Point File Formats until the warning symbol - in the top box, next to the filename - goes away. Better than that, post your point file in this thread. Someone will recommend which format to select.

 



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Platinum Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
0 Likes
Message 6 of 11

Joe-Bouza
Mentor
Mentor

make sure the files saved as MS-DOS

Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

0 Likes
Message 7 of 11

Joe-Bouza
Mentor
Mentor

you will also get this error if your try to load it to c3d while you have it open

Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

0 Likes
Message 8 of 11

Udo_Huebner
Mentor
Mentor
Accepted solution

As you can see, your file contains unwanted characters at the beginning.

Udo_Huebner_0-1624903837376.png

 

It was saved with an encoding (I assume UTF-8) that Civil 3D Command IMPORTPOINTS does not yet understand.

Open the CSV file with the Windows editor NOTEPAD.EXE and save it again with an ANSI encoding (which @Joe-Bouza already mentioned).

Udo_Huebner_0-1624904145656.png

 

 

Gruß Udo Hübner (CAD-Huebner)
Message 9 of 11

Pointdump
Consultant
Consultant

Hi Udo,
Good eyes! I didn't notice that in the Screenshot.
Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2027
Message 10 of 11

Udo_Huebner
Mentor
Mentor
Accepted solution

Summary: If you created your CSV file from AutoCAD objects using the _dataextraction command, the file is UTF-8 encoded in current AutoCAD versions. Civil command IMPORTPOINTS, however, requires ASCII/Ansi encoded text files. So you need to prepare/re-save the export in a text editor like Notepad.exe before re-importing with IMPORTPOINTS.

 

Gruß Udo Hübner (CAD-Huebner)
Message 11 of 11

pics.munmun
Collaborator
Collaborator

My text file had a empty line at bottom and also the file format was not correct. 

 

Now my issue got solved.

 

Thanks All.

0 Likes