Hi team,
I have four scenarios for my process. For that, I have prepared four sets of datatables that I need for four sub-processes in a website. All the four processes are ordering tickets. But the steps are not exactly the same for all the 4s
Question: 1) How to upload POs for these separate sub processes to the Queue items in orchestrator?
2) How to put in the Process Part of the REF in terms of sequence?
Can anyone help tackling this problem?
While uploading the po if we know for which sub process it belongs to then add that in the reference field or any specific content field like step1 or 1 to identify which sub process it needs to go
And in the process xaml use a switch case and check transactionitem.reference or transactionitem.SpecificContent("Stepnumber").Tostring
Hope this helps
Cheers
@Anil_G thank you so much the idea of using switch case which makes sense though I have to give it a try. I still did not understand on how to upload those four sets of POs. It is not from one data table, I have separate for data table for each of the scenarios. Could you please elaborate on how to approach this one? if you could, give a sample design. Thanks a lot!
Do you want to upload four different datatables to queue?
Is there anyway to differentiate which po belongs to which sub processes while adding the queue item…can you elaborate please
If each set of POs for each case are in different datatable then add one extra column to the datatable to determine which PO belongs to which sequence then we can merge the datatable together and then add one by one and also add the identifier of each sequence also to queue as a reference or queue data
Cheers
@Anil_G from the long list of POs
We have to filter a set of POs by company, Store Id, date
For example
Instead of creating 4 datatables…add one extra column and add value like 1 ,2,3,4 to determine which sub process the po belongs to…
And I hope you are adding one PO as one queue item…now add the column you added to differentiate the PO to the queue item reference if like reference for PO with column value 1 will have reference as 1…so your switch case in process xaml will be on Cint(transaction.reference) and the type argument can be changed to integer and in case values can be 1 ,2,3,4 and under eqch case have one sub process
Hope this is clear
Cheers
@Anil_G
And I hope you are adding one PO as one queue item – NO
in the actual manual process we paste all the POs into the POs space at once for one scenario
We’d continue doing like this for all the four scenarios (Customers). Help me how to prepared POs from excel file for Queue items for each scenario. I could not envision how to do that. Thanks a lot for your help!
String.Join(",",Dt.AsEnumerable.Select(function(x) x("POColumn").ToString))
This will give all po’s in the datatable as a string with comma separation…so for each datatable we cna repeat the same while adding to queue…and add all PO’s at once to queue
and when you retrieve you will have the same comma separation you can replace comma with environment.Newline if that is needed
cheers
@Anil_G Just wanted to confirm I got it right.
– The expression/ query you shared me would give me POs in separated commas in a datatable
– I have to have data tables for all the four scenarios – meaning I will have four datatables
Follow up questions:
When you say “add all POs at once to queue”, do I have to all POs in all the four datatables at once? If so, how would I do that?
In the Sub-process (Company A) part we have paste all POs for that paste field, how do we do that from the Queue item?
Please let me know if my process is not clear enough. Thanks a lot!
No…so in the dispatcher process I guess you will add only four items one for each set of PO’s as I understand…because you want to process all the PO’s for once set at once…So the expression I gave you will give you a string output of all the PO’s in one datatable and that string can be added as a specific content to the queue item …along with that you will add which sub process it needs to run
Now in each queue item you will have two inputs one which talks about the sub process (1/2/3/4) and other one would be a comma separated string of all the PO numbers for the respective sub process
As said above not from all datatables …for each datatable you will have separate string so you get four strings
now when you retrieve the queue item in_TransactionItem.SpecificContent("PONumbers").ToString will have all PO numbers with comma separation…if you need with new line then use .Replace(",",Environment.Newline) which can be assiged to clipboard usign set clipboard if you want to paste or send to type into if you want to type it out
Hope this is clear
cheers
Hi @Anil_G
Sorry though for the multiple back and forth. It is much clearer now.
No…so in the dispatcher process I guess you will add only four items one for each set of PO’s as I understand…because you want to process all the PO’s for once set at once…So the expression I gave you will give you a string output of all the PO’s in one datatable and that string can be added as a specific content to the queue item …along with that you will add which sub process it needs to run.
Now in each queue item you will have two inputs one which talks about the sub process (1/2/3/4) and other one would be a comma separated string of all the PO numbers for the respective sub process
Now I understand that the expression you gave me for one sub process to return the POs as a string with comma separation. è This will lead me to another question on how to upload 4 separate datatables (grouped POs) into Queue items. Does that mean I have to have 4 queue items? However, from what I understand, from your second paragraph response, it looks like subprocess will have corresponding queue item, meaning 4 queue items. How would that look like in orchestrator? Am I going to have 4 Queue names in orchestrator as well??
now when you retrieve the queue item in_TransactionItem.SpecificContent(“PONumbers”).ToString will have all PO numbers with comma separation…if you need with new line then use .Replace(“,”,Environment.Newline) which can be assiged to clipboard usign set clipboard if you want to paste or send to type into if you want to type it out.
Is this last option (.Replace(“,”,Environment.Newline)) to support the capability of paste in the PO field in the website I am working on (where I am making the Orders)?
Thanks a lot for taking the time to help. Much appreciated!!
Queue will be one only…as said you will add both details
Consider re framework
In dispatcher change the datatype from datatable to list of datatables in the transactiondata variable…and have your datatables inside the list…
Change the transactionitem to datatable then each time you will get one table in the process xaml…so add one queue item each
If not using reframework also the same logic applies for loop …
Coming to the replace part yes …as per screenshot i see you have one po in one line…so for pasting there i was saying this
Hope this helps
Cheers
@Anil_G
Yes, I am going to consider REFramework.
Thanks a lot. This is very helpful. I’ll give you an update as I give it a try. Thanks again!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
