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

Multiple xml files to one xlsx file

  • Christian Oosterling
  • Topic Author
  • Offline
  • User
  • User
More
5 years 8 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 adress all xml files in this directory?
(one xml file is the adress 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 to join the conversation.

More
5 years 8 months ago - 5 years 8 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: 5 years 8 months ago by FlowHeater-Team.

Please Log in to join the conversation.

Time to create page: 0.351 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.