topic Re: Generating XML from QVD, double quotes in QlikView

Generating XML from QVD, double quotes

Snaigius213 — Thu, 02 Jan 2025 13:35:44 GMT

Hello,

trying generate XML file from QVD file, but have problems with quotes.

IF in code i write - '<?xml version="1.0" encoding="UTF-8"?>'

at result file i get "<?xml version=""1.0"" encoding=""UTF-8""?>"

and in data rows, where are values i need values insert in quotes ("xxx"), but finally get ""xxx""

Here is my script:

SET vSourceFile = 'xxx.qvd'; SET vOutputFile = 'xxx.xml'; TempXML: LOAD '<?xml version="1.0" encoding="UTF-8"?>' AS XML_LINE AUTOGENERATE 1; CONCATENATE (TempXML) LOAD '<ROOT><InitStocks>' AS XML_LINE AUTOGENERATE 1; STOCK_DATA: LOAD CUST_ID, STATUS, DTLM, STOCK, LOT_ID, LOCALCODE, WAREH_CODE FROM $(vSourceFile) (qvd); FOR i = 0 TO NoOfRows('STOCK_DATA') - 1 LET vXMLRow = '<InitStock CUST_ID=' & Trim(Peek('CUST_ID', i, 'STOCK_DATA')) & ' ' & 'STATUS=' & Trim(Peek('STATUS', i, 'STOCK_DATA')) & ' ' & 'DTLM=' & Trim(Peek('DTLM', i, 'STOCK_DATA')) & ' ' & 'STOCK=' & Trim(Peek('STOCK', i, 'STOCK_DATA')) & ' ' & 'LOT_ID=' & Trim(Peek('LOT_ID', i, 'STOCK_DATA')) & ' ' & 'LOCALCODE=' & Trim(Peek('LOCALCODE', i, 'STOCK_DATA')) & ' ' & 'WAREH_CODE=' & Trim(Peek('WAREH_CODE', i, 'STOCK_DATA')) & ' />'; CONCATENATE (TempXML) LOAD '$(vXMLRow)' AS XML_LINE AUTOGENERATE 1; NEXT; CONCATENATE (TempXML) LOAD '</InitStocks></ROOT>' AS XML_LINE AUTOGENERATE 1; STORE TempXML INTO [$(vOutputFile)] (txt);

Tryed use Chr(34), But nothing helps.

If here i write " - 'STATUS="' & Trim(Peek('STATUS', i, 'STOCK_DATA')) & '" ' &

in xml i get:

"<InitStock CUST_ID=6 STATUS=""2"" DTLM=20241223 04:41 STOCK=168.0000 LOT_ID=0 LOCALCODE=4860019001421 WAREH_CODE=EN1 />"

-----------------------------------------------------------------
Now are writed macro, but i want remove the macro and make all in one script

Re: Generating XML from QVD, double quotes

David_Friend — Thu, 02 Jan 2025 13:49:48 GMT

does this help:
https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/use-quotes-in-script.htm

What happens if you use single quotes?

Re: Generating XML from QVD, double quotes

Snaigius213 — Thu, 02 Jan 2025 13:54:24 GMT

I try search many info.

but if use single quotes, i get the same :

Re: Generating XML from QVD, double quotes

marcus_sommer — Thu, 02 Jan 2025 15:52:39 GMT

AFAIK it's not possible. Not because the Qlik-load wouldn't be able to create the wanted data-structure else the provided store-feature into a txt has no configurations in regard to the quote-handling. As far as there are any quotes they will be embedded with further ones.

Depending on the target you may replace the quotes with other chars and advising the target which chars are now which kind of quotes and/or using the feature that some targets interpret n following quotes as one quote - both are more theoretically possibilities as practically solutions ...

Another look may go to store the data into a *.qvx - which creates a xml but I never tried that in such a way and it may come with any other overhead ...

Therefore you may remain by the macro or involving any extra tool/batch in between the source and the target which adjusted/replaced the wrong quotes.

Re: Generating XML from QVD, double quotes

p_verkooijen — Fri, 03 Jan 2025 10:40:59 GMT

Hi,

Tried all I could think of, and indeed not possible within Qlik, so I used powershell commands to replace these chars.

Replaced all wanted " with ### in the Qlik script, and used Powershell to replace them for the correct one.

For example

TempXML: LOAD '<?xml version=###1.0### encoding=###UTF-8###?>' AS XML_LINE AUTOGENERATE 1;

Content of _ConvertSteps.ps1

(Get-Content Qlikraw.xml) -replace '"', '' | Out-File -encoding ASCII XMLStep1.xml (Get-Content XMLStep1.xml) -replace '###', '"' | Out-File -encoding ASCII Import.xml Del Qlikraw.xml Del XMLStep1.xml

EXECUTE POWERSHELL.EXE /C C:\QlikView\XMLOutput\_ConvertSteps.ps1;