BalaReva.Externals.Activities


#1

1.Simple download file . 2.Zip the files.3.UnZip the Zip flie

Package: BalaReva.Externals.Activities
Author: @balupad14


Zip and Unzip files
BalaReva.Externals.Activities Continue
How to Unrar multiple files inside a folder
How to compress and save in a specific folder
How to remove a row from a Excel Data Table?
Zip and unzip a file in uipath
#2

Hi Friends,

I have update the package “BalaReva.Externals.Activities” with some new features in Zip Files Activity.

Now the zip file activity is having the option to do the zip with multiple folder. Here I have attached sample for your reference and also I have attached other activities sample to know all

1.Zip

FolderOption:Single

File : SingleFolder.xaml (4.3 KB)

FolderOption:Multiple

File: MultipleFolder.xaml (4.6 KB)

3.Download File

File DownLoad File.xaml (4.3 KB)

Regards
Balamurugan


Extracting Pdfs from website
Download File activity
Type Into activity not working as expected
Download all the images from a website
Type Into activity not working as expected
ZipAndUnzipFile.UnZipFile' --> why i am getting this error?
How to zip multiple Folder into single ZipFile?
UIElement is no longer valid
異なるフォルダに入っている複数のファイルをzip化する方法
Loop excel
Download Image Activity
#3

Hi Friends ,
Here you can see the quick reference by picture.

1.Zip Files Activity

1.1 .FolderOption = Single

1.2.FolderOption = Multiple

~

  1. UnZip File Activity

  1. Down File Activity

Thank you
Balamurugan


How to zip files using invoke method?
Compress Files
"Could not load file or assembly ‘System.IO.Compression" when trying to unzip
Unzip files
Unzip Files using invoke method
Compress files to .zip format
Unzip .tar.gz files
Read the contents of Zipped(compressed) folder without extracting them
Zip and unzip files?
#4

Hi friends,
I have update the package “BalaReva.Externals.Activities” with some new components Directory size and file size.

  1. Directory Size.
    It will return the total size of the directory.
    it has option to include the sub directory or not
    Can able to search directory name inside the root directory.
    File Sample : DirectorySize.xaml (5.3 KB)

  2. File Size.
    It will return the total size of the File.
    File : FileSize.xaml (5.0 KB)

  3. Renamed the Zip Files activity to Zip activity

  4. Renamed the UnZip Files activity to UnZip activity

Thank you
Balamurugan


Download File activity
Customized activity Folder/File size identifier
#5

Hi friends,
I have update the package “BalaReva.Externals.Activities” with some new components Service Status and Service execution.

  1. ServiceStatus
    Return the status of the window service
    File : ServiceStatus.xaml (4.9 KB)

  2. ServiceExecute
    Can Start,Stop,Pause,Continue the windows service…
    File :ServiceExecute.xaml (5.1 KB)

Important Note:
Must have to import the “System.ServiceProcess”

Regards
Balamurugan


Custom Activity : System Service Manager
#6

Hi Friends,
First of all I thank to all and who are updating the bugs and suggestion with me.
In the Unzip activity .It has bug. Now it is fixed. you take the latest version 1.3.2.

Here I have attached the sample : Unzip.zip (1.9 KB)

Let me know if you have any issue and also I would happy to receive more suggestions.

Regards
Balamurugan


Unzip Password protected file
#7

Hi @balupad14 ,
I am getting error when I trying the latest package to unzip and zip file using encryption.“UnZip : The given path’s format is not supported.”
I tried editing the example that you have sent then also it is giving me error not sure why.


#8

Hi @KapilJain,

Thank you for the feed the feedback.

Here I have attached a sample with zip file . It is working well. But I believe that something problem happen. Can you please send me a sample file to test at my side to ensure the problem.

File :Unzip0001.zip (10.0 KB)

Regards
Balamurugan.S


#9

Hi Friends,

I have included a new activity in the package to trace the activity like log.

Name Space:
image

Properties
image

Sample : logText.zip (2.2 KB)

Regards
Balamurugan.S


How to keep track of records status(success or failed) into excel
How to Create an Own Log file using Text Document?
#10

Hi Friends,

In the UnZip Activity. I have added a new property called Code Page. It is to extraction for multiple languages.

image

I really thank to @Toby for the feedback .

By Default it is 1252. And 932 is for the Japanese language.

You can find code page number in the below link to all the languages

Here I have attached the sample :

toby.zip (843 Bytes)

Thank you
Balamurugan.S


#11

Dear Balamurugan,

The new version work fine, my file was extracted successfully.

Great thank you.

Toby


#12

Hi Friends,

I have added a new activity to get exchange .

Namespace :
image


Properties :
image

Sample : ExchangeRate.zip (1.9 KB)

Note :
The counties currency codes are available in the below gallery of Documentation.

Let me know if you have any error
I would be happy to get more suggestions

Regards
Balamurugan.S


Converting valuta? (e.g. from euro to dollar)
#13

Hey balupad!

Your exchange rate activity is very powerful and probably a must for many people, but how do you convert all the data from an excel file with the column “Price” that contains a STRING of data e.g. “£3300,23”?

I want to convert all the rows from british pund to DKK but i’m not quite sure how to do that.


#14

Hi Balamurugan,
Thx for this package.

However I found a conflict of this package and Studio 2018.2.3

After upgrade to Studio 2018.2.3 I start getting error “Method ‘Newtonsoft.Json.Linq.JToken get_Item(System.String)’ declared on type ‘Newtonsoft.Json.Linq.JObject’ cannot be called with instance of type ‘Newtonsoft.Json.Linq.JObject’” in a workflow using Newtonsoft.Json library. After in-depth investigation I found this library embedded in your package, but in different version (10.0.2). It caused the conflict with system wide installed version 8.0.3. After removing Newtonsoft.Json.dll from your package everything works fine again.

Cheers,
J0ska


#15

Hi @Ibra,

Sorry for my delay reply. Can you please add the sample excel sheet to test my side. I will attach it with xaml.

Regards
Balamurugan.S


#16

Hi @J0ska ,

Thank you for the review. Unfortunately I have upgrade my studio to 2018.3.0-beta.1. It is working in this version. But I will let you after I tested in the 2018.2.3 version.

Thank you
Balamurugan.S


#17

amazoniPhoneX.xlsx (9.2 KB)
ebayiPhoneXData.xlsx (17.2 KB)


#18

Hi @Ibra,

Here I have attached the solution xmal. I have converted to USD . The both excel .

File : ExchangeRate.zip (46.2 KB)

To Know about the currency code please Click the show more in below documentation .

Regards
Balamurugan.S


#19

Unfortunately it gives a xaml error at the For Each Row. I cannot see the steps you made there…


#20

i have developed in UiPath Studio 2018.3 beta-1