Hi, i am trying to convert my access template into an gml compliant with an xsd. Is there any tutorial taht could guide me through this process?

Hi @valantistsiakos, the best way is Generate Workspace:

Reader and Writer configuration:

And now in Parameter Writer Option, you choose the GML Application Schema: and click in your XSD file in your machine.

Thanks,

Danilo

Hi Danilo,

I tried this approach but still the output GML is not compliant with the xsd. I ran the produced GML and still an error occurs (https://www.freeformatter.com/xml-validator-xsd.html).

Are there any other parameters that i have to consider or any other suggestions for the transformation ?

Thanks,

Valantis

@valantistsiakos, what kind of error is showing in the LOG FME Desktop?

log-file.txtworkflow-mapping.png

Hi I am attaching the log message and a screenshot of the mapping.

Thanks your information log file @valantistsiakos.

Really has a problem with feature types.

The following feature types were not written, they did not match any feature types from the GML Application Schema:

Could you send the template file ( . FMWT )?

Thanks,

Danilo

Has a message in LOg that the feature types from GML Application Schema are not the same the feature types:

The feature types determined from the GML Application Schema are: 'AccessRestriction, ActivityComplex, Address, AddressAreaName, AdminUnitName, AdministrativeBoundary, AdministrativeUnit, BasicPropertyUnit, Building, BuildingPart, CadastralBoundary, CadastralParcel, CadastralZoning, ConditionOfFacility, Condominium, CrossReference, GradeSeparatedCrossing, MaintenanceAuthority, MarkerPost, NamedPlace, Network, NetworkConnection, OwnerAuthority, PostalDescriptor, ProductionBuilding, ProductionFacility, ProductionInstallation, ProductionInstallationPart, ProductionPlot, ProductionSite, ReportData, RestrictionForVehicles, SpatialDataSet, ThoroughfareName, TrafficFlowDirection, TransportNetwork, VerticalPosition

Hi Danilo,

I attaching: the MS Access, the xsd, and the fmw files

http://dd.eionet.europa.eu/schema/euregistryonindustrialsites/EUReg.xsd/view process.fmweu-registry-ek-04-07-2017-dummy-data-final.zip

Hi @valantistsiakos,

thanks your files. I tested here to import the XSD.

Writers - Import Writer Feature Types - Parameters:

• Feature Types -

And OK. The Schema from XSD is showing:

Now you need to mapping the feature types in your Workspace.

I didnt execute the Workspace because the Reader is other version from mine.

Thanks,

Danilo

Thanks for your answer. However, the feature type list contains various features that are not provided by the reader. In addition some of the features of the reader cannot be mapped with the writer feature types.

Thanks,

Valantis

Hi Danilo @danilo_inovacao,

I managed to advance the mapping. The only issue that i am encountering lies with the coordinates. In the feature type i am trying to map the latitude and longitude attributes with pointGeometry attribute in the writer. I've tried various things (i.e. StringConcatenator, etc) but i cannot find something to actually working.

Could you please be so kind and let me me know if you have any thoughts on hte matter ?

I attach also the fmw and microsoft access files for your kind review.

Thanks you in advance,

Valantis mdb-ado2gml-new.fmweu-registry-ek-04-07-2017-dummy-data-final.zip