image compression project - XML / XSL Discussion Boards

Chetan Ranpariya2-Jan-06 17:43

2-Jan-06 17:43

Hi Friends,
In my application I am using XML as database and my application is web based applicaton.
I want the user to be able to export data in xml file to a excel sheet.
I tried with various codes and samples but no one worked.
If any one have some thing ragarding this problem plz let me know.

Thank u all in advance.

Chetan Ranpariya.

Grouping XML Elements using XSLT

gandhiaryah28-Dec-05 19:57

gandhiaryah

28-Dec-05 19:57

I have the following XML
-----------------------------------
<fname>aaaaa</fname>
<surname>xxxx</surname>
<fname>bbbbb</fname>
<surname>yyyyy</surname>
<fname>ccccc</fname>
<surname>zzzzz</surname>
-----------------------------------
I want the following output
-----------------------------------
<authorgrp>
<author>
<fname>aaaaa</fname>
<surname>xxxx</surname>
</author>
<author>
<fname>bbbbb</fname>
<surname>yyyyy</surname>
</author>
<author>
<fname>bbbbb</fname>
<surname>yyyyy</surname>
</author>
</authorgrp>
------------------------------
Anyone can help??????????????????
-- modified at 1:59 Thursday 29th December, 2005

Re: Grouping XML Elements using XSLT

Michael Flanakin29-Dec-05 3:54

Michael Flanakin

29-Dec-05 3:54

Try this...

<xsl:template match="/">
    <authorgrp>
    <xsl:for-each select="fname">
        <author>
            <fname><xsl:value-of select="."/></fname>
            <surname><xsl:value-of select="../surname[position()]"/></surname>
        </author>
    </xsl:for-each>
    </authorgrp>
</xsl:template>

I haven't tested it, but it should get you close.

Michael Flanakin
Web Log

-- modified at 9:55 Thursday 29th December, 2005

storing xml file in sql using asp

suneelbabu_net27-Dec-05 16:03

suneelbabu_net

27-Dec-05 16:03

I want to store an xml file in sqlserver using asp
xml file should be used as an input paramenter for a stored procedure

suneel

how to create instance after passing class type to function

Michael Lev26-Dec-05 9:33

Michael Lev

26-Dec-05 9:33

I want function in one namespace to create instance of class defined in
another namespace.
(more detailed - I try to make independent "Seralizer" dll, to be used
by different application, each calling it from its own class which
defines the application configuration)
I failed to make it work.
Notify that in the Seralizer source I dont know the definition of the
class I get.
Foe example, how do I make lines like below working?
public void Deserialize(Type cfgType)
{
myType obj = Activator.CreateInstance(cfgType);
XmlSerializer serializer = new XmlSerializer( cfgType);
FileStream stream = new FileStream("some file...", FileMode.Open,
FileAccess.Read);
cfgType configuration = (cfgType)serializer.Deserialize(stream);
}
thanks

Michael Lev (mlev)

MSXML 0xC00000FD stack overflow

agent_hunt26-Dec-05 1:06

agent_hunt

26-Dec-05 1:06

hello
I am making DOm msxml parser .
My current compiler in visual C++ 6
but it crashes while loading xml file in loadxml() method.

if any one know how to overcome this error kindly help me ?:->

mast

How to Get the Value when we specify the name ..

zxc8925-Dec-05 19:35

zxc89

25-Dec-05 19:35

How can i get the value in an xml file when i specify the name in the xml file..Please provide me the code to do this in C#.NET..

Thanks..

image compression project

Femi Buroh25-Dec-05 10:17

Femi Buroh

25-Dec-05 10:17

I'm studying computer science and I'm in 400 level. I have a project to be submitted in 3month time and I should get the review and some of the designs ready for January. My project is to design a Software Like you cvtmovie but this time around it would convert any movie compres it and probably keep it in an archive untill its demanded for. This should aid the applications of large video user to be able to keep voluminuous video. I can cope with any prog language if i understand the problem being defined. I need to start from somewhere but I dont know how.

God Bless

extracting data from xml and loading into dataset

