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: automatic import and upload csv to access mdb

automatic import and upload csv to access mdb 2 years 7 months ago #2327

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
I get every day 5 csv files at fix time which I need to convert to mdb file.

My steps are :
  1. extract them.
  2. Convert to 5 mdb tables (can I schedule the convert with your program?)
  3. Upload the new db into my webserver.

Which steps you can help me with?

Another question, I see that you have more facilities can I change some fileds before I will put them on the db ?

i.e.
csv file : A;DSL;TSO;RC1;2014-09-01;O;1

mdb file should be
: A;DSL;TSO;RC1;2014-09-01;R;1

I have fix rule for that. If DSL;TSO then change to R

Today I work with your program like that:
I make 5 definitions 1 for each table then each day I open each definition and connect it to the new csv table.

I would appreciate your help
Avishay
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.

automatic import and upload csv to access mdb 2 years 7 months ago #2328

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Avishay,

You could automate and schedule all these steps with just one batch CMD script and the Windows Task Scheduler. You find an example how to implement here: Automated batch CSV import into MS Access

You need for each different CSV file and Access table one FlowHeater definition with our rules for this file.

Then you have to create one CMD script for your needed steps. I’ve made a short example please have a look to the file “automatic-import.cmd” in the attached archive.
The CMD Script works like
  1. Define where the FHBatch.exe and the WinSCP.exe can be found
  2. Import 1-n CSV files with the Batch Module to your Access mdb tables. In the script wildcards are used for each file.
  3. Upload the new Access mdb file to your web server. For uploading I’ve used WinSCP with command line parameters. WinSCP is free, more details can be found here: http://winscp.net/eng/docs/commandline

Manipulate content before importing) That’s the power of FlowHeater. In the example I use the String Replace Heater together with the String Append Heater to implement your rule.


File Attachment:

File Name: automatic-...cess.zip
File Size:17 KB
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.
Last Edit: 2 years 7 months ago by FlowHeater-Team.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.075 seconds