two or more linked tables in Access (write side)

mark
Topic Author
Offline
User

12 years 1 month ago #2249 by mark

two or more linked tables in Access (write side) - Post(2249) was created by mark

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.

Please Log in or Create an account to join the conversation.

FlowHeater-Team
Offline
Admin

12 years 1 month ago #2250 by FlowHeater-Team

Replied by FlowHeater-Team on topic Re:two or more linked tables in Access (write side) - Post(2250)

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

Code:

@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

Please Log in or Create an account to join the conversation.

mark
Topic Author
Offline
User

12 years 1 month ago #2252 by mark

Replied by mark on topic Re:two or more linked tables in Access (write side) - Post(2252)

thanks for replay. I`m already working with separate definitions manually and looking forward to the next version.

Please Log in or Create an account to join the conversation.

Gennaro
Offline
User

12 years 1 month ago #2259 by Gennaro

Replied by Gennaro on topic Re:two or more linked tables in Access (write side) - Post(2259)

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

Code:

@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

Please Log in or Create an account to join the conversation.

FlowHeater-Team
Offline
Admin

12 years 1 month ago #2260 by FlowHeater-Team

Replied by FlowHeater-Team on topic Re:two or more linked tables in Access (write side) - Post(2260)

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.

Code:

// 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:

Code:

@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

Please Log in or Create an account to join the conversation.

Time to create page: 0.287 seconds

Main Menu mobil EN

The Data Specialist

Download the Freeware version

two or more linked tables in Access (write side)

FlowHeater - The Data Specialist

PAGES

Legal information

Support & Contact

Contact