XML

20K

Solutions

9

Articles & Videos

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

I'm getting "duplicate attribute" error when attempting to create this document.  Is it not allowed to have the multiple Filter Field entries?
Jean

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<ApiDocument xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://microsoft.com/wsdl/types/">
  <Request>
    <Settings></Settings>
    <Filters>
      <Filter Field="FiscalDate" Operator="Greater than or equal" Value="2017-06-19T00:00:00.000" />
      <Filter Field="FiscalDate" Operator="Less than" Value="2017-06-20T00:00:00.000" />
      <Filter Field="Location" Operator="Equal" Value="100" />
    </Filters>
    <SortDescriptions>
      <SortDescription Name="FiscalDate" Direction="Ascending" />
    </SortDescriptions>
  </Request>
</ApiDocument>
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Please help! I'm receiving a "Problems During Load" prompt when I try and open up my XML file. I am able to open it in NotePad, but I can't seem to get it open no matter what I do. I would really appreciate if someone could take a look!

I attached the file.
BCNMitosisCopy.xml
0
I'm able to customize the Excel 2010 Ribbon, adding custom tabs/groups and hiding built-in tabs etc. as needed by using a CustomUI xml file.  I do this by starting the ribbon from scratch using:

 <ribbon startFromScratch="true">

... and then adding my own custom tabs/groups in the xml file.


What I would like to do is to leave the xml so the built-in ribbon is visible, for example, using:

 <ribbon startFromScratch="false">

but within the Excel application itself, use VBA code to hide (or remove) certain built-in Tabs from the Ribbon.

In other words, I'd like the VBA code to do the equivalent of:

 File > Options > Customize Ribbon > [select a Tab by name, e.g. 'Insert'] > Remove

The above steps can be done manually to get the desired result but I can't seem to find the VBA code to do it with.

Using SENDKEYS doesn't seem robust enough and only takes me a few steps into the File > Options > ... sequence before I'd have to resort to sending cursor control movements like cursor down, etc..
0
Hi all,

