TOPIC:

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

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.

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

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.

This is the original def

This is the bundle file

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.

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.

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.


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.

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

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.

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