|
Welcome,
Guest
|
TOPIC:
Scheduled import of CSV files 6 years 2 months ago #2342
|
|
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. |
Scheduled import of CSV files 6 years 2 months ago #2343
|
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 |
|
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. |
