BalaReva.Externals.Activities

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

Package: BalaReva.Externals.Activities
Author: @balupad14

4 Likes

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

5 Likes

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

The latest zip and unzip activity is here…~

Thank you
Balamurugan

5 Likes

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

2 Likes

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

2 Likes

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

2 Likes

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.

2 Likes

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

2 Likes

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

2 Likes

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

3 Likes

Dear Balamurugan,

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

Great thank you.

Toby

1 Like

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

3 Likes

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.

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

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

2 Likes

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

2 Likes

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

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

2 Likes

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

i have developed in UiPath Studio 2018.3 beta-1

2 Likes