Question

How to save filename with timestamp from SAP

  • 22 March 2024
  • 0 replies
  • 50 views

Badge

I am creating a bot to automate the process below at requested time everyday:

 

  1. Login SAP
  2. run T-CODE
  3. get the data of certain countries
  4. export the data in .xlsx (need to indicate the date and the time with the filename)
  5. open the excel
  6. delete unnecessary columns 
  7. save the excel
  8. send the excel via email to PIC

 

Currently still stuck at step 4.

 

Due to the bot need to run twice a day, the PIC requested to indicate the date and time for the excel filename. Previously this bot was created with Brity RPA so they used java script to set the file name as something like ddmmyyyy_TCODE.

 

Initially I planned to save the excel file with ‘set text’ first, then run a batch file to change the filename every time I run this bot.

 

But after doing some research, I found that batch file seems like only can create new folder or new file with timestamp instead of changing the filename of an existing file.

 

So right now I came back with the idea to use the actions in AA360 instead.

 

The filename can be changed even after the excel file is edited. It will do as long as the filename comes with timestamp before it’s sent out.

 

It would be much appreciated if anyone could help on this issue.

 

Thank you~!


0 replies

Be the first to reply!

Reply