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 send race results to race finishers in classic asp and my script keeps timing out.  I have my Server.ScriptTimeOut set plenty high.  (note that I just added the xmlhttp.SetTimeOuts)  Not sure if I have the other timeout set correctly.  Can someone look at the following code and let me know what changes might help please?  Thans!

Set cdoConfig = CreateObject("CDO.Configuration")
With cdoConfig.Fields
    .Item(cdoSendUsingMethod) = cdoSendUsingPort
    .Item(cdoSMTPServer) = "smtp.mandrillapp.com"
    .Item(cdoSMTPAuthenticate) = 1
    .Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 587
    .Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic
    .Item(cdoSendUsername) = "username"
    .Item(cdoSendPassword) = "pwd"
    .Update
End With

    bSentBCC = False

	For j = 0 To UBound(SendTo) - 1
		'get email address
		sMyEmail = vbNullString
				
		If DontSend(SendTo(j)) = False Then sMyEmail = SendTo(j)

		If Not sMyEmail = vbNullString Then
			If ValidEmail(sMyEmail) = True Then
                            
                sPageToSend = "http://www.gopherstateevents.com/misc/pix-vids_notif.asp?event_id=" & lEventID 

                Set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
	                xmlhttp.open "GET", sPageToSend, false
                    xmlHttp.SetTimeouts 0, 60000, 300000, 300000
	                xmlhttp.send ""
	                EmailContents = xmlhttp.responseText
            

Open in new window

0
Build an E-Commerce Site with Angular 5
LVL 19
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

trying to figure out how to modify an xml version 1.0 script to allow several files to be picked up by an ftp server. We have a current script in place that was created many years ago.. we haven't have to change it but now have the need.
Here is the script below... what I am trying to do is get the last documents (pull file 3 and 4) to actually recognize and pull the files. The file names are also listed below...

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

 <!--
NOTE: CU Contact Info
 

 -->

 <!-- NOTE: ftp dirs lowercased-->
    <appSettings>

       

        <add key="archiveDays" value="60"/>
        <add key="archiveDirectory" value="archive"/>

      <!-- FTP Server INfo -->
        <add key="FTPServer" value="192.168.1.00" />
        <add key="FTPUN" value="confidential" />
        <add key="FTPPwd" value="confidential" />
        <add key="FTPPort" value="22" />

        <!-- Log file info -->
        <add key="LogFile" value="\\blgappserv1\infinity\CreditUnionFTP\work\logs\BLGFeed.log"/>


        <!-- To/From paths-->
        <!-- <add key="networkRootDirectory" value="P:\PCFS\" /> -->
        <add key="networkRootDirectory" value="\\blgdcserv1.blg.local\data\PCFS\" />
        <add key="networkSourceDirectory" value="Exports" />
        <add key="networkDestinationDirectory" value="Imports" />

        <add key="ftpSourceDirectory" value="export" />
        <add key="ftpDestinationDirectory" value="import" />




0
Hi Experts,

Could you help me how to find below special charcters "&#141;&#26;&#26;" in JAVA and Shell Script please.

This appers just of the first name of a person. Since we are not identifying this...this slips through our process and fails at the end of complete process. if we could identify this as part of the first parsing step. it would save lot of reprocessing time and defects etc.


This is what I see in a XML file
Firstname &#141;&#26;&#26; Lastname


Same above character in a CSV file after the complete process failed
Firstname � Lastname
0
Within SQL Server, I am looking for a query to find an xml tag value within a column defined as nvarchar(max)? I tried using cast but my syntax is off... can anyone help?

 select  CAST (t.[xml] AS XML).value ('(/Project', 'nvarchar(max)') AS project  FROM mytable t

does not work

