Skip to main content
Solved

Excel Parameters and Published Parameters

  • August 7, 2019
  • 4 replies
  • 78 views
F

Hey Everyone,

I am using FME 2018.0 and it starts with a creator and a FeatureReader. This FeatureReader reads an excel file, and in the parameters I designate it to only read a particular row/column cell and that works fine. My challenge now is that I want to make the excel file a published parameter so no matter which excel file is used, the FeatureReader will always use the same excel parameter rules to read the particular row/column cell. I started by making a file published parameter and only accepted excel file types. For the FeatureReader, the dataset box (where you add which excel file to read) I added the user parameter function to grab whatever excel file the user adds. This however doesn't work because the FeatureReader parameters are cleared out and it wont find the particular column/row anymore. Any ideas? Thank you!or this issue?

Best answer by takashi

Hi @fme_noob, while you configure the Excel reader parameters with the first Excel file, set "Use Current Setting" to the Additional File Settings parameter. Then, link Dataset to the Published Parameter.

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.

4 replies

arnovananrooij
Contributor
Forum|alt.badge.img+5

Hi,

It is not clear what you're trying to accomplish. After you've configured the FeatureReader with a sample dataset you can change the dataset parameter to a User Parameter as you see in the image below.

After you've done this the user can run the workspace with prompt and will be asked to enter a excel file. The workspace will be run with that file....

Greetings,

Arno

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • August 8, 2019

Hi @fme_noob, while you configure the Excel reader parameters with the first Excel file, set "Use Current Setting" to the Additional File Settings parameter. Then, link Dataset to the Published Parameter.

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
F
  • fme_noob
  • Author
  • August 8, 2019

Hi @fme_noob, while you configure the Excel reader parameters with the first Excel file, set "Use Current Setting" to the Additional File Settings parameter. Then, link Dataset to the Published Parameter.

Thank you Takashi! That "Use Current Setting" was exactly what I was looking for, my workbench now works with whatever excel file I throw at it. Thanks again.

maica
Contributor
Forum|alt.badge.img+1
  • maicaContributor
  • Contributor
  • September 23, 2019

Hi, I've the same problem. But I use FME 2017.1 and the solution to imposte Additional File Setting as Use Current Settings doesn't works. Can you help me?

Community Stats

32,120
Posts
121,954
Replies
39,772
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.