XML

20K

Solutions

Content

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

Integrate external Web Services inside WordPress

Need to create a page in WordPress that would connect to the API and display a search form and list of items from an external API:

Example that needs to be achieved:

http://www.pharmachoice.com/health-advice/medical-conditions

Info about Webservices:

Conditions
Specification: http://webservice.mediresource.com/mridisease.asmx?WSDL

URL: http://webservice.mediresource.com/mriDisease.asmx?op=GetDiseaseInfo

Changeable Variables:
•      strDiseaseInput – any text string (ie. cancer, blood, nose, etc.)
•      intDiseaseID – disease id
•      strAlpha – letter of the alphabet (ie. a, b, c, etc.)

Set Variables
•      intChannelID = 0
•      intLanguageId = 0 (English) / 1 (French)
•      intCountryID = 0
•      strWsKey = {removed}
•      intCaptureOne = 0
•      intCaptureTwo = 0
•      intCaptureThree = 0
•      intCaptureFour = 0
•      intCaptureFive = 0

I have not had the chance to work with API's in the past, so any insight will be very helpful.

Thank you very much!

3 Comments

LVL 1

Question by

rwheeler23

3d ago

Extracting text within quotation marks using C#

I am trying to write a small extraction program using C#. Looking at the example below I am trying to extract IVIOINFO,MYDATABASE and IVItem Other Info.
<DataObject PhysicalName="IVIOINFO" Resident="N" data_source="MYDATABASE" name="IVItem Other Info"><Encrypt val="N" />

In other words I want everything within the quotation marks and to ignore everything else. These data elements are the physical data table name, the database it resides in and the long table name.

tw.WriteLine("{0,0},{1,-0}", tc, objectString.Substring(objectString.IndexOf("data_source")+13,12)); would get me MYDATABASE
tw.WriteLine("{0,0},{1,-0}", tc, objectString.Substring(objectString.IndexOf("PhysicalName")+14,12)); would get meIVIOINFO
tw.WriteLine("{0,0},{1,-0}", tc, objectString.Substring(objectString.IndexOf("name")+6,12)); would get me IVItem Other Info

The problem I have is determining how long the strings will be. Using 12 all the time does not work because when the text is shorter than 12 I get an error message about the index overshooting the length of the string. How can I have it find the first quotation mark, get the string and stop at the next quotation mark?

42 Comments

Question by

Asif KHan

3d ago

SWIFT Message Parser

Hi,

I need to know the available SWIFT Message Parsers for reading unstructured BLOB and structuring the data into XML or some other format.

I did my research and found a few to name below but wasn't convinced if they are enterprise level and scalable.

