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

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

  • JD Cox
  • JD Cox's Avatar Topic Author
  • Offline
  • Junior Member
  • 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

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

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 265
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-dynamic-lines-to-csv-output.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.

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

  • JD Cox
  • JD Cox's Avatar Topic Author
  • Offline
  • Junior Member
  • 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

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

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

  • JD Cox
  • JD Cox's Avatar Topic Author
  • Offline
  • Junior Member
  • 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.

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

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

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

On my side the output is like expected. I guess you use an old Version? Please try it with the latest Version.

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.

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

  • JD Cox
  • JD Cox's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 39
After updating and making a couple adjustments this works like a charm…thanks again Robert.

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

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.124 seconds