Skip to main content
Question

how to read files when filenames and path are stored in another datasource (database)

  • January 15, 2019
  • 1 reply
  • 12 views
A

Hi everybody,

it seems to be an easy job, but at the end it is taking a lot of time to implement. I have patterns in my oracle database to access and read multiples Excel files, which contains several sheet.

When i access to this database, i get the filename, i cannot call directly the Reader for excel passing the name, sheet name and format.

 

I did some experiment with subroutines (like external calls) but it seems more complicated than expected. How can i read Excel files whose name is in the database without calling another workflow ? which is the logic standing behind this ?

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.

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+59
  • redgeographicsCelebrity
  • Celebrity
  • 3697 replies
  • January 15, 2019

You can read the database with an Oracle reader, then run those features through a FeatureReader so you can construct the filename of the Excel file to be read using the attribute out of the Oracle database.

FME rocks! \m/

Community Stats

32,058
Posts
121,723
Replies
39,686
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.