topic Re: How to import all fields of my GML file in AutoCAD Map 3D Forum

How to import all fields of my GML file

patrickvanhoeijen — Mon, 29 Mar 2021 10:09:11 GMT

I have this GML file attached ( I renamed to txt as I could not upload GML). I try to import this in Autocad map via Mapimport>GML. Some of the data I cannot import, I am interested in these fields/values for example to display as labels/texts:

<oz:kadastraleAanduiding>
<oz:TypeKadastraleAanduiding>
<oz:kadastraleGemeente>
<oz:KadastraleGemeente>
<t:code>272</t:code>
<t:waarde>Emmen</t:waarde>
</oz:KadastraleGemeente>
</oz:kadastraleGemeente>
<oz:sectie>AF</oz:sectie>
<oz:perceelnummer>58</oz:perceelnummer>
<oz:aKRKadastraleGemeenteCode>
<oz:AKRKadastraleGemeenteCode>
<t:code>319</t:code>
<t:waarde>EMN00</t:waarde>
</oz:AKRKadastraleGemeenteCode>
</oz:aKRKadastraleGemeenteCode>
</oz:TypeKadastraleAanduiding>
</oz:kadastraleAanduiding>

Anyone can help me?

Re: How to import all fields of my GML file

Pointdump — Mon, 29 Mar 2021 13:47:56 GMT

Patrick,
I changed .txt to .gml, dropped into QGIS and re-saved as a Shapefile. Attached.
Dave

Re: How to import all fields of my GML file

АлексЮстасу — Mon, 29 Mar 2021 15:13:09 GMT

patrickvanhoeijen, I can't import this GML either. Perhaps we need his scheme?

Pointdump, No area objects were transferred.
I did through Global Mapper.

Re: How to import all fields of my GML file

ChicagoLooper — Mon, 29 Mar 2021 18:39:10 GMT

I don't know how you got your gml but it looks like someone changed the extension from .gml to .txt. You can make a COPY of the dk_parceel.txt then change the extension of the copy back to .gml. Once you have the .gml you can use MAPIMPORT command to bring in the parcels and the accompanying object data.See image-1.

Image-1

You only need to import Parceel, the other two gml's don't have any data or any geometry. It appears Map3D doesn't like long Target Field names. Most of the target fields are OK so you can keep them as is. For the ones that are too long, you can edit them so they'll be a few characters shorter. Change 'Type' to 'T' and 'Status' to 'Sta.' By shortening the target field names, you'll be able to import the Object Data. See image-2.

Image-2

Klazienaveen. Correct? A new layer has been created and this layer has adopted the name of the gml. The Object Data is displayed at the bottom of the Properties Palettes under the heading OD:Parceel.

Image-3

The method described above doesn't use third party software and doesn't use any add-on. The entire procedure was easily accomplished using Map3D.

Re: How to import all fields of my GML file

patrickvanhoeijen — Tue, 30 Mar 2021 10:18:19 GMT

Thanks, however I need GML files and therefor a solution for these. My solution is not converting to shape. Anyway, your help is much appreciated!

Re: How to import all fields of my GML file

patrickvanhoeijen — Tue, 30 Mar 2021 10:19:05 GMT

Hmm, I can import, but not using all fields. Thanks for your reply.

Re: How to import all fields of my GML file

patrickvanhoeijen — Tue, 30 Mar 2021 10:23:06 GMT

Thanks a lot for this detailed description. Yes, I changed the gml extension to txt as I could not upload .gml before zipping. All clear now. Only one thing: In the future I need to import these files coming from an open source. So they will all be like this, with the long names. Is there a way to automise this shortening of names to be able to import complete?

Re: How to import all fields of my GML file

patrickvanhoeijen — Tue, 30 Mar 2021 13:05:14 GMT

Hmm, I did a complete test now: shortened all target field names until all were accepted. Unfortunately much information that is in the GML, like for example these values 272, Emmen, I, 9319 etc:
<oz:KadastraleGemeente>
<t:code>272</t:code>
<t:waarde>Emmen</t:waarde>
</oz:KadastraleGemeente>
</oz:kadastraleGemeente>
<oz:sectie>I</oz:sectie>
<oz:perceelnummer>9319</oz:perceelnummer>
<oz:aKRKadastraleGemeenteCode>
<oz:AKRKadastraleGemeenteCode>
<t:code>319</t:code>
<t:waarde>EMN00</t:waarde>

Are not shown in Autocad object data:

Am I doing something wrong?

