Uniquely rename file

Help Studio
, ,
1

I have one sample excel file. I’m coping that file to new location with unique name .for 1st record i’m using write range & for remaining record i’m using append range to add results. Every time when i run process i want to use that sample file template to store the results in it. So my problem is how can i rename that file with unique name. Currently i’m using date time but that process has multiple records.for every record time changes then how can i use that file created at 1st record time.
@Sudharsan_Ka @supermanPunch @Anil_G

2

Hey @pravin_bindage,
Instead of date time you can just use just date now.tostring(“dd/MM/yyyy”) so for that date you can use template. Along with that can give the count to make it unique the number of times you ran per day

Cheers.

3

HI @pravin_bindage

Assign a New integer value
CountFile=0

Before creating the file
Assign CountFile=Countfile+1
WHen creating the file you can use

"Filename_date+CountFile.toSTring

So If you use Filename_07032023_1 it will get you the first file that is created

Regards
Sudharsan

4

If i run same process again same day with different records then it overwrites that earlier file?

5

If you run the process multiple time try this

Give the file name like this
FIlename_Date_ +(Directory.GetFiles(FolderPath,“FileName_date*.extension”).Count+1).Tostring.extension

Then it will be updated based on the file count in the folder so the file will not be overwrited

Regards
Sudharsan

6

@pravin_bindage

You can store the time and use it as the file name for whole of the process

At the start of the process use a variable and store "FileName_" + Now.ToString("MMddyyyyhhmmss") + ".xlsx" say this is stored in str variable

Then in whole of the process for every transaction we can use the same name and as it contains timestamp…for everyrun it would be unique as well

Hope this helps

Cheers

7

In which state of RE Framework should i store it?

8

@pravin_bindage

You can store it in initialization state inside the first run if condition…

So that it can be unique for the run and can be used across the transactions

Cheers

9

image
image1156×945 58.7 KB

i checked add headers option but still headers not adding is there anything i’m missing?

10

@pravin_bindage

In the main datatable do you have headers?

If yes then in the required write range did you check the add headers option…

Please check the same…

Cheers

11

Yes my sample excel have headers which i use as a template

12

@pravin_bindage

If your template already has headers…then I see you are writing from A1…instead write it from A2…as the first row already has headers in it

Cheers

1 Like
13

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