[gdal-dev] ogr2ogr, GMLAS driver, help

[Even Rouault]

Hi,

It is very difficult to create manually the table & field structure that 
will be generated by the GMLAS driver. It is likely that the attribute 
name generated by the GMLAs driver is not the one you expect. First try 
ogr2ogr to a not-yet-existing PotsgreSQL table to see if data is 
correctly ingested (on a quick try on my side with a very simple 
example, it is)

Even

Le 26/03/2024 à 11:01, Bence Megyesi via gdal-dev a écrit :
> Hello,
>
> i am importing an xml with ogr2ogr using GMLAS driver to a PostgreSQL 
> server. I am also using an .xsd file to correctly import and manage 
> the imported xml in the server. This way i was able to import every 
> element into the correct column based on the xsd, except one, a 
> type="xsd:time" element. In the server i created a table list and 
> their columns with types based on the xsd, but this "Uhrzeit" 
> element's value wont get imported into the server. I checked the type 
> in PostgreSQL, which is "time without time zone".
> The value in the xml is HH:MM:SS formated so in theory it should work, 
> but it wont.
> My question is: what adjustments can i do with my ogr2ogr command
> ogr2ogr_command = [
>         'ogr2ogr', '-skipfailures', '-f', 'PostgreSQL', 
> f'PG:host={host} port={port} dbname={dbname} password={password} 
> user={user} schemas={schema}',
>         f'GMLAS:{xml_file_path}',
>         '-oo', f'XSD={xsd_file_path}',
>         '-oo', 'REMOVE_UNUSED_LAYERS=YES', '-oo', 
> 'REMOVE_UNUSED_FIELDS=YES', '-append', '-forceNullable'
>     ]
> to be able to import this type of data too?
>
> I hope i am sending my question to the right person. If this is not 
> the case, kindly disregard my message.
>
> Best regards,
> Bence
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.