How to process List of order numbers (each order number having its own sub-list) using RPA

Help Studio
, ,
1

Hi team,
I have the following problem that I’d like to have a solution for using RPA (Studio).
Here is the detail and steps: I have a list of order numbers in my input file (excel)

  •      Each order number is inserted into the app’s entry fields

  •      Each order number inserted into the app has different style numbers (aka line numbers). For example, one order number might have 7 line numbers, and another order number may have one line number.

  •      I want to open each line number of an order number and edit and save AND move to another line number of the same order number.

  •      These steps would continue until all the order numbers in the list are processed.

Can anyone advise the approach on how to tackle this issue?

If you need more information, please let me know. Thanks!

2

Hi team,

I have the following problem that I’d like to have a solution for using RPA (Studio). Here is the detail and steps: I have a list of order numbers in my input file (excel)
Each order number is inserted into the app’s entry fields
Each order number inserted into the app has different style numbers (aka line numbers). For example, one order number might have 7 line numbers, and another order number may have one line number.
I want to open each line number of an order number and edit and save, AND move to another line number of the same order number.
These steps would continue until all the order numbers in the list are processed.

Can anyone advise the approach on how to tackle this issue?

3

Hi @Sisay_Dinku , To solve your problem by automating the manual process of editing and saving line numbers for each order number in the input file,

  1. Read the list of order numbers from the input file (Excel).
  2. Create a loop that iterates through each order number in the list.
  3. Within the loop, use an “Open Application” activity to open the app where the order numbers are entered.
  4. Use an “Insert Into Field” activity to insert the order number into the app’s entry field.
  5. Use a nested loop to iterate through each line number of the order number.
  6. Within the nested loop, use an “Edit Field” activity to edit the line number as desired and use a “Save” activity to save the changes.
  7. Use a “Next Item” activity to move to the next line number of the same order number.
  8. Repeat steps 6 and 7 until all line numbers of the order number have been processed.
  9. Use a “Close Application” activity to close the app after all line numbers of the order number have been processed.
  10. Repeat steps 4 through 9 for all order numbers in the list.
4

@Shanmathi thank you for the very insightful steps. one more thing, the number of lines is different for each order number. I’ll give it a shot. If you do not mind, I would greatly appreciate and like to see the design in studio, so that I can understand we are on the same page. That will give me a good perspective. Thanks again!

1 Like