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

two or more linked tables in Access (write side)

More
11 years 5 months ago #2249 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 to join the conversation.

More
11 years 5 months ago #2250 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:two or more linked tables in Access (write side)
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

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.

More
11 years 5 months ago #2252 by mark
thanks for replay. I`m already working with separate definitions manually and looking forward to the next version.

Please Log in to join the conversation.

More
11 years 4 months ago #2259 by Gennaro
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 to join the conversation.

More
11 years 4 months ago #2260 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:two or more linked tables in Access (write side)
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

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.341 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.