Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

XML

20K

Solutions

13K

Contributors

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Share tech news, updates, or what's on your mind.

Sign up to Post

How can I view the contents of xml files on an Excel sheet (both in local Excel and Google Sheet) in easy to read format?

I will have each xml file inserted as a link in an Excel cell, and when clicking on the icon I want that the contents of that xml file should be displayed in easy to read format.

Would something like this work?:

https://stackoverflow.com/questions/8984254/how-to-view-the-xml-form-of-an-excel-file
0
Quick Cloud Training
Quick Cloud Training

Looking for some quick training on the cloud in 2 hours or less? Check out these how-to guides in AWS, Linux, OpenStack, Azure, and more!

For cells in one column, I want to be able to upload a XML file to each cell and have it saved there, and then another user should be able to download this file.

For cells in another column, I want to be able to upload a BMP or JPG file to each cell and have it saved there, and then another user should be able to download this file.

Is this possible to achieve in Google Spreadsheet, or by help from a plug-in?
0
When I attempt to export a schedule to xml, I receive the following message: The selected application C:\Program Files\Java\jre7\BIN\JAVA.exe cannot be found. If you are trying to run a JAVA API application, check the JAVA_HOME environment variable.

This happens on all of our machines and we have Java installed. What can we do to fix this important issue?
0
I want to do following:

1. Load Original.xml
2. convert to string look like result.xml
3. for loop and list
      Response.write attribute("id") + "  " + attribute("value")
   next

how can I do that in c#?


Original.xml
<?xml version="1.0" encoding="utf-8" ?>
<Surety QuoteID="123" CreatedDateTime="01/10/2017">
  <Line>
    <Commercial>
      <Bond Name="Notary" Form="Notary.pdf">
        <State name="CA">
          <Step name="Principal" StepNo="Step 1">
            <input type="text" class="" id="principalPhoneNo" placeholder="Custom field" value="310" />
             <input type="text" class="" id="principalPhoneNo2" placeholder="Custom field" value="210" />
            <input type="text" class="" id="principalPhoneNo3" placeholder="Custom field" value="110" />
          </Step>
          <Step name="P2" StepNo="Step 1">
            <input type="text" class="" id="principalPhoneNo4" placeholder="Custom field" value="310" />
             <input type="text" class="" id="principalPhoneNo5" placeholder="Custom field" value="210" />
            <input type="text" class="" id="principalPhoneNo6" placeholder="Custom field" value="110" />
          </Step>
        </State>
      </Bond>
    </Commercial>
  </Line>
</Surety>

Open in new window


Result.xml
<?xml version="1.0" encoding="utf-8" ?>
<Surety QuoteID="123" CreatedDateTime="01/10/2017">  
            <input type="text" class="" id="principalPhoneNo" placeholder="Custom field" value="310" />
            <input type="text" class="" id="principalPhoneNo2" placeholder="Custom field" value="210" />
            <input type="text" class="" id="principalPhoneNo3" placeholder="Custom field" value="110" />       
             <input type="text" class="" id="principalPhoneNo4" placeholder="Custom field" value="310" />
             <input type="text" class="" id="principalPhoneNo5" placeholder="Custom field" value="210" />
            <input type="text" class="" id="principalPhoneNo6" placeholder="Custom field" value="110" />  
</Surety>

Open in new window

0
I have xml file (c:\\data\abc.xml)

in c#, I want to search string "principalPhoneNo", if it is existed, then show find me the value, in this case it is 310,
in c#, I want to search string "principalPhoneNo2", if it is existed, then show find me the value, in this case it is 210,

how can i do that in c# that I do not have specific where the element tag is? meaning i want to find the value (no matter where it is located inside of XML file)

<?xml version="1.0" encoding="utf-8" ?>
<Surety QuoteID="123" CreatedDateTime="01/10/2017">
  <Line>
    <Commercial>
      <Bond Name="Notary" Form="Notary.pdf">
        <State name="CA">
          <Step name="Principal" StepNo="Step 1">
            <input type="text" class="" id="principalPhoneNo" placeholder="Custom field" value="310" />
             <input type="text" class="" id="principalPhoneNo2" placeholder="Custom field" value="210" />
            <input type="text" class="" id="principalPhoneNo3" placeholder="Custom field" value="110" />
          </Step>
        </State>
      </Bond>
    </Commercial>
  </Line>
