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 Chart

Multiple xml files to one xlsx file

  • Christian Oosterling
  • Topic Author
  • Offline
  • User
  • User
More
6 years 3 months 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 :-) ??
Attachments:

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

More
6 years 3 months ago - 6 years 3 months 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

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: 6 years 3 months ago by FlowHeater-Team.

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

Time to create page: 0.264 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:
This email address is being protected from spambots. You need JavaScript enabled to view it.


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