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 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
Become a CompTIA Certified Healthcare IT Tech
LVL 12
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Visual Studio 2015, SSRS

I am having a problem working on RDL files locally.  I was sent some RDL file to review.   When I use  "Add Existing"  to add the reports to a report project, I can see the report design when I right-click and select "View Designer"

However, when I select "View Code", I only see XML.  What am I doing wrong?

Thanks
0
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
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
Become a Microsoft Certified Solutions Expert
LVL 12
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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
I have xml in which the data is present in a non-regular structure, and I can't use the value method to retrieve it.
By non-regular, I want the value of certain attributes and I can't predict how many nodes deep it might be.

The interesting part is that I want to retrieve attributes from the 3rd level of nodes (1st  level of 'Item') in one column, then place all other instances of a particular attribute, regardless of how many nodes deep it is, into the next column.  The first level always has the same structure (/ItemList/Definition/Item).
While the example shows a depth of perhaps 8 nodes, in reality there may be five or ten times that depth/complexity.

Can this be done?
Thanks,
Ed

DECLARE @TestXMLTable Table(XmlData xml) 
INSERT INTO @TestXMLTable 
SELECT
 ' <ItemList>
    <Definition Trigger="False">
      <Item Id="1" Status="True">
        <ItemDefinition ID="Name1-FirstLevelVariableText" Type="Custom" Key="0">
          <Items>
            <Item ID="Yada-VariableTextFor101" FieldID="101" ManyOthers="xxxxxx" >
              <ItemDefinition ID="yyyy" Expression="zzzzzz">
                <Items>
                  <Item ID="Yada-VariableTextFor102" FieldID="102" IgnoreNull="false" CompareValue="568|569|570">
                    <ItemDefinition ID="">
                      <Items />
                    </ItemDefinition>
                  </Item>
                  <Item ID="Yada-VariableText102b" FieldID="102" IgnoreNull="false" 

Open in new window

0
While writing a custom ribbon for Access, I'm having troubles removing 2 elementsin the info tab of the backstage. See attached image, I would like elements circled in red to be removed.

RibbonCreator did not help much as it hardly support the backstage view (or is that just the shareware ?), and isMso provided by Ribbon Wizard were frowned upon by Access (GroupFileProperties and GroupFileLocation).

Below, the XML I obtained:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
    <commands>
         <command idMso="Help" enabled="false"/>
    </commands>
    <ribbon startFromScratch="true"/>
    <backstage>
         <tab idMso="TabInfo" visible="true">
              <firstColumn>
                   <group idMso="GroupDatabaseCompact"/>
                   <group idMso="GroupDatabaseEncryption" visible="false"/>
                   <group idMso="GroupFileProperties" visible="false"/>
                   <group idMso="GroupFileLocation" visible="false"/>
              </firstColumn>
         </tab>
         <tab idMso="TabOfficeStart" visible="false"/>
         <tab idMso="TabRecent" visible="false"/>
         <button idMso="FileSave" visible="false"/>
         <tab idMso="TabSave" visible="false"/>
         <tab idMso="TabPrint" visible="false"/>
         <button idMso="FileCloseDatabase" visible="false"/>
         <tab idMso="TabHelp" visible="false"/>
         <button idMso="ApplicationOptionsDialog" visible="true"/>
    </backstage>
</customUI>

Open in new window

Access-Backstage.png
0
I want to write a web page that requests an xml or json request every hour from another site and then parse and update fields
I have written general pages that are static in nature, but now I want to write on that auto updates every how with new data pulled from another site which returns the data in either json or xml.
I am not sure how I would do this.
I am looking for some basic samples or a good tutorial for this type of action.

Thanks, Bruce
0
I have to install and activate Visio 2019 pro and I have dilemma.
Having license key but having issues with xml activation process.
Presently I have Visio2019 folder where I downloaded stream.x64.x-none.dat and other necessary components for Visio 2019 Pro.
I don't know what is the problem with my configuration.xml...???
Should I run setup /configure configuration.xml from the location of the stream files or ODT folder (main Visio2019 folder) ...???
XML-SYNTAX.PNG
Stream.x64-location.PNG
Visio2019-folder.PNG
0
Running Access 2013.  Creating custom Ribbons.  Trying to streamline one of my forms that has a tab control on the form, by removing the actual  Tabs on the TabControl and setting focus to the correct tab as the user clicks the Tab on the ribbon. Not a button, but just the Tab above the buttons on the ribbon.
This is the XML for the ribbon and it works fine.  I just needs the proper way to insert an "onAction" to allow the function to run which sets focus to the correct tab.  FYI: The functions work fine too as I have already tested them with a button.

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<tabs>
<tab idMso="TabCreate" visible="false" />
<tab idMso="TabExternalData" visible="false" />
<tab idMso="TabDatabaseTools" visible="false" />
<tab id="VendorsTab" label="Vendors" visible="true">

