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

v4.1 Move File Task - Expando Fields not working the way I expected (2 replies)

Sue Herrmannn
5 years ago
Sue Herrmannn 5 years ago

I have a client on v4.1 and I am trying to take the sys.inputfile at the end of the job and move it to an archive folder. I'd like to add the date to the file name. I've tried this a couple of different ways:

1. I tried creating a formula with the new file name and referencing it in the destination file box -- %OE0520.NewFileName - the file moved and literally named itself %OE0520.NewFileName - even though I see the NewFileName field in the preview of data.

2. I tried using the %OE0520.FILENAME plus the date plus the %OE0520.FILEEXT - no luck.

What am I missing? See snapshot of my move file screen and File Explorer showing how it named/moved the file...

https://www.realisable.co.uk/wp-content/uploads/2019/08/move-file-expando-fields.jpg
Support
5 years ago
Support 5 years ago

Sue, presently this isn't supported.

The reason is there source file with a wild card could match more than 1 file, and you may end up deleting files in the process (by renaming them all to a single name).

Thanks

Sue Herrmannn
5 years ago
Sue Herrmannn 5 years ago

Okay, good to know. I'll get creative. Thanks!

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