Dear Experts,
the below code, it works perfectly fine,

$xmlDATA = '<?xml version="1.0" encoding="utf-8"?><VposResponse><MerchantId>000000000125427</MerchantId><TransactionType>Sale</TransactionType></VposResponse>';

$xml = simplexml_load_string($xmlDATA);

echo $MerchantId = $xml->MerchantId;
echo "<br><br>";
echo $TransactionType = $xml->TransactionType;

Select all Open in new window

however it doesn't work, altough it is the same data.

 $xmlDATA = htmlentities($_POST["BankResponse"]);


$xml = simplexml_load_string($xmlDATA);

echo "MerchantId :" .  $MerchantId = $xml->MerchantId;
echo "<br><br>";
echo "TransactionType :" . $TransactionType = $xml->TransactionType;

Select all Open in new window

I don't understand why it is not working. what do you suggest I should do?

Given this information...

POST /Sale/Application/v2/mypage.asmx HTTP/1.1
Host: b2b2.mywebsite.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://tempuri.org/Persist"

Select all Open in new window

How would I post my xml data to a service in vb.net web page win 4.5 environment

I do NOT want to import the wsdl

Stumped.
 Server 2012 core with 2 VMs. VM1 had a usb drive attached for backup.
When swapping drive, forgot to remove it in VM1 before I unplugged the cable to the usb drive. Couldn't start VM1 w/o drive at all. Got it reconnected. It didn't show up in VM settings under controller 0. Tried to re-add  it in settings but errors that the drive is already attached. Went into the xml file and removed anything pertaining to the usb drive and I must have taken out something I shouldn't have and it said it couldn't find the file. I'm pretty bad at xml'
Any ideas now to reconnect (or remove and re-add it) the usb drive to the virtual machine. I have the machine files. Would deleting the vm and creating a new vm and attaching the machine file. Any suggestions are very welcome.
Drive-already-attached.jpg
Not-initiate.jpg

Hi,

I have the below xml stuff inserted into a clob column in a dummy table. I am aware that ideally it needs to be an xmltype column in the table but it is not possible to change from clob to xmltype now. Hence need your help with the extract and extractvalue functions to get the node values out from the below. I am not an expert into the xml world and hence please suggest.

<?xml version="1.0"?>
<tns:FIToFI xmlns:outdir="http://www.abcd.co.in/v2/outdir" xmlns:head="urn:iso:std:iso:20022:tech:xsd:head_pacs008.001.001.01" xmlns:pt="urn:iso:std:iso:20022:tech:xsd:pacs.008.001.04" xmlns:pt_supp="urn:cash:std:xsd:supp.pacs.008.v2" xmlns:tns="urn:cash:std:xsd:FIToFI">
  <tns:Header>
    <head:Fr>
      <head:OrgId>
        <head:Id>
          <head:OrgId>
            <head:AnyBIC>POINT1</head:AnyBIC>
          </head:OrgId>
        </head:Id>
      </head:OrgId>
    </head:Fr>
    <head:To>
      <head:OrgId>
        <head:Id>
          <head:OrgId>
            <head:AnyBIC>POINT2</head:AnyBIC>
          </head:OrgId>
        </head:Id>
      </head:OrgId>
    </head:To>
    <head:BizMsgIdr>ABCD1234567890</head:BizMsgIdr>
    <head:MsgDefIdr>pacs.008.001.04</head:MsgDefIdr>
    <head:BizSvc>BASH_GST</head:BizSvc>
    <head:CreDt>2019-02-10T01:59:02Z</head:CreDt>
  </tns:Header>
  <tns:Document>
    <tns:FIToFICstmrCdtTrf>
      <tns:GrpHdr>
        <pt:MsgId>KA09881902108848</pt:MsgId>
        <pt:CreDtTm>2019-02-10T01:59:02</pt:CreDtTm>
        

Select all Open in new window

…

Greetings Experts!

Working with vbscript and a very limited knowledge of XML files, I'm trying to create a function that gets several pieces of information from the MaterialPosting element of an XML file.  

As long as I stick to elements that 1) are always present in the XML and 2) have values directly under the /JobInfo/MaterialPosting element, such as StockCode, I can get what I need but I'm having trouble retrieving the values of items that are one level deeper, such as Bins and Serials.  I was able to figure out how to get the value of the Bins/Bin element (see line 21 of the code below). However, it doesn't work for serials because the Serials element does not always exist.  

After spending the better part of a day with the Microsoft docs on XML Dom, my head is spinning and I still don't get it.  The code below is my latest attempt.  It returns an error of "object doesn't support this property or method" at line 11.  

How can I check to see if the element called Serials exists in my XML and, if the Serial element exists, retrieve its value?

Many thanks, in advance, for your help!

