Dynamic data import / export

datenbank

simply more productive
Up to 100,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.
  • Page:
  • 1

TOPIC: Advance Read File Number

Advance Read File Number 4 months 2 weeks ago #2908

  • JD Cox
  • JD Cox's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 39
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 4 months 2 weeks ago #2913

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 254
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 4 months 2 weeks ago #2914

  • JD Cox
  • JD Cox's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 39
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
Moderators: FlowHeater-Team
Time to create page: 0.289 seconds