I am able to write inspire GML (it validates, too). I do it in FME. Now I would like to write that gml directly to the postgresql database (add postgresql writer), so that i have the entire data flow in one workspace, but i cannot join two writers (inspire gml writer and postgresql writer) together... I am very new to FME.
Question
INSPIRE GML to postgres database
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Im not sure on your exact workflow but you can connect multiple writers to a single dataset.
Alternatively if you are trying to write to PostGres and then from PostGres to GML you could try using feature readers and writers rather than the standard readers and writers. That way you can continue the process after you have written to PostGres.
A screenshot of your workbench would be helpful to see the data flow.
Hello!
Thank you for the feature readers and writers suggestion. I have made some changes to my workspace and tested using feature readers and writers. I will let you know when I have succeeded with writing the inspire gml to postgres.
I am lost as the Atlantis. Do I understand correctly that I am unable to actually connect one writer's output as an input to another writer? I can only connect its summary? Or is the summary really the output? @mwiltshire
Just a lot of the data being written ... gets lost with this.
+51- Evangelist
I am lost as the Atlantis. Do I understand correctly that I am unable to actually connect one writer's output as an input to another writer? I can only connect its summary? Or is the summary really the output? @mwiltshire
Just a lot of the data being written ... gets lost with this.
In 2018 and above the featurewriter has an option under output ports to output all features ('one per feature type')
If you just want to write the same data to both GML and postgres though, i'd just do this
In 2018 and above the featurewriter has an option under output ports to output all features ('one per feature type')
If you just want to write the same data to both GML and postgres though, i'd just do this
@triintjr - I would follow this example. Unless you need to write to GML before PostGIS then you can just write to both simultaneously.
Otherwise you can update the output ports on the feature writer to pass all attributes instead of a summary.
Thank you @egomm "In 2018 and above the featurewriter has an option under output ports to output all features ('one per feature type')" - this is what I needed. Success!
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.