XML / XSL Discussion Boards

el_pablo12-Dec-08 8:07

12-Dec-08 8:07

Hi,

I'm trying to figure out how to extract data from an ASP.NET generated table.

Here's an excerpt of the HTML:

<body>
...
<table cellspacing="1" cellpadding="3" border="0" id="ctl00_ContentPlaceHolderDroit_GridView1" style="border-width:0px;width:690px;">
...
<tr class="txt_general" style="background-color:#F4F4F4;"> // <--- Row that contains the data that is repeated
<td style="width:70px;" rowspan="1" colspan="1">
<img src="../Photo.ashx?id=1576120" style="height:58px;width:70px;border-width:0px;" /> // <-- I want to extract the photo ID
</td>
<td rowspan="1" colspan="1">
<span id="ctl00_ContentPlaceHolderDroit_GridView1_ctl02_lblPrice">87 000$</span> // I want to extract the price. The ID increments ct103_lblPrice would be the next row.
<br clear="none" />
</td>
</tr>
...
</table>
</body>

Can someone help me with this problem?

developing new applications

Matt Cushing12-Dec-08 2:35

Matt Cushing

12-Dec-08 2:35

We are in the process of centralizing everything - data, apps, 3rd party imports, SSIS jobs, etc. Most of the home grown apps are going to need to be completely overhauled, and the 3rd party stuff and SSIS jobs can all use XML.

If you were going to use a development platform going forward to get things off the ground and you were starting from scratch, what would you use? We currently write everything in C# and rely heavily on AD for application permissions and access.

Any suggestions would be welcome. I was thinking that since we're moving to a bigger focus on BI and possibly moving to Sharepoint for a lot of our internal work, that Flex, Adobe Air, Laszlo Systems or some other XML RIS technology might be a good way to look.

All of this is internal, don't have to worry about being public.

Thanks! Big Grin | :-D

Re: developing new applications

Christian Graus12-Dec-08 19:49

Christian Graus

12-Dec-08 19:49

This sounds frighteningly like someone just heard of XML for the first time and decided to use it everywhere.

Use visual studio to write your C# apps. XML, you can edit in any text editor.

Christian Graus

Driven to the arms of OSX by Vista.

Re: developing new applications

Matt Cushing13-Dec-08 15:40

Matt Cushing

13-Dec-08 15:40

Nope, it's someone who is trying to figure out where we should be in several years and trying to set the ground work now. We have a bunch of C# apps, a bunch of SSRS reports, and a LOT of sql data that needs to be manhandled into some state to allow our users to analyze it.

I figured since a lot of things can be translated somehow into XML so that would be a good medium.

Honestly, I'm in way over my head, and I'm looking for some direction.

Re: developing new applications

evden eve nakliyat20-Dec-08 15:12

evden eve nakliyat

20-Dec-08 15:12

Thanks for all evden eve nakliyat
evden eve nakliyat
evden eve nakliyat please go on

I'm New To XML

khande200811-Dec-08 16:05

khande2008

11-Dec-08 16:05

I need to create an XML document with these Laugh | :laugh:

values, then convert the xml to a xml schema.. How can i do this?

Ticket Number: IR123456

Application: about 15 applications we support ex. Solspark, NSS and so on

Date and Time:

Duration: 15 min 60 min or more

Missed SLA?: Yes/No

Repeat Problem: Yes/No

Impacted Program/Job: text

Customers Impacted: text

Incident Description: text

Root Cause: text

Resolution: text

Re: I'm New To XML

Christian Graus12-Dec-08 19:50

Christian Graus

12-Dec-08 19:50

Well, sounds like you need to read some very basic articles. Creating XML from this is trivial, it's just a case of deciding on a format ( use nodes or attributes, etc ). If you don't know how to do that, then you really shouldn't be messing with any XML until you do.

You can't really create a 100% accurate schema from one XML, you're better off creating it by hand.

Christian Graus

Driven to the arms of OSX by Vista.

web service - post xml data

dotnetlover_1111-Dec-08 7:01

dotnetlover_11

11-Dec-08 7:01

I need to utilize a web service to send XML data. I have the XML file as a SOAP format and have converted to a string. I just need to be able to send this via the web service - sync or async - and check the response is ok. Can someone please guide me through this?

Re: webservice - post XML data

led mike11-Dec-08 7:52

led mike

11-Dec-08 7:52

shalu madan wrote:
I have this task in hand to utilize a web service to send XML data. I have the XML file as a SOAP format and have converted to a string. I just need to be able to send this via the web service - sync or async - and check the response is ok.

The technology you are intending to use for connecting and communicating to the Web Service has nothing to do with XML/XSL. You should find more relevant forum to ask your question. Also don't forget to actually ask a question, as you did not here. Also, it sound more like you should be looking for an example, sample or tutorial using the specific tools you intend on using. Perhaps you should do that rather than post another non-question in a forum.

