Skip to main content
Question

Launch FME using Visual Basic

  • May 13, 2014
  • 1 reply
  • 61 views
A
Rather than have our users learn the FME interface, I would like to launch an FME model from within Microsoft Access.  I assume that there is a way to do this using Visual Basic.  Any Pointers?

 

 

(The user will populate model parameters in Access which will store the parameters as entries in linked configuration tables stored in SQL Server.  My idea is that the user can use Access to populate teh parameters and then launch FME (using a VBA event procedure).  FME will then read the appropreate database entries and will also write the (profiling) results to the SQL Server database for the Access you to review).

1 reply

david_r
Celebrity
  • david_rCelebrity
  • May 15, 2014
Hi,

 

 

your question has two parts:

 

  1. How to execute an external program from VB.NET: There are lots of examples to be found with Google, such as this (http://blogs.msdn.com/b/vbfaq/archive/2004/05/30/144573.aspx).
  2. How to run FME on the command line, specifying published parameters: When executing a workspace inside FME Workbench, scroll to the very top of the log window, where you will see exactly how to re-run the workspace on the command line, with your current user parameters.
Hope this helps.

 

 

David

Reply


Helpful Members This Week

Community Stats

31,323
Posts
118,784
Replies
38,912
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.