1. Informatica has a tool to extract messages but it has limitations.
2. Data Transformation SWIFT OOTB library.
3. Volanté
4. Paymentcomponents (http://www.paymentcomponents.com/) parser is easy to use and finds all errors.

Any thoughts?
Thanks in advance.
Asif

3 Comments

Using Delphi XE8 I get errors all the time when compiling a project:

1. [CreateAndroidManifestFile Warning] android:hardwareAccelerated attribute not found. Please review AndroidManifest.template.xml
2. [PAClient Error] Error: E2312 Unable to execute '"C:\Users\Public\Documents\Embarcadero\Studio\16.0\PlatformSDKs\android-sdk-windows\build-tools\21.1.2\Aapt.exe" package -f -M "D:\myprograms\NEW\Delphi\Test\Android\Debug\Clicked\AndroidManifest.xml" -F "D:\myprograms\NEW\Delphi\Test\Android\Debug\Clicked\bin\Clicked-unsigned.apk" -I "C:\Users\Public\Documents\Embarcadero\Studio\16.0\PlatformSDKs\android-sdk-windows\platforms\android-21\android.jar" -S "D:\myprograms\NEW\Delphi\Test\Android\Debug\Clicked\res" -A "D:\myprograms\NEW\Delphi\Test\Android\Debug\Clicked\assets" "D:\myprograms\NEW\Delphi\Test\Android\Debug\Clicked\library" "D:\myprograms\NEW\Delphi\Test\Android\Debug\Clicked\classes"' (Error 1)

[PAClient Error] Error: E2312 D:\myprograms\NEW\Delphi\Test\Android\Debug\Clicked\AndroidManifest.xml:1: error: Error parsing XML: not well-formed (invalid token)

How to solve the problems with this Manifest XML? I didn't input Api keys and all other keys at testing stage. What needs to be done to get rid of this Manifest problems?

Thanks for help.

1 Comment

I had this question after viewing Change a specific key value in app.config file with another value..

i have a config file as below
<meeServices>
<edmServers>
<server name="EDMServer" description="EDMServer" username="" password="" integratedSecurity="true" />
</edmServers>
<rdmServers>
<server name="EDMServer" description="EDMServer" username="" password="" integratedSecurity="true" />
</rdmServers>
<settings>
<add name="ExposureSource" value="path" />
<add name="DomainDatabase" value="Server=HeadNode;Initial Catalog=RMS_MEE_Data;Integrated Security=True;" />
<add name="ResultsDatabase" value="Server=HeadNode;Initial Catalog=RMS_MEE_Results;Integrated Security=True;" />
<add name="JobManagerService" value="url" />
<add name="licensecode" value="code" />
<add name="WhiteListedIPAddresses" value="*" />
</settings>
</meeServices>

in settings , i want to change the name which contains licensecode to newcode. how do i do this.

$ConfigFile = 'C:\Users\psman\Downloads\dev_qa.config'
## XML Node names and Attributes are CaSe SeNsItIvE!
$xml = [xml](Get-Content -Path $ConfigFile)

$xml.SelectSingleNode("meeservices/settings/add[@name='licensecode']").SetAttribute("name", "data1")

$xml.Save($ConfigFile)

0 Comments

Hello Experts,
Can you explain to me how to use a Digital Certificate programmatically:
I need to send electronic invoices on XML format
all is ready I just need orientation on how to sign digitally each XML file programmatically.

I have never used DC before and from what I can see on youtube
it's a software that you operate manually per each file...
This is not practical for us since my customer makes almost a thousand sales per day using our app.
The idea is to have our app use the DC programmatically
Regards,

2 Comments

Hi,

I am trying to pass a div id from XSL to Java script to open the value of div in a modal pop up.
I used the following code - http://jsfiddle.net/uKaBH/
Only difference between the code in this jsfiddle and mine is, I need to do it for multiple div values. PFB a sample of my code.

<html lang="en">
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta charset="utf-8">
      <title>jQuery UI Dialog - Default functionality</title>
      <link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css"><script src="http://code.jquery.com/jquery-1.9.1.js"></script><script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script><link rel="stylesheet" href="/resources/demos/style.css"><script>
          $(function() {
            $( "#{$AID}" ).dialog({autoopen: false});
            $( "#{$AID}" ).dialog("close");
          });
          $(document).ready(function() {
            $('#{$CID}').click(function() {
              $( "#{$AID}" ).dialog({ modal: true });
            });
          });
        </script></head>
   <body>
      <div class="section">
					<div colspan="4" class="sectionHeader">
						<b>Attachments</b>
					</div>
					<xsl:for-each select="/file/notes/note">
					   <table width="100%" class="clsGridTableBase">
							<tr>
                                <xsl:variable name="CID" value="generate-id()"/>						
								<td id="{$CID}" title = "Click to View Content">

Open in new window

…

11 Comments

LVL 9

Question by

xav056

5d agoSolved

fo:block-container in fo:table-cell AntennaHouse position

I have a situation where I need to have an fo:block-container with multiple columns (column-count="4") inside an fo:table-cell The fo:block-container contains a few elements when I have 2 or three fo:blocks within the container everything works fine and the content is displayed properly within the table cell. When I have many fo:blocks in the fo-container the content of the fo:block-container pops out of the table cell and displays on the following page. How can I ensure that the block-container with its content displays within the relevant fo:table-cell? Actually it seems that the whole containing table-row is getting pushed to the second page although there is a lot of space to have that table-row on the same page with the previous row. I should also add if I have fo:block-container column-count="1" it works properly when the count is > 1 the weird positioning happens

1 Comment

I am trying to produce XML output from the following sql query:

select distinct
Builder.DivisionName as [Name]
,convert(varchar, getdate(), 126) as [DateGenerated]
,Builder.ClientdivisionID as [NHTNumber]
,Organization.DivisionName as [Name]
,cast(Organization.ClientdivisionID as varchar) as [LocationNumber]
,'Div' as [LocationLevel]
,OganizationOptions.OganizationOptionsID
,[Option].[Option] OptionNumber
,'Normal' as OptionType
,[Option].SubCategoryName CategoryNumber
,[Option].Description as OptionName
,substring([Option].Comments,1,2000) as OptionDescription
,Price
from
MasterOptionList [Option]
join (Select top 1 '' as OganizationOptionsID from SystemConfiguration) OganizationOptions on OganizationOptionsID=''
join Division Builder on Builder.ClientdivisionID =1
join Division Organization on Organization.ClientdivisionID =[Option].ClientdivisionID
where [Option].IsInactive = 0
order by cast(Organization.ClientdivisionID as varchar)
for xml auto

My desired Output looks like this:

<Builder Name="Builder Name." DateGenerated="2018-08-11T11:55:05.120" NHTNumber="1">
<Organization Name="Division A" LocationNumber="2" LocationLevel="Div">
<OrganizationOptions>
      <Option OptionNumber="ANDAV01C01" OptionType="Normal" CategoryNumber="GENERAL" Price="6350.00">
            <OptionName>Extended Master Bedroom</OptionName>
            <OptionDescription>2 feet wider</OptionDescription>
      </Option>
<Option OptionNumber="ANDAV01C02" OptionType="Normal" …

2 Comments

Cloud Class® Course: SQL Server Core 2016

LVL 12

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Question by

Skumar_CCSA

7d agoSolved

zip the xml files

sourcefolder : C:\zipto\
backupfolder : C:\Zipto\archive
i have xml files in folder..
files 1.xml, 2.xml, 3.xml
want to zip it make the file name 1.zip, 2.zip.3.zip
after sucessfull zip it should move the source file alone to backup folder with 1.xml_DDMMYYYY_HHMMSS
activities must log file logfile
can help to share script...

19 Comments

HEllo,

I have an xml wihich i am try to extract data from. It looks like this:

declare @xmlData xml = '
<BPSD-registret><Measurement2018>
<naza_bpsd><CarePlan>Hi</CarePlan>'+
  '<Actions>'+
    '<Current>'+
      '<Action>'+
        '<id>124</id>'+
        '<msr_id>405397</msr_id>'+
        '<activity>qdq</activity>'+
        '<when>d</when>'+
        '<where>qdw</where>'+
        '<how>dsf</how>'+
        '<whom>sdfsdf</whom>'+
        '<duration>sdfsdf</duration>'+
        '<estimations>'+
        '<estimation>2</estimation>'+
        '</estimations>'+
        '<measures/>'+
      '</Action>'+
      '<Action>'+
        '<id>125</id>'+
        '<msr_id>405397</msr_id>'+
        '<activity>Aaaa</activity>'+
        '<when>jklj</when>'+
        '<where>lk</where>'+
        '<how>jlk</how>'+
        '<whom>j</whom>'+
        '<duration>lkj</duration>'+
        '<estimations>'+
          '<estimation>1</estimation>'+
        '</estimations>'+
        '<measures>'+
          '<measure>1</measure>'+
          '<measure>2</measure>'+
          '<measure>3</measure>'+
        '</measures>'+
      '</Action>'+
    '</Current>'+
    '<Previous/>'+
  '</Actions>'+
'</naza_bpsd>'+
'</Measurement2018></BPSD-registret>' ;

Open in new window

I can extract and save the content of each <action> node using the following code:

insert into BPSD_MeasurementActions
select
a.value('(activity)[1]', 'nvarchar(500)' ) as act_Activity,
a.value('(when)[1]', 'nvarchar(500)' ) as act_When,
a.value('(where)[1]', 'nvarchar(500)' ) as act_Where,
a.value('(how)[1]', 'nvarchar(500)' ) as act_How,
a.value('(whom)[1]', 'nvarchar(500)' ) as act_With,
a.value('(duration)[1]', 'nvarchar(500)' ) as act_HowLong
from @xmlData.nodes('/BPSD-registret/Measurement2018/naza_bpsd/Actions/Current/Action') Actions(a)

Open in new window

The table BPSD_MeasurementActions has an identity column called Id (Integer).

The problem is that the node <measures> has now been added to the xml. I need to save the values of each <measure> node. Therefore there is a one to many relationship with the <action> node and i need to save these values in a details table. The value of Id from BPSD_MeasurementActions will be the foreign key.

Any sugestions on how i can traverse this xml and do the appropriate insertions?

1 Comment

Hi Team,

I have an XML file i need to parse the XML and covert the output into CSV file .

I need output like below . Please help me with the code.
StableChangeVersion|LocalId|Trading Account|type|Value|Status
2|0171375670|NTPA|Y37F40|Active|
2|0171375670|0170485038|SDSMARSH38LONGB|ActiveFB|
2|0171375670|FXOP|XXXX|Active

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruction xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>2</StableChangeVersion>
<Core>
<LocalId>0171375670</LocalId>
</Core>
<TradingAccount>
<Core>
<LocalId>0170485038</LocalId>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id>
</SystemCodeType>
<Value>4973662</Value>
<ValueStatus>Active</ValueStatus>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</ValueStatus>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>FXOPs</Id>
</SystemCodeType>
<Value>L61774</Value>
<ValueStatus>Active</ValueStatus>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>SDSFB</Id>
</SystemCodeType>
…

1 Comment

LVL 2

Question by

CipherIS

2018-08-06Solved

SQL FOR XML Path Display Result

Using below code

CREATE TABLE #Student (
	StudentID		INT,
	ProgramID		INT,
	Email			VARCHAR(25),
	GPA				FLOAT,
	GradYear		INT
)

