Skip to main content
Question

Excel attribute exposer/hyperlink

K
Forum|alt.badge.img

I am trying to convert Excel file to KML. There is a column RPN# with the project number like RPN-123456 and also hyperlink embedded in it that opens local folder on the server. I have done this before with AutocAD file but I am having issues exposing attribute in Excel file. I attached pictures of the workflow.

When I run translation I do not see RPN# in KML file, what am I missing here. Instead the dot representing RPN# shows generic kml_1 or something like that.

Thank you very much.

4 replies

takashi
Contributor
Forum|alt.badge.img+19
  • takashiContributor
  • Contributor
  • January 18, 2018

I cannot find any problem with just seeing the screenshots, but have questions:

  1. Why are you using an AttributeExposer even though the Excel reader feature type has exposed 'RPN#' attribute already?
  2. If you send the features output from the AttributeManager to an Inspector and run the workspace, can you see desired value of 'RPN#' with FME Data Inspector?
  3. If you connect an Inspector to the Excel reader feature type directly and run the workspace, what value can you see with FME Data Inspector for 'RPN#'?
arnold_bijlsma
Enthusiast
Forum|alt.badge.img+14
Without actually diving into the problem, have you tried removing/replacing the #-sign? I have no idea if this has any bearing on your problem, but these special characters can sometimes lead to unexpected results!

 

 

K
Forum|alt.badge.img
  • klika68
  • Author
  • January 18, 2018
takashi wrote:

I cannot find any problem with just seeing the screenshots, but have questions:

  1. Why are you using an AttributeExposer even though the Excel reader feature type has exposed 'RPN#' attribute already?
  2. If you send the features output from the AttributeManager to an Inspector and run the workspace, can you see desired value of 'RPN#' with FME Data Inspector?
  3. If you connect an Inspector to the Excel reader feature type directly and run the workspace, what value can you see with FME Data Inspector for 'RPN#'?

 

Hi takashi,

 

I figured it out without AttributeExposer, it works now but the only problem is , how to expose embed hyperlink in RPN# ?

 

 

 

 

 

 

arnold_bijlsma
Enthusiast
Forum|alt.badge.img+14
takashi wrote:

I cannot find any problem with just seeing the screenshots, but have questions:

  1. Why are you using an AttributeExposer even though the Excel reader feature type has exposed 'RPN#' attribute already?
  2. If you send the features output from the AttributeManager to an Inspector and run the workspace, can you see desired value of 'RPN#' with FME Data Inspector?
  3. If you connect an Inspector to the Excel reader feature type directly and run the workspace, what value can you see with FME Data Inspector for 'RPN#'?
Hi @klika68. Looks like you need a KMLPropertySetter transformer, which lets you set the balloon text (= pop-up text) and the menu text.

 

Reply


Most helpful members this week

Community Stats

30,872
Posts
117,041
Replies
38,692
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.