LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jberry

Is there a way to create a new folder in which to output a csv file. I want my csv to be output into an automatically generated folder named on today's date.
c:\mystuff\TODAY(CCYYMMDD)\myfile.csv

I thinking about a node that can run a DOS command?

Thanks

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

This is a rather roundabout method to solve the problem, but can be done with standard nodes (doesn't require a DOS command node).

Setup a static data node that generates a single record of output.
Connected to that, add an OutputBRD node.. Pick your directory and some random filename.
Then, on the Parameters 2 tab, select the option "Create".

Run the node(s) and it will create the folder, and the BRD file within it.
From there, you can delete the file with the moveFile() operator in a filter.
Then you can write your CSV file into the folder with no problem.

I believe there already is an enhancement request in the system to add the "Create" option to the OutputDelimited node.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: hlahteenma

Hi,

Sorry to pick this old thread up like this but has there been any updates on the automatic creation of a new output folder (e.g. a subfolder that doesn't yet exist in the output folder)? I'm running the 6.1 version on the server environment or similarly on the desktop version.

Thanks in advance for your time.

-Heikki