FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the SqlServer Adapter Adapter, which may answer your question: CSV text file import , flat file export , Import IDENTITY (Auto Increment) fields , CSV export divided into several files
  • Page:
  • 1

TOPIC: How Import multiple spread sheets with specific order?

How Import multiple spread sheets with specific order? 3 months 2 weeks ago #3536

  • Doron Farber
  • Doron Farber's Avatar Topic Author
  • Offline
  • Posts: 4
Hi,

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

Thanks,

Doron

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

Last edit: by Doron Farber.

How Import multiple spread sheets with specific order? 3 months 1 week ago #3537

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.

File Attachment:

File Name: file-proce...rder.zip
File Size:6 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.
Attachments:

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

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: by FlowHeater-Team.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2019 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en