Pick 50 cells each time

[Sonam_Nath]

I was working on creating a bot for compressing images but the site only accept 50 images at once and I have a data of like 6000 images to be compressed. Is there any possibility for me to put a validation where the bot can pick 50 cells each time and start again from where it dropped off.

[THIRU_NANI (NaNi)]

Hi! Welcome to community!

Could you please show us the data how it looks like?

You can use Data Scraping to extract the data… First scrape the first page data if page available… after extracting the first page data you can choose the next page option… This will scrape the entire data…

Regards,
NaNi

[Sonam_Nath]

Hello, Thanks For replying!

So the data is in URL Format which I am putting on the http://bulkImagecompressor.com website and the problem is that website only accept 50 Images at once but I have like total 6000 something URLs.
So it would be a great help if you can tell me what to do

[harinathreddy.yn (Hari)]

You mean 50 images each time? move/copy first 50 images to a different folder and compress, delete the folder you created and move 50 images again.

Let me know If I misunderstood your problem.

Thanks,
Harinath

[Sonam_Nath]

Oh, Okay. I’ll give it a try. Can you tell me can we do bulk upload by uipath if we want to upload each images on a website later.

[ppr (Peter Preuss)]

it looks like you want to segment the datatable to splits with 50 rows.

have a look here for segmenting a datatable:

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …