Skip to main content
simply more productive
The Data Specialist

✅ Easy data integration - import/export
✅ No programming required thanks to visual modeling
✅ Simple ETL tool with versatile options

Flowheater Chart

Multiple xml files to one xlsx file

  • Christian Oosterling
  • Topic Author
  • Offline
  • User
  • User
More
8 years 1 week ago #3458 by Christian Oosterling
Multiple xml files to one xlsx file was created by Christian Oosterling
Hi.
I am trying to read multiple xml files, and write the information to one! excel xlsx file.
The xml files is automaticaly gennerated from my webpage, so this is a function i need for printing address labels on my rfid printer.

When i use xml adapter, and target one xml file, everything just works, and the xlsx file contains the rigt stuff in all the right places.
My question is: how do i address all xml files in this directory?
(one xml file is the address to one customer)
I hav tried \Documents\xml\*.xml. This generates following error message: Illegal characters in path.
What to do :-) ??

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

More
8 years 1 week ago - 8 years 1 week ago #3459 by FlowHeater-Team
Replied by FlowHeater-Team on topic Multiple xml files to one xlsx file
Hi Christian,

I´m affraif the XML Adapter (or even the TextFile and Excel Adapter ) are not supporting wildcards for file names. In case you would like to procedd all XML Files with one designed Definition you need the help of the Batch Module .

In your case you have to use the Batch Module with the option /ReadFileName *.xml

For example: FHBatch.exe /ReadFileName C:\Temp\*.xml your-excel-import-definition.fhd

With this option the Batch Modul proceed all present XML files in the C:\Temp directory.

Best wishes
Robert Stark
Last edit: 8 years 1 week ago by FlowHeater-Team.

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

Time to create page: 0.132 seconds
FlowHeater Logo
FlowHeater - The Data Specialist
Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.
Legal information
Support & Contact
Contact

Phone:
0951 / 9933 9792

eMail:
info@flowheater.net


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