- Posts: 444
Scheduled import of CSV files
- FlowHeater-Team
-
Topic Author - Offline
- Admin
-
- FlowHeater-Team
- Topic Author
- Offline
- Admin
-
10 years 5 months ago #2343 by FlowHeater-Team
Best wishes
Robert Stark
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
Please Log in or Create an account to join the conversation.
Time to create page: 0.262 seconds