CREATE TABLE #Program (
	ProgramID		INT,
	Title			VARCHAR(25)
)

INSERT INTO #Program
(ProgramID, DeptID, Title)
VALUES
(1, 10, 'Mechanics'),
(2, 20, 'Computers')

INSERT INTO #Student
(StudentID, ProgramID, Email, GPA, GradYear)
VALUES
(1, 1, 'aaaa@test.com', 3.0, 1999),
(2, 1, 'bbbb@test.com', 4.00, 2000),
(3, 2, 'test@test.com', 3.5, 2001)

SELECT 
	 Student.StudentID AS 'Student/ID'
	,Program.Title AS 'Student/Program'
	,Student.Email
	,Student.GPA AS 'Info/gpa'
	,Student.GradYear AS 'Info/Year'
FROM #Program AS Program
INNER JOIN #Student AS Student ON Student.ProgramID = Program.ProgramID
WHERE Title = 'Mechanics'
FOR XML PATH ('Student'), ROOT('Students')

DROP TABLE #Program
DROP TABLE #Student

Open in new window

I'm trying to get result

<Students>
	<Student ID="1" Program="Mechanics" >
		<EmailAddress>aaaa@test.com</EmailAddress>
		<Info>
			<Gpa>3.0</Gpa>
			<Year>1999</Year>
		</Info>
	</Student>
	<Student ID="2" Program="Mechanics" >
		<EmailAddress>bbbb@test.com</EmailAddress>
		<Info>
			<Gpa>4.0</Gpa>
			<Year>2000</Year>
		</Info>
	</Student>
