FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Command Line Processing

Command Line Processing 1 week 1 day ago #3566

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 347
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

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.

Please Log in or Create an account to join the conversation.

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.

Command Line Processing 1 week 1 day ago #3568

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 347
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.

File Attachment:

File Name: parameter-...name.zip
File Size:12 KB

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.
Attachments:

Please Log in or Create an account to join the conversation.

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.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2020 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en