Re: How to import all fields of my GML file

TerryDotson — Tue, 30 Mar 2021 13:35:08 GMT

@patrickvanhoeijen wrote:
I did a complete test now: shortened all target field names until all were accepted.

Keep in mind that dBase III (.DBF Files) column names are limited to 10 characters. That is one of the few negatives involved in using ShapeFiles.

Re: How to import all fields of my GML file

АлексЮстасу — Tue, 30 Mar 2021 15:53:16 GMT

Where did these fields come from?
In Global Mapper, I don't see them:

Re: How to import all fields of my GML file

patrickvanhoeijen — Thu, 01 Apr 2021 14:28:49 GMT

You say: "I don't see...". In your screenshots I do see the values of the attributes I would like to see in Autocad Map importing this GML. So I would like to know how.

Re: How to import all fields of my GML file

АлексЮстасу — Fri, 02 Apr 2021 14:50:28 GMT

Apparently, Map cannot interpret your GML as described.
Alternatively, you can to create a *.xls schema for such GML that Map reads it correctly.
Or use a path via QGIS, GM or the like.

I tried a funny option. (Funny because I don't understand GML, XML, *.xls...).
When MAPEXPORT your data in GML from dwg is created schema - *.xls.
If you give this scheme when MAPIMPORT read your GML, the desired fields are visible.
However, objects are not imported. 😞
But the necessary fields are already visible. 🙂

Probably need a person who understands GML, XML...

Re: How to import all fields of my GML file

Pointdump — Mon, 05 Apr 2021 18:22:56 GMT

Alexander,
Trying to MAPIMPORT that GML into Map 3D all I get is "Invalid data or no data found." I have no idea how @ChicagoLooper managed it. Anyway, after a re-save in QGIS I got an XSD file. I also saved as a CSV file. All attached.
Dave

Re: How to import all fields of my GML file

ChicagoLooper — Mon, 05 Apr 2021 19:21:11 GMT

To Mr. @Pointdump ,

To use MapImport, you'll need to change the .txt file back to its original extension of .gml. You can refer to post #17 which confirms my suspicion that the gml was edited prior to uploading to the forum.

Also refer to post #19 written by @TerryDotson . Terry is correct in saying the the attributes are too long. Map 3D wants Field Names that are 10 characters or less. Editing the filed name to abbreviations will get the job done.

BTW, this 10 character limitation is also present when performing Bulk Copy. When you copy Fields from the orignal shapefile and pasting them into a new shapefile during Bulk Copy, the new Fields in the new shapefile can't be longer than 10 characters. Even though the orignal shapefile has Fields longer than 10, the new, or copied shapefile, can't. The solution when performing Bulk Copy is to abbreviate or shorten the new field names to less than 10 characters.

Re: How to import all fields of my GML file

Pointdump — Mon, 05 Apr 2021 21:07:18 GMT

@ChicagoLooper,
Understand about the gml extension. Patrick told us about this in the first sentence of his first post.
I'm not getting to the point where I can change the attributes. Map 3D gives me this:

Re: How to import all fields of my GML file

АлексЮстасу — Mon, 05 Apr 2021 22:49:11 GMT

I also did not succeed at first for the same reason - this is the import of the wrong GML, this is "CityGML", but you need to take the second - "Geography Markup Language".

Can you attach *.xsd if QGIS creates it when exporting to GML?

Re: How to import all fields of my GML file

Pointdump — Mon, 05 Apr 2021 23:16:50 GMT

Alexander,
Yes, you're right. I was using "CityGML", but when I used the second one everything came in fine. (I shortened the attribute names as @ChicagoLooper explained.)
I'm ashamed and embarrassed to admit that I don't have a clue how to attach an XSD file.
In QGIS all I got was some points. In Map 3D now there are 9246 objects--linework, points, and who knows what all. I suppose you could use a Map Annotation Template to label things.

Dave

Re: How to import all fields of my GML file

АлексЮстасу — Mon, 05 Apr 2021 23:49:41 GMT

I meant you to attach a *.xsd schema file to your forum message. 😀

And when importing, you can specify the desired file *.xsd - see picture in my 12.

Re: How to import all fields of my GML file

Pointdump — Tue, 06 Apr 2021 00:17:34 GMT

Alexander,
When I click "Driver Options" I get something bad:

Dave

Re: How to import all fields of my GML file

patrickvanhoeijen — Tue, 06 Apr 2021 07:41:46 GMT

I am curious about this XSD file and how this could help me further.