Skip to main content
Solved

Append to SDE from joined Excel spreadsheets and address point feature class not working properly. It's only appending the attributes and not appending the geometry.

  • August 25, 2020
  • 2 replies
  • 37 views
cshir065
Forum|alt.badge.img

Hello,

I wrote a tool to join 3 Excel spreadsheets (solar data and 2 different meter tables) and an address point feature class. I tried appending this data to a SDE geodatabase feature class called, Distributed Generation. The writer only appended the attributes and not the geometry. I'm not sure why the geometry is getting lost during the translation. (As a temporary work around... i wrote it to a file geodatabase and am manually appending in ArcMap).

 

I have attached a screenshot of my workflow and parameters of the writer. Any help or ideas would be greatly appreciated 😊

 

SolarExportHelp2

SolarExportHelp1

Best answer by debbiatsafe

I would recommend double-checking the FeatureJoiner transformers, FeatureJoiner_3 in particular.

The address point feature class is connected to the Right input port. Is the Geometry Handling parameter set to 'Use Right' in FeatureJoiner_3?

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.

2 replies

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • Best Answer
  • August 25, 2020

I would recommend double-checking the FeatureJoiner transformers, FeatureJoiner_3 in particular.

The address point feature class is connected to the Right input port. Is the Geometry Handling parameter set to 'Use Right' in FeatureJoiner_3?

cshir065
Forum|alt.badge.img
  • cshir065
  • Author
  • August 26, 2020

I would recommend double-checking the FeatureJoiner transformers, FeatureJoiner_3 in particular.

The address point feature class is connected to the Right input port. Is the Geometry Handling parameter set to 'Use Right' in FeatureJoiner_3?

@debbiatsafe​  Thank you so much... that solved the problem. I had missed that detail in 'FeatureJoiner_3' 👍

Community Stats

32,207
Posts
122,305
Replies
39,891
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.