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.
Up to 100,000 records can be processed with the freeware version!
Flowheater Chart

Multiple xml files to one xlsx file

  • Christian Oosterling
  • Topic Author
  • Offline
  • User
  • User
More
6 years 4 months ago #3458 by Christian Oosterling
Multiple xml files to one xlsx file - Post(3458) 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 4 months ago - 6 years 4 months ago #3459 by FlowHeater-Team
Replied by FlowHeater-Team on topic Multiple xml files to one xlsx file - Post(3459)
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: 6 years 4 months ago by FlowHeater-Team.

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

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