Problem: How to sort a XML file into another XML File ? - XML / XSL Discussion Boards

led mike11-Dec-08 5:52

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

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

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

Javascript in xsl

Ashvish2-Dec-08 0:47

Ashvish

2-Dec-08 0:47

Hi All,

I would like to load a java script array dynamically inside xsl. Suppose I have the following xml

<srsource>
<individualsr>
<srid>srid1</srid>
<srothervalue>srothervalue1</srothervalue>
</individualsr>
<individualsr>
<srid>srid2</srid>
<srothervalue>srothervalue2</srothervalue>
</individualsr>
</srsource>

What I want to do is populate a javascript array during the xsl transformation so that I get an array like the one below when the html page is loaded.

test['srid1'] = 'srothervalue1'
test['srid2'] = 'srothervalue2' and so on..

Could anyone tell me how the above piece of code can be included inside xsl:for-each?

Thanks
Ashvish

Re: Javascript in xsl

led mike2-Dec-08 5:20

led mike

2-Dec-08 5:20

Ashvish wrote:
What I want to do is populate a javascript array during the xsl transformation so that I get an array like the one below when the html page is loaded.

Ashvish wrote:
Could anyone tell me how the above piece of code can be included inside xsl:for-each?

Not sure I understand your question. I mean whatever you put inside the xsl:for-each is output into the result so like:

<xsl:for-each select="*/individualsr">
  test['<xsl:value-of select="./srid"/>'] = '<xsl:value-of select="./srothervalue"/>';
</xsl:for-each>

led mike

Re: Javascript in xsl

Ashvish3-Dec-08 19:36

Ashvish

3-Dec-08 19:36

Thanks for the reply. What I am really trying to do is something like
<xsl:variable name="user" select="Login/UserInfo/UserName"/>
<SCRIPT language="JavaScript">
<![CDATA[
...
rowA = new Object()
rowA.data1 = ']]><xsl:value-of select="$user" /><![CDATA['
rowA.data2 = 'needs'
rowA.data3 = 'help'
myTable.append_row(rowA)
...
]]>
</SCRIPT>

This works in Mozilla but not in IE. What could be the reason?

Re: Javascript in xsl

led mike4-Dec-08 5:24

led mike

4-Dec-08 5:24

I don't know if you post got messed up or what but it doesn't make any sense.

led mike

Would this allow Employee and Member both?

paresh_joe1-Dec-08 22:27

paresh_joe

1-Dec-08 22:27

<xs:element name="person" xmlns:xs="#unknown">
<xs:complextype>
<xs:sequence>
<xs:choice maxoccurs="unbounded">
<xs:element name="employee" type="employee">
<xs:element name="member" type="member">

Re: Would this allow Employee and Member both?

led mike2-Dec-08 4:35

led mike

2-Dec-08 4:35

Hey Joe, your post is empty. You probably need to read the posting instructions for posting code. They are located on the page you use to post your source code. Also make sure your question, problem, requirements, goal, is clear if you desire a helpful answer.

led mike

Problem with xml data

snehasish29-Nov-08 0:29

snehasish

29-Nov-08 0:29

hi all,
i have got an xml of huge no. of data. http://www.propertyworld.com/xml/PW_XMLfeed_15224.xml[^].i have to keep option(some textbox) for user that they will search property by country ,region ,bedroom ,bathroom ,price.And outcomes data will be show in a datalist.I need a solution which gives a faster searching.

How can i solve this?
Waiting for reply.

Snehasish

Re: Problem with xml data

led mike1-Dec-08 5:07

led mike

1-Dec-08 5:07

snehasish wrote:
i have got an xml of huge no. of data.

How huge? Are you not able to provide us with specific information?

snehasish wrote:
I need a solution which gives a faster searching.

Databases Engines are designed for fast searching of large amounts of data. XML and related technologies are NOT, and are therefore not a replacement for Database Engines.

led mike

Re: Problem with xml data

snehasish1-Dec-08 21:42

snehasish

1-Dec-08 21:42

hi sir,
I have another xml which have 7000 properties.Underneath which have child and sub child element.I think datareader or something like this will not be helpful for searching.If you have any specific answer to solve my problem please reply me.

wating for reply.
snehasish.

Re: Problem with xml data

Steve Westbrook1-Dec-08 5:43

Steve Westbrook

1-Dec-08 5:43

I second led mike. You'll get orders of magnitude better performance out of SQL Express. If you're irreversibly committed to XML, use an XML Reader, but you're just not going to get great performance out of it. Scalability is another issue - assuming you've got XML files, you'll constantly be getting conflicts as two users try to open the same file.

Since you're already using XML, I suggest looking into SQL server support for it (i.e. the XML data type). I've never used it in any serious way, but you can at least take a whack at getting the best of both worlds.

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