led mike

XML Explanation

Vimalsoft(Pty) Ltd11-Dec-08 2:04

Vimalsoft(Pty) Ltd

11-Dec-08 2:04

Good Afternoon Guys , i have never attempted to save Data to the Database from the XML FILE, i have the Following

// pass an object to this function
// the attribute of the object tells the function which stored proc to call
// the object itself is serialized to an xml string and passed to the database
// the stored proc on the other side takes care of the behind the scenes details
public static string SaveObjectToDB(object obj)
{
    string sql = "", xml = "", result = "";
    // populate the object from the database using the specified ID
    // loop through the attributes of the object/class
    // Look up the stored procedure attribute on the object to use the appropriate stored proc to save the object
    foreach (Attribute attr in obj.GetType().GetCustomAttributes(true))
    {
        DBStoredProcAttribute dbSPAttr = attr as DBStoredProcAttribute;
        // check if the attribute is a DBStoredProcAttribute
        if (dbSPAttr != null)
        {
            // serialize the object to xml
            xml = SerializeObjectToXML(obj);
            // trim of the xml headers
            // Subject Structures can be longer than 8000 characters so must trim off the prefix in .Net for SubjectStructure objects
            xml = xml.Replace("\\r\\n", "").Replace("\r\n", "").Replace("<?xml version=\"1.0\" encoding=\"utf-16\"?>", "");
            int StartPos=0;
            StartPos = xml.IndexOf("<SubjectStructure>");
            if (StartPos > 0)
            {
                xml = xml.Substring(StartPos);
            }
            // run the sp for this type of object passing the xml for the object
            sql = dbSPAttr.SaveObjectSP + "'" + xml.Trim() + "'";       // stored proc for SaveObject ;

            // execute the stored proc
            result = ExecuteStoredProc(sql);
        }
    }

    return result;
}

Can you please help Explain this Function code.If i can Directly save the data to the Database, why should i put it to XML First then SQL

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: XML Explanation

led mike11-Dec-08 5:52

led mike

11-Dec-08 5:52

I don't understand. Are you asking what the code does? It sounds like you are asking why the person did it this way, there is no way we can know that.

led mike

Re: XML Explanation

Vimalsoft(Pty) Ltd11-Dec-08 18:56

Vimalsoft(Pty) Ltd

11-Dec-08 18:56

hi Led

I meant , Am new to XML, i wanted to Know what are these Functions do like

Attribute attr in obj.GetType().GetCustomAttributes(true))

xml.Replace("\\r\\n", "").Replace("\r\n", "").Replace("<?xml version=\"1.0\" encoding=\"utf-16\"?>", "");

StartPos = xml.IndexOf("<SubjectStructure>");

sql = dbSPAttr.SaveObjectSP + "'" + xml.Trim() + "'";		// stored proc for SaveObject ;

Am reading a book, to famirialize myself with XML

Thank you

xsd restriction

User 5838528-Dec-08 15:44

User 583852

8-Dec-08 15:44

In my xsd file I have a bool element. I want to set a restriction so that it can only be set to true if a previous element is present and has a particular value.

Something like this

<xs:simpleType name="someEnum">
  <xs:restriction base="xs:string">
    <xs:enumeration value="Value1" />
    <xs:enumeration value="Value2" />
  </xs:restriction>
</xs:simpleType>

...

<xs:element name="Field1" type="someEnum" minOccurs="0" maxOccurs="1" />
<xs:element name="Field2" type="xs:boolean" minOccurs="0" maxOccurs="1" />

I want to change it so that Field2 can only be true if Field1 is Value2 from the enum

Need help..

raveen8-Dec-08 7:28

raveen

8-Dec-08 7:28

How to valitate Xml test suites? is there any tool for valitate them?

Re: Need help..

led mike8-Dec-08 7:40

led mike

8-Dec-08 7:40

raveen wrote:
How to valitate Xml test suites?

If you can't be bothered to provide specific relevant information why should we bother to help you?

led mike

Showing Image

amit sahu207-Dec-08 19:58

amit sahu20

7-Dec-08 19:58

How i show image

Re: Showing Image

Christian Graus11-Dec-08 14:46

Christian Graus

11-Dec-08 14:46

XML is a text format, so there's no images to show.

Christian Graus

Driven to the arms of OSX by Vista.

Problem: How to sort a XML file into another XML File ?

zouzoulikou4-Dec-08 7:03

zouzoulikou

4-Dec-08 7:03

Hello.
I've a problem to sort a XML file into another xml file.

Here's the content of my XML File:

File: Drive.xml

<code>