wpcolleen20-Dec-05 1:31

wpcolleen

20-Dec-05 1:31

I have an xml file which contains schedules for all employees. How do I extract data from this file for a specific employee? Below is a snippet of the code, but this loads all employees.

DataSet allSchedulesDs = new DataSet();

// get schedules
allSchedulesDs.ReadXml(myFilepath + "AllSchedules.xml");

scheduleCount = allSchedulesDs.Tables["ALLSCHEDULES"].Rows.Count - 1;

for (int j = 0; j <= scheduleCount; j++)
{
// check all xml file for badge number input
if ((string)allSchedulesDs.Tables["ALLSCHEDULES"].Rows[j][0] == textBoxBadgeId.Text.PadLeft(5, '0'))
// record found set up for display
{
// this gets all schedules need to limit display to just this badge number
scheduleList.DataSource = allSchedulesDs.Tables["ALLSCHEDULES"].DefaultView;
scheduleList.DataBind();
}
}

Easy JPG question!

SpeBeeTo19-Dec-05 9:38

SpeBeeTo

19-Dec-05 9:38

Hi everyone,

I first would like to warn you that I'm a newbie programmer. So if I have left out important code for you guys to determine what I'm doing wrong, let me know. Smile | :)

I am making a PocketPC application using C# and an XML file as a database. I would like to display the corresponding JPG image in a PictureBox, or somewhere on the main page.

A sample of my xml file. The bolded line is the picture reference.

<fragenkatalog><br />
<ca_id>4</ca_id><br />
<ca_titel>head ap</ca_titel><br />
<ca_bildurl1>kopf_ap.jpg</ca_bildurl1><br />
<ca_disabled>0</ca_disabled><br />
<ca_alter>999</ca_alter><br />
<ca_sex>n</ca_sex><br />
</fragenkatalog>

This is what I have, which doesn't work.

	//Bind image to picturebox<br />
<br />
	ca_bildurl.DataBindings.Add("Image",dt,"ca_bildurl1");

The ID is chosen from a ListBox, and the corresponding data is displayed on the screen.

Any help would be appreciated! Thanks!

M.

-- modified at 21:09 Friday 30th December, 2005

Re: Easy JPG question!

Michael Flanakin29-Dec-05 3:58

Michael Flanakin

29-Dec-05 3:58

Please repost your XML with < and > instead of the < and > symbols.

Michael Flanakin
Web Log

Re: Easy JPG question!

SpeBeeTo30-Dec-05 15:08

SpeBeeTo

30-Dec-05 15:08

Ok, it's changed. Smile | :)

Sorry about that.

Trouble using sql:relation/sql:relationship in xsd file ...

cmacgowan19-Dec-05 9:17

cmacgowan

19-Dec-05 9:17

Trouble using sql:relation/sql:relationship in xsd file ...

Hi ...

I am attempting to use the sql:relation annotation and am having some troubles. I have used it successfull with the MS Sample (Customer / Order) where all the data is contained in elements (example below).

<code><ROOT>
<Customers>
<CustomerID>1111</CustomerID>
<SynchID>700</SynchID>
<CompanyName>Sean Chai</CompanyName>
<City>NY</City>
<Order OrderID="1" />
<Order OrderID="2" />
</Customers>
</ROOT>

In the xml that I am having trouble with the data is contained in attributes. In the code below I get the following
error when executing the bulk insert.

Any comments ?
Thanks !!
Chris

//////////////////////////////////////////////////////////////////////////
// error message
<?xml version="1.0"?><Result State="FAILED"><Error><HResult>0x80004005</HResult><Description><![CDATA[Schema: the parent/child table of the relationship on 'surface' does not match.]]></Description><Source>Schema mapping</Source><Type>FATAL</Type></Error></Result>

//////////////////////////////////////////////////////////////////////////
// xsd file
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">

<xsd:annotation>
<xsd:appinfo>
<sql:relationship name="MacgowanTest_Atmospheric_Surface"
parent="MacgowanTestRWISRawAtmospheric"
parent-key="SystemId RpuId"
child="MacgowanTestRWISRawSurface"
child-key="SystemId RpuId" />
</xsd:appinfo>
</xsd:annotation>

