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

I am trying to create an Android contacts app/service that will do the following once every 24 hours:

1 - Get contacts from an XML file on our web server and put them into an array.
2 - Loop through the array, inserting those contacts into the phone's address book.
3 - Delete all the contacts with the same name to stop duplicates.

I have managed to get steps 1 and 2 working correctly, as well as a service that runs every 24 hours. However, I cannot delete contacts with the same name. I've only managed to get it to delete all the contacts on the phone including personal ones etc.

If someone could show me how to delete only contacts with the same display name as those in my XML file, that would be very helpful.

Here is part of my code without any delete functions. This gets the contacts from the XML file and inserts them into the phone successfully.

        String folderPath = "http://mywebsite.co.uk/phonebook.xml";
        String xmlFile = folderPath;
        DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
        DocumentBuilder dBuilder;

        try
        /// gets the main nodes in the config and saves them to a list
        {

            dBuilder = dbFactory.newDocumentBuilder();
            Document doc = dBuilder.parse(xmlFile);
            doc.getDocumentElement().normalize();
            //System.out.println("Root element is:" + doc.getDocumentElement().getNodeName());
            NodeList mainList = 

Open in new window

0
Introduction to R
LVL 13
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

In Windows 10 Enterprise, using an xml file for Start Layout.  Set policy in gpedit on three identical machines.  One machine has missing program tile, other two machines work fine.  Same image & xml file on all three machines.  Any ideas of what could be wrong, preventing the program tlle/icon and/or link to appear and function on third machine?
0
or an OPENXML spreadsheet, can you create all the rows needed like this loop

for (uint i = 1; i < 44; i++)
 {
 row = new Row() { RowIndex = i };
sd2.AppendChild(row);
}

Open in new window


And elsewhere in the code reference specific rows and create new cells etc as needed
row1.RowIndex = 5;

//create a new cell
Cell celltest = new Cell() { CellReference = "I5", DataType = CellValues.String, CellValue = new CellValue("Issue:"), StyleIndex = 7 };
                

//append the cell to the row
row1.Append(celltest);

Open in new window


And then update cells later by referencing the specific row index?
Do the cells need to be created/updated during the creation of each row?

I am not having much luck with this approach and want to ensure I am not going crazy.

Thanks
Jed -
0
I have the following codes on mvc code behind, and have I have two questions.

1. string returnStrInHTML = sa.AgingInDetailsInHTML(agingInDetail) is return string in <html> codes.
how can I return as Json or xml format?

2. With current codes, I also have exceeding max size as well. I think it is because the HTML codes is too big.
I did make the changes on web config but still not working. How to fix it?

	[HttpPost]
        public JsonResult GetAgingReport(string invoicestartandenddate, string receiptstartandenddate, string assoication, string chargecode)
        {
            string[] invoiceStartEndDateList = invoicestartandenddate.Split('-');
            Int64 invoicestartdate =MasterHelper.Generic.CustomDateFormat(invoiceStartEndDateList[0]);
            Int64 invoiceenddate = MasterHelper.Generic.CustomDateFormat(invoiceStartEndDateList[1]);

            string[] receiptStartEndDateList = receiptstartandenddate.Split('-');
            Int64 receiptstartdate = MasterHelper.Generic.CustomDateFormat(receiptStartEndDateList[0]);
            Int64 receiptenddate = MasterHelper.Generic.CustomDateFormat(receiptStartEndDateList[1]);

            Domain.Accounting.Report r = new Domain.Accounting.Report();             
            r.invoicestartdate = invoicestartdate;
            r.invoiceendate = invoiceenddate;
            r.receiptstartdate = receiptstartdate;
            r.receiptenddate = receiptenddate;
            r.chargecode = chargecode;
            

Open in new window

0
Hi guys, we are using this feed here to be then imported by our mobile apps, https://nova.ie/feed however it is displaying two images within the body, is there anyway that it doesnt show the image within the body.

To get this working yesterday i put this code into functions.php on Wordpress

?php

function featuredtoRSS($content) {
global $post;
if ( has_post_thumbnail( $post->ID ) ){
$content = '<div>' . get_the_post_thumbnail( $post->ID, 'medium', array( 'style' => 'margin-bottom: 15px;' ) ) . '</div>' . $content;
}
return $content;
}
 
add_filter('the_excerpt_rss', 'featuredtoRSS');
add_filter('the_content_feed', 'featuredtoRSS');

Open in new window

0
Any one has suggestion on below. how to fix. this is office365 hybrid server

The Microsoft Connectivity Analyzer is attempting to test Autodiscover for email@domain.com.
       Testing Autodiscover failed.
       
      Additional Details
       
Elapsed Time: 47185 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: 47185 ms.
       
      Test Steps
       
      Attempting to test potential Autodiscover URL https://domain.com:443/Autodiscover/Autodiscover.xml
       Testing of this potential Autodiscover URL failed.
       
      Additional Details
       
Elapsed Time: 971 ms.
       
      Test Steps
       
      Attempting to resolve the host name domain.com in DNS.
       The host name resolved successfully.
       
      Additional Details
       
IP addresses returned: 54.252.148.134
Elapsed Time: 133 ms.
      Testing TCP port 443 on host domain.com to ensure it's listening and open.
       The port was opened successfully.
       
      Additional Details
       
Elapsed Time: 210 ms.
      Testing the SSL certificate to make sure it's valid.
       The SSL certificate failed one or more certificate validation checks.
       
      Additional Details
       
Elapsed Time: 627 ms.
       
      Test Steps
       
      The Microsoft Connectivity Analyzer is attempting to obtain the SSL certificate from remote server domain.com on port 443.
       The Microsoft Connectivity Analyzer successfully obtained the remote SSL certificate.
       …
0
Looking for SQL String to combine 1 field from many records.  If no records found need to return a 0.  
Below is what I have so far and it works  EXCEPT
If a person has no records in prod_Materials - I need it to return a 0

SELECT LTRIM(STR(prodID)) + ',' AS 'data()'
from prod_Materials
where personID = 'B1970'
Group by prodID
order by prodID
FOR XML PATH ('')

Any ideas?

Thanks
JS
0
App is taking too long to load images from website XML.

Hi,

We are trying to launch a new app, but i got this back from the app developer.

Hi Jonathan,
 
The issue is with the nova.ie/feed URL and any of the media:thumbnail elements which are used to display the images in the app.
 
If you pass the feed through a validator, there is a major issue blocking it.
https://validator.w3.org/feed/check.cgi?url=https%3A%2F%2Fwww.nova.ie%2Ffeed%2F
The script and data-lang issues are not something we need, but the first about "media:thumbnail being unbound" does need addressing.
It looks like "xmlns:media="http://search.yahoo.com/mrss/"" needs to be defined in the initial <?xml> element rather than at an individual element level.

I cant see why the images are taking so long to load. the server seems not under too much stress, could it be the fact the site is behind cloudfare?
0
Hi Everyone,

I would like to add child nodes to the existing xml file through VBA macro. Please have a look at this and help me how to insert child nodes to Main.xml (line 158) from a spreadsheet. Also please suggest me if there are any other ways to do it. Thanks!

I have attached the files.

Regards,
NizamMain.xmlinput.xlsm
0
I am facing Problem when converting xml file to soap message for making a call to web service attaching my code and request  

following is the error

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" 
xmlns:wsdl="http://xmlns.qtel.com.qa/B2B/WSDL" 
xmlns:par="http://www.tibco.com/namespaces/bc/2002/04/partyinfo.xsd">
   
   <soapenv:Header>
      <wsdl:TxInfo>
         <wsdl:Created>2018-06-10T11:07:20.953+03:00</wsdl:Created>
         <wsdl:Source>POS101</wsdl:Source>
         <wsdl:Lang>EN</wsdl:Lang>
      </wsdl:TxInfo>
      <par:PartyInfo>
         <from>
            <name>RQ</name>
         </from>
         <to>
            <name>Qtel</name>
         </to>
         <operationID>Qtel.Gateway/1.0/CheckLineStatus</operationID>
         <operationType>syncRequestResponse</operationType>
         <transactionID>RQJAV270220190000000010</transactionID>
      </par:PartyInfo>
   </soapenv:Header>


   <soapenv:Body>
      <wsdl:CheckLineStatusRequest>
         <wsdl:Request>RQ</wsdl:Request>
      </wsdl:CheckLineStatusRequest>
   </soapenv:Body>
</soapenv:Envelope>
ContentDescription >> null
Soap Header        >> [soapenv:Header: null]
Soap Part          >> com.sun.xml.internal.messaging.saaj.soap.ver1_1.SOAPPart1_1Impl@37f8bb67
SOAP Body          >> [soapenv:Body: null]

Open in new window

SoapEnv.java
sample_rq.xml
0
Expert Spotlight: Joe Anderson (DatabaseMX)
LVL 13
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

Not sure if this is even possible..but here goes
-<Fields>
<Field List="ListABC;ListDEF;ListGHI;ListJKL;" ID="001" Value="ListDEF" Type="K" Name="List">
</Field></Fields>



What I would like to do is  instead of explicitly naming the Field List.. I would like to have it read values from a .txt file......go ahead call me stupid.

Is this even possible?
0
I was using the owssvr.dll? URL parameter successfully to download all of the items from a list in xml format - INCLUDING THE different versions.  Then all of a sudden yesterday the results returned NO data.

The team had made some changes to the view that was being used so not sure if that would cause an error. I can not rework the URL To produce a file that has ALL of the versions of the record again. it's like functionality has disappeared.

See the URL that was working.

https://mycompany.sharepoint.com/teams/lms_help/portal/_vti_bin/owssvr.dll?XMLDATA=1&List={29329E39-175F-435A-ADB5-D7632A1CD143}&View={EC5A3FBC-5642-4134-AA51-EFBABF521CF7}&RowLimit=0&IncludeVersions=TRUE
0
Hi Experts,
how to validate xml using java
i dont want any data from the xml just need validate it as valid xml or not
0
I am trying to run some simple API calls to Jet.Com to first get my token and then publish some product I have for sale. I am using Access 2013 and I am getting close, but know I am leaving our some import information possible regarding the header or XML format. Below is my code and any help would be appreciated. Please forgive my lack of detail in the code, but with a little help I believe I can lean it. See code below:

  strURL = "https://merchant-api.jet.com/api/token?"
    strURL = strURL & "User=" & JetAPIUserKeyTest & "&pass =" & JetSecretKeyTest '& """" ''" '" '& "}"

    Dim htm As Object
    Set htm = CreateObject("htmlFile")
    With CreateObject("msxml2.xmlhttp")
       ' .Open "GET", strURL, False
        .Open "POST", strURL, False
        .send
        Response = .responseText
     End With
Thank you
0
I have a need to schedule a task to occur every four hours, but unbelievably I cannot find any way to do this with the  GPO Task Scheduler in Server 2008. The options for "repeat task every" are 5, 10, 15, 30 minutes and 1 hour...
I can modify the custom repeat time manually in 2008 Server task scheduler but the same isn't possible when doing it on GPO task schedule. I understand and tried changing the repeat interval by editing .XML file but instead GPO tasks schedule change to "5 minutes". Please help its very urgent and important.

Thanks in advance.

 here is the .xml file

<?xml version="1.0" encoding="UTF-8"?>
-<ScheduledTasks clsid="{CC63F200-7309-4ba0-B154-A71CD118DBCC}">-<TaskV2 clsid="{D8896631-B747-47a7-84A6-C155337F3BC8}" removePolicy="0" userContext="0" uid="{E5521DE0-0643-4ED9-AC8E-8EA1DD8FED23}" changed="2019-01-15 16:33:08" image="2" name="Reboot Notification">-<Properties name="Reboot Notification" logonType="InteractiveToken" runAs="%LogonDomain%\%LogonUser%" action="U">-<Task version="1.3">-<RegistrationInfo><Author>TMMCADM\admin152</Author><Description/></RegistrationInfo>-<Principals>-<Principal …
0
I need to reset the default the start menu that was customized to point to a website for a default app. What is the location of the XML file that I need to update for Users that have already logged into the Workstations.

Advice please
0
I am receiving the following XML as a result of the HTTP GET function from the B2B supplier.
I need to process this file in the Azure LogicApp and get the invoice IDs, so I can use them to download each invoice using another LogicApp and another URL with GET method.

<Invoices xmlns="http://gateway.com/schemas/Invoices" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://gateway..com/schemas/Invoices Invoices.xsd">
   <DocumentInfo>
      <DocType>INVOICES</DocType>
      <DocVersion>2.0</DocVersion>
   </DocumentInfo>
   <Header>
      <StartDate>2018-12-01T00:00:00+01:00</StartDate>
      <EndDate>2019-01-03T00:00:00+01:00</EndDate>
   </Header>
   <Documents>
      <Invoice InvoiceId="RP82807" InvoiceDate="2019-01-02T00:00:00+01:00" DocumentType="IN" RefDocId="FT34532" RefDocType="ORDER" SystemId="10" HasPDFImage="0" />
      <Invoice InvoiceId="T609881" InvoiceDate="2018-12-31T00:00:00+01:00" DocumentType="IN" RefDocId="FT39339" RefDocType="ORDER" SystemId="0" HasPDFImage="0" />
   </Documents>
</Invoices>

Open in new window


Based on this article I've created the liquid map file to get the list of invoice IDs:
{
"Invoice": "{{content.Documents.Invoice}}"
}

Open in new window


When using it in the LogicApp in the XML->Json converter, got the following result:
{
    "Invoice": ""
}

Open in new window


I have also tried this as a liquid file:
{
"Invoice": "{{content.Invoices.Documents}}"
} 

Open in new window


and this:
{
"Invoice": "{{content.Invoices.Documents.Invoice}}"
}

Open in new window


with the same result.
I have also tried the XSLT file which I found here.
As a result, I got this error:

Open in new window

0
I have an application using MSXML to retrieve data from a web site. On Successful receipt I 'PUT' an XML document to the web site confirming this and the data is cleared from the web site.

Subsequent retrievals then exclude documents previously downloaded.

However within the same application data session I am getting replicated downloads even though all objects related to the download are released after successful download and recreated each time a download process is started.

When I close and restart the application the correct data position is returned.
0
I am trying feed a json to a Dymo printer for labels. I found some old doc on it here  
I want to use Option 2

Put I don't know how to import my json array in there code. On Line 30 is my Var mike it's getting the json array from a input box I used to store it. The json array is this

[{"Barcode ":"M125942-002","part ":"F06984-0027","DESCR":"BACC69CCC0027J\/BOEIN, REV R","MFG":"M125942-002","Cable_Length":"27.125 Inches","Test_A":"0.03","Test_B":"0.05"},{"Barcode ":"M125942-003","part ":"F06984-0027","DESCR":"BACC69CCC0027J\/BOEIN, REV R","MFG":"M125942-003","Cable_Length":"27.125 Inches","Test_A":"0.06","Test_B":"0.04"}]

Open in new window


There are only 2 labels I know the Dymo being used only has 1 text field I will be making my own label and adding the xml to this file when it's done. I just need help in importing the json in to this so then I can use it's fields to feed the label.




//----------------------------------------------------------------------------
//
//  $Id: GoogleSpreadSheet.js 38773 2015-09-17 11:45:41Z nmikalko $ 
//
// Project -------------------------------------------------------------------
//
//  DYMO Label Framework
//
// Content -------------------------------------------------------------------
//
//  DYMO Label Framework JavaScript Library Samples: 
//    Print mulltiple labels using Google Spreadsheet as a data 

Open in new window

0
HTML5 and CSS3 Fundamentals
LVL 13
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Using xmlspy, I created a sample xml document from a valid schema definition to use as test data for an Oracle database (11.2.0.4). However, the resulting document is substantially large and I am running into a "string literal too large" error when trying to load it. I have searched and searched for a possible solution and none of them seem to work. Has anyone at EE been able to load a large (>32 kb) text file into an xmltype column? If so, how?
0
Hi all,

I've written a code that actually works but is really slow and can be improved to make it less error sensitive and faster.

It's a code that uses IE automation in Excel VBA and extracts store prices from a supermarket website. The thing is that across the different stores (in different cities) the prices are different for the same products. To extract the different 'price lines' for the products the codes does/ must do the following:

1- visit the website of the dutch supermarket and select the first store / city. The selected store is saved in a browser cookie.
2- the next code part visits the specified product (in total, finally it will be a fixed list around 200 products, using a loop). (The prices are extracted in a worksheet, not includes in this code yet)
3- next a second city/supermarket is selected and stored in the browser cookie
4- the same code (#2, see above) is called and the prices for the same 200 products is scraped from the store, and saved.


When using IE automation the specific store/city is remembered when visiting the product pages. I found that when using a different method like XMLHTTP request the code is much faster but the problem then is that the product page is not linked to the store that was saved in a browser cookie. Any suggestions how to use the XMLHTTP code (provided at the bottom) or a different method together with a cookie in which the correct store is saved while scraping the product prices?

Below the code, it's
0
I am stuck with the following problem:

What I am trying to achieve:
1. Create a application that generates webservices on the fly
2. Deploy these as individual services in JBoss Fuse.
    Package these as OSGi bundle to deploy in JBoss Fuse server, using Apache CXF framework (This uses Apache Felix)
3. Call these Web Services
    a. Individually
    b. Aggregate / Combine output from multiple web services, create a new web service and deploy this in JBoss Fuse


The issue I'm, facing:
I get the following errors and warnings during deployment of 3 b, i.e. the new web service:
    Errors
     org.apache.felix.scr.impl.manager.DependencyManager.getServiceObject(DependencyManager.java:2012)[54:org.apache.felix.scr:1.8.2]
     org.apache.felix.framework.util.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:943)[org.apache.felix.framework-4.4.1.jar:]

     Warnings
     org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4445)[org.apache.felix.framework-4.4.1.jar:].
     org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:346)[org.apache.felix.framework-4.4.1.jar:]


