- Posts: 6
- Thank you received: 1
Cannot Open XML file
1 year 7 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.
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.
1 year 7 months ago #21604
by admin
Mike
ETL Architect
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.
1 year 7 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
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
The following user(s) said Thank You: admin
Please Log in or Create an account to join the conversation.
1 year 7 months ago #21606
by admin
Mike
ETL Architect
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.
1 year 7 months ago #21607
by admin
Mike
ETL Architect
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.
We will fix it in the next release.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
1 year 7 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.