</Surety>

Open in new window

0
It is possible to select range of node using start node and end node.
Below is sample code.

            <w:body>
               <w:p w:rsidR="009F72A0" w:rsidRDefault="00C14A8B" w:rsidP="00D80B27">
                  <w:pPr>
                     <w:pStyle w:val="Heading1" />
                  </w:pPr>
                  <w:bookmarkStart w:id="0" w:name="Page_1" />
                  <w:bookmarkEnd w:id="0" />
                  <w:proofErr w:type="spellStart" />
                  <w:r>
                     <w:t>Microsof</w:t>
                  </w:r>
                  <w:proofErr w:type="spellEnd" />
               </w:p>
               <w:p w:rsidR="00472CBA" w:rsidRDefault="00472CBA" w:rsidP="00472CBA">
                  <w:pPr>
                     <w:spacing w:after="0" />
                  </w:pPr>
               </w:p>
               <w:tbl>
                  <w:tblPr>
                     <w:tblStyle w:val="GridTable5Dark-Accent6" />
                     <w:tblW w:w="0" w:type="auto" />
                     <w:tblLook w:val="04A0" w:firstRow="1" w:lastRow="0" w:firstColumn="1" w:lastColumn="0" w:noHBand="0" w:noVBand="1" />
                  </w:tblPr>
                  <w:tblGrid>
                     <w:gridCol w:w="3116" />
                     <w:gridCol w:w="3117" />
                     <w:gridCol w:w="3117" />
                  </w:tblGrid>
                  <w:tr w:rsidR="00E317D5" w:rsidRPr="00531C77" w:rsidTr="00531C77">
        …
0
Hi-

I want to Delete Word Bookmarked Text and paragraph Data using OpenXML in .Net.

I have below code using OpenXML and "Content controls". But my plan is to do the same using "Bookmarks".
I haven't found OpenXML solution to edit and delete text and paragraphs using bookmarks.

