Get only .xls file from the folders

Help
21

bro did same but giving the same error as I mentioned above. It seems everything is fine. Please see the above error bro

image
image860×412 15.8 KB

22

This is the error
image

1 Like
23

Buddy you cannot send a directory as a file path input so what we can do is i want to know what is the output of get files first, so lets just use a writeline activity to see what is the output we get simple
inside the for each loop use a writeline activity with input as item.tostring and lets see what is coming up as output

Cheers buddy lets sort this out, we are almost done @balkishan

1 Like
24

I’m so sorry for the late response bro.
Got the .csv format bro

image
image751×242 11.6 KB

1 Like
25

Is this you want buddy @balkishan

Cheers

1 Like
26

@Palaniyappan yes bro, I want this, so how to save this in a particular folder bro. Bro if you see here this file is in the first folder of Export. and the file name is extracted_information.csv, But the same file name will be in the next folder…so how can we save, do we need to use timestamp here?

1 Like
27

You can save this in a particular folder by just using move activity, by mentioning the source filepath as this (item) and the destination path that you want
no NEED to have timestamp as the path will be varying if its going to be from another folder buddy

Cheers @balkishan

1 Like
28

@Palaniyappan See bro, We need to create a timestamp, because 1st file is copied when come to the second file it says that can’t create file because same name file is existing in the folder.
image

29

So, you can use assign activity to create a timestamp (timeStamp = DateTime.Now.ToString()) and in move file activity you have the source from and to path where you want to move it put destination path an insert timeStamp in front of the file format, i.e. something like finalPath = , and to destination, you can write: finalPath.Insert(finalPath.LastIndexOf(“.”),timeStamp).

30

Buddy with the file name we can just concatenate the datetime as string like budy
path.GetFileNameWithoutExtension(yourpathinstring)+Datetime.Now.Tostring(“dd-MM-yyyy hh:mm tt”)

Simple buddy @balkishan
Try and let know buddy and lets sort this out today

Cheers @balkishan

3 Likes
31

Really?
If you have fileName = myFile.xlsx, you wil get string myFile.xlsx14-05-2019…,won’t you?

1 Like
32

@Palaniyappan Thanks a lot bro. It worked :slight_smile:

1 Like
33

Amazing
Cheers buddy @balkishan
Keep going

1 Like
34

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.