Back to forum list… Back to How Do I?...

File task: add date to a moved file (No replies)

Arline Welty
5 years ago
Arline Welty 5 years ago

Does the IMAN "Move task" not respond to all Expando fields? I'm looking for something similar to "Evaluate file name" in the move file task but I'm not seeing it. Ideally I would just move a file and give it a dynamic timestamp with today's date. IMAN seems to be writing the formula as a literal (see screenshot)

I have a field in the transformation that I'd like to use: It's called IM_ProcessedFileName. Here's the formula for that field:

Format(Date, "yyyyMMdd") & "_" & %OH.IM_FileName

 

Ideally I could use that variable as my 'new' file name, but IMAN is not responding to any expando field other than %FILENAME%FILEEXT . Is that by design?

 

https://www.realisable.co.uk/wp-content/uploads/2021/12/FileName.png

Contact

    Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

    Looking to purchase IMan, please see our resellers here.

    Realisable Software
    Ph: +44 (0) 208 123 1017

    Copyright © Realisable. All rights reserved.
    Realisable is a registered trademark

    Close

    Request Demo

      Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

      Looking to purchase IMan, please see our resellers here.

      Realisable Software
      Ph: +44 (0) 208 123 1017

      Copyright © Realisable. All rights reserved.
      Realisable is a registered trademark

      Close

      Access Downloads

        Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

        Looking to purchase IMan, please see our resellers here.

        Realisable Software
        Ph: +44 (0) 208 123 1017

        Copyright © Realisable. All rights reserved.
        Realisable is a registered trademark

        Close