the tag is <Project>value</Project>
0
I use MSXML from a C++ code. It transforms some XML and XSLT to XHTML. To do that I create an IXSLProcessor out of IXSLTemplate and then call its transform() method passing an empty IXMLDOMDocument object (I want an IXMLDOMDocument be populated with the output because I want to do some additional manipulation with its nodes).
That work fine if the XSLT has an <xsl:output method="xml" encoding="UTF-8"/> instruction.
The C++ code can be compiled in two versions - single byte encoding (windows-1252) and Unicode. For the single byte case the XSLT has <xsl:output method="xml" encoding="windows-1252"/>
If the XML or XSLT has a not ASCII (greater than 127) character, the transform() method fails. It either returns E_FAIL or the output document remains empty.
Is it possible to setup the output document to accept a specific single-byte encoding (windows-1252)?
0
On internal intranet the C/C++ client sends out REST-like queries via TCP/IP and receives an XML response from the Java server. If the REST query loops fetching 3 records at a time, the total time to accumulate 90000 records is about 10x longer than if we fetch 100 records at a time. We will be performing a number of timing tests to isolate the cause. In anticipation that the problem may be the slow TCP/IP start due to initial small windowing, what settings are there to tell TCP/IP to start off with the largest (or larger) window size possible?

We are on 64-bit RHEL servers, and I assume that since the client/server are run on an intranet self-contained within the company, that we do not have to be concerned about congestion.

Thanks,
Paul
0
In my node app I have to insert a new XMLnode for identify it later. I developed some code where I expected the right result.
It is really simple:

var xmlDoc = new DOMParser().parseFromString(dataRegelWerk);  //Incomming data
if(allok == false){
                var root = xmlDoc.documentElement;

                var varselem = xmlDoc.getElementsByTagName('vars')[0];
                var newEle = xmlDoc.createElement('TCafe');
                var att1 = xmlDoc.createAttribute("initvalue");
                att1.value = "1";
                var att2 = xmlDoc.createAttribute("type");
                att2.value = "int";
                newEle.setAttributeNode(att1);
                newEle.setAttributeNode(att2);

                root.insertBefore(newEle, varselem);
            }

var myFile = serializer.serializeToString(xmlDoc); //Put back to string to store in db

Open in new window


This is the original formatted XML

<xml xmlns:xi="http://www.w3.org/2001/XInclude">

   <vars>
....

Open in new window


I tried to insert before "vars" and the result is

<xml xmlns:xi="http://www.w3.org/2001/XInclude">

    <TCafe initvalue="1" type="int"/><vars>

Open in new window


But I expected

<xml xmlns:xi="http://www.w3.org/2001/XInclude">

    <TCafe initvalue="1" type="int"/>

       <vars>

Open in new window


Is there anything wrong with my code or do I expect a wrong thing? Maybe I have to close the new XMLNode? (I expected the last / will do it.
Any help will be great.
0
Alex kindly helped me with the following:

Get-GPOReport -All -ReportType Xml -Path "C:\temp\GPOReportAll.xml"

I tried to use the same command on a Server running Windows Server R2 but it won't recognise the Get-GPOReport cmdlet and it won't let me import it.  I need to get a GPO Report from this server as it is our DC.

Since I was struggling I thought I would try to get the GPOReport  using our second DC running the following command:

Get-GPOReport -All -Domain "mydomain" -Server "SERVER01" -ReportType Html -Path "C:\GPOReportAll01.html"

However, all I get is the GPO from Server10 the server I am running the command from which is running Windows 12 R2.

Any help would be greatly appreciated.

Thanks.
0
I am logged in as Administrator using Windows PowerShell ISE and running the following cmdlet:

C:\> Get-GPOReport -All -Domain "mydomain.com" -Server "Server10" -ReportType Xml -Path "C:\Users\myname\Documents\GPOReportAll.xml"

I get the following error message:

Get-GPOReport : Value does not fall within the expected range.
At line:1 char:1
+ Get-GPOReport -All -Domain "mydomain.com" -Server "Server10" -ReportTy ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Get-GPOReport], ArgumentException
    + FullyQualifiedErrorId : System.ArgumentException,Microsoft.GroupPolicy.Commands.GetGpoReportCommand

I can't understand why I am getting this message.  Do any of the experts have any ideas?  How do I address it?

Thanks.
0
I would like to understand how to read and pull out specific information from a table in HTML.
The HTML file is provided as an attachment for your review and the basis for this question.

This HTML file has many tables but specifically I'm concerned about the Exxon Mobil Corporation condensed Consolidated Statement of Income table.   I even put it in a separate attachment shown as Table1.png with the value highlighted in yellow.  I'm specifically focusing in on the values $67,491 and $71,456 line items for Sales and other operating revenue for the years 2019 and 2018.

What I would like to do is identify the table's unique row value.   I'm looking for a commonality that when I parse out this html into a database form - I want to be able to associate that $67,491 value is with sales and other operating revenue specifically.  

