Question

FeatureReader doesn't read all .xlsx files

  • 16 March 2023
  • 2 replies
  • 10 views

Hi all,

I have issues using FeatureReader transformer when reading all .xlsx files from folder. During execution of the entire workbench it will load just couple of them. But when I use Run From This (from FeatureReader) it will load all files.

I'm using FME Desktop 2022.2 version.

 

Thanks,

Bogdan


2 replies

Userlevel 2
Badge +10

Hi @bdjuric16​ sorry to hear you're running into this issue. So far I haven't been able to reproduce the issue. I have a few questions to better understand what's going on here:

  • Would you be able to share a screenshot of your FeatureReader parameters?
  • How many features are you expecting to come out of the FeatureReader? When you do a full workspace run, how many features are missing from the FeatureReader?
  • How many excel files are you reading at once with the FeatureReader?
  • What specific build of FME 2022.2 are you using? You can find this information by going to Help (in the toolbar) > About FME Workbench

 

Thanks!

Dan

Hi @danminneyatsaf​ , I just realised it's my bad. I'm using FeatureReader after HTTPCaller (downloading .xlsx files) and putting FeatureHolder before FeatureReader solved the problem. All data should be downloaded before moving forward and use FeatureReader.

Reply