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: two or more linked tables in Access (write side)

two or more linked tables in Access (write side) 4 years 1 month ago #2249

  • mark
  • mark's Avatar
  • Offline
  • New Member
  • Posts: 5
When using multiple linked tables in my (write side) database for example, children and parents, Is it possible to process simultaneously two or more Access tables?
If I write data in separate tables, in separate process the database remains unbound. To make it work, I need access all new rows manually and bind data using table lookup values.
Is there any possibility that I still have not noticed to make this process easier.
The administrator has disabled public write access.

Re:two or more linked tables in Access (write side) 4 years 1 month ago #2250

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

This functionality is planned for early next year. Currently you have to create two (or more) separate FlowHeater definitions and run this one after other either manually by using the Designer or automatically by using a little CMD script and the help of the Batch Module.

Example Batch CMD script
@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files\FlowHeater V2\BIN\FHBatch.exe"

%FHBATCH% import-master-table.fhd
%FHBATCH% import-detail-table.fhd
REM … and so on
In case you post more details I could make a little example how to do this.
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.

Re:two or more linked tables in Access (write side) 4 years 1 month ago #2252

  • mark
  • mark's Avatar
  • Offline
  • New Member
  • Posts: 5
thanks for replay. I`m already working with separate definitions manually and looking forward to the next version.
The administrator has disabled public write access.

Re:two or more linked tables in Access (write side) 4 years 1 month ago #2259

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
FlowHeater wrote:
Hi Mark,

This functionality is planned for early next year. Currently you have to create two (or more) separate FlowHeater definitions and run this one after other either manually by using the Designer or automatically by using a little CMD script and the help of the Batch Module.

Example Batch CMD script
@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files\FlowHeater V2\BIN\FHBatch.exe"

%FHBATCH% import-master-table.fhd
%FHBATCH% import-detail-table.fhd
REM … and so on
In case you post more details I could make a little example how to do this.


Hi Robert,

I need to process several files but one by one through
more flowheater sequential definitions.

e.g.
step 1: process sequential flowheater definitions on file 1
step 2: process sequential flowheater definitions on file 2
step n: process sequential flowheater definitions on file n


I was wandering If you can suggest a script for doing this.

thank you

regards
The administrator has disabled public write access.

Re:two or more linked tables in Access (write side) 4 years 1 month ago #2260

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

It’s possible but a bit tricky. You have to use the help of the .NET Script Heater and the following little script to set the output file name for each current processing file.
// NOTE! to use this script you have to switch the "Execute when" option to "Start"
public object DoWork()
{
  // get access to the read/write TextFile adapters
  TextFileAdapter read = (TextFileAdapter)AdapterRead;
  TextFileAdapter write = (TextFileAdapter)AdapterWrite;


  // obtain the read file name, extract directory and file name without extension
  string directory = Path.GetDirectoryName(read.Filename);
  string filename  = Path.GetFileNameWithoutExtension(read.Filename);


  // set new write file name with new extension for next step!
  write.Filename = Path.Combine(directory, filename + ".step1");


  // just return null
  return null;
}

The script obtains the current READ file name, set this filename on the WRITE side and modifies the extension for the next step.

NOTE: You have to switch the .NET Script Heater "Execute when" option to "Start"

For example:
  • Step 1: Read all files who match the wildcard *.step1 and generate new files with output file name *.step2
  • Step 2: Read all files who match the wildcard *.step2 and generate new files with output file name *.step3
  • Step 3: Read all files who match the wildcard *.step3 and generate new files with output file name *.csv = !!! FINAL STEP !!!

Exampe Batch CMD Script:
@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files\FlowHeater V2\BIN\FHBatch.exe"

%FHBATCH% /ReadFileName *.step1 transform-1.fhd
%FHBATCH% /ReadFileName *.step2 transform-2.fhd
%FHBATCH% /ReadFileName *.step3 transform-3.fhd
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.081 seconds