Skip to main content
  • EN

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?

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

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.

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.

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?

Reply


Community Stats

30,162
Posts
114,480
Replies
37,808
Members
Terms & ConditionsCookie 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.