Here's a snippet of code:

<us-gaap:Revenues
      contextRef="FROM_Apr01_2019_TO_Jun30_2019_Entity_0000034088"
      decimals="-6"
      id="ID_81A"
      unitRef="USD">67491000000</us-gaap:Revenues>
    <us-gaap:Revenues

Open in new window


And from this I can find several amounts that are under "FROM_Apr01_2019_TO_Jun30_2019_Entity_0000034088" to identify my unique value for the column going down.
However the row that this is related to and how it ties back to " Sales and other operating revenue" - I'm a little lost in identifying.

So when you look at the HTML there is a table and there is relationship but how do I go about finding that unique value for " Sales and other operating revenue" within the html doc I provide below?

Any steps in the right direction would be appreciated.
Table1.PNG
0000034088-19-000042-1-.html
0
Exploring SharePoint 2016
LVL 19
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

I want to find the value of an xml element based on its attribute, where I know the attribute value.
In a particular node, there may be multiple elements with the same "tag", each containing different attributes (& values).
I want to be able to select just one of those elements based on its attribute, the same way I would if I were using the value method and specifying the position in the node.
What is the best way to do this?
I explain in comments through the example.

--Here's an example of the structure (preexisting) I'm querying
DECLARE @Table TABLE([Record] INT, [xmldata] xml, [Morecolumns] varchar(50))
DECLARE @xml xml =
'<root>
	<Record>1</Record>
	<Details>
		<Release R_ID="2" R_Text="ReleaseDate">2019-10-24</Release>
		<Release R_ID="1" R_Text="ReleaseVersion">0.0.1</Release>
		<Release R_ID="3" R_Text="ReleaseName">WoolyAlpha</Release>
	</Details>
	<MoreData>Plenty More Nodes</MoreData>
</root>'
INSERT INTO @Table([Record], [xmldata], [Morecolumns])
SELECT 1, @xml, 'A lot more columns'
--Could be a lot more rows

--What's in the table
SELECT * FROM @Table

--If I could trust the positions within the node, I could just do this.
SELECT 'Desired results' AS 'What'
		, Record
		, xmldata.value('(/root/Details/Release)[2]','varchar(20)') AS 'ReleaseVersion'
		, xmldata.value('(/root/Details/Release)[1]','varchar(20)') AS 'ReleaseDate'
		, xmldata.value('(/root/Details/Release)[3]','varchar(20)') AS 'ReleaseName'
		, xmldata
		, MoreColumns 
	FROM @Table

Open in new window

0
I'm attempting to read in an XML file  I'm getting

ERROR
Inner Exception 1:
InvalidOperationException: <RDF xmlns='http://www.w3.org/1999/02/22-rdf-syntax-ns#'> was not expected.

Open in new window


I think It's to do with Not dealing with Namespaces in FromXml method properly

Can some one advise how to solve

Sample xml
<rdf:RDF 
	xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
	xmlns:skos="http://www.w3.org/2004/02/skos/core#"       
	xmlns:foaf="http://xmlns.com/foaf/0.1/">
    <foaf:Image rdf:about="http:/example.com/img/bangersandmash.jpg"/>
	
	<skos:Concept rdf:about="http:/example.com/Concept/0001">
		<skos:prefLabel>Bangers and mash</skos:prefLabel>
		<skos:altLabel>Sausage and mash</skos:altLabel>
		<skos:altLabel>Sausage and mashed potato</skos:altLabel>
		<skos:inScheme rdf:resource="http:/example.com/thesaurus"/>
		<skos:broader rdf:resource="http:/example.com/Concept/0002"/>
	</skos:Concept>

	<skos:Concept rdf:about="http:/example.com/Concept/0002">
		<skos:prefLabel>English cuisine</skos:prefLabel>
		<skos:altLabel>English dishes</skos:altLabel>
		<skos:altLabel>English food</skos:altLabel>
		<skos:inScheme rdf:resource="http:/example.com/thesaurus"/>
		<skos:narrower rdf:resource="http:/example.com/Concept/0001"/>
	</skos:Concept>

</rdf:RDF>

Open in new window


Program.cs
using System;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;