<xsd:element name="site" sql:relation="MacgowanTestRWISRawAtmospheric" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="sensors" sql:relation="MacgowanTestRWISRawSurface"
sql:relationship="MacgowanTest_Atmospheric_Surface">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="surface" sql:relation="MacgowanTestRWISRawSurface"
sql:relationship="MacgowanTest_Atmospheric_Surface" >
<xsd:complexType>
<xsd:attribute name="id" type="xsd:string" sql:field="SensorId"/>
<xsd:attribute name="datetime" type="xsd:date" sql:field="ObsDateTime" />
<xsd:attribute name="surfacecondition" type="xsd:string" sql:field="SurfaceCondition"/>
<xsd:attribute name="surfacetemp" type="xsd:string" sql:field="SurfaceTemperature"/>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>

<xsd:attribute name="sysid" type="xsd:string" sql:field="SystemId"/>
<xsd:attribute name="rpuid" type="xsd:string" sql:field="RpuId"/>
</xsd:complexType>
</xsd:element>
</xsd:schema>

//////////////////////////////////////////////////////////////////////////
// xml data file
<?xml version="1.0"?>
<odot_rwis_site_info>
<site id="200000" number="1" sysid="200" rpuid="0" name="1-SR127 @ SR249" longitude="-84.554946" latitude="41.383527">
<atmospheric datetime="12/05/2005 03:48:00 PM" airtemp="-490" dewpoint="-800" relativehumidity="73" windspeedavg="11" windspeedgust="19" winddirectionavg="265" winddirectiongust="295" pressure="65535" precipitationintensity="None" precipitationtype="None" precipitationrate="0" precipitationaccumulation="-1" visibility="2000" />
<sensors>
<surface id="0" datetime="12/05/2005 03:48:00 PM" name="North Bound Driving Lane" surfacecondition="Dry" surfacetemp="1900" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="450" waterlevel="0">
<traffic datetime="12/05/2005 03:48:00 PM" occupancy="0" avgspeed="82" volume="21" sftemp="1900" sfstate="255">
<normalbins>
<bin datetime="12/05/2005 03:48:00 PM" binnumber="0" bincount="7" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="1" bincount="0" />
</normalbins>
<longbins>
<bin datetime="12/05/2005 03:48:00 PM" binnumber="2" bincount="0" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="3" bincount="0" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="4" bincount="1" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="5" bincount="0" />
</longbins>
</traffic>
</surface>
<surface id="1" datetime="12/05/2005 03:48:00 PM" name="Bridge Deck Simulator" surfacecondition="Other" surfacetemp="-60" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="-999999" waterlevel="0" />
</sensors>
</site>
<site id="200001" number="2" sysid="200" rpuid="1" name="2-Hardin County Garage" longitude="-83.6148588" latitude="40.6305358">
<atmospheric datetime="12/05/2005 03:49:00 PM" airtemp="-590" dewpoint="-900" relativehumidity="75" windspeedavg="9" windspeedgust="22" winddirectionavg="303" winddirectiongust="299" pressure="65535" precipitationintensity="None" precipitationtype="None" precipitationrate="0" precipitationaccumulation="-1" visibility="2000" />
<sensors>
<surface id="0" datetime="12/05/2005 03:49:00 PM" name="Bridge Deck Simulator" surfacecondition="Other" surfacetemp="-410" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="300" waterlevel="0" />
</sensors>
</site>
</odot_rwis_site_info></code>

XPath expression

Andy H14-Dec-05 22:37

Andy H

14-Dec-05 22:37

I am not too hot on XML etc, and would appreciate a little help.

I have a large XML document and would like to know if it is possible to find a node within the document that has a specific value, (not attribute), with the .SelectNode( ... ) function? All that I have read so far leads me to believe that I will have to loop through the document searching for a node with a specific value rather than being able to home in on it with a clever XPath expression!

Re: XPath expression

Stuart Dootson15-Dec-05 7:26

Stuart Dootson

15-Dec-05 7:26

