TOPIC:

Is the only way to doing Command Line Processing to use FHBatch ?

I have a set of definition files (inputs being Flat File Text , Excel Spreadsheets & CSV ) that I convert into a SQLite3 Database .

I have a Master.DB that has initial tables setup that need to be expanded with the above inputs.  That I want to copy to the
proper name as the setup of the Output File.

The Input files come with monthly names and the out database file needs to be monthly named however the table names
rename generic from month to month to make the 100+ SQL scripts not need to be updated going forward.

I would need to override the Input FileNames & Output FileName as I run thru the process each month.  From what I have read
it would appear I need FHBatch and that the Designer would not allow Command Line Processing, correct?  I am the only that
needs to run this so I am not trying to pass the processing along to someone else to do.  Just automate going forward.

Regards,
Keith
Request received via Email

Hello Keith,

Command line parameters are only accepted by the Batch Module . Here it would be possible to use also wildcards.

e.g.
FHBatch.exe /ReadFileName *.csv Your-Import-Definition.fhd


But there are two other ways available to proceed some files automatically.

1. If you daily receive a file with the current date as part of the file name you may use FlowHeater Parameters . This parameter can be dynamically set with the help of the .NET Script Heater  or with a pre dummy processing step. I´ve made two short examples to demonstrate this. Please have a look to the attachment. In this case you never have to change the read file name before executing the Definition.
   
   
2. With the FlowHeater Server  you can perform a directory monitoring. The  FlowHeater Server starts the Definition as soon as a new file is available in this folder. The FlowHeater Server also take care about the file name and changes this automatically before executing the Definition, no further interaction is needed.