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: Add a line of data triggered by input data…

Add a line of data triggered by input data… 1 year 3 months ago #2410

  • JD Cox
  • JD Cox's Avatar
  • Offline
  • Junior Member
  • Posts: 39
When our customer’s, customer purchases product B our customer would like to add product Z to the order. I’ve done this for others in the past with VBA in our WMS. But, there’s always a risk of duplication when the order gets moved around. I feel the safest way is to add product Z during the import. Any suggestions, much thanks in advance.

JD
The administrator has disabled public write access.

Add a line of data triggered by input data… 1 year 3 months ago #2411

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi JD,

It´s possible but a bit tricky. I´ve attached a short example.

With an IF-THEN-ELSE condition you decide with product is currently proceeded. In case of product “B” you have to duplicate the CSV record X times by using the GroupOut Heater. In your case you need just one copy of them. This is done with the Input parameter form the two X-Value Heaters. 0=no copy needed, 1=make one copy. Note: 2=make two copies …

Afterwards you need for each field you would like to have other content another IF-THEN-ELSE condition to decide which content should be adopt on the WRITE side. For this condition you need the AutoID Heater with enabled GroupOut option. With this you can build a condition like if AutoID = 2 use Product Z other use the original content.

Sounds hard but I guess with the example it should be clear and easy to handle.



File Attachment:

File Name: add-dynami...tput.zip
File Size:2 KB
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.
The administrator has disabled public write access.

Add a line of data triggered by input data… 1 year 3 months ago #2412

  • JD Cox
  • JD Cox's Avatar
  • Offline
  • Junior Member
  • Posts: 39
You guys rock

Thanks FlowHeater-Team…thanks for the easy to follow instructions and example.

As always Robert, very helpful I will find other uses for this as well.

Thanks Again, JD
The administrator has disabled public write access.

Add a line of data triggered by input data… 1 year 3 months ago #2440

  • JD Cox
  • JD Cox's Avatar
  • Offline
  • Junior Member
  • Posts: 39
Hey guys I’m still struggling with this. It’s overwriting one of the line items on the first order and adding the new item. In your example (zip) change the second line item “B” to “C”, run the def as it is and it will change the “C” to “Z”. We were forced to reship a couple orders, on our dime, until I was able to identify the problem. They’re manually entering the additional item where needed for now.
The administrator has disabled public write access.

Add a line of data triggered by input data… 1 year 2 months ago #2445

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi JD,

On my side the output is like expected. I guess you use an old Version? Please try it with the latest Version.
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.
The administrator has disabled public write access.

Add a line of data triggered by input data… 1 year 2 months ago #2462

  • JD Cox
  • JD Cox's Avatar
  • Offline
  • Junior Member
  • Posts: 39
After updating and making a couple adjustments this works like a charm…thanks again Robert.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.088 seconds