I have posted this on stackoverflow, jboss developer forums and raised issues in redhat but no responses on this query.

Please find summary of files attached

1. Blueprint :- The blueprint container is a dependency injection framework that simplifies interaction with the OSGi container. In particular, the blueprint container …
0
Hi all,

I've written a code that actually works but is really slow and can be improved to make it less error sensitive and faster.

It's a code that uses IE automation in Excel VBA and extracts store prices from a supermarket website. The thing is that across the different stores (in different cities) the prices are different for the same products. To extract the different 'price lines' for the products the codes does/ must do the following:

1- visit the website of the dutch supermarket and select the first store / city. The selected store is saved in a browser cookie.
2- the next code part visits the specified product (in total, finally it will be a fixed list around 200 products, using a loop). (The prices are extracted in a worksheet, not includes in this code yet)
3- next a second city/supermarket is selected and stored in the browser cookie
4- the same code (#2, see above) is called and the prices for the same 200 products is scraped from the store, and saved.


When using IE automation the specific store/city is remembered when visiting the product pages. I found that when using a different method like XMLHTTP request the code is much faster but the problem then is that the product page is not linked to the store that was saved in a browser cookie. Any suggestions how to use the XMLHTTP code (provided at the bottom) or a different method together with a cookie in which the correct store is saved while scraping the product prices?

Below the code, it's
0
MSExchangeApplicationLogic Event 3028

Nombre de registro:Application
Origen:        MSExchangeApplicationLogic
Fecha:         20/11/2018 8:41:20
Id. del evento:3028
Categoría de la tarea:Extension
Nivel:         Advertencia
Palabras clave:Clásico
Usuario:       No disponible
Equipo:        SVR.contoso.lan
Descripción:
Scenario: ProcessKillBit. Failed to read killbit list file because of exception System.IO.IOException: El proceso no puede obtener acceso al archivo 'C:\Program Files\Microsoft\Exchange Server\V15\ClientAccess\owa\prem\15.1.1591.8\ext\killbit\killbit.xml' porque está siendo utilizado en otro proceso.
   en System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   en System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   en System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
   en Microsoft.Exchange.Data.ApplicationLogic.Extension.KillBitHelper.TryReadKillBitFile(Int32& refreshRate, DateTime& lastModifiedTime)
XML de evento:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSExchangeApplicationLogic" />
    <EventID Qualifiers="32772">3028</EventID>
    <Level>3</Level>
    <Task>3</Task>
    …
0
I'm trying to create a SCOM Management Pack for my HPE Aruba Switches. However, when using the tool that Microsoft gives you for creating Management packs, I can't import the management pack due to the following error:

This management pack cannot be imported.

: XSD verification failed for the management pack. [Line: 1, Position: 2]
The 'Root' element is not declared.

This is my XML below. What am I doing wrong?

<Root>
  <Manifest>
    <Id>HPEArubaSwitches</Id>
    <Name>HPE Aruba Switches</Name>
    <Version>1.0</Version>
  </Manifest>
  <Device Name="HPE Aruba 2530 48G Switch">
    <DeviceDiscovery>
      <SysObjId>.1.3.6.1.4.1.11.2.3.7.11.139</SysObjId>
      <Type>Switch</Type>
      <Vendor>HPE Aruba</Vendor>
      <Model>2530-48G</Model>
    </DeviceDiscovery>
    <Monitoring>
      <Oids />
      <Rules />
      <Monitors />
    </Monitoring>
    <Components />
  </Device>
  <Device Name="HPE Aruba 2530 48 PoE Switch">
    <DeviceDiscovery>
      <SysObjId>.1.3.6.1.4.1.11.2.3.7.11.136.1</SysObjId>
      <Type>Switch</Type>
      <Vendor>HPE Aruba</Vendor>
      <Model>2530-48 PoE</Model>
    </DeviceDiscovery>
    <Monitoring>
      <Oids />
      <Rules />
      <Monitors />
    </Monitoring>
    <Components />
  </Device>
  <Device Name="HPE Aruba 2530 24G Switch">
    <DeviceDiscovery>
      <SysObjId>.1.3.6.1.4.1.11.2.3.7.11.140.1</SysObjId>
      <Type>Switch</Type>
      <Vendor>HPE Aruba</Vendor>
      …
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).