Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Scheduled import of CSV files

Scheduled import of CSV files 1 year 11 months ago #2342

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
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.
The administrator has disabled public write access.

Scheduled import of CSV files 1 year 11 months ago #2343

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
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.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.071 seconds