Save a variable to start on the next day

Help Studio
, , ,
1

Hi to everyone!
I have a automation that send promotions to clients of my organization in WhatsApp Web.
My automation works from 8am to 17pm and i have to save the last contact that my loop For Each traversed.
I’m using one CSV file to save the contacts of my clients and i have to start the next contact in the next one in the next day.
How can i do that?
I will put one attachment of a printscreen of the CSV file for example.

Screenshot_1

2

@Matheus_Antunes

One thing you can do is save the value to an asset …and on the following day…you can first start the bot with reading the asset…if asset is NA then either its start or everything is complete…if asset has a value then

rownumber = Dt.Rows.IndexOf(dt.AsEnumerable.Where(function(x) x("ID").ToString.Equals(str_assetvalue))(0))

This will give you the row number where the data is present …now use

Dt.Skip(rownumber+1).CopyToDataTable as the input for the for loop …so when its NA value will be -1 so it comes to 0 …else if some row index is found it will skip all the rows till that row and then starts from the next

Hope this helps

Cheers

3

Hi @Matheus_Antunes

Another approach

image
image1292×608 38.4 KB 

dtResult.AsEnumerable().Skip(index + 1).CopyToDataTable

Then just loop though the dtResult

Regards

4

you can save the last contact in a text file or something using write text file
so the text file looks like this
image

before your for-each loop add this

  1. read text file to lastdayContact variable
    2 set skip = True
  2. if lastDayContact is empty set skip = False (meaning start from beginning of the file)
    image
    image362×532 17.5 KB

in for each add this logic

image
image975×584 23.8 KB

for reference
Sequence.xaml (18.6 KB)

5

Hey guys!
Thanks for helping me again! I’m very happy with this community, but I’m having some problems running this way :/.
I’m a little newbie to UiPath, but I’m trying really hard.
Can you send me those ideas with another way to execute this?
I believe that my difficulty is in understanding the order in which things need to be in order to work.