Hi Andrew,
To support wildcards (e.g. C:\Temp\*.csv) you have to use the
Batch Module
option /ReadFileName
For example: FHBatch.exe /ReadFileName C:\Temp\*.csv adopt-csv-filename.csv
NOTE: All CSV file who match this condition are processed!
Here you find an example how it works:
Automated batch CSV import into MS Access
To adopt the
CSV filename
into the Definition for further processing you need the help of the
.NET Script Heater
and the simple Script below.
public object DoWork()
{
// adopt the CSV file name from the READ Side!
TextFileAdapter adapter = (TextFileAdapter)AdapterRead;
// get file name without path
string filename = Path.GetFileName(adapter.Filename);
// return the file name
return filename;
}
The script returns just the CSV filename without the path. With the
String Append Heater
you have to add a prefix “FH_” to this result and afterward set this value to a
FlowHeater Parameter
by using the
Set Parameter Heater
. This Paramater (e.g. $FILENAME_WRITE$) you have to use in TextFile Adapter for the CSV output file name.
I’ve made a simple example for this, please have a look to the example adopt-csv-filename.zip
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
