Skip to main content
Question

Set Excel Reader parameters so they dont have to be set every time a new excel is selected

  • April 23, 2018
  • 5 replies
  • 40 views
L

Hi,

I have an excel reader and i convert that to a shape file, which will then be published as a feature service to ArcGIS portal. I will be using this workspace multiple times and will be using new excels each time. My problem is that when i add a new excel the parameters previously specified for the excel before it do not stay the same (i need to specify x and y coordinates).

So when i publish my data to a Portal feature service, my points do not appear on the map but they are in the attribute table.

Is there anything I can do that will just set the parameters for me each time? so i dont have to add a new excel reader and specify x and y coordinates as the data type each time?

I just want to be able to click run with prompt and then select my excel then.

Thanks in advance for your help

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.

5 replies

nielsgerrits
VIP
Forum|alt.badge.img+64

You could save the settings as default. (FeatureReader, configure then Defaults, Save as defaults.)

 

As an alternative you could save the FeatureReader configured this way in a custom transformer. I would prefer this as I have another default for the FeatureReader. This would be a more elegant solution anyway, using a Published Parameter (Filename Existing) to select the file.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
L
  • liskett162
  • Author
  • April 23, 2018

You could save the settings as default. (FeatureReader, configure then Defaults, Save as defaults.)

 

As an alternative you could save the FeatureReader configured this way in a custom transformer. I would prefer this as I have another default for the FeatureReader. This would be a more elegant solution anyway, using a Published Parameter (Filename Existing) to select the file.

Thankyou @neilsgerrits, I went with your alternative option!Really appreciate the help!

 

 

danilo_fme
Celebrity
Forum|alt.badge.img+53
  • danilo_fmeCelebrity
  • Celebrity
  • April 23, 2018

You could save the settings as default. (FeatureReader, configure then Defaults, Save as defaults.)

 

As an alternative you could save the FeatureReader configured this way in a custom transformer. I would prefer this as I have another default for the FeatureReader. This would be a more elegant solution anyway, using a Published Parameter (Filename Existing) to select the file.

Good solution @nielsgerrits

 

Partner Solutial Brazil - www.solutial.com.br
jdh
Contributor
Forum|alt.badge.img+40
  • jdhContributor
  • Contributor
  • April 23, 2018

See this idea. https://knowledge.safe.com/idea/22577/add-option-to-save-as-default-to-writers.html

It was for writers, but could apply equally to readers.

andreaatsafe
Safer
Forum|alt.badge.img+15

Hi @mroche162,

 

You can also set the parameter in the ehe Excel Reader for how to handle additional files. You can find this under Advanced > Additional File Handling and set it to "Apply Current Settings to Additional Files"

 

Hope this helps too!

Community Stats

32,274
Posts
122,518
Replies
39,982
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.