Dim objDom, objNodeList, Counter, myXML
   Set objDom = CreateObject("MSXML2.DOMDocument")
   objDom.LoadXML(XMLOut)

   Set objNodeList = objDom.SelectNodes ("//JobInfo/MaterialPosting")
       If objNodeList.length > 0 then

  ' Loop through each of the MaterialPosting elements
      For Counter = 0 To objNodeList.length - 1
          dim aSerialNode
          

Select all Open in new window

…

BCP QUERY OUT, I am not sure how to query out, so i am attempting to output the headers which i will then combine with the data. I have never used query out to do this as we usually create a table and place the headers in the bcp the data out of the table then combine.   IS it possible to do this with query out..

                                                declare @outfile nvarchar(1000),@comrun nvarchar(500)
                        set @outfile = '\\eincutil01\Syteline\report\outputfiles\ezimmerman\'  + db_name() + 'PaperLessBak.csv'


                     SET @HEAD = 'BCP "select ''CONUM'',''LINE'',''CUSTPO'',''BILLTO'',''BILLTOADDR'',''SHIPTO'',''SHIPTOADDR'',''SHIPCODE'',''DESCTIPTION'',''ITEM'',
                                   ''DESCRIPTION'',''UM'',''QTYORDER'',''QTYREQUIRED'',''QTYSHIPPED'',''WHSE'',''DUEDATE'',''PROMISEDATE'',''CERTYPE'',''COFC'',''COLLECTACCT'',
                                   ''LOCATION'',''QTYONHAND'',''ITEMTOBECUT'',''ITEMTOCUTTO'',''QTYTOCUT'',''LOC'' " queryout ' +  @outfile +'  -c -t, -T -SEINCDATA01'
                                       PRINT  @HEAD
                        
                              exec master..xp_cmdshell @HEAD
                        
                              exec master..xp_cmdshell @HEAD

