Dynamic Filename in Microsoft Excel Driver

Situation:

I need to process an .xlsx file containing multiple sheets.

The Adeptia support forum recommends treating excel as a database schema: http://support.adeptia.com/entries/21277917-Treating-Excel-as-database-schema

Is there a way of passing the filename to the database info when the process flow is kicked off via file trigger?

 

Solution:

We have looked into your scenario and hopefully the following approach should fulfill your requirement. You can get the source file name that triggered the Process by following below forum post.
http://support.adeptia.com/entries/21280958-Passing-Source-file-name-to-Target

File name can be picked by $$Service.ActivityName.fileName$$ in the Put Context Var activity. The only change that you have to do is to over-ride the URL of DB info activity and use the above file name variable for fetching the file name. For overriding DB info parameters refer below forum post.
http://support.adeptia.com/entries/21587228-Dynamically-Over-riding-DBinfo-parameters

Server URL should be like this: jdbc:odbc:Driver={MicroSoft Excel Driver (.xls)};DBQ=$$Service.ActivityName.fileName$$*

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.