XML Help

Hi This is following on from here

As a learning exercise I'm retrieving and updating an XML file of TV show information

It occurred to me that it's possible to have multiple seasons to the same TV show so I adjusted the XML accordingly
TV.XML

<?xml version="1.0"?>
<TV>
  <Show>
      <Name>MacGyver 2016</Name>
      <FolderName>MacGyver 2016</FolderName>
      <TMDBid>67133</TMDBid>
      <Season>
        <SeasonNumber>3</SeasonNumber>
        <Episode>
          <EpisodeNumber>1</EpisodeNumber>
          <EpisodeName>Improvise</EpisodeName>
          <BackDrop>https://image.tmdb.org/t/p/w350_and_h196_bestv2/eQMVJkBltvID73sh9vvTistssS6.jpg</BackDrop>
          <FullPath>J:\Media\TV\MacGyver (2016)\S03\Macgyver.2016.S03E01.Improvise.mp4</FullPath>
        </Episode>
      </Season>
      
  </Show>
</TV>

Open in new window

Of course this broke the LINQ query from the previous so answer

How do adjust the select query bellow to retrieve Episode data which is now nested in Season?

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

namespace XmlReader
{
    class Program
    {
        static void Main(string[] args)
        {
            // Load the XML Document using Linq to XML
            var xdoc =

Open in new window

…

1 Comment

Become a CompTIA Certified Healthcare IT Tech

LVL 12

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.

Question by

sridhar R

1d agoSolved

XSLT to sum totals and grouping

Hi All,

I am working on an xslt which should transform XML to space separated flat file. I was able to do xslt which essentially as per requirement is space delimited and restricts record to 300 characters.

My output at the moment is

003339334070 0000554509 0000000200 10192018 EUNICE PRICE
003339334070 0000554510 0000005750 10192018 M3 USA Corporation
003339334071 0000554509 0000000300 10192018 EUNICE PRICE
003339334071 0000554510 0000005700 10192018 M3 USA Corporation

But vendor came back with new requirement to add another record which should be sum total amount and count the line items. For example I need the data like below. Where 2 is number of lines and 003339334070 is feild wd:CF_Account_number_HSBC_Canada from source. This field is also key to group the records. And 0000005950 is sum of two totals.

003339334070 0000554509 0000000200 10192018 EUNICE PRICE
003339334070 0000554510 0000005750 10192018 M3 USA Corporation
003339334070 2 0000005950
003339334071 0000554509 0000000300 10192018 EUNICE PRICE
003339334071 0000554510 0000005700 10192018 M3 USA Corporation
003339334071 2 0000006000

I am attaching the XSLT and XML i am using for testing. Can some one please help me to achieve above result? I am new to XSLT and learning.

Thanks & Regards,
Sridhar
XSLTHELP.xsl
pp2.xml

4 Comments

I have a dynamic web project ( SOAP web service), which takes parameters from a received message and inserts data to oracle db. This all works fine. However, db connection url, password and user are hardcoded.

This web app will be distributed to a number of servers with different db connection details, so it can't be hardcoded and generating a new app for each server is not an option.

I wonder if I could store needed info in an xml file and read from there. Is someone able to give me a nice simple example of how to do it?

Also, where such file would have to be placed, bearing in mind it would have to be possible to edit it after the deployment?

11 Comments

Is there a way to convert a scan document PDF to XML 2.6? I tried to convert it using Adobe Acrobat, Save as XML format, but it saved as XML 1.0.

3 Comments

LVL 1

Question by

trevor1940

3d agoSolved

C#: Reading and appending XML file

Hi

Using the XML file bellow as a log I'm gathering information about TV shows using TMDB api (Not part of question just background)

How do I access each show name and its childs episodes details?

Ultimately I want to be able to access a Episode path and if doesn't exist in the xml create a new entry or parent show

XmlReader

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

namespace XmlReader
{
    class Program
    {
        static void Main(string[] args)
        {
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load(@"J:\Media\TV\TV.xml");
            XmlNodeList Nodes = xmlDoc.SelectNodes("TV/Show");
            for(int I =0; I <= Nodes.Count; I++)
            {
                Console.WriteLine(Nodes[I].Name); // This throws an error 
            }

            Console.ReadKey();
        }
    }
}

Open in new window

TV.xml

<?xml version="1.0"?>
<TV>
  <Show>
      <Name>MacGyver 2016</Name>
      <FolderName>MacGyver 2016</FolderName>
      <TMDBid>67133</TMDBid>
      <Season>3</Season>
      <Episode>
          <EpisodeNumber>1</EpisodeNumber>
          <EpisodeName>Improvise</EpisodeName>
          <BackDrop>https://image.tmdb.org/t/p/w350_and_h196_bestv2/eQMVJkBltvID73sh9vvTistssS6.jpg</BackDrop>
      <FullPath>J:\Media\TV\MacGyver (2016)\S03\Macgyver.2016.S03E01.Improvise.mp4</FullPath>
      </Episode>
  </Show>
</TV>

Open in new window

I'm assuming I would create a new episode by appending to it's parent show (something like bellow) but how do I find the correct show / season
Similarly How do create a new show?

XmlNode EP = xmlDoc.CreateElement("Episode");
            XmlNode EpNum = xmlDoc.CreateElement("EpisodeNumber");
            EpNum.Value = "2";
            EpNum.AppendChild(EP);
            // repeate for each element

Open in new window

5 Comments

Hello,

I generated soap web services using Eclipse JEE, which then I deployed ( .war) on Tomcat 7.0 on Centos 7 - this works fine.
The aim is to insert a data received in an xml and insert it to an Oracle table.

I've added the below code to a java class file, which meant to do some insert statement ( which is valid ) , with hardcoded values, just to prove I can do it.

    public void InsertValue(String MessageId, String value){
    	try{

    	Connection con=null;
    	Class.forName("oracle.jdbc.driver.OracleDriver");


    	con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xxx", "xxx","xxx");
    	Statement s = con.createStatement();

    	s.execute("INSERT INTO ping_message (message_id,dstamp) VALUES ('1',To_char(SYSDATE))");
    	con.setAutoCommit(true);
    	s.close();
    	con.close();
    	}catch(Exception e){
    	System.out.println("ERROR: "+e.getMessage());
    	}
    	}

Open in new window

Unfortunately, this does not work. I wonder if this is because of the java code or Tomcat needs some db drivers in order to establish a connection the database ?

btw, my java skills are being developed as I type this :)

8 Comments

Msg 2370, Level 16, State 1, Line 30
XQuery [value()]: No more tokens expected at the end of the XQuery expression. Found '1'.

Getting this error above when I do this select statement below. Is there a better way to fix this XML PATH statement?
Thanks.
(Using Sql Server 2016)

select 7271 container_id into #cr_containers

(SELECT
      Stuff((
            SELECT N',' + cast(container_id as nvarchar(50))
            from #cr_containers
            FOR XML PATH(''),TYPE
      ).value('text()1','nvarchar(max)'),1,1,N''));

4 Comments

Hi all, hoping one of you Gurus can assist please.

I have been using a payment system for many years but they have now changed one of their SOAP calls to an external URL. For the life of me I'm unable to connect without the following error:

"cannot be processed at the receiver, due to a ContractFilter mismatch at the EndpointDispatcher. This may be because of either a contract mismatch (mismatched Actions between sender and receiver) or a binding/security mismatch between the sender and the receiver. Check that sender and receiver have the same contract and the same binding (including security requirements, e.g. Message, Transport, None). "

these are the binding info from their App.config file if it helps

<bindings>
      <basicHttpBinding>
        <binding name="BasicHttpBinding_IPortalService">
          <!-- Transport security is only required when the portal service is running under https, for http this should be set to None -->
          <security mode="Transport" />
        </binding>
      </basicHttpBinding>
    </bindings>

Open in new window

I'm using PHP7 and have free run on the server to implement any of your suggestions. Previously I used cURL to simply create the SOAP XML, post if off and grab the response but having no luck here.

I cant post all the login details etc as it's payment and site specific but I'm after being initially able to at least connect to the SOAP URL below, and get a more valid error (for example, invalid user logon) etc.

Ok, here's the details:

https://pay360sc.e-paycapita.com/LivePayments242/PortalService.svc?wsdl

Action required is "Invoke" for which I believe the following should be the right XML to be sent:

Open in new window

…

18 Comments

LVL 8

Question by

Sam Jacobs

2018-12-02Solved

Formatting the output of an OData Query

I have an OData query to get a historical list of HDX sessions (username, start/end times, protocol, Delivery Group) from Director. What's the easiest way to extract the data from the XML and produce a simple table of the fields above? I tried using Chrome's Advanced REST Client, but while the XML response came back fine, the client couldn't parse it successfully.
The actual query:

http://ddc.company.com/Citrix/Monitor/OData/v3/Data/Sessions?$filter = StartDate ge datetime'2018-12-02T15:14:49' and StartDate le datetime'2018-12-03T03:14:49' and CurrentConnection/Protocol eq 'HDX'&$select = StartDate,EndDate,CurrentConnection/Protocol,Machine/DesktopGroup/Name,User/UserName,User/FullName&$expand = CurrentConnection,Machine/DesktopGroup,User

Open in new window

11 Comments

Hello Experts,
I have the content of an XML file being shown in a richtextbox (.NET VB)
How can I make it have the color formatting?
Regards,

5 Comments

PMI ACP® Project Management

LVL 12

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

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

…

2 Comments

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?

3 Comments

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…

2 Comments

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 …

4 Comments

0 Comments

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>
…

Exchange
XML

4 Comments

LVL 1

Question by

whorsfall

2018-11-18Solved

Add XML Attribite to XML string.

Hi,

How can I change the following code to add a video attribute in the second node of the string.
I want to make sure it appears straight after the image attribute.

Thanks,

Ward.

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

namespace PieXML
{
    class Program
    {
        static void Main(string[] args)
        {
            string xml_data =
@"<?xml version=""1.0""?>
<gameList>
<game>
	<path>./2005 Minigame Multicart (USA) (Unl).zip</path>
	<name>2005 Minigame Multicart (USA) (Unl)</name>
	<image>./boxart/2005 Minigame Multicart (USA) (Unl).png</image>
	<video>./snap/2005 Minigame Multicart (USA) (Unl).mp4</video>
	<releasedate />	
	<developer />
	<publisher />		
	<genre />	
</game>
<game>
	<path>./A-VCS-tec Challenge (USA) (Unl).zip</path>
	<name>A-VCS-tec Challenge (USA) (Unl)</name>
	<image>./boxart/A-VCS-tec Challenge (USA) (Unl).png</image>
	<releasedate />
	<developer />
	<publisher />
	<genre />
</game>
</gameList>
 ";

            XmlDocument doc = new XmlDocument();
            doc.LoadXml(xml_data);

            foreach (XmlNode node in doc.DocumentElement.ChildNodes)
            {
                Boolean video_found = false;
                foreach (XmlNode locNode in node)
                {
                    string node_name = locNode.Name;

                    if (node_name == "video")
                    {

Open in new window

…

11 Comments

Question by

Boopathy S

2018-11-14Solved

Namespace error occuring on validated file

I'm having the lot of XSD, which is included with single XSD file and all the files are getting valid well and the corresponding XML file also getting valid against corresponding XSD using oxygen XML editor. But while uploading the xml file against the XSD's file in the product. I'm getting the below error:

Error resolving component 'Definition.attrib'. It was detected that 'Definition.attrib' has no namespace, but components with no target namespace are not referenceable from schema document

When I opened the corresponding file, it shows validated in oxygen XML editor. Here is the code for the corresponding file:

<?xml version="1.0" encoding="UTF-8"?>

<xs:schema 
  xmlns:xs="http://www.w3.org/2001/XMLSchema"
  xmlns="http://www.w3.org/1998/Math/MathML"
  targetNamespace="http://www.w3.org/1998/Math/MathML"
  elementFormDefault="qualified"
 >

<xs:include schemaLocation="common-attrib.xsd"></xs:include>
<xs:include schemaLocation="../common/common-attribs.xsd"></xs:include>

<xs:attributeGroup name="mean.attlist">
  <xs:attributeGroup ref="Definition.attrib"/>
  <xs:attributeGroup ref="Common.attrib"/>
</xs:attributeGroup>


<xs:complexType name="mean.type">
  <xs:attributeGroup ref="mean.attlist"/>
</xs:complexType>

<xs:element name="mean" type="mean.type"/>

<xs:attributeGroup name="sdev.attlist">
  <xs:attributeGroup ref="Definition.attrib"/>
  <xs:attributeGroup ref="Common.attrib"/>
</xs:attributeGroup>

<xs:complexType name="sdev.type">

Open in new window

…

3 Comments

Question by

tmajor99

2018-11-14Solved

XLST Question

I am new to XLST and I have what I think is a pretty question. The XLST below is only selecting attributes with metadata xml tags. For exmaple; in the XML below there are two attributes Eco_228 & Eco_1717. Eco_1717 does not have metadata so the XLST skips it. Is there anyway to include this?

XML Before:
<Classification ID="webfolder2-2671" UserTypeID="FOL Folder" ParentID="webfolder2-2669">
<Name>End Boots</Name>
<AttributeLink AttributeID="Eco_228">
<MetaData>
<Value AttributeID="Endeca Refiner Type">Multi-Select</Value>
<Value AttributeID="Display Sequence">2</Value>
</MetaData>
</AttributeLink>
<AttributeLink AttributeID="Eco_1717"/> ---> This line gets dropped because it does not have <MetaData> tags..
</Classification>

After XLST:
AttributeID Text ClassificationID Classificatioin Name AttributeLinkID
Endeca Refiner Type Multi-Select webfolder2-2671 End Boots Eco_228
Display Sequence 2 webfolder2-2671 End Boots Eco_228

I would like the XLST to include all attributes so I would like to do this:

AttributeID Text ClassificationID Classificatioin Name AttributeLinkID
Endeca Refiner Type …

XML
XLST

1 Comment

Exploring SQL Server 2016: Fundamentals

LVL 12

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

On my PC this location contains a bunch of XML files

C:\SmartCompletion\Backend\IBS.Core\Resources

I'd like to limit my search to **just** the Resources folder.

There is a particular tag inside these XML files that I want to look at and verify that it does NOT contain a certain attribute:

<Layout mode="Complex" UsePurgeRestore="true" UseCopy="true"> //////////// this would not show up in the search results

UsePurgeRestore="true" or UsePurgeRestore="false" must NOT be an attribute in the <Layout> tag

So this would be a match for my search:

<Layout mode="Complex" UseCopy="true">

or this:

<Layout UseAssignment="true" mode="Complex" EditNewView="vAssetPacksLines">

Can Visual Studio do this using Regular Expressions?

I would need the RegEx. I'm too slow at it and I need this as fast as I can.

NOTE: I am open to freeware tools that can do this kind of exclusionary search of file contents. I have AgentRansack, for example. I also have Notepad++. Do either of those support RegEx searches?

Thank you!

3 Comments

Question by

James White

2018-11-12

Element is not declared in XML file

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>
…

24 Comments

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

…

1 Comment

I'm fairly novice with PHP, but I can usually figure things out. But I'm stuck on working around this legacy code that we use on our sales form.
I have to shoehorn in another Card processing merchant that does things a little differently with their API.

This is processing the response from a cURL API where I receive a SOAP XML response. I'm having some issues with the actual response as well, so I have it sampled in what appears to be a proper xml format, then attempting to parse out the message objects.

The process:
1. I have the response XML converting into a "SimpleXMLElement" with the simplexml_load_string
2. Then the XML is "converted to an array", I think, with the $array = (array)$xml;
3. Then, the code should be able to look into the array values and process a Success or Failed based on the Status Value
4. Then the $data is json encoded and is passed to the JavaScript file for further processing of the notification and filling in the Auth code field of the sales form.

The Problem(s):
1. You'll see in the PHP code that I have 2 testing sections to process the response. The first uses the $array and the second skips the array and just uses the $xml. One is commented out for testing the other, of course.
2. When using the $xml section to get the values, I get real close to what I need until it get json encoded, then the output just says Object Object in the JS Alert. It appears that the code is finding the proper value of the key, but it's not …

4 Comments

LVL 15

Question by

Fabrice Lambert

2018-11-09

MS Access ribbon

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

4 Comments

Question by

Bruj

2018-11-09

Auto request XML or JSON for a webpage

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

XML
JSON

3 Comments

XML

Related Topics

XML

Related Topics