- Posts: 1
Multiple xml files to one xlsx file
- Christian Oosterling
- Topic Author
- Offline
- User
Less
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 ??
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.
- FlowHeater-Team
- Offline
- Admin
6 years 3 months ago - 6 years 3 months ago #3459
by FlowHeater-Team
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.
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.
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