namespace Diskos
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Hello World!");
            List<RDF> DiskosList = new List<RDF>();

            string PathToSausage = @"E:\DISKOS_Data\Sausage.xml";

             var Sausage = Utilities.FromXml<List<RDF>>("RDF", PathToSausage);

            DiskosList.AddRange(Sausage);

            foreach(var rDF in DiskosList)
            {
// Not got this far so haven't  built code to access xml 
                //Console.WriteLine("Sausage: {0}", rDF);
                //foreach(var skos in chair.Skos)
                {

                }
            }


        }
    }
}

Open in new window


Utilities.cs: Please note I generated the classes by Edit > Paste Special > Paste XML as Classes  Is this the best Way


Open in new window

0
I exported data from a Shopify store to a CSV file. The original data are product descriptions from the store inventory.

When you scroll down the worksheet to ROW 10313, some of the product description and other columns are no longer populated. COL A displays the following type of formatting (XML ?) rules. Those rules continue to be displayed to the last row of about 32000. Some of the rows contain the correct product data:


<m:brkBin m:val=""before""/>
...
<m:mathFont m:val=""Cambria Math""/>
...
UnhideWhenUsed=""false"" Name=""Colorful Grid Accent 6""/>
...
<w:LsdException Locked=""false"" Priority=""73"" SemiHidden=""false""

QUESTION:
Can you explain what is happening and how to fix it?
0
Hey Experts.  Running into a situation that is just defying logic, so I know it's time to bring in the pro's.

This is on a Windows 10 ENT test box.  Using a GP, I'm deploying a defaultapps.xml file for many of the apps we have on that Win 10 PC and for all but one file association, the file associations match the defaultapps.xml.

The one that isn't getting set is with .ps1.  Here is the code that I am using in that xml file for Powershell:

<Association Identifier=".ps1" ProgId="Applications\powershell.exe" ApplicationName="Windows PowerShell" />

Open in new window


When I run gpupdate /force on that PC, it runs successfully.  I use cmd /c assoc .ps1 to see if .ps1 is associated with PowerShell and it shows it is.  When I go to Default Apps > file extension, .ps1 shows Notepad.  However when I browse to a directory where there are .ps1 files, the icon next to a powershell script has the notepad icon and if I open it, the script opens with Notepad.

I'm at a loss for trying to get .ps1 files to open with PowerShell.  Can anyone offer any insight into this?  I would appreciate your help and time.
0
Hello,

Using SQL Server 2012.

I have an xml held by a variable called Variables.  How can i empty every node?  i.e. set it to nil or clear it.

declare @Variables xml = 
'<Variables xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <UserId>1</UserId>
  <UserFirstName xsi:nil="true" ></UserFirstName>
  <UserLastName>Administratör</UserLastName>
  <UserHSAIdentity xsi:nil="true" ></UserHSAIdentity>
  <UserUserId>2Admin</UserUserId>
  <UserEmailAddress1>xx@Skane.se</UserEmailAddress1>
  <UserEmailAddress2 xsi:nil="true" ></UserEmailAddress2>
  <UserAdressRad1>e</UserAdressRad1>
  <UserAdressRad2 xsi:nil="true" ></UserAdressRad2>
  <UserAdressRad3 xsi:nil="true" ></UserAdressRad3>
  <UserPostKod xsi:nil="true" ></UserPostKod>
  <UserPostStad xsi:nil="true" ></UserPostStad>
  <UserTelefon1>12344 129877</UserTelefon1>
  <UserTelefon2 xsi:nil="true" ></UserTelefon2>
  <UserStatus>Inaktiv</UserStatus>
  <UserJobCategory>Övrigt</UserJobCategory>
  <UserChangePasswordDateTime>Aldrig ändrat</UserChangePasswordDateTime>
  <UserLoginTries>0</UserLoginTries>
  <UserLockedDateTime>2018-02-09 14:23</UserLockedDateTime>
  <UserIsGDPRApproved>Nej</UserIsGDPRApproved>
  <UserGDPRApprovalDateTime xsi:nil="true" ></UserGDPRApprovalDateTime>
</Variables>'

Open in new window

0
hi

how can i remove a node from html collection xml in javascript
0
Hello Experts,
Here is my issue.  I have a MySQL database that a report is being derived from. There is a field in one of the tables that is stored as XML. Previously, an expert gave me some great advice and I was able to create a formula that broke out one of the 3 pieces of data that I need.

