no point file format match found

[Anonymous]

english is not my first language, so i wil ltry to explain the best i can my problem.

i made a survey, about 2000 points with my TSC3\R6. I exported my CSV file to a PNEZD file with comma seperated. When i try ti import the file (CSV then i made a .txt), C3D tells me "no point file format match found". Then I opened the txt file, searched for any error that would not let me import my points. The only thing i have found would be the description of my points that sometimes had a space between 2 words (ex: bt balast and ht balast) so i changed it to bt-balast and ht-balast. i looked further and didnt found anything else. heres a sample of my txt file:

11251,5038721.804,370118.600,52.877,69
11252,5038722.437,370118.327,52.980,82
11253,5038725.381,370117.058,54.235,81
11254,5038725.967,370117.395,54.325,bt-balast
11255,5038727.637,370116.899,54.860,ht-balast
11256,5038728.983,370116.602,54.857,balast
11257,5038730.043,370116.150,54.839,ht-balast
11258,5038731.524,370115.635,54.345,bt-balast
11259,5038731.763,370115.674,54.308,81
11260,5038733.529,370114.961,53.606,82
11261,5038734.460,370114.525,53.505,350

Now i have to draw something but i cant even find why importing points fails in C3D.

some usefull informations maybe:

windows 7 32bits SP1

autocad civil 3d 2013 (not yet activated, next week)

thanks

simon

[Sinc · Accepted solution]

Is your CSV file open in Excel...?  That will cause the failure you're describing.  Pretty annoying, especially since the error message is so vague, but that's how I hit that message.

[antoniovinci]

Please attach here your .CSV file, so we may run through it.

[fritzbone]

I would leave it as a .csv file to import it. Also I would ensure there are no column headers in the file.

[Anonymous]

Simple, yet outstanding answer.  You just saved me a silly waste of time.  Thanks for the post!

[IamAwefulatCAD]

Why am I getting a no point file match found message when I try to import the below point file? I do not have the excel file open when I try to import. I see that there is a pre made point file format that matches my point file. I have tried creating my own point file format also. I have tried restarting and saving my .csv in diffent formats. I usually figure problems like this out on my own, but I have already wasted way to much time on figuring this out. TIA for any help or suggestions.

P1	13872200	2304791	596.765	Exist Sidewalk
P2	13872201	2304803	596.463	Exist Sidewalk
P3	13872202	2304813	596.237	Exist Sidewalk
P4	13872203	2304826	596.026	Exist Sidewalk
P5	13872204	2304838	595.721	Exist Sidewalk
P6	13872205	2304853	595.652	Exist Sidewalk
P7	13872206	2304865	595.812	Exist Sidewalk
P8	13872195	2304866	595.521	FARM PKG
P9	13872189	2304867	595.554	FARM PKG
P10	13872176	2304867	595.453	FARM PKG
P11	13872160	2304867	595.418	FARM PKG
P12	13872146	2304869	595.116	FARM PKG
P13	13872142	2304869	594.887	FARM PKG
P14	13872132	2304869	594.166	FARM PKG
P15	13872122	2304869	593.624	FARM PKG
P16	13872120	2304866	594.04	FARM PKG
P17	13872118	2304865	595.34	CHIMY PKG
P18	13872118	2304852	595.358	CHIMY PKG
P19	13872117	2304842	595.399	CHIMY PKG
P20	13872116	2304833	595.665	CHIMY PKG
P21	13872115	2304817	596.463	CHIMY PKG
P22	13872114	2304806	597.345	CHIMY PKG
P23	13872114	2304798	597.738	ALLEY
P24	13872124	2304796	597.598	ALLEY
P25	13872135	2304795	597.559	ALLEY
P26	13872147	2304794	597.51	ALLEY
P27	13872160	2304793	597.402	ALLEY
P28	13872172	2304792	597.261	ALLEY
P29	13872172	2304792	597.26	ALLEY
P30	13872183	2304792	597.083	ALLEY
P31	13872192	2304791	596.828	ALLEY
P32	13872200	2304791	596.319	NG
P33	13872201	2304808	595.955	NG
P34	13872202	2304822	595.954	NG
P35	13872204	2304838	595.708	NG
P36	13872205	2304853	595.626	NG
P37	13872205	2304862	595.494	NG
P38	13872180	2304793	596.868	NG
P39	13872181	2304811	595.86	NG
P40	13872184	2304837	595.407	NG
P41	13872187	2304848	594.951	NG
P42	13872186	2304853	595.471	NG
P43	13872170	2304857	595.155	NG
P44	13872170	2304835	595.435	NG
P45	13872167	2304821	595.745	NG
P46	13872166	2304810	596.063	NG
P47	13872165	2304801	596.818	NG
P48	13872164	2304794	597.252	NG
P49	13872147	2304795	597.067	NG
P50	13872148	2304804	596.038	NG
P51	13872148	2304815	595.846	NG
P52	13872149	2304826	595.578	NG
P53	13872149	2304839	595.268	NG
P54	13872149	2304848	595.116	NG
P55	13872130	2304796	597.314	NG
P56	13872130	2304799	597.928	ELEC BOX
P57	13872121	2304800	597.926	ELEC BOX
P58	13872122	2304810	597.933	ELEC BOX
P59	13872131	2304809	597.933	ELEC BOX
P60	13872131	2304809	596.322	NG
P61	13872122	2304810	596.597	NG
P62	13872117	2304812	596.601	NG
P63	13872118	2304822	595.578	NG
P64	13872120	2304841	594.82	NG
P65	13872120	2304852	594.94	NG
P66	13872121	2304862	594.592	NG
P67	13872133	2304867	594.243	NG
P68	13872133	2304862	594.619	NG
P69	13872134	2304850	595.266	NG
P70	13872133	2304840	595.187	NG
P71	13872133	2304830	595.274	NG
P72	13872149	2304855	595.274	NG

[Jeff_M]

Which PointFileFormat do you think should match your data, IamAwefulatCAD?

[autoMick]

You're better off to attach the CSV file rather than paste in to your forum post.

The only issue I could see was that you're point numbers include letters. So I created a point file format that just loaded them as a description field rather than 'point number'. I would rename your points, so that the 'P' is removed. Test your format by loading the file and parsing it using the buttons at the bottom of the format editing dialog box.

I can post some step by step instructions if you need.

Cheers

- Mick

[Jeff_M]

The PFF could also be set to use the PointName instead of Number, this allows the file to be imported as well. That's why I asked them what they expected...

[IamAwefulatCAD]

Removing the P from point numbers worked. Thanks again!

[lekosho2]

what was i doing wrong?

[Pointdump]

Olalekan,
Welcome to the Autodesk Forums.
Your GRV PK.csv point file has 6 columns: PNEZDD. If you concatenate the last two columns, then you can use a PNEZD file format. If you want them separate, then you'll need to create a UDP (User Defined Property).
Dave