Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Best appraoch to connect to an XML url and export the data to a SHP file format with all data presenting in the correct column format.

I have connected to an third party data source via an XML url and managed to export this to SHP file format.

 

The issue I am having is that the latitude and longitude are not being pulled through into the writer. Equally, the lat/long and name of the data source are showing as there own row in the attribute table not as a column. I have attached a snip for reference.

 

This is my first time using FME so have read a few articles and tried a few differerent transformers to try and get the output I am looking for but to no avail. Any help would be appreciated.

Hey @andyh​ sounds like you want to have some geometry generated for those rows that contain values for the lat/long fields? In FME, you'll need to create this geometry using the VertexCreator transformer. In there, you can set the X Value to your Longitude attribute, and the Y Value to your Latitude attribute. Afterwards, you can use a CoordinateSystemSetter to set the coordinate system before writing out your shapefile.

image 

Hope this helps! If you're still having issues, a small snippet of your source dataset may help us here.

Reply


Community Stats

30,364
Posts
115,373
Replies
38,148
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.