TOPIC: How Import multiple spread sheets with specific order?

Hi,

How to Import multiple spread sheets with specific order?
Please provide steps.

Thanks,

Doron

Hi Doron,

To import multiple CSV / XML files or Excel spreadsheet you can use the Batch Module (FHBatch.exe) with wildcards and the command line option /ReadFileName

e.g. FHBatch.exe /ReadFileName  C:\Temp *.xlsx Exel-Import.fhd

The order will be the alphabetic order like the “dir” command in the console. Currently no other order supported by default but have a look to the workaround below.

With the FlowHeater Server it would be possible to setup a file monitoring on a specific directory and the import order will be the file creation time.
Note: You can change the line/row processing order within a definition during the import process with the Sort Heater or the InMemory Adapter . Here you can find an example how the InMemory Adapter works: Merging CSV and Excel data using the InMemory Adapter


Workaround
It would be possible to create a temporary CMD script during a data import/export process. The steps are.

1. Get the file names from a certain directory using the console "dir" command and store the output in a text file “files.txt”
2. Create a FlowHeater Definition and process this file. Filter  out all unwanted lines, store the file names and create timestamp using an InMemory Adapter  table.
3. Sort the InMemory Adapter table like you want and create a temporary CMD script

I´ve attached a brief example.

Please note) The example use German “dir” settings. You have to modify the FlowHeater with your locales first.