Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Scheduled import of CSV files

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
9 years 3 months ago #2342 by FlowHeater-Team
Scheduled import of CSV files was created by FlowHeater-Team
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 to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
9 years 3 months ago #2343 by FlowHeater-Team
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
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 to join the conversation.

Time to create page: 0.284 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.