Skip to main content
Question

Having dynamic filename in migration jobs

  • Dec 7, 2021 9:49 AM UTC
  • 7 replies
  • 313 views

Forum|alt.badge.img+1
  • Do Gooder (Customer)

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)
  • Mar 22, 2022 5:11 AM UTC

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)
  • Jul 4, 2022 6:04 PM UTC

Hi,
Please try this.
 



/Malan Jayanka


Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • May 15, 2023 6:17 PM UTC

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)
  • Apr 17, 2024 8:26 PM UTC

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)
  • Apr 18, 2024 4:00 AM UTC

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)
  • Apr 19, 2024 6:36 PM UTC

 

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)
  • Apr 19, 2024 7:57 PM UTC

My Cloud version is 23R2