ERROR
usage: BCP {dbtable | query} {in | out | queryout | format} datafile
  [-m maxerrors]            [-f formatfile]          [-e errfile]
  [-F firstrow]             [-L lastrow]             [-b batchsize]
  [-n native type]          [-c character type]      [-w wide character type]
  [-N keep non-text native] [-V file format version] [-q quoted identifier]
  [-C code page specifier]  [-t field terminator]    [-r row …

I have used a macro supplied by Norie for importing data into Excel 2010, until I tried the attached XML. The imported numbers do not look right.

Original post and solution: https://www.experts-exchange.com/questions/29134758/Importing-an-XML-array-to-an-Excel-column.html?headerLink=workspace_answered_questions

Can anyone tell me what is broken about the xml file, or macro, which prevents importing?

Thanks

2.xml

I need to merge a bunch of xml files and save into 1 removing any duplicate entries
I'm getting errors in ConsoleApplication2 @ line         private history = new history();

Severity	Code	Description	Project	File	Line	Suppression State
Error	CS1519	Invalid token '=' in class, struct, or interface member declaration	ConsoleApplication2	d:\VB\Test\ConsoleApplication2\ConsoleApplication2\Program.cs	13	Active

Select all Open in new window

any suggestions what the above is?

Unless there is a better way I was going to use sort on id to filter out duplicates with the newest file taking precedence over older

using System.IO;
using xml;

namespace ConsoleApplication2
{
    class Program
    {
        private history = new history();

        static void Main(string[] args)
        {
            string RootDir = @"C:\Users\user\AppData\Roaming\AppName\user";
            
            if (Directory.Exists(RootDir))
            {
                var Files = Directory.EnumerateFiles(RootDir, "history.xml", SearchOption.AllDirectories);
                foreach (string File in Files)
                {
                    this.history += xml.history.Load(File);
                }

            }
        }
    }
}

Select all Open in new window

xml.cs

using System.Xml.Serialization;

namespace xml
{
    
    public class history
    {
        List<post> post{ get; set; } = new List<post>();
        private static string xmlFile { get; set; }

        public static history Load(string xmlFile)
        {

Select all Open in new window

…

How do I convert the following nested XML creation:
 
Dim xmlKW As String = "  <keywords>" &
            vbCr & vbLf & "    <item>" &
            vbCr & vbLf & "      <name>angels</name>" &
            vbCr & vbLf & "      <enabled>true</enabled>" &
            vbCr & vbLf & "      <threshold>0.5</threshold>" &
            vbCr & vbLf & "    </item>" &
            vbCr & vbLf & "    <item>" &
            vbCr & vbLf & "      <name>there</name>" &
            vbCr & vbLf & "      <enabled>true</enabled>" &
            vbCr & vbLf & "      <threshold>0</threshold>" &
            vbCr & vbLf & "    </item>" &
            vbCr & vbLf & "    <item>" &
            vbCr & vbLf & "      <name>test</name>" &
            vbCr & vbLf & "      <enabled>true</enabled>" &
            vbCr & vbLf & "      <threshold>0.4</threshold>" &
            vbCr & vbLf & "      <pronunciations>" &
            vbCr & vbLf & "        <item>" &
            vbCr & vbLf & "          <phonemes>t eh s t</phonemes>" &
            vbCr & vbLf & "          <enabled>true</enabled>" &
            vbCr & vbLf & "        </item>" &
            vbCr & vbLf & "      </pronunciations>" &
            vbCr & vbLf & "    </item>" &
            vbCr & vbLf & "</keywords>"

to a serialised string using something similar to:

        public static string SetTime()
        {
            var dateTimeOffset = new DateTimeOffset(DateTime.Now);

            return JsonConvert.SerializeObject(new
…

How do I create a JSON array in vb.net using Newtonsoft.JSON (json.net) from this xml string;

<?xml version="1.0" encoding="UTF-8"?>
<result>
  <version>2</version>
  <name>ListResult1</name>
  <model_name>ENGLISH</model_name>
  <my_list>test</my_list>
  <myitems>
    <item>
      <name>thing1</name>
      <enabled>true</enabled>
      <threshold>0.5</threshold>
      <types1/>
    </item>
    <item>
      <name>thing2</name>
      <enabled>true</enabled>
      <threshold>0</threshold>
      <types1s/>
    </item>
    <item>
      <name>thing3</name>
      <enabled>true</enabled>
      <threshold>0.4</threshold>
      <types1>
        <item>
          <otherthing1>text2</otherthing1>
          <enabled>true</enabled>
          <otherthing2>0</otherthing2>
          <otherthing3>true</otherthing3>
        </item>
      </types1>
    </item>
  </myitems>
</result>

I have the following input:

<root>
	<CollectMiscFeeRQ>
		<Payment xmlns="http://services.sabre.com/STL/v01">
			<Amount currencyCode="MXN">549</Amount>
			<FormOfPayment>
				<Cash/>
			</FormOfPayment>
		</Payment>
		<Payment xmlns="http://services.sabre.com/STL/v01">
			<Amount currencyCode="MXN">549</Amount>
			<FormOfPayment>
				<Cash/>
			</FormOfPayment>
		</Payment>
		<Payment xmlns="http://services.sabre.com/STL/v01">
			<Amount currencyCode="MXN">549</Amount>
			<FormOfPayment>
				<Cash/>
			</FormOfPayment>
		</Payment>
	</CollectMiscFeeRQ>
</root>

Select all Open in new window

I want to group by FOP so that my output sums the total:

	<Payment xmlns="http://services.sabre.com/STL/v01">
		<Amount currencyCode="MXN">1647</Amount>
		<FormOfPayment>
			<Cash/>
		</FormOfPayment>
	</Payment>

Select all Open in new window

I was trying to do something like this but it failed:

  <xsl:key name="paymentCash" match="stl:Payment" use="stl:FormOfPayment/stl:Cash"/>


      <xsl:for-each select="stl:Payment[stl:FormOfPayment/stl:Cash and generate-id(.)=generate-id(key('paymentCash', stl:FormOfPayment/stl:Cash)[1])]" >
....

but it would never enter the for-each clause.

Im trying to optimize SQL and XQuery  stored procedure to be as quick and efficient as possible in comparing old and new values.

The biggest slow down comes down to the FULL OUTER JOIN when comparing old folder counts to new folder counts.

Does anyone know a better way to write that? Or is that the best way to go?

	DECLARE 	@paramVcAccountID INT = 2,
	@paramVcUserID	INT = 2,
	@paramFolderUnreadCountDtoXml XML  =N'<?xml version="1.0"?>
<root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <FolderUnreadCountDto>
    <FolderID>30</FolderID>
    <UnreadCount>0</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    <FolderID>31</FolderID>
    <UnreadCount>0</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    <FolderID>32</FolderID>
    <UnreadCount>361</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    <FolderID>33</FolderID>
    <UnreadCount>9</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    <FolderID>12109</FolderID>
    <UnreadCount>6</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    <FolderID>12125</FolderID>
    <UnreadCount>0</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    <FolderID>12143</FolderID>
    <UnreadCount>4</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    <FolderID>12145</FolderID>
    <UnreadCount>0</UnreadCount>
  </FolderUnreadCountDto>
  <FolderUnreadCountDto>
    

Select all Open in new window

…

I am having an issue with SQL not returning a value properly. I am using the following:
(Test_Value_One * 100) AS Test_Value_Goal
the value of Test_Value_One is .075. I am writing this to an xml file but the result displayed is: 7.500000000000000e+001
Not sure why this is occurring. Any assistance would be greatly appreciated.