StringVar strTest := {_invoice_transaction1.Extra};
ExtractString (strTest,'"CheckDate">',"</v");

While this formula gives me the CheckDate, as I suspected, I could not create a parameter field from the formula.
Unless there is a workaround that I have not yet deduced, my latest attempt is to go to the SQL query and modify the query prior to the data reaching the report.

I know I need to go to: Database:database expert: odbc: add command... and there I can modify the SQL.

So, that leaves me 2 questions: Where and or how can I see the SQL statement output so I know if my modifications are going to have the desired results. If I was using straight SQL I would probably add a line like: ExtractString(_invoice_transaction1.extra, '"Checkdate">',"</") as checkdate     -  to my query which I have copied from Crystal below.

 SELECT _invoice_transaction1.TransactionDate, _customer1.LastName, _customer1.FirstName, _customer1.MiddleName, _insurancecompany1.Name, _invoice1.ID, _invoicedetails1.BillingCode, _user1.Login, _invoice_transaction1.Amount, _invoice_transaction1.Taxes, _invoicedetails1.ReviewCode, _invoice_transactiontype1.ID, _invoice_transaction1.Extra
 FROM   …
0
Hi,

How can I take the results of a Linq Query and convert to XML and save to file.

I have provided some same code below.

Thanks,
Ward

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Linq_Test_1
{

    class Person
    {
        public string Name;
        public int Age;
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Person> People = new List<Person>();

            Random rnd = new Random();

            for (int i=1;i<=100;i++)
            {
                Person person = new Person();

                person.Name = "Name" + i.ToString();                
                person.Age = rnd.Next(1, 101);
                People.Add(person);
            }

            int counter = 1;
            var results = from Person in People orderby Person.Age descending
                         select new
                         {
                             Name = Person.Name,
                             Age = Person.Age,
                             Index = counter++ 
                         };


        }
    }
}

Open in new window

0
dear all

