FlowHeater Logo

FlowHeater Support Forum

simply more productive

Download the freeware version (10 Mb)

Up to 100,000 records can be processed with the freeware version!

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Advance Read File Number

Advance Read File Number 1 year 1 month ago #2908

I’m using a control number during imports that I pick up with a Replace Heater from a .csv file. This number can only be used one time. At the time of the import I would like to advance that number. I can run a second def advance the number in question but it writes it to a new line. What is the best way to handle this?

Thanks, JD

Please Log in or Create an account to join the conversation.

Advance Read File Number 1 year 1 month ago #2913

Hi JD,

You need the power of FlowHeater Parameters :-)

In your case you have to define one parameter (e.g. ID). Set the default value to the desired one and activate the option “store”. With this FlowHeater creates automatically a new file [definition name].fhpara to store parameter values for the next run.

To increment the value just once per each run (not in test mode) you need a .NET Script Heater with the little script below. In the configuration dialog you have to set “Execute when” to “Finish”. With this setting the value are only increment once at the end of the import/export process.

Note: The value are automatically stored when you execute the definition. When you execute the definition just in “Test mode” the parameter values are not changed!

Attached you´ll find a little example how it works.

Define the parameter


Script to increment tha value


File Attachment:

File Name: increment-control-number-per-each-run.zip
File Size: 2 KB
Attachments:

Please Log in or Create an account to join the conversation.

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: by FlowHeater-Team.

Advance Read File Number 1 year 1 month ago #2914

Wow, that is way better then what I was trying to do. Robert I can not thank you enough.
The power of FlowHeater makes my job so much easier it works great. ;)

Thank You, JD

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.469 seconds