I am very new to working on XML data or files. I need to load data from below XML to a table in sql server. But i am unable to even parse it, i have tried few different methods like xquery and OpenXML but no luck. I am getting blank columns, i think i am not giving proper nodes to navigate to data. I am struggling with this since last 2 days :-(

XML:

 
 <?xml version="1.0" encoding="UTF-8" ?> 
- <Document xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02">
- <CstmrDrctDbtInitn>
- <GrpHdr>
  <MId>999</MId> 
  <CDT>2017-06-01T04:59:46</CDT> 
  <NTxs>16</NTxs> 
  <CS>345.00</CS> 
- <InitgPty>
  <Nm>Ter Elst BVBA</Nm> 
- <Id>
- <PrvtId>
- <Othr>
  <Id>000000</Id> 
  </Othr>
  </PrvtId>
  </Id>
  </InitgPty>
  </GrpHdr>
- <PmtInf>
  <PmtInfId>317-0</PmtInfId> 
  <PmtMtd>DD</PmtMtd> 
  <NTxs>16</NTxs> 
  <CS>345.00</CS> 
- <PmtTpInf>
- <SvcLvl>
  <Cd>PA</Cd> 
  </SvcLvl>
- <LclInstrm>
  <Cd>RE</Cd> 
  </LclInstrm>
  <SeqTp>RCUR</SeqTp> 
  </PmtTpInf>
  <ReqdColltnDt>2017-06-01</ReqdColltnDt> 
- <Cdtr>
  <Nm>Ter Elst BVBA</Nm> 
  </Cdtr>
- <CdtrAcct>
- <Id>
  <IBAN>0000</IBAN> 
  </Id>
  <Ccy>EUR</Ccy> 
  </CdtrAcct>
- <CdtrAgt>
- <FinInstnId>
  <BIC>LXXX</BIC> 
  </FinInstnId>
  </CdtrAgt>
  <ChrgBr>SLEV</ChrgBr> 
- <CdtrSchmeId>
- <Id>
- <PrvtId>
- <Othr>
  <Id>000000</Id> 
- <SchmeNm>
  <Prtry>PA</Prtry> 
  </SchmeNm>
  </Othr>
  </PrvtId>
  </Id>
  </CdtrSchmeId>
- <DrctDbtTxInf>
- <PmtId>
  

Open in new window

0
I have already make a "XML Maps" Mapping list under the XML Sources.
It works file when I do the XML import to the Excel sheet.

However, I would like to add the file name of the XML which imported to the excel.
Can anyone help me on this?

Enclosed with the Excel sheet with the mapping list included
https://drive.google.com/open?id=0B-cvVcO00sRvVldicS1kWFhGSGs
0
I am having a SOAP API project in which I send the request in XML while calling the API from SOAP UI to create the account on portal. In return, I get the response in XML.

Now I want to change it to Web UI (Don't want to use SOAP UI). To do that I want to use HTML form which will have input fields like v1:type,company name etc (Currently, I pass the fields in XML request using SOAP UI) and while submitting the form, API should be triggered and parse the XML response to display on Web UI.

Note : I am also having the certificate (jks) for API in SOAP UI. where that certificate will I configure?

Please help me as I am very new in this area.

Below is the request and response.

Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v="abc.com" xmlns:v1="abc.com">
   <soapenv:Header>
      <v:vfExtendedHeader>
         <v1:traceIdentifier>
            <v1:applicationId>VSDM_PROVISIONING</v1:applicationId>
            <v1:serviceId>ARI_sis_${=new java.text.SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'").format(new Date())}</v1:serviceId>
            <v1:serviceInterfaceVersion>2.0</v1:serviceInterfaceVersion>
            <v1:timestamp>${=new java.text.SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'").format(new Date())}</v1:timestamp>
            <v1:referenceId>ARI_rid_${=new java.text.SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'").format(new Date())}</v1:referenceId>
            <v1:correlationId>NULL</v1:correlationId>
      

Open in new window

0
HI All,

We have got stuck at a task to convert csv to xml conversion. we have tried some VB script solution but that din't worked out.
PFA sample csv and sample xml output as required.sample1.csvsample1.xlsx
0
We are in the process of rolling out Microsoft Enterprise Mode Site List Manager to our enterprise environment, but we were curious if it is possible to specify in the Enterprise Mode list that a URL/Domain can be opened with either IE11 or Edge?  The Enterprise Mode Site List Manager GUI allows to select either IE11 or Edge, but I was curious if there was a hidden syntax we could update the Enterprise Mode - XML file to allow both browsers to be used for a certain URL?
0
Hey,

I checked a selfmade ebook with epub validator and it gives many errors:

ERROR      OEBPS/Text/KINDLE FINAL JUNE 2017_split_000.htm      36      2      Error while parsing file 'text not allowed here; expected the element end-tag'.
FATAL      OEBPS/Text/KINDLE FINAL JUNE 2017_split_000.htm      36      18      Fatal Error while parsing file 'The prefix "W" for element "W:WordDocument" is not bound.'.
ERROR      OEBPS/Text/KINDLE FINAL JUNE 2017_split_000.htm      -      -      Error while parsing file 'The prefix "W" for element "W:WordDocument" is not bound.'.




<w:WordDocument>
 
 
  <w:ActiveWritingStyle Lang="EN-GB" VendorID="64" DLLVersion="131078"
   NLCheck="1">1</w:ActiveWritingStyle>
  <w:ActiveWritingStyle Lang="EN-US" VendorID="64" DLLVersion="131078"
   NLCheck="1">1</w:ActiveWritingStyle>
  <w:ActiveWritingStyle Lang="DE" VendorID="64" DLLVersion="131078" NLCheck="1">1</w:ActiveWritingStyle>
 
 
 
  <w:HyphenationZone>21</w:HyphenationZone>
  <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery>
  <w:DisplayVerticalDrawingGridEvery>0</w:DisplayVerticalDrawingGridEvery>
 
 
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
 
  <w:LidThemeOther>DE</w:LidThemeOther>
  <w:LidThemeAsian>JA</w:LidThemeAsian>
  <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
  <w:Compatibility>






I would appreciate some help.

0
Hi

I am updating an XML file and using XML::LibXML

My attribute value that I am replacing is

DESCRIPTION="== Conversion Messages Start ==&#xA;&#xA;Message ID : INF11004 (31284-19308)&#xA;Description : An empty RBC is added..&#xA;&#xA;== Conversion Messages End ==&#xA;FTP to FTP"

When i try to substitute using the following code the data is not changed.
just trying to move the last line to the beginning line.

$AA =~ s/(.*)== Conversion Messages End ==(.*)/$2 $1== Conversion Messages End ==/;

Output is

== Conversion Messages Start ==

Message ID : INF11004 (31284-19308)
Description : An empty RBC is added..

 == Conversion Messages End ==
FTP to FTP


where it should be

FTP to FTP
== Conversion Messages Start ==

Message ID : INF11004 (31284-19308)
Description : An empty RBC is added..

 == Conversion Messages End ==


I believe its due to the line endings which is causing it to not get the first (.*)


not sure how to get the correct output.

Thanks for the help

Mike
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hello,

i have a class that I am using JSON to read the data from. I am getting this error but not quite sure why when I am not seeing an array in my class

ERROR
An unhandled exception of type 'Newtonsoft.Json.JsonSerializationException' occurred in Newtonsoft.Json.dll

Additional information: Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[SpringAhead.Timecard]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.

To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.

Path '?xml', line 1, position 8.

Open in new window



CLASS
Imports System.Xml.Serialization
''' <remarks/>
<System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "4.6.1055.0")>
<System.SerializableAttribute>
<System.Diagnostics.DebuggerStepThroughAttribute>
<System.ComponentModel.DesignerCategoryAttribute("code")>
<System.Xml.Serialization.XmlRootAttribute([Namespace]:="", IsNullable:=True)>
Partial Public Class SA

    Private timecardField As Timecard()

    ''' <remarks/>
    <System.Xml.Serialization.XmlElementAttribute("Timecard", IsNullable:=True)>
    Public Property Timecard() As Timecard()
  

Open in new window

0
We have rolled out Office 365 Pro Plus (2016) to all our computers but we initially excluded the Skype for Business product from the rollout by adding the line "ExcludeApp ID="SkypeforBusinessRetail" " to the install XML file

We now want to add the Skype for Business product back to the package already installed on all the computers. The trouble is I can only seem to run the setup.exe program again if all Office 2016 apps are closed. If Outlook or Excel etc are open on the computer at the time then the re-install of Office with Skype fails.

As we want to script this to run automatically is there a way to have Skype for Business install without closing Office apps?
0
Hello,

I have 1000 same xml files. I want to change a single line of code in all files.
<ClimateFileID>0</ClimateFileID>
<ClimateFileName>2A_H2_0001.wac</ClimateFileName>
 <KLIClimateSideID>1</KLIClimateSideID>

I want each file to go from 2A_H2_0001 to 2A_H2_1000 and also change the filename in the same way.
I have very little programming skills. Is there a faster way to do it?

I tried doing this in MATLAB but the Unicode format is getting messed up and the xml files cannot be read by my software after the MATLAB process.

Thanks
0
I have made app with 6 datatables ,I can save in datagridview but it deletes when I close my app,now I need to know how to save in the file and reload it
0
I have an XML file that when passed through SOAP UI returns a proper response as XML file. I need to create an application to pass the XML and recuperate the response. I tried searching but many say REST web service where they using only post/get.

Please send me some sample code and/or tutorials.
0
I have jquery codes below, and when we try to call it, it alerts us - see attached
Not sure what is going on. It looks like the codes working

 function RemoveXMLData(msgID) {
           

            var parameters = "{'messageID':'" + msgID + "'}";

            $.ajax({
                type: "POST",
                url: "DisplayMessage.aspx/RemoveXMLData",
                data: parameters,
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (msg) {
                 
                    if (msg.d == 'Data deleted')
                        readAndUpdateXML();
                },
                error: function (xhr, status, error) {
                    alert("responseText=" + xhr.responseText + "\n textStatus=" + status + "\n errorThrown=" + error);
                }
            });
        }

Open in new window

error.png
0
I have a SOAP web service on another server and it returns XML as response when called from SOAP UI software.
I need to develop a web console application.
How can I input the XML directly into codes ?  

Please send me a sample code or tutorial.
0
Hello Everyone,

Trying to create file converter i.e FSA to GAML. In that need to convert some part of FSA which is ASCII and need to convert it into Base64 Float32 in GAML.
Here I have to map tags and values of FSA file to GAML tags where GAML is kind of XML file.
Some reference document on FSA  and GAML

Applied Biosystems 3500 Genetic Analyzer tags
http://www6.appliedbiosystems.com/support/software_community/ABIF_File_Format.pdf
GAML Tags
http://www.gaml.org/documentation/xml%20analytical%20archive%20format.pdf

First Step is to Encode Data i.e ASCII to BASE64
Input ASCII Example - DATA, 1 (shortType): 4 8 0 15 9 7 8 14 8 8 5 0 1 5 4 7 11 2 13 12 10 16 9 0 5 11 12 7 9 5 6 8 13 7 15 10 15 16 15 13 24 20 17 18 22 19 21 27 18 24 26 32 31 33 35 38 38 48 60 52 58 62 65 72 68 80 84 87 93 88 98 107 109 105 113 126 129 122 126 128 129 129 139 141 136 134 150 131 140 134 137 132 137 127 133 130 132 127 118 123 122 122 110 106 118 112 108 105 106 101 104 103 101 103 101 95 107 99 96 101 90 95 88 94 93 84 94 97 82 85 88 85 95 86 85 83 85 79 85 81 83 85 76 78 77 77 76 78 78 84 76 88 80 83 68 81 90 75 74 65 74 78 75 76 80 76 80 69 76 79 76 75 78 69 76 73 77 72 65 71 80 72 69 66 72 71 72 70 73 80 67 78 78 78 78 71 70 76 78 72 77 79 78 72 79 80 76 85 71 70 77 75 77 80 74 83 82 92 74 82 88 83 85 81 94 76 81 87 88 73 81 74 77 81 84 77 79 85 83 82 78 73 75 81 74 76 80 73 74 73 75 74 76 78 80 79 66 69 69 73 60 69 84 81 64 77 74 68 68 76 68 78 69 69 71 73 70 66 73…
0
Hi All,

I have some third party code supplied to me and I want to change some parts of it. Basically it generates an XML I need to POST to their API/Web Service and it is erroring due to me outputting text null telephone numbers. At the moment it generates an Array of the Communications XML Element that I cannot work out how to only output valid phone numbers.

Code Snip's below;

/// <remarks/>
        [Serializable]
        [DesignerCategory("code")]
        [XmlType(AnonymousType = true, Namespace = "http://www.cieca.com/BMS")]
        public class DispositionAddRqAdminInfoPolicyHolderPartyPersonInfoCommunications
        {

            private string _commQualifierField;

            private string _commPhoneField;

            private DispositionAddRqAdminInfoPolicyHolderPartyPersonInfoCommunicationsAddress _addressField;

            /// <remarks/>
            public string CommQualifier
            {
                get
                {
                    return _commQualifierField;
                }
                set
                {
                    _commQualifierField = value;
                }
            }

            /// <remarks/>
            public string CommPhone
            {
                get
                {
                    return _commPhoneField;
                }
                set
                {
                    _commPhoneField = value;
                }
            }

            /// <remarks/>
            public 

Open in new window

0
Free Tool: Site Down Detector
LVL 8
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

We are currently on Exchange 2010 and our OWA is working fine, but when we try to set up users email on their phones we get the following message "Cannot get mail"  The connection to the server failed.  Our ActiveSync is not working.  Here is the test results from https://testconnectivity.microsoft.com

 The Microsoft Connectivity Analyzer is testing Exchange ActiveSync.
 The Exchange ActiveSync test failed.
 
Additional Details
 
Elapsed Time: 2598 ms.


 
Test Steps
 
Attempting the Autodiscover and Exchange ActiveSync test (if requested).
 Testing of Autodiscover for Exchange ActiveSync failed.
 
Additional Details
 
Elapsed Time: 2591 ms.


 
Test Steps
 
Attempting each method of contacting the Autodiscover service.
 The Autodiscover service couldn't be contacted successfully by any method.
 
Additional Details
 
Elapsed Time: 2591 ms.


 
Test Steps
 
Attempting to test potential Autodiscover URL https://company.com:443/Autodiscover/Autodiscover.xml
 Testing of this potential Autodiscover URL failed.
 
Additional Details
 
Elapsed Time: 2427 ms.


 
Test Steps
 
Attempting to resolve the host name company.com in DNS.
 The host name resolved successfully.
 
Additional Details
 
IP addresses returned:  

Elapsed Time: 204 ms.



Testing TCP port 443 on host company.com to ensure it's listening and open.
 The port was opened successfully.
 
Additional Details
 
Elapsed Time: 214 ms.



Testing the SSL…
0
Would like to implement a WOOCOMMERCE plugin with the following functionality
Pull Product and Order Information from a storefront
must be able to schedule pulls to run automatically
csv or xml file export
ftp capability to a remote site.
0
Hello Experts,

I have to parse 3rd-party-xml-Data on a daily basis to an oracle 11 database. I connect the file as an external table and INSERT the wanted data into the database with the following code (as shown and improved in this thread):

External table:
CREATE TABLE "EXTVLB" 
   (	"XML" CLOB
   ) 
   ORGANIZATION EXTERNAL 
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "XML_IMP"
      ACCESS PARAMETERS
      ( FIELDS TERMINATED BY ','
(clob_pointer CHAR(200))
COLUMN TRANSFORMS (xml FROM LOBFILE (clob_pointer) FROM (xml_imp) CLOB)        )
      LOCATION
       ( 'pointer.txt'
       )
    )
  ;

Open in new window


Querry:
INSERT INTO VLB (
ISBN, 
EAN, 
TITEL, 
PRODUKTART, 
AKTION,
L_AEND,
PREIS, 
PREISTYP,
UPDDATE
)
SELECT DISTINCT x.ISBN, x.EAN, x.TITEL, x.PRODUKTART, x.AKTION, x.L_AEND, y.PREIS, y.PREISTYP, sysdate as UPDDATE
FROM extvlb ev, 
XMLTABLE('/products/product' passing ev.xml
      COLUMNS 
      ISBN VARCHAR2(20) PATH 'isbn',
      EAN VARCHAR2 (20) PATH 'ean',
      TITEL VARCHAR2(1000) PATH 'title',
      PRODUKTART VARCHAR2(10) PATH 'productform',
      AKTION VARCHAR2(10) PATH 'action',
      L_AEND VARCHAR2 (10) PATH 'last_price_mod',
      PRICE_OBJ XMLTYPE PATH 'price'
) x,
XMLTABLE('price' passing x.PRICE_OBJ
			COLUMNS
			MARKET VARCHAR(2) PATH 'market',
			PREIS VARCHAR2(10) PATH 'amount',
      PREISTYP VARCHAR2 (40) PATH 'pricetype'
) y
WHERE y.MARKET = 'DE'

Open in new window


Nearly every xml-file which I receive contains characters that the database rejects as "bad" or wrong (eg. "ß" or a long "-", sample-data below). In January when I had to get the whole process at work, I build a workaround. Since then I parse the data into a mysql-database and export it as csv which I import to the oracle-database. There I don't have any parsing-problems ...
Now I would like to skip this workaround and get it working in oracle. How do I have to modify the above Insert-Statement to skip the bad characters? Is it possible to regex the no-ascii-characters? I don't need the "TITLE"-column necessarily but the database stops parsing even without this column.
I would be very glad if someone could help me ...

BR
Christoph

Sample-Data

Open in new window

0
I am using SharePoint 2010 and do not have access to SharePoint Designer at this point.  

I have an RSS Viewer web part where I wrote custom XSL code.  
I now want to share this web part on many pages, but use one source for the XSL code.  

I created a file with this code with the extension .xsl in a library and tried to reference it using xsl:include and xsl: import, but both return an error.  

I have tried fully qualified URL, root relative and ../path-to/stylesheet.xsl

Here is an example of a variation of the code I am trying
<xsl:include href="/documents/xslfile.xsl"/>

Open in new window


Is there a way to share one XSL file for many RSS Viewer web parts on different pages?  
End goal is to make updates to one XSL file and have them apply to my RSS Viewer web parts.
0
I have successfully installed LinqToXSD which is supposed to enforce strong typing and also provide a relatively easy way to create XML files but there are no classes to use "new" on which should create the document.  Does anyone know how to create a class that is an XML Document that is tied to a LinqtoXSD schema?
0
Hi ,

We have SOAP API to consume from third party. We are developing wrapper in C#.

We are able to consume successfully when we create SOAP envolope and execute using webrequest and posting soap envelope in XML

We are not able to consume successfully using service reference. We are able to fire the request but as a response it is coming as NULL and action has been triggered at Third party end.

Please let me know what would be the issue while adding as service reference and response is coming as null.
0

XML

20K

Solutions

9

Articles & Videos

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).