Skip to main content
Archived

Excel Reader: Tick box to enable/disable automatic creation of geometry via x_co

Related products:Transformers
  • February 10, 2020
  • 1 reply
  • 7 views
milo89
Enthusiast
Forum|alt.badge.img+26

***Note from Migration:***

Original Title was: Excel Reader: Tick box to enable/disable automatic creation of geometry via x_coordinate, y_coordinate


The Excel Reader has the ability to automatically create geometry when it detects fields such as X/Y and Longitude/Latitude. https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/xlsx/XLSX_reader.htm#xyz_coords

I believe it would be handy to have a tick box or selection to enable/disable automatic spatial handling of an excel reader.

I understand that in a lot of situations that automatically creating points from an excel may be useful. However, I'm starting to deal with a lot of excel data which stores multiple coordinates for a record (Eastings/Northings as well as Longitude/Latitude) and even adding new excels to older workspaces is causing issues (VertexCreators previously set to 'Add point' by default creating a line geometry). In both situations I'm having to review the parameters of the reader to determine which field is being set to the 'X_coordinate'/'Y_coordinate' or change the field type. In some workspaces it seems like adding a geometry remover straight after the reader is just easier.


Interested to hear if anyone else has the same feelings.

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.

1 reply

stuiew
Participant
Forum|alt.badge.img
  • stuiewParticipant
  • Participant
  • February 12, 2020

I've had this issue when creating a KML file from excel data.

I created points from the excel coords using the vertex creator and my KML file ended up with lines of zero length instead of points because the excel reader had already auto created points.

Additionally the excel file contained easting and northing data across multiple zones as well as Lat\\Long data. I needed to use the Lat\\Long data due to the zone issue, so how does the reader know which coordinates to use?

Community Stats

32,221
Posts
122,361
Replies
39,916
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.