Read side link

Hey guys, a copy of our current WMS resides on each user’s terminal server desktop. I want to connect to a table (not linked) on the read side stored there.

I tried > C:\Documents and Settings\%userprofile%\Desktop\MyDateBase.mdb< in the Login information with negative results.

Is there a way to always connect to the user’s desktop copy?

Thanks JD

Hi JD,

Environment variables are not supported for parameters directly in FlowHeater but you can use FlowHeater Parameters instead.

There are two ways to overtake environment variables at definition start time.

1. In the Batch Module you could set them on command line with the command line option /SetParameter
   e.g. FHBatch.exe /SetParameter UP=%USERPROFILE% Your-Import-Export-Definition.fhd


2. With .Net Script Heater and the simple Script below. You have to switch “Exceute when” to “Start” in the Heater options.

The two solution above sets the FlowHeater Parameter $UP$ with the content of the environment variable %USERPROFILE% at start time. This parameter can be used in the filename for the Access Database .

NOTE: You have to use $UP$\Desktop\MyDataBase.mdb instead of C:\Documents and Settings\%userprofile%\Desktop\MyDateBase.mdb


C# .NET Script to obtain environment variables

Robert,

That works great…as always, I can’t thank you enough. With our growing company this will be a great asset for us by allowing multiple users to run the end of day tasks simultaneously as opposed to one user.

JD