using (WordprocessingDocument myDoc = WordprocessingDocument.Open(destFilename, true))
            {
                MainDocumentPart mainPart = myDoc.MainDocumentPart;
                DocumentFormat.OpenXml.Wordprocessing.Document bodyDoc = mainPart.Document;
                IEnumerable<SdtBlock> ccBlocks = bodyDoc.Descendants<SdtBlock>();
                IEnumerable<SdtRun> ccRuns = bodyDoc.Descendants<SdtRun>();

                foreach (var item in cBO.map)
                {
                    
                    SdtBlock myBlock = ccBlocks.FirstOrDefault(ccb => ccb.Descendants<SdtAlias>().FirstOrDefault().Val == item.Key);
                    SdtRun myRun = ccRuns.FirstOrDefault(ccb => ccb.Descendants<SdtAlias>().FirstOrDefault().Val == item.Key);
                  
                    Text textContent=new Text();
                    if (myBlock != null)
                    {
                        textContent = myBlock.Descendants<Text>().FirstOrDefault();
                    }
                    if(myRun != null)
                    {
                        textContent = myRun.Descendants<Text>().FirstOrDefault();
                    }
                
                    if

Open in new window

0
Hi Experts,

I was wondering if any one has experience with FortiClient Configuration Tool for 5.6.0 version.
I am trying to remove Fortinet banners, change background colors and add our logo but I checked on the xml tags of the forticlient configuration and can not see those tags. I see a lot of these TAG <![CDATA[]>.
Please advice where should I modify those settings.
0
I have a XML file already as below.
<?xml version="1.0" encoding="UTF-8"?>
-<Form>
+<Checkbox state="False">
+<Checkbox state="True">
+<Checkbox state="False">
+<Checkbox state="False">
-<Checkbox state="True">
<Caption>Dynamic Rod</Caption>
<Tag>C:\Users\DAIP\Desktop\leila\X-Pact Level Control\sources\DynamicRod.docx</Tag>
</Checkbox>
+<Checkbox state="False">
</Form>
How can I copy and paste the files which the sate is True into the word file?
I have already created a Pop up window with Checkboxs where store the documents path. And want to add one more buttom to insert the data from XML file into the word file. The buttom suppose to read the state and then copy the file and paste into the word file.
Appreciate your help!
0
I have an InfoPath form with a repeating table which has a dropdown.  I can add rows and set different values per row dropdown and save and reload the xml document and the rows and values are there.

I need to be able to do three things with the repeating table:
Read the rows and specifically the value of the dropdown
Add rows and set the value of the dropdown
Modify a row and set its value of the dropdown

I need to do all this within a Nintex Workflow.

Please advise.
0
Understanding Linux Permissions
Understanding Linux Permissions

Linux for beginners: How to view the permissions associated with files and directories and also how you can change them.

I have 2 different types of XML files called Install and Uninstall.

Install I have the XML file, generated the XSD and then ran the file through and it imports the data fine.

Now the uninstall one is very similar to the install, mostly the same columns 1-2 different, I have created it in exactly the same way, generate the XSD and then run my job but no data is transferred from the flat file source, there are no error messages and no information.

I am at a bit of a loss here as to why this could be happening. Does anyone have any ideas what could be causing this?

Looking at both XSD and XML files I cant see any structure problems.
0
Hi my soap client is not sending any xml request to the soap server. I tried sending data with wsdl link.

require_once('../libs/nusoap.php');
$client = new nusoap_client('http://url.com/wsdlfilelink', 'wsdl');

....

$merchantIDStruct = new stdClass();
$merchantIDStruct->name = 'merchant_id';
$merchantIDStruct->value = '1234567';

$detailArray = new stdClass();
$detailArray->item = $merchantIDStruct;

$parameters = new stdClass();
$parameters->details = $detailArray;
$parameters->billerRef = "RB_C1_RECO";
$parameters->payinstrRef = "RB_C1_RECO";

//$param_merchant_id = array( "merchant_id" => "5235437" );
//$parameters = array("Request" => $param_Request, "merchant_id" => $param_merchant_id);
$query = 'php';
 /* create the proxy object */
$proxyclientwsdl = $client->getProxy();
$result = $proxyclientwsdl->RECOstep1($parameters);


WSDL:

<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:typens="urn:PaymentServer" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" name="RECOstep1" targetNamespace="urn:PaymentServer">
<wsdl:types>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:p="http://schemas.xmlsoap.org/wsdl/soap/" targetNamespace="urn:PaymentServer">
<xsd:element name="Request">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="billerRef" minOccurs="1" maxOccurs="1">
<xsd:simpleType>
0
I have a table in which there is a field stored XML data like below

<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>98765</body>
</note>

If  I want to develop  a script, only output the number like 98765, how to do that?

select *
from table
where field like 'number only'
0
Is it possible to acquire "subcondition" by Amazon PA-API?
I set a request parameter with ResponseGroup = OfferFull and made a request but the returned XML did not contain a subcondition.

In the API document, explanation about subcondition is described, but just the document is old, was subcondition obsolete?

somebody help
0
Hi, I need to create a user defined data collector on a 2012 DC and save and copy the collector to a 2nd DC.
Here's what I've done so far.
1. Create new collector choosing Active Directory Diagnostic as the template.
2. I open the collector when done and change the config, for example, save log files to F drive instead of default systemdrive. Once I have made my changes I r-click and save to template, I name it ADD.xml. It saves to xml file.
3. Using logman I run this command "Logman create counter ADD -s RemoteHostName -c c:\temp\ADD.xml

All runs fine and collector get created on target server. But there's a problem. If I right click the new collector it does not have the config changes I created, so doesn't point to F drive.

Has anyone got a way of doing this better than I? In reality I need to copy it to 800 servers, so you see the need to automate.
Thanks all.
0
Dears,

I have a XML file with content as below.

<?xml version="1.0" encoding="utf-8"?>
<!--Informations Vendor="XXX S.A."-->
<City>
      <Region>
            <Name>001</Name>
            <Name>002</Name>
            <Name>004</Name>
            <Name>005</Name>
      </Region>
</City>

Now, I need a VB script, which adds a <name> node with value '003' in an ascending order.

And the final content of the XML must look as below.

<?xml version="1.0" encoding="utf-8"?>
<!--Informations Vendor="XXX S.A."-->
<City>
      <Region>
            <Name>001</Name>
            <Name>002</Name>
                <Name>003</Name>
            <Name>004</Name>
            <Name>005</Name>
      </Region>
</City>

Please guide me how to write a VB script code for this.
I am struggling to do it for the time being. Your help is highly appreciated.
0
HI,
I have got an an xml file with chinese chars like below  and trying to parse it in Oracle, but it is not returning the chars exactly as it is in Xml file. Can someone advice what setups should I do to get chinese chars ?

<?xml version='1.0' encoding='UTF-8'?>
      <emp_data>
         <name xml:lang="zh">国金证券股份有限公司</name>
      </emp_data>

   SELECT *
    FROM XMLTABLE('/emp_data'
      PASSING XMLTYPE(BFILENAME('XML_DIR', 'test_xml.xml'),
      NLS_CHARSET_ID('AL32UTF8'))
        COLUMNS
     name  VARCHAR2(200)  PATH 'name'        
      ) t;


<code>
          SELECT 'VARCHAR2' charset, value$, NAME FROM sys.props$ WHERE name
             = 'NLS_CHARACTERSET'
</code>
returns: WE8MSWIN1252
0
Hello Everyone

I'm currently in the process of migrating our current PBX system away from asterisk to Freeswitch. I am using FusionPBX on Debian 8. I am using the freeswitch webapi to originate calls. I am at the stage where when I execute the command, it rings the call centre agents phone and the customer automatically without the agent manually dialling the number. I would like the ability to manually specify a caller id number for the outbound leg of the call. At the moment it is not sending any caller ID. I can manually specify a caller ID number in the extensions page, and it works statically, however we have a need for the caller ID to be dynamic.

http://X.X.X.X:8080/webapi/originate?{click_to_call=true,origination_caller_id_name='Click to Call',origination_caller_id_number=1000,instant_ringback=true,ringback=\'%(400,200,400,450);%(400,2200,400,450)\',presence_id=630@X.X.X.X,call_direction=outbound,sip_auto_answer=true,domain_uuid=52b92yy9-7fb7-52ae-9e9e0595058bcdaa,domain_name=X.X.X.X}user/630@X.X.X.X &transfer('SOME EXTERNAL NUMBER XML X.X.X.X')

What do i need to add to this web address to get it to send a custom caller ID number to the customer outbound?

Many thanks in advance.
0
assume i have xml called quote.xml

and I want to pass data into the xml. like {firstname} and {lastname}

Q1. How can I pass the value from c# asp.net to the xml? assume i have value like request.form["firstname"]
Q2. <InsuredOrPrincipalInfo> is actually array data type meaning that I may have more than 1 <InsuredOrPrincipalInfo></InsuredOrPrincipalInfo>
how can I pass the array from c# asp.net to the xml?

<xml>
<quote>
<firstname>{firstname}</firstname>
<lastname>{lastname}</lastname>
<principal>
<InsuredOrPrincipalInfo>
          <InsuredOrPrincipalRoleCd>Insured</InsuredOrPrincipalRoleCd>
          <PersonInfo>
            <GenderCd>{genderCd}</GenderCd>
            <BirthDt>{BirthDt}</BirthDt>
            <MaritalStatusCd></MaritalStatusCd>
            <EducationLevelCd />
            <OccupationDesc></OccupationDesc>
          </PersonInfo>
</InsuredOrPrincipalInfo>
</principal>
</quote>
</xml>

Open in new window

0
On Demand Webinar: Networking for the Cloud Era
LVL 10
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

At the moment my D3 navbar uses several SVG icons and loads them individually. In the interests of performance and tidyness I would like to be able to load a single XML file containg multiple SVG icons into d3 and to be able to transform them individually.

I have given up scratching my head to get this to work.

Please Help - Chris Coleman.
0
Hola buen día necesito de su ayuda para poder guardar una consulta de SQL en XML, he revisado varias consultas en el foro, pero no he encontrado nada,  he intentado con varios métodos y no logro que se guarde correctamente el XML pues dice que la codificación no es la correcta.

consulta:

<%
Dim cnn,strSQL, objRS, FirstName
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=10.4.58.35;UID=usuario;PWD=H78@2527*;DATABASE=" & Request.QueryString("Empresa")
strSQL = "SELECT [XML_Comprobantes].[XML], [XML_Comprobantes].[UUID] FROM [Comprobantes] INNER JOIN [dbo].[XML_Comprobantes] ON ([Comprobantes].[UUID] = [XML_Comprobantes].[UUID]) WHERE [Comprobantes].[UUID]  ='" & Request.QueryString("UUID") & "'"
Set objRS = cnn.Execute(strSQL)
NombreEmpresa = request.querystring("Empresa")
NombreProveedor=Request.QueryString("Proveedor")
%>
<%
   while (not objRS.Eof)
Response.Write(objRS("XML"))
   objRS.MoveNext
   wend
   cnn.Close
   set objRS = nothing
   set cnn = nothing
 %>


método:

<%Response.AddHeader "Content-Disposition", "attachment; filename = Nombre.xml"
Response.ContentType = "text/XML"  %>

resultado de la consulta SQL

<?xml version="1.0" encoding="UTF-8"?><cfdi:Comprobante xmlns:cfdi="http://www.sat.gob.mx/cfd/3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:terceros="http://www.sat.gob.mx/terceros" xmlns:tfd="http://www.sat.gob.mx/TimbreFiscalDigital" …
0
I have a HTML code and i want to store that code in database in XML Format.
i also want to get that data in HTML.
How do i achieve this using Asp.net[VB.net]?
i'm using Oracle 9i for the database things.
0
I am getting the following error report when i try to upload my custom template.

i have found out that the eroor most likely is in this xml file

<?xml version="1.0" encoding="utf-8"?>
<ProjectProcessConfiguration>
  <TypeFields>
    <TypeField refname="System.AreaPath" type="Team" />
    <TypeField refname="Microsoft.VSTS.Scheduling.RemainingWork" type="RemainingWork" format="{0} h" />
    <TypeField refname="Microsoft.VSTS.Common.BacklogPriority" type="Order" />
    <TypeField refname="Microsoft.VSTS.Scheduling.Effort" type="Effort" />
    <TypeField refname="Microsoft.VSTS.Common.Activity" type="Activity" />
    <TypeField refname="Microsoft.VSTS.Feedback.ApplicationStartInformation" type="ApplicationStartInformation" />
    <TypeField refname="Microsoft.VSTS.Feedback.ApplicationLaunchInstructions" type="ApplicationLaunchInstructions" />
    <TypeField refname="Microsoft.VSTS.Feedback.ApplicationType" type="ApplicationType">
      <TypeFieldValues>
        <TypeFieldValue value="Web application" type="WebApp" />
        <TypeFieldValue value="Remote machine" type="RemoteMachine" />
        <TypeFieldValue value="Client application" type="ClientApp" />
      </TypeFieldValues>
    </TypeField>
  </TypeFields>
  <PortfolioBacklogs>
    <PortfolioBacklog category="Microsoft.EpicCategory" pluralName="Epics" singularName="Epic" workItemCountLimit="1000">
      <States>
        <State value="New" type="Proposed" />
       <State value="Approved" …
0
i got a list of lists in ,
outerlist = [['name Belgian Waffles', 'price $5.95', 'description Two of our famous Belgian Waffles with plenty of real maple syrup', 'calories 650']
['name Strawberry Belgian Waffles', 'price $7.95', 'description Light Belgian waffles covered with strawberries and whipped cream', 'calories 900']]

The requirement is  to write the list to a csv file in the format

name                                                 description                                                                                                             price           calories      
Belgian Waffles                                Two of our famous Belgian Waffles with plenty of real maple syrup        $5.95         650             
Strawberry Belgian Waffles        Light Belgian waffles covered with strawberries and whipped cream        $7.95         900             
 

I tried the following python code

l = []

for item in outerlist:
    d = {kv.split()[0]:' '.join(kv.split()[1:]) for kv in item}
    l.append(d)
print (l)                     #----> returns random order

keys = l[0].keys()

with open(csvFileDir ,'w', newline = '') as o:
    writer = csv.DictWriter(o,fieldnames=keys)
    writer.writeheader()
    writer.writerows(l)

I am able to parse the same to a csv file , but the order returned is random .

What should I do to make sure the order returned is the same as the order given as input .

I tried OrderedDict but it returned

ValueError: too many values to unpack …
0
Hi,

I ran a Nessus scan on a PC and I found the attached vulnerability: Microsoft XML parser (MSXML) and XML Core Services Unsupported.

The solution provided by NEssus is to upgrade the sw package responsible for the unsupported DLL versions or upgrade to a supported version of Windows. Alternatively, Uninstall the outdated MSXML or XML Core Services.

Can you help me find out:

A. What is using MSXML? (What software?)
B. How do yo uninstall MSXML?
C. How do you upgrade it?

Thank you.
Microsoft-XML-Parser.PNG
0

XML

20K

Solutions

13K

Contributors

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).