Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Read side link

More
8 years 6 months ago #2471 by JD Cox
Read side link was created by JD Cox
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

Please Log in to join the conversation.

More
8 years 6 months ago - 8 years 6 months ago #2472 by FlowHeater-Team
Replied by FlowHeater-Team on topic Read side link
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
Code:
public object DoWork() { // Set the FlowHeater Parameter $USERPROFILE$ with the content of the environment variable %USERPROFILE% Parameter["UP"].Value = Environment.GetEnvironmentVariable("USERPROFILE"); // return value not required at "Start" return null; }


Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:
Last edit: 8 years 6 months ago by FlowHeater-Team.

Please Log in to join the conversation.

More
8 years 6 months ago #2473 by JD Cox
Replied by JD Cox on topic Read side link
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

Please Log in to join the conversation.

Time to create page: 0.336 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.