Scheduled import of CSV files
- FlowHeater-Team
-
Topic Author
- Offline
- Admin
-
- FlowHeater-Team
-
Topic Author
- Offline
- Admin
-
9 years 11 months ago #2343
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic Scheduled import of CSV files
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
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
Code:
@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.250 seconds