</Students>

Open in new window

6 Comments

I have created a program to make some XML files used to export data from our local system to another system. I used xsd.exe on Visual Studio 2010 to generate C# classes based on XSD schemas that I received from the other system. One of the types of data that are exported are clients. Now, the problem is that the XML files contain too much data. They have this structure (I have replaced some of the data with xx to not leak sensitive client data):

<?xml version="1.0" encoding="utf-8"?>
<ROWSET xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="Clients">
 <rOWField>
  <BI_CLIENTS>
   <CLIEREFINDIVIDU>xxxx</CLIEREFINDIVIDU>
   <CLIENACEBUSINESS>Wholesale xxxx</CLIENACEBUSINESS>
   <CLIENACECODE>xx</CLIENACECODE>
   <CLIECOUNTRYCODE>DNK</CLIECOUNTRYCODE>
   <CLIEEMAIL>xx</CLIEEMAIL>
   <CLIEZIP />
   <CLIEADDRESS>xx</CLIEADDRESS>
   <CLIECITY>xx</CLIECITY>
   <CLIENAME>xx</CLIENAME>
  </BI_CLIENTS>
  <BI_CLIENTS>
...
</rOWField>
<ROW>
  <CLIEREFINDIVIDU>xx</CLIEREFINDIVIDU>
  <CLIENACEBUSINESS>Wholesale xx</CLIENACEBUSINESS>
  <CLIENACECODE>xx</CLIENACECODE>
  <CLIECOUNTRYCODE>xx</CLIECOUNTRYCODE>
  <CLIEEMAIL>xx</CLIEEMAIL>
  <CLIEZIP />
  <CLIEADDRESS>xx </CLIEADDRESS>
  <CLIECITY>xx</CLIECITY>
  <CLIENAME>xx</CLIENAME>
 </ROW>
