Skip to main content
Best Answer

Excel Reader: Selecting a single attribute to expose results in all attributes to be exposed [BUG?]

  • December 2, 2019
  • 6 replies
  • 61 views

Forum|alt.badge.img

Hi all,

 

 

I'm facing a problem while adding an Excel Reader to my workspace:

 

Adding Excel Reader - I'm selecting only one attribute to be exposed:

 

When the Reader is brought into the workspace all attributes are exposed:

 

Is this a bug or am I doing something wrong?

I'm using FME(R) 2019.1.2.0 (20190829 - Build 19630 - WIN64) but I've noticed this on older versions as well.

 

Cheers,

Eduard

 

 

 

Best answer by markatsafe

@edhere This is definitely something we should clean-up. We've added the issue to our problem database.

As suggested by @danullen for now edit the schema in the feature types, not the reader parameters.

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.

6 replies

oscard
Influencer
Forum|alt.badge.img+22
  • Influencer
  • December 2, 2019

I have also had this problem in FME 2018


Forum|alt.badge.img
  • December 2, 2019

I get the same result as you in 2019.2. But it still works fine to edit the reader afterwards and change the list of exposed attributes. Then it sticks and gives the expected result.


Forum|alt.badge.img
  • Author
  • December 2, 2019

I get the same result as you in 2019.2. But it still works fine to edit the reader afterwards and change the list of exposed attributes. Then it sticks and gives the expected result.

That's true. But still it is annoying having to expose your attributes twice as the first time when importing the Excel Reader it doesn't work.


Forum|alt.badge.img
  • December 2, 2019

That's true. But still it is annoying having to expose your attributes twice as the first time when importing the Excel Reader it doesn't work.

Yep, agreed. (The obvious workaround is of course to not do it the first time. :-D )


Forum|alt.badge.img+2
  • Best Answer
  • December 2, 2019

@edhere This is definitely something we should clean-up. We've added the issue to our problem database.

As suggested by @danullen for now edit the schema in the feature types, not the reader parameters.


Forum|alt.badge.img
  • Author
  • December 3, 2019

Hi Mark,

 

 

Thanks for looking into this.

Best,

 

Eduard