-
FlowHeater-Team
-
Topic Author
-
Offline
-
Posts: 391
-
-
-
-
|
Is there some way that Flowheater can check a folder for the presence of a file in a folder every 15 minutes. If there is a CSV file present, import the data. Then move the file to a different folder.
Thanks
Kim
[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.
|
-
FlowHeater-Team
-
Topic Author
-
Offline
-
Posts: 391
-
-
-
-
|
Hi Kim,
Yes of course
You need the help of the
FlowHeater Batch Module
, an additional CMD Batch script and nevertheless a Windows Task to schedule the periodical call of this task.
You’ll find an example here:
Automated batch CSV import into MS Access
Example Batch CMD script for CSV Import automation@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files (x86)\FlowHeater V3\BIN\FHBatch.exe"
REM set the path and CSV file name you can use wildcards!
set FILES=c:\Temp\import*.csv
REM Check whether CSV files are available
if exist %FILES% goto IMPORT
echo No files available
goto END
:IMPORT
%FHBATCH% /ReadFileName %FILES% C:\FH\import.fhd
REM move the proceeded CSV files to the archive folder
move %FILES% C:\FH\Archive\
:END
echo END
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.
|
Time to create page: 0.093 seconds