Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Read side link

Read side link 1 year 2 months ago #2471

  • JD Cox
  • JD Cox's Avatar
  • Offline
  • Junior Member
  • Posts: 39
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
The administrator has disabled public write access.

Read side link 1 year 2 months ago #2472

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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
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.
Last Edit: 1 year 2 months ago by FlowHeater-Team.
The administrator has disabled public write access.

Read side link 1 year 2 months ago #2473

  • JD Cox
  • JD Cox's Avatar
  • Offline
  • Junior Member
  • Posts: 39
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
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.075 seconds