FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC:

Bundle Problem 1 month 2 weeks ago #3573

Team,
 
Having problems with a bundle import.  The first order 138159 has one item to be bundled with four bundle items.  It works great for that order but the AutoID count continues on to the next order.  Order 138160 is not a bundle order and the GroupOut is 0…correct, but the AutoID is 5, it should be 1.  This causes a problem for the rest of the file.  I know we’ve covered this before and it had something to do with the sequence. I’ve removed and recreated several pipes but nothing works.  I believe you said the next update would allow for setting the sequence.

Thanks for the help
 
JD
Attachments:

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

Bundle Problem 1 month 2 weeks ago #3574

Hello JD,

May I ask you which version you´re using? This is a known BUG and should be solved since more than two years.

Perhaps this is another issue related to using a combination of Heaters ( GroupOut , AutoID , ...) ? For deeper analytics please post your created definition, Thanks

Please find attached a short example, how it works with the latest version.



File Attachment:

File Name: bundle-items.zip
File Size:6 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.
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.

Bundle Problem 1 month 2 weeks ago #3576

Thanks Robert,

We're running version 4.1.7 install date 2/1/2020.
The attached is a definition I got from you a while back.
In my definition I'm using the same setup.
If I need to share it I will need to recreate it to something smaller.

JD
Attachments:

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

Bundle Problem 1 month 2 weeks ago #3577

The version should be fine :)

I need the original Definition without data. You can also remove database/tables names and of course user and password settings.

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.

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.

Bundle Problem 1 month 2 weeks ago #3578

This is the original def
Attachments:

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

Bundle Problem 1 month 2 weeks ago #3579

This is the bundle file
Attachments:

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

Bundle Problem 1 month 1 week ago #3580

Hi JD,

This is related to the Set/Get Parameter Heater and the AutoID with dependency to the used GroupOut relation.
You can solve this with a direct connection from the .NET Script Heater and the Field “strCusRefNumber3” like shown in the screenshot below.


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.
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.

Bundle Problem 1 month 1 week ago #3581

Thanks Robert
 
I appreciate your help but that doesn’t get me there.  The ref3 field is only there so I could see the output.
I need the SKU set to run the SQL heater.  I need to be able add items to an order based on an item on the file…bundle.

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

Last edit: by JD Cox.

Bundle Problem 1 month 1 week ago #3582

Hi JD,

You can use the following workaround.

Just add the 2 below listed C# lines into the .NET Script Heater like the attached screenshot. For you this will work because your field order the SQL Heater were trigger just afterwards.


// set FlowHeater Parameter sku
   Parameter["sku"].Value = pos.ToString("0");

Note: The issue occurs just in combination with the 3 Heater AutoID with grouping, GroupOut   and Set Parameter Heater .  We´re currently working on a solution.




File Attachment:

File Name: skbset_import.zip
File Size:45 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.
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.

Bundle Problem 1 month 1 week ago #3583

Robert,That changed things but not what I needed.  But, your explanation helped me understand what was going on.  I added a step to the beginning of the process to recreate the order file and add the bundle items at that time, works perfectly.  However, I do have two questions:I would like to sort and group, reason being some bundle items have the same SKUs, any suggestions?
And, the “bundle.txt” file, is there a way to put a path in the net heater (attachment) so I can store the file elsewhere?

As always, thanks for your help Robert

JD
Attachments:

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

Last edit: by FlowHeater-Team.

Bundle Problem 1 month 1 week ago #3584

Hi JD,

To use absolute or relative path in the .NET Script Heater you just have to change the line with

                string bundlefile = @”C:\Temp\bundles.txt”;
or
                string bundlefile = @”..\data\bundles.txt”;


Sorting and grouping question) I guess you just want to filter out duplicate values? In this case you can use the Filter Heater and just activate the “Filter duplicates values” option like the screenshot below.

Otherwise for sorting and grouping you can use the Sort Heater together with the GroupBy Heater . The only hint is, you have to switch to the Memory Mode before executing the definition. I´ve made two brief examples, please have a look to the attachment.



File Attachment:

File Name: filter-dup...lues.zip
File Size:36 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.
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.

Bundle Problem 1 month 1 week ago #3585

Perfect on the absolute path, thank you.  I don't want to filter them out I needed to sort/groupout and sum the quantity.  And, I can't run the definition in memory mode because there are several processing steps.  I'm trying to avoid having multiply lines of the same item of one piece each.  We  would prefer them on one line with the total pieces.  And I can't use the sort heater in massdata. What I ended up doing was instead of recreating the file I now write the data to an InMemoryAdapter while adding the bundle items.  Then sort on the two columns I need during output and sum the totals when writing it to me wms. 

All is good, thanks for your help Robert.

JD

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

Last edit: by FlowHeater-Team.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2020 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en