-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
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.
|
-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
|
Please Log in or Create an account to join the conversation.
|
-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
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.
|
-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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
|
Please Log in or Create an account to join the conversation.
Last edit: by FlowHeater-Team.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
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.
Last edit: by FlowHeater-Team.
|
-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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.
|
Time to create page: 0.358 seconds