</ROWSET>

Open in new window

I want to have only the <ROW></ROW> data, not the <BI_CLIENTS> </BI_CLIENTS> data, so that the data can be imported correctly in the other system. I have attached the code for the generated C# class.
Please help. I am not asking for at complete solution, just for some help to find the right place to change the code.
clients.cs

5 Comments

Question by

Charles Silva

2018-08-05

PKCS15 on Python

Hello guys,

I have to implement an xml signature routine using smart card / token using x.509 signatures in a web application using python. The initial purpose would be for the user to sign xml files that the system generated using the client's certificate. I know that one kind of solution to this situation involves several steps. I'm primarily thinking of python communication with the user's smarcard / token.

I did some testing using python-pkcs11, worked well with an eToken Alladin Pro 72. But when I tried to use a newer smartcard (OberThur Cosmo v7.0.1 PCKS # 15) did not work.

Is there any library in python with pkcs11 and pkcs15 support?

Or will my life go easier by creating middleware in .net or java?

Charles

XML
Python

1 Comment

I have the following xml input and I want to iterate through each Flight grouped by OanD

<root>
	<Data>
		<Flight OanD="ODC1" CnxxIndicator="Y">
			<Depart>
				<CityCode>MUC</CityCode>
			</Depart>
			<Arrive>
				<CityCode>TXL</CityCode>
			</Arrive>
			<Carrier>
				<AirlineCode>TT</AirlineCode>
				<FlightNumber>2036</FlightNumber>
			</Carrier>
		</Flight>
		<Flight OanD="ODC1">
			<Depart>
				<CityCode>TXL</CityCode>
			</Depart>
			<Arrive>
				<CityCode>FRA</CityCode>
			</Arrive>
			<Carrier>
				<AirlineCode>TT</AirlineCode>
				<FlightNumber>187</FlightNumber>
			</Carrier>
		</Flight>
		<Flight OanD="ODC2">
			<Depart>
				<CityCode>FRA</CityCode>
			</Depart>
			<Arrive>
				<CityCode>MUC</CityCode>
			</Arrive>
			<Carrier>
				<AirlineCode>TT</AirlineCode>
				<FlightNumber>94</FlightNumber>
			</Carrier>
		</Flight>
	</Data>
</root>

Open in new window

The desired output xml :

<Response>
	<OriginDestination>
		<Flight OanD="ODC1" CnxxIndicator="Y">
			<AirlineCode>TT</AirlineCode>
			<FlightNumber>2036</FlightNumber>
			<Departure>
				<AirportCode>MUC</AirportCode>
			</Departure>
			<Arrival>
				<AirportCode>TXL</AirportCode>
			</Arrival>
		</Flight>
		<Flight OanD="ODC1">
			<AirlineCode>TT</AirlineCode>
			<FlightNumber>187</FlightNumber>
			<Departure>
				<AirportCode>TXL</AirportCode>
			</Departure>
			<Arrival>
				<AirportCode>FRA</AirportCode>
			</Arrival>
		</Flight>
	</OriginDestination>
	<OriginDestination>
		<Flight OanD="ODC2">
			<AirlineCode>TT</AirlineCode>
			<FlightNumber>94</FlightNumber>
			<Departure>
				<AirportCode>FRA</AirportCode>
			</Departure>
			<Arrival>
				<AirportCode>MUC</AirportCode>
			</Arrival>
		</Flight>
	</OriginDestination>
</Response>

Open in new window

My current snippet of code is below but it's not building desired results. I tried the Muenchian method to group by but it'd only retrieve unique OanD and not group them so I can get the Flights found within the group.

<xsl:key name="OandD" match="/root/Data/Flight" use="@OanD" />

  
<xsl:apply-templates select="Data"/>


<xsl:template match ="Data">

 <OriginDestination>  
 
         <!--<xsl:for-each select="Flight[generate-id() = generate-id(key('OandD', @OanD))]">-->

       <xsl:for-each select="Flight">    
	   
			//do something
			
	   </xsl:for-each>


 <OriginDestination>  
  
</xsl:template>

Open in new window

3 Comments

Question by

nick libee

2018-08-02

XML data to a Restful URL

Hello all,

Kindly advice how I can send XML data to a Restful URL..

Please provide me some sample codes.

I have created a WCF service but unfortunately its not sending anything and moreover i am getting following error message
The remote server returned an error: (415) Unsupported Media Type.

Following is the WCF code.
Dim xml As String
xml = "http://send/p1/?xml=<?xml version=""1.0"" encoding=""utf-8""?>" +
"<Emp ID=""1234"">" +
"<EmpDtls>" +
"<Empno>" & Empno & "</empno>" +
"</EmpDtls>" +
"</Emp>"
Dim url As String = "http://send/p1"
Dim req As HttpWebRequest = DirectCast(WebRequest.Create(url), HttpWebRequest)
Dim requestBytes As Byte() = System.Text.Encoding.ASCII.GetBytes(xml)
req.Method = "POST"
req.ContentType = "text/xml;charset=utf-8"
req.ContentLength = requestBytes.Length
Dim requestStream As Stream = req.GetRequestStream()
requestStream.Write(requestBytes, 0, requestBytes.Length)
requestStream.Close()
Dim res As HttpWebResponse = DirectCast(req.GetResponse(), HttpWebResponse)
If res.StatusCode = HttpStatusCode.OK Then

End If
Dim sr As New StreamReader(res.GetResponseStream(), System.Text.Encoding.[Default])
Dim backstr As String = sr.ReadToEnd()
sr.Close()
res.Close()

Web.config
<system.net>
<defaultProxy>
<proxy usesystemdefault="False"/>
</defaultProxy>
</system.net>

<system.web>
<compilation debug="true" strict="false" explicit="true" targetFramework="4.0" />
</system.web>
…

26 Comments

Another XSLT question, related to some previous ones I've asked.

I'm creating output for an Office Open document. The original template was this simple one:

  <xsl:template match="*[contains(@class, ' topic/body ')]" name="body">
    <xsl:apply-templates select="*"/>
  </xsl:template>

Open in new window

Then I wanted to be able to add processing instructions to change paper orientation. The processing instruction would be <?orientation landscape?> and <?orientation portrait?>

The natural place to put such an instruction is where one wants the paper orientation to change. The paper orientation starts out Portrait by default, then we come to a place where we want the paper orientation to switch to Landscape, so we insert a <?orientation landscape?> instruction in the input stream, and continue. Then later on we want to switch back to portrait mode, we insert a <?orientation portrait?> instruction in the input stream, and continue.

The only problem is, my output is the Office Open format, which wants these paper orientation instructions to go at the END of the section, rather than at the beginning. One essentially says, "End this section and Orient all the pages in this section in Portrait mode."

So if I encounter a <?orientation landscape?> instruction, I need to output a "end this section and orient all the pages in this section in Portrait mode",
and then magically remember I'm in "Landscape" mode now, and remember that until I …

5 Comments

Cloud Class® Course: Python 3 Fundamentals

LVL 12

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Question by

Trent Aams

2018-08-01

Oracle OPERA Hotel Automated Emails

Integration with Oracle OPERA. I have a customer who uses Oracle OPERA for their hotel bookings etc. The customer would like to have an email sent out a couple days before their reservation and then upon checkout. I was thinking Microsoft FLOW would be a good candidate, however, I'm not sure if FLOW is able to connect to the Oracle database.
Someone mentioned that OPERA has an XML web service, however, didn't really elaborate as to if this would work for my scenario. I'm open to suggestions and what would be the best or at least a recommended way of getting booking information such as the name, dates and email addresses.
If Microsoft FLOW is not recommended, would a C# application be advisable to use?

Currently, we have someone who creates an email list everyday and sends through Mail Chimp. Thanks for your assistance in advance.

0 Comments

LVL 2

Question by

Steven O'Neill

2018-08-01Solved

Merge 2 XML Files together - Reworking of original

Quite some time ago I received a huge amount of help from Geert Bormans on merging an XML and XLS(X) file together...now I'm back with some alterations to one of the XML files which hopefully someone - Geert :) - is able to help with.

The original questions can be found here for review:

https://www.experts-exchange.com/questions/28691313/Merge-Excel-file-with-contents-of-XML-file.html
https://www.experts-exchange.com/questions/28691770/Merge-Excel-file-with-contents-of-XML-file-Part-2.html
https://www.experts-exchange.com/questions/28965298/Merge-2-XML-Files-together.html

Everything has been working great but we have a new XML output file that I need to merge together with the original XML file. I've added the files to the question and hopefully the names I've provided make sense.

We need to take the new style file CARDIOLOGY-REPORTS & CARDIOLOGY-REPORTS-Converted XML files and merge these together (they will always be in the correct order within the XML files) using the Merge-File-Cardio.XSL file and create the CARDIOLOGY-REPORTS XML output file (this goes into a different directory so doesn't overwrite any of the original input files.

Essentially we need to change the XSL file to take into account the new style of the original CARDIOLOGY-REPORTS.XML file. I've tried to get this to work but altering the XSL Templates to root (as I believe this is what it should be but not sure if I've done this correctly) and the Group-Starting-With element has changed form …

5 Comments

LVL 3

Question by

Jon Jaques

2018-07-31Solved

Asp.net Sitemap Provider Error

I have an asp.net project that I'd like to add the menu control to, but when I do, and I add a sitemapdata source, the page always gives me an error, like this:

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. 

Parser Error Message: Authentication to host '' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'CODE2017' (using password: NO)

Source Error: 


Line 283:    <siteMap>
Line 284:      <providers>
Line 285:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
Line 286:      </providers>
Line 287:    </siteMap>

Source File: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config    Line: 285

Open in new window

I don't know why it's referencing MySql, the site uses MS Sql and works well otherwise, but when I inspect the machine.config file, sure enough, only that one sitemap provider is listed.

I cannot find any documentation to get me past this, does anybody have a suggestion?

Thanks!

5 Comments

HI ALL

Greetings!!!

what is the best approach to copy a schema to a new schema with in same Data Base if I have LOB , CLOB and XML data Types.

I also have generated columns in my schema.

In IBM documentation, it is clear that it (ADMIN_COPY_SCHEMA utility) does not support XML Data , as below.

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0022035.html
(Please refer the heading Restrictions )

How to handle this case of copying the schema.

2 Comments

XML
Python

36 Comments

I have a sql script that writes the selection into xml format. I am trying to write a batch file that will output this data into an xml file. Using :XML ON I am receiving the following error in the output file:

<?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="No description provided"?>
HResult 0x80004005, Level 16, State 1
No description provided

my .bat file code:
sqlcmd -i "ProductHierarchy-Dept-Cat-Subcat.sql" -S "SC-L-WINSQL-001" -d "HQ_L" -o "output.xml" -y0

If I turn :XML OFF it prints out the entire data selection into one line.

SET NOCOUNT ON 
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON

--drop tables if exist
If(OBJECT_ID('tempdb..#importType') Is Not Null)
Begin
    Drop Table #importType
End

--select data
If(OBJECT_ID('tempdb..#AMSprocuctHierarchy') Is Not Null)
Begin
    Drop Table #AMSprocuctHierarchy
End

select 
	distinct DIM.pos_dept as Department, 
	SD.DESCRIPTION as DeptDesc,
	--left(DIM.category,4) as Category, 
	--right(rtrim(DIM.category),4) as Subcategory,  
	DIM.upc as UPC, DIM.description as ItemDesc, 
	substring(DIM.CATEGORY, 1, 4) as Category, 
	substring(DIM.CATEGORY, 5, 8) as SubCategory, 
	CAT.DESCRIPTION as CategoryDesc,
	subcat.DESCRIPTION as SubcatDesc
		into #AMSprocuctHierarchy
			from DHAT_ITEM_MASTER DIM
			join store_department SD on DIM.pos_dept = SD.STORE_POS_DEPARTMENT
			join CATEGORY subcat
			   on subcat.CATEGORY = DIM.CATEGORY
			join CATEGORY cat
			   on

Open in new window

…

3 Comments

First
Prev
1
2
3
4
5
6
7
Next
Last

XML

20K

Solutions

Content

13K

Contributors

XML

Related Topics

XML

Related Topics