Extracting data from XHTML with XSL - XML / XSL Discussion Boards

Re: C# .NET web services: Manipulating XML

Not Active24-Dec-08 3:43

24-Dec-08 3:43

What database are you using? If its SQL Server you can use the FORXML clause to format the resultset.

Also, why use .NET 1.1? It is very outdated, 2.0 is the minimum you should be working with.

only two letters away from being an asset

Problem with Installing Service from MSM in WIX

swamy Narasimha23-Dec-08 4:36

swamy Narasimha

23-Dec-08 4:36

Hi,

I have one Merge Module (MSM) created using WISE which I want to use it in WIX.

When I created MSI using WIX which contains the above MSM and RUN the MSI then the Service EXE and the related DLL's are copied to my system Folder but the service is not Installed and started in my system.

But when I do the same steps mentioned above with WISE ( Created MSI which contains MSM) then the service is Installed and Started in my system.

Is there anything extra I need to do it in WIX in order to Install and Start the Service?

Thanks,

Narasimha.

Dynamically Creating Tables based on XSD or XML

Dan Madden18-Dec-08 6:34

Dan Madden

18-Dec-08 6:34

Hi All,

I have to read in an xml or xsd document (XCCDF - The Extensible Configuration Checklist Description Format) and would like to create tables in the Database based on them (if they do not exist). I do NOT know what the Table names/Fields will be so I am looking to do it dynamically.

XCCDF is a specification language for writing security checklists, benchmarks, and related kinds of documents.

This is a view of the formt (xml):

<?xml version="1.0" encoding="utf-8"?>
<Benchmark id="MicrosoftSecurityComplianceManagementForWindows2008" resolved="0" xml:lang="en" xmlns="http://checklists.nist.gov/xccdf/1.1" xmlns:cdf="http://checklists.nist.gov/xccdf/1.1" xmlns:cpe="http://cpe.mitre.org/XMLSchema/cpe/1.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xsi:schemaLocation="http://checklists.nist.gov/xccdf/1.1 xccdf-1.1.xsd http://cpe.mitre.org/XMLSchema/cpe/1.0 cpe-1.0.xsd">
  <status date="2008-05-16">draft</status>
  <title>Microsoft Security Compliance Management for Windows Server 2008</title>
  <description>Microsoft Security Compliance Management for Windows Server 2008</description>
  <notice id="terms-of-use" xml:lang="en">
  </notice>
  <front-matter>
    <xhtml:p>
    </xhtml:p>
  </front-matter>
  <rear-matter>
  </rear-matter>
  <reference href="http://checklists.nist.gov/repository/1001.html">
    <dc:title>Microsoft Security Compliance Management for Windows Server 2008</dc:title>
    <dc:creator>Microsoft Solution Accelerator for Security and Compliance</dc:creator>
    <dc:publisher>
    </dc:publisher>
    <dc:identifier>
    </dc:identifier>
  </reference>
  ...
  ...

Full info on these files can be found here[^]

So, any ideas how to do this dynamically?

Regards,

Dan

Re: Dynamically Creating Tables based on XSD or XML

led mike18-Dec-08 9:23

led mike

18-Dec-08 9:23

Dan Madden wrote:
So, any ideas how to do this dynamically?

Could you be more specific. Your post seems to be asking for a complete solution rather than answers to specific questions. You have also not provided any development environment information.

led mike

HTML Transparent Background

Punitha_V17-Dec-08 14:16

Punitha_V

17-Dec-08 14:16

How can I set an transparent background using HTML. Give me a example of code for that....

Re: HTML Transparent Background

Brij18-Dec-08 1:10

Brij

18-Dec-08 1:10

you can set a transparent on bodytag as background.But first make a transparent image for it.

Cheers!!
Brij

XmlSchemaValidationException

mdv11316-Dec-08 5:35

mdv113

16-Dec-08 5:35

When catching an XmlSchemaValidationException, the debugger shows hidden members like ‘Res’ = ‘Sch_InvalidElementContentExpecting’ and string Args[] with the expected elements. I would like to access these hidden members so that I can create my own error message in my native language. Does anybody know how to retrieve this information? Code fragment: invoked after call to XmlDataDocument.Validate:
private void ValidationCallBack(Object sender, ValidationEventArgs args)
{
if (args.Exception.GetType() == typeof(XmlSchemaValidationException))
{

XmlSchemaValidationException ex = args.Exception as XmlSchemaValidationException;
textBoxValideer.Text += node.Name + " " + ex.Message + "\n";
}
else
{
textBoxValideer.Text += "\n?";
}
}
Cry | :((

M.A

Extracting data from XHTML with XSL

el_pablo12-Dec-08 8:07

el_pablo

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

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