@@@@  NEED A STATEMENT HERE THAT CALLS "Set Tab1 Focus"   @@@@@@

<group id="VendorGroup" label="Purchase Orders"  visible="true">
         <button id="CreatePO" label="New Purchase Order"  imageMso="QueryShowTable" size="large" onAction="=CreateNewPO()" />
         <button id="FindPO" label="Find Purchase Order"   imageMso="FindDialog" size="large" onAction="=FindPurchaseOrder()" />
</group>
<group id="POGroup" label="Vendor"  visible="true">
         <button id="EditVendor" label="Edit Vendor"  imageMso="FileCloseDatabase" size="large" onAction="=EditVendor()" />
         <button id="NewVendor" …
0
I need to create a PHP script to convert XML to JSON using only native PHP XML parsing modules. No json_decode is allowed.
0
Become a Certified Penetration Testing Engineer
LVL 12
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Hi

We need to convert the text on an  invoice which can be in the form of image/PDF into XML.

Any third party service which uses artificial intelligence to process different kind of invoice template, is needed.

Please let me know about any tool/service(free/paid) is available for same.
In net I can see many companies providing same but when we actually contact them, they deny.
Please help.

Thanks.
0
Hi,

I need to suppress a repeating value within a Group in BIPublisher Report. Except for the Plan, Level, and number of seats fields within a course - I want to suppress repeating values of all other columns within a course.

I have attached what the report layout should look like.  You don't need to be familiar the report writer only with xml.

A search for a solution was suggested that I can used the later in bold below in the form field.  The form field is where a variable resides and you can do what you want with it.

For the Course header, form field looks like this..

<?fld_COURSE_DESCR?>
[b]<xsl:if xdofo:ctx="cell" test="position()=1"></xsl:if><xsl:attribute xdofo:ctx="block" name="number-rows-spanned"><xsl:value-of select="last()"/></xsl:attribute>[/b]

Open in new window


--- this does not work with variables that are numbers such as the Enrl Total
--- Also, say a course has 2 instructors both different, I want them to appear.  This makes only one appear.

So,  I tried the second suggestion which I can understand.  I am not familiar with the code above.

<? fld_NAME[not(.=preceding:: fld_NAME)]?> 

Open in new window


If a name like 'Assn Fac not'  appears once for a course and is needed again for another course it will not appear.  For the number, scenario like the Enrl Total - sometimes values appear sometimes they don't.

Any help would be greatly appreciated,

Brock
report.PNG
codeentry.PNG
desired.PNG
result.PNG
0
I have googled this one and despite numerous suggestions I have not succeeded and yet it seems so simple.
In visual studio community 2017 edition, I have a vb web application which includes an XML file of program settings which I do not want to embed, I want it to stay as an .xml file so the site's behavior can be altered without recompilation.
When I run the web application in debug , the output folder shows the web app DLL of the compiled web app and no XML file and the program fails to locate it.
The file is set to Copy to Output directory and I have tried Content, Additional Files, None, to no avail, it never copies.  If I copy the XML file to the output folder whilst in debug mode it works so the question is why does my XML file not copy to the output directory.
I have included the xml file at the top level of the project.  
What needs to happen for the web app to copy the XML file to the temporary debug iis express folder so my website can find it and work?
Thank you,
0
Hi ,

We're wondering if it is possible to pull XML data directly from an online feed straight into a SQL procedure rather than saving the XML data as a stored table first?

Thanks in advance!
0
I am trying to post an  xml file to a website that uses https and TSL1.2 with the following vbscript.  I supsect the TSL1.2 requirement is casuing the failure point .  I do get back
error 80072EE6  "the url does use a recognized protocol"  .  The vbs code is as follows:

Dim xmlhttp

Set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")

' Indicate that page that will receive the request and the
' type of request being submitted
xmlhttp.Open "POST", " https://xxxxx.xxxx.xxxxx.xxxxx/data.xml", False


' Indicate that the body of the request contains form data
xmlhttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"

' Send the data as name/value pairs
xmlhttp.send "Id=1&S=2"

Set xmlhttp = Nothing

Open in new window


Any thoughts
0
According to this Greg Maxey article it's possible to customise the context sensitive menu at the bottom of this screenshot both via customUI XML and the older CommandBars model.

Office context menu for text
But is there any way to customise the smaller popup menu at the top e.g. the one with the font formatting controls in it?
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).