Question

Having dynamic filename in migration jobs

  • 7 December 2021
  • 7 replies
  • 154 views

Badge +1
  • Do Gooder (Customer)
  • 2 replies

I’m trying to make a migration job where the filename should be in the format of: ‘A12 2021 Voucher.csv’

So the format is like this: A[MM] [YYYY] Voucher.csv

I did try to change the dateformat to ‘MM YYYY’ and use &DATF, but then the dateformat is changed for the lines inside the file as well. This is not something I would like to do.

 

Anyone any suggestions on how to make the filename as described without changing the dateformat inside the file lines?


7 replies

Userlevel 1
Badge +7

Hey ,

I have a same requirement to read Dynamic File Names through a Migration Job and appreciate if you could share  details if you manage to get this working.

Thanks

Bhagya

 

 

Userlevel 3
Badge +9

Hi,
Please try this.
 



/Malan Jayanka

Userlevel 1
Badge +2

Old question but for information it is possible to dynamically name the created file in these ways:

 

&DATF Date in same dateformat as migration header
&DATE Date in format YYYYMMDD
&USER The User name of the current user
&GUID Guid
&TIME Time in format hh24iss
&SEQN Sequence Number

 

Badge

Hi,
Please try this.
 



/Malan Jayanka

Tried in IFS Cloud and it is not working.

Userlevel 3
Badge +9

Hi,
Please try this.
 



/Malan Jayanka

Tried in IFS Cloud and it is not working.




What is the cloud version that you tried?
Please refer the below tech doc link

Write Data to File - Technical Documentation For IFS Cloud

 

 

Badge

 

To read the data from the csv using dynamic file name, which is not working, says the error message

 

 

Badge

My Cloud version is 23R2

Reply