If you have

<doc>
<node>1</node>
<node>2</node>
</doc>

then the XPath expression node[text()='1'] should select the node with text contents of '1' (i.e. the first node in that document)

Stuart Dootson

'Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p'

Re: XPath expression

Michael Flanakin3-Jan-06 3:09

Michael Flanakin

3-Jan-06 3:09

That's not completely true. You'll have to already be in the doc element, for that to work. If you're not already traversing thru the XML, you'll need to specify the absolute path to a property you want. You can do this by typing /doc/node. That will give you the value within the node element. If you have attributes, they need to be preceded with the at (@) symbol.

http://www.w3schools.com/xpath/default.asp[^]

Michael Flanakin
Web Log

Tool for creating xml from database table?

pankazmittal14-Dec-05 11:35

pankazmittal

14-Dec-05 11:35

Hi
I have lot of config data in a table which I want to put in .config file.

Is there any tool using which I can save the data into customized xml file?

Please advice. Thanks

Pankaj

Re: Tool for creating xml from database table?

mysorian9-Jan-06 3:14

mysorian

9-Jan-06 3:14

May be you should place your data in a table and use the forXML T-SQl extension.
This can be done on MS SQL and SQL Anywhere.
The other option is to put it ina Access tbale and export in XML format.

Elements vs Attributes

monrobot1313-Dec-05 10:17

monrobot13

13-Dec-05 10:17

I'm fairly new to XML and I'm just wondering if there is any difference between using elements or attributes to store data in an XML file. From a programatic view is is better to use one or the other for having to read in the file and such? Are there any performance differences? Is one more flexible than the other?

Any information on the topic is very appreciated.

- Aaron

Re: Elements vs Attributes

Sushant_Mathur13-Dec-05 21:16

Sushant_Mathur

13-Dec-05 21:16

There are no rules about when to use attributes, and when to use child elements. My experience is that attributes are handy in HTML, but in XML you should try to avoid them. Use child elements if the information feels like data.
Some of the problems with using attributes are:

.attributes cannot contain multiple values (child elements can)
.attributes are not easily expandable (for future changes)
.attributes cannot describe structures (child elements can)
.attributes are more difficult to manipulate by program code
.attribute values are not easy to test against a Document Type
.If you use attributes as containers for data, you end up with documents that are difficult to read and maintain.

Try to use elements to describe data. Use attributes only to provide information that is not relevant to the data.

Sushant Mathur
Ocwen Financial Sol. Pvt. Ltd,
Bangalore,
INDIA.

-- modified at 3:17 Wednesday 14th December, 2005

Re: Elements vs Attributes

Shem Su6-Jan-06 0:44

Shem Su

6-Jan-06 0:44

i fairly agree with you, i'm newbie too,and i'm always baffled by configuration of document.

How To Load & Validat XML file with XSD file using XML .Net Parser

zxc8913-Dec-05 0:37

zxc89

13-Dec-05 0:37

Hi..
I am new to XML.NET Parser...So can anyone help me in providing some good links for XML .NET Parser so that i can load an xml file and validate it with xsd file in VC++..

Kindly provide the links or any advices regarding this..Plz don't tell me to search in Google..I had searched alot..So whoever familiar with XML .NET Parser,plz help me..

Thanks..

Re: How To Load &amp; Validat XML file with XSD file using XML .Net Parser

DavidNohejl20-Dec-05 1:52

DavidNohejl

20-Dec-05 1:52

Do you mean this[^] one?

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

Re: How To Load &amp;amp; Validat XML file with XSD file using XML .Net Parser

zxc8920-Dec-05 1:58

zxc89

20-Dec-05 1:58

Not that...

String vs. XML file

sonicsqwirl11-Dec-05 21:27

sonicsqwirl

11-Dec-05 21:27

I have a project, in which we need to read in an XML file. But, when we read in that file, we need to parse it so that only designated data is used. So we parsed it into a string. We now are running into the difficulty of passing the String into the XSLT.

Is there a way to convert a String with XSLT, or do we need to rewrite the XML file?

TIA,
Scott

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