topic Re: "Column 'PI y' does not belong to table" Error in Civil 3D Forum

"Column 'PI y' does not belong to table" Error

ekoneo — Tue, 09 Oct 2018 10:51:20 GMT

Hi,

I get "Column 'PI y' does not belong to table" error when I am exporting some feauturelines that are created from corridor, as leica infrastructure .xml file. Normally I can transfer corridor featurelines however, if the corridor's aligment has a spline I get this kind of error. Anybody has any suggestion?

Thanks.

Re: "Column 'PI y' does not belong to table" Error

tcorey — Tue, 09 Oct 2018 14:09:32 GMT

I suggest you don't use splines in alignments. How do you even get an alignment to accept a spline as a sub-entity?

Or did you mean spiral?

Re: "Column 'PI y' does not belong to table" Error

ekoneo — Tue, 09 Oct 2018 17:06:43 GMT

Sory tcorey you are right I thought as spiral but I wrote spline

I used spiral as a subentity.

Re: "Column 'PI y' does not belong to table" Error

tcorey — Tue, 09 Oct 2018 21:45:37 GMT

In that case, you should consider contacting Leica support, as this is their command.

Re: "Column 'PI y' does not belong to table" Error

ekoneo — Mon, 15 Oct 2018 12:30:20 GMT

I already asked Leica. But they didnt reply me about this situation.

Thanks a lot Tcorey.

Re: "Column 'PI y' does not belong to table" Error

tcorey — Mon, 15 Oct 2018 14:00:06 GMT

My guess is that the error lies in the definition of the table ANA_6. It appears that the export routine is trying to output the coordinates as separate values. X and Y would each populate its own variable. Maybe the table is defined such that it expect X and Y as a single variable, a list of the two coordinates. Try to find the .xls file that defines the ANA_6 table. That might hold further clues.

I might be able to help more, but I will need you to click the Details button and then post the screenshot.

Re: "Column 'PI y' does not belong to table" Error

ekoneo — Mon, 15 Oct 2018 14:51:32 GMT

I serched in xml. But I couldnt find anything that can cause something.

I atached a photo of xml icludings.

Thanks.

Re: "Column 'PI y' does not belong to table" Error

tcorey — Mon, 15 Oct 2018 16:05:03 GMT

It might be in an xls file.

Re: "Column 'PI y' does not belong to table" Error

ekoneo — Mon, 15 Oct 2018 16:15:36 GMT

Thanks.. Now I attached .xls file.

Re: "Column 'PI y' does not belong to table" Error

tcorey — Mon, 15 Oct 2018 16:33:40 GMT

I am unable to find anything in your .xlsx file that will help us pin down the error. Sorry.

Re: "Column 'PI y' does not belong to table" Error

ekoneo — Mon, 15 Oct 2018 17:30:32 GMT

Thanks a lot for your attention and effort.