Skip to main content
Question

Having dynamic filename in migration jobs

  • December 7, 2021
  • 7 replies
  • 239 views

Forum|alt.badge.img+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?

This topic has been closed for replies.

7 replies

Forum|alt.badge.img+7
  • Sidekick (Employee)
  • 20 replies
  • March 22, 2022

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

 

 


Malan Jayanka
Sidekick (Employee)
Forum|alt.badge.img+9
  • Sidekick (Employee)
  • 35 replies
  • July 4, 2022

Hi,
Please try this.
 



/Malan Jayanka


Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • 8 replies
  • May 15, 2023

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

 


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 3 replies
  • April 17, 2024

Hi,
Please try this.
 



/Malan Jayanka

Tried in IFS Cloud and it is not working.


Malan Jayanka
Sidekick (Employee)
Forum|alt.badge.img+9
  • Sidekick (Employee)
  • 35 replies
  • April 18, 2024

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

 

 


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 3 replies
  • April 19, 2024

 

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

 

 


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 3 replies
  • April 19, 2024

My Cloud version is 23R2