Skip to main content
Question

Having dynamic filename in migration jobs

  • December 7, 2021
  • 7 replies
  • 217 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 comments

7 replies

Forum|alt.badge.img+7
  • Sidekick (Employee)
  • 18 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+2
  • Do Gooder (Partner)
  • 4 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
Malan Jayanka wrote:

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
Cajeth wrote:
Malan Jayanka wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings