Question

Having dynamic filename in migration jobs

  • 7 December 2021
  • 7 replies
  • 161 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

Badge

My Cloud version is 23R2

Badge

 

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

 

 

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

Hi,
Please try this.
 



/Malan Jayanka

Tried in IFS Cloud and it is not working.

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

 

Userlevel 3
Badge +9

Hi,
Please try this.
 



/Malan Jayanka

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

 

 

Reply