Sort file and store attributes

[aksh1yadav (AKSHAY YADAV)]

@selrac

The files have a reference ID based on the date & time that has been created like YYMMDDHHMMSS. This allows to order the files. But how can UiPath order the files so that it pickups up the older? Basically I want to create a first in first out sequence, so that the older request is being processed.

Please try this:

folder_path = “D:\TestExcel”
dir_info = new DirectoryInfo(folder_path)

dir_info.GetFiles().OrderBy(Function(x) x.CreationTime)

*Note- if you wants to sort on the basis of latest to old by replacing “OrderBy” to" OrderByDescending".

@selrac

I need to read some data from the file to do a few tasks. The contents of the file is something like this:
From: user@server.com
Sent: 25 March 2017 12:37
To: Rob1
Subject: Rob1
Task: Process1
Attrib1: FEB17
Attrib1: 200012

The information I need to capture is

The email, so that I can inform the user that the task is being processed. (I don’t see an activity in UiPath, is it possible to send emails?)
The Task to start the required process
The attributes that are required in the task

I have attached 2 workflow named as follows:

1. Sort_Dir_files_Creation_time.xaml //For to sort files on the basis of dates cretion from last to new
2. textdatahandling.xaml // For to Handle your text file data.

@selrac

I don’t see an activity in UiPath, is it possible to send emails?)

Yes it is possible to send an email by using “Sent outlook mail” or “Send Smtp mail” or “Send exchange mail” activities.

You are not able to see those activities because you have not installed “UiPath.Mail.Activities” package.first install it then after restart check it.

and if you do not know how to install packages then please search previous post on forum

For further assistance please review this attached workflow and let me know

Sort_Files_and_attributes.zip (4.9 KB)

Regards…!!
Aksh