<drive name="C" type="Local Disk" filesystem="NTFS" capacitygb="232" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<folder name="Depends" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Depends" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<file name="Profile.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Depends/Profile.xml" type="File" typefile="XML" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="Identity.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Depends/Identity.xml" type="File" typefile="XML" sizebytes="1284" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
</folder>
<file name="Meteo.pdf" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Meteo.pdf" type="File" typefile="PDF" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="Documents and Settings" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Documents and Settings" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="etc" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/etc" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="Program Files" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Program Files" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<file name="Identity.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Program Files/Identity.xml" type="File" typefile="XML" sizebytes="1284" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
</folder>
<folder name="Zouzou" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<file name="Profile.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou/Profile.xml" type="File" typefile="XML" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="Identity.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou/Identity.xml" type="File" typefile="XML" sizebytes="1284" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="Report.doc" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou/Report.doc" type="File" typefile="DOC" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
</folder>
<folder name="Windows" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Windows" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="LastCoroner.avi" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/LastCoroner.avi" type="File" typefile="AVI" sizebytes="1231254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="Inetpub" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Inetpub" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
</drive>
</code>

I want to sort it to have the following file : SortedDrive.xml which is sort first by the <file> and after by the <folder>

<code>

<drive name="C" type="Local Disk" filesystem="NTFS" capacitygb="232" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<file name="LastCoroner.avi" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/LastCoroner.avi" type="File" typefile="AVI" sizebytes="1231254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="Meteo.pdf" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Meteo.pdf" type="File" typefile="PDF" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="Depends" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Depends" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<file name="Profile.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Depends/Profile.xml" type="File" typefile="XML" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="Identity.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Depends/Identity.xml" type="File" typefile="XML" sizebytes="1284" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
</folder>
<folder name="Documents and Settings" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Documents and Settings" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="etc" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/etc" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="Inetpub" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Inetpub" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="Program Files" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Program Files" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<file name="Identity.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Program Files/Identity.xml" type="File" typefile="XML" sizebytes="1284" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
</folder>
<folder name="Windows" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Windows" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<folder name="Zouzou" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou" type="Folder" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}">
<file name="Profile.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou/Profile.xml" type="File" typefile="XML" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="Identity.xml" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou/Identity.xml" type="File" typefile="XML" sizebytes="1284" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
<file name="Report.doc" key="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}/Zouzou/Report.doc" type="File" typefile="DOC" sizebytes="1254" description="" repositoryid="{A9545674-FD69-4AFE-ACEC-D53767EC22B8}" />
</folder>
</drive>
</code>

How can I do that ?

Thank you very much

Re: Problem: How to sort a XML file into another XML File ?

led mike4-Dec-08 7:37

led mike

4-Dec-08 7:37

Dude you can't even follow the instructions on this site for posting code. What are the odds that you can accomplish the far more complicated task of developing a software solution?

led mike

Re: Problem: How to sort a XML file into another XML File ?

TJS4u4-Dec-08 23:05

TJS4u

4-Dec-08 23:05

whr is the file xml

[Message Deleted]

zouzoulikou4-Dec-08 6:49

zouzoulikou

4-Dec-08 6:49

[Message Deleted]

Re: How to sort a XML file into another XML File

zouzoulikou4-Dec-08 6:53

zouzoulikou

4-Dec-08 6:53

Sorry, here's the input file

XSD Conditional Elements

Skippums3-Dec-08 7:24

Skippums

3-Dec-08 7:24

I am attempting to make a schema where the valid options for a given enumeration are based on the content of another tag. Right now, I am attempting the following: I have an element with name="source", which can contain one of the following enumerated values {"src1", "src2"}. Now, what I want to do is to have another element with name="dependent", such that if tag "source" is set to "src1", the user has options {"opt1", "opt2"} for the "dependent" tag. If tag "source" is set to "src2", I would like the user to be able to set the "dependent" tag to one of {"opt3", "opt4"}. I am presently attempting the following:

<xs:choice>
  <xs:sequence>
    <xs:element name="source">
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:enumeration value="src1"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:element>
    <xs:element name="dependent">
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:enumeration value="opt1"/>
          <xs:enumeration value="opt2"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:element>
  </xs:sequence>
  <xs:sequence>
    <xs:element name="source">
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:enumeration value="src2"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:element>
    <xs:element name="dependent">
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:enumeration value="opt3"/>
          <xs:enumeration value="opt4"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:element>
  </xs:sequence>
</xs:choice>

However, I am getting the error, "Elements with the same name and in the same scope must have the same type." Is there a way to accomplish what I am trying to do without forcing the tags in either option to have unique names? Thanks,

Sounds like somebody's got a case of the Mondays

-Jeff

I want to use search of a website through my application

IrfanHaleem2-Dec-08 7:15

IrfanHaleem

2-Dec-08 7:15

I have a list of employees in excel file and I want to use a Search of a website for all the employees one by one.

I want to do this through my application. My quertion is how can I access that website through my application. And how to use the Search of a website with my own searching criteria.

please reply as soon as possible

Cross Post

led mike3-Dec-08 8:00

led mike

3-Dec-08 8:00

Don't cross post

led mike

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.