i have a xml file
var m_XML_segments_Grid =  ($.parseXML(m_result_segments_Grid); where m_result_segments_Grid is an string
and m_XML_segments_Grid_str = new XMLSerializer().serializeToString(m_XML_segments_Grid);
contain the below :
"<NewDataSet>↵  <DsResQuery>↵    <SEQ>2</SEQ>↵    <SEGMENTNBRE>Segment #1</SEGMENTNBRE>↵    <P_SEGID>1</P_SEGID>↵    <CBOIN>08:00</CBOIN>↵    <CBOOUT>13:00</CBOOUT>↵    <DATE_TIME_STR>09/02/2019</DATE_TIME_STR>↵    <P_DESC>Segment 1 desc</P_DESC>↵    <P_DSCHEMA>8</P_DSCHEMA>↵    <P_WRKSTAT>0</P_WRKSTAT>↵    <P_PRESENT>1</P_PRESENT>↵    <P_STATUS_DAY>0</P_STATUS_DAY>↵    <P_FLOAT>0</P_FLOAT>↵  </DsResQuery>↵  <DsResQuery>↵    <SEQ>3</SEQ>↵    <SEGMENTNBRE>Segment #2</SEGMENTNBRE>↵    <P_SEGID>2</P_SEGID>↵    <CBOIN>14:00</CBOIN>↵    <CBOOUT>17:30</CBOOUT>↵    <DATE_TIME_STR>09/02/2019</DATE_TIME_STR>↵    <P_DESC>Segment 2 desc</P_DESC>↵    <P_DSCHEMA>8</P_DSCHEMA>↵    <P_WRKSTAT>0</P_WRKSTAT>↵    <P_PRESENT>1</P_PRESENT>↵    <P_STATUS_DAY>0</P_STATUS_DAY>↵    <P_FLOAT>0</P_FLOAT>↵  </DsResQuery>↵</NewDataSet>"

Open in new window

i need to add row to this xml and delete row from this xml how to do it?
1
HTML5 and CSS3 Fundamentals
LVL 19
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.

Hi Experts:
So I'm not super with Crystal Reports... let's start there.

I have a memo field that is stored as XML.
I need to parse the XML and pull 3 variables for one for Checknumber, one for checkdate, and one for paid.

Here is part of the problem. Some data sets contain the 3 variables, some don't, some data sets are null (no data at all).
Here are 2 sample pieces of data.

<values>
  <v n="Billable">50</v>
  <v n="CheckDate">04/29/2019</v>
  <v n="CheckNumber">12</v>
  <v n="Paid">35</v>
  <v n="PaymentMethod">Check</v>
</values>


<values>
  <v n="Billable">3617.85</v>
  <v n="Paid">500</v>
  <v n="PaymentMethod">Cash</v>
</values>

Ultimately, the goal is to have a formula and to be able to search for the CheckDate, CheckNumber, or Amount.
At this point, I am not certain that even If I can isolate the variables, that the variable can be made into parameters for searching...

I have researched and attempted various string variables but without success.
0
Hi,

I have the following json_decode data :

Array
(
    [metadata] => Array
        (
            [result] => 1
            [version] => 1
            [command] => listzones
            [reason] => OK
        )

    [data] => Array
        (
            [zone] => Array
                (
                    [0] => Array
                        (
                            [zonefile] => mybrand.asia.db
                            [domain] => mybrand.asia
                        )

                    [1] => Array
                        (
                            [domain] => mybrand.my
                            [zonefile] => mybrand.my.db
                        )

                )

        )

)

Open in new window


May i know how to manipulate the data ?

Eg:

1. How to get "mybrand.asia" or "mybrand.my.db" output ?

2. How to loop each data in foreach ?


Appreciates anyone assistant on this.

Thank you.
0
Hello,  I'm having an issue with a vendor,  regarding post titles in an XML feed we are sending them.

The majority of the post titles are like this below.
6-Day, Chocolate Dedicated Class A Driving Job – Hannibal, MO

They (vendors) want us to eliminate the city, state from the title.  so would be just
6-Day, Chocolate Dedicated Class A Driving Job

We have over 2500 jobs, with titles like that. So, is it possible to truncate the title in the feed, so it outputs everything up to the -

Below is the template i created, and the actual feed url is here
<?php
/**
* Template Name: Custom RSS Template - sptshafferfeed
*/
$postCount = 500; // The number of posts to show in the feed
$cacheFile = "wp-content/themes/enfold/rsscache/sptshafferfeed.rss";

if(!file_exists(dirname($cacheFile)))
{
  mkdir(dirname($cacheFile));
}

$posts_per_page = 50;
$paged = 0;
$theres_more = true;
$rss_items = array();
if(file_exists($cacheFile) && !isset($_GET["reset"]))
{
  $rss_items = json_decode(file_get_contents($cacheFile),true);
  if($rss_items == null) { $rss_items = array(); }
}

$charset = get_option( 'blog_charset' );
header( 'Content-Type: ' . feed_content_type( 'rss-http' ) . '; charset=' . $charset, true );
?>
<?php echo '<'.'?xml version="1.0" encoding="utf-8"?'.'>'; ?>
<source>
<title><?php bloginfo_rss( 'name' ); ?> - SmartPhoneTrucker - Shaffer Trucking Job Feed</title>
<link><?php bloginfo_rss('url'); ?></link>

Open in new window

0
I have a text string like this:
"stuff<offset>1234</offset><length>78</length>stuff <offset>1000134</offset><length>5678</length>stuff...<offset>11234</offset><length>5678</length>stuff"

Open in new window

My goal is to find the largest offset value and the corresponding length value.

I know I can write a loop searching for each "<offset>" and extract the value. I was wondering if in python3.7, there is a non-loop approach. (I can  use existing xml parsing code, but this seems simple enough to just use the text string.)

Thanks,
Paul
0
As far as I know, in XML we use the following XML Escape characters to convert the same from Excel formula to XML Formula for use in XML files.

" with & quot;
> with & gt;
< with & lt;
& with & amp;
' with & apos;

Now what is the XML equivalent of following in Excel

<> (Not equal to
>= (Greater than or equal to)
<= (Less than or equal to)

Whether there are any other such characters ?

Is there any specific way of representing / rewriting Excel Formula to XML Formula ?

In addition to above, as an example What would be the XML equivalent of the following formula in Excel ?

=IF(OR(B1<>"Receipt",K1<>"Advance",LEN(TRIM(AQ1))=0),"","Advance Receipt")

Regards
Kanwal
0
I'm new to oracle , if one has  to save XML in Oracle datatype ( 11 or higher) , is there a XML datatype in oracle?
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).