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

Use Dynamic File path OR dynamic file name in CSV writer? (2 replies)

Arline Welty
5 years ago
Arline Welty 5 years ago

Hi there, 

I can't seem to get something working and hope you have advice. I need to create a file each month and want the names to include a field called %FileDate so that they are date-stamped. I am trying to either:

  • Create a CSV file using CSV writer, that has an expando field in the file name. EG, I'm trying to use "Invoices" & %FileName & ".csv"
  • If that can't work, how about a dynamic folder in which I can put the file? I've tried using the CreateFolder function, which worked, and then when trying to define the file path, I used: 

    Dim Dir

    Dir = "\\GroupDocs\Sage2019\IMAN_File\" & %FileName

    CreateFolder(Dir)

Both of these attempts result in an error: 

"Illegal characters in path."

 

I'm confused by the illegal characters. The characters in %FileName are: 2020-04-23_Invoices

I've also tried to change the expando field from %FileName to ones that are strictly letters. Same result.

So is this possible? I was referencing this page, which shows exactly what I want to do:

https://www.realisable.co.uk/support/Documentation/iman-user-guide/IOControllers/File.htm

Support
5 years ago
Support 5 years ago

Have you enabled the 'Evaluate File Name'?

Thanks

Arline Welty
5 years ago
Arline Welty 5 years ago

Thank you, I completely blew past that. And I was also trying to use Expando fields in the file path itself, and that threw a "syntax error." But once I just used a plain vanilla path, and moved all the Expando fields to the file name itself, I was back in business. Thank you for pointing that out.

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