Cannot Open XML file

More
4 years 5 months ago #21603 by Nardjr
Cannot Open XML file was created by Nardjr
Hi,

I have the following issue.
we have a package where we do an XLST conversion from XML to CSV, which we set up using your tips on thread:
www.etl-tools.com/forum/data-warehousing...xml-files.html#21259

Currently i moved the repository from computer A to computer B. cause i needed to reinstall a computer.
i set up all folders correctly, everything works except for the XSLT converters, they keep saying that they cannot find the directory.
The exact error is:
Error 16-2-2022 14:31:00 Following Error happened: Cannot open file "C:\Program Files\DB Software Laboratory\Advanced ETL Processor Enterprise\"C:\ETL\20211129\ETL\Original sources\DiamondFMSXML\XMLFILE.xml"". De syntaxis van de bestandsnaam, mapnaam of volumenaam is onjuist

Last part is in dutch but it reads: The syntax of the filename, folder or volume is incorrect.
I tried manually resetting up the XLST conversion using the buttons, and pointed out all the correct files and target locations but sadly this did not solve my issue.

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

More
4 years 5 months ago #21604 by admin
Replied by admin on topic Cannot Open XML file
Please post the screeshot of your settings so we can understand the issue better

Mike
ETL Architect

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

More
4 years 5 months ago #21605 by Nardjr
Replied by Nardjr on topic Cannot Open XML file
ERRORLOG:Information16-2-2022 14:31:00Preparing to execute: DFMS_XML-TXT_Company B.V..Information
16-2-2022 14:31:00StartedInformation
16-2-2022 14:31:00Executing:DFMS_XML-TXT_Company B.V..Information
16-2-2022 14:31:00Executing Set Variable:XSLT TransformationInformation
16-2-2022 14:31:00Executing XSLT Transformation : XSLT TransformationInformation
16-2-2022 14:31:00Loading XML File : "C:\ETL\20211129\ETL\Original sources\DiamondFMSXML\XMLFILE.xml"Error
16-2-2022 14:31:00Following Error happened: Cannot open file "C:\Program Files\DB Software Laboratory\Advanced ETL Processor Enterprise\"C:\ETL\20211129\ETL\Original sources\DiamondFMSXML\XMLFILE .xml"". De syntaxis van de bestandsnaam, mapnaam of volumenaam is onjuistError
16-2-2022 14:31:00Failed


Attachments:
The following user(s) said Thank You: admin

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

More
4 years 5 months ago #21606 by admin
Replied by admin on topic Cannot Open XML file
Please remove double quotes around file names

Mike
ETL Architect
The following user(s) said Thank You: Nardjr

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

More
4 years 5 months ago #21607 by admin
Replied by admin on topic Cannot Open XML file
At the moment quotes are automatically added to the file name when it has spaces inside.
We will fix it in the next release.

Mike
ETL Architect

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

More
4 years 5 months ago #21608 by Nardjr
Replied by Nardjr on topic Cannot Open XML file
Yes, This fixed it!

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

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save