|
Hello,
I have written a XSL which is to read the data from a DTO and write to a .CSV file with the following format. I am not able to create semi-colon values and also the padding format written is not being reflected in the output file. Can anyone help in incorporating these formats. I am attaching my XSL here for the reference. Thanks for the same.
-The file created is an excel file. The extension is “.CSV”.
-The data are separated by the character semi-colon “;”.
-Every data row end up with an end of row character and a carriage return character (CR/LF).
-The end of the file is marked by an empty record row. In other words, the last row only contain semi-colon characters and all the fields are empty.
If the data length is inferior to the data maximum size, a padding is done as following:
- the numeric data are filled with “0” (zero) on the left (for example 003)
- the alphanumeric data are filled with empty spaces “ “
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:dft="http://MyProj.Dto.CustomerSpecificExport/">
<xsl:output method="text" indent="yes" />
<xsl:template match="/dft:ArrayOfExportDataDto">
<xsl:apply-templates select="dft:ExportDataDto"/>
</xsl:template>
<xsl:template match="dft:ExportDataDto">
- <xsl:call-template name="pad-right">
<xsl:with-param name="str" select="AgencyName" />
<xsl:with-param name="len" select="20" />
</xsl:call-template>
- <xsl:call-template name="pad-right">
<xsl:with-param name="str" select="CandidateName" />
<xsl:with-param name="len" select="20" />
</xsl:call-template>
- <xsl:call-template name="pad-right">
<xsl:with-param name="str" select="CandidateSurname" />
<xsl:with-param name="len" select="10" />
</xsl:call-template>
- <xsl:call-template name="pad-right">
<xsl:with-param name="str" select="BeginDate" />
<xsl:with-param name="len" select="10" />
<xsl:with-param name="pad" select="0" />
</xsl:call-template>
- <xsl:call-template name="pad-right">
<xsl:with-param name="str" select="InitialMissionEndDate" />
<xsl:with-param name="len" select="10" />
<xsl:with-param name="pad" select="0" />
</xsl:call-template>
- <xsl:call-template name="pad-left">
<xsl:with-param name="str" select="AmendmentDate" />
<xsl:with-param name="len" select="10" />
<xsl:with-param name="pad" select="0" />
</xsl:call-template>
- <xsl:call-template name="pad-left">
<xsl:with-param name="str" select="LastAmendmentDate" />
<xsl:with-param name="len" select="10" />
<xsl:with-param name="pad" select="0" />
</xsl:call-template>
- <xsl:call-template name="pad-left">
<xsl:with-param name="str" select="ResortCaseCode" />
<xsl:with-param name="len" select="3" />
<xsl:with-param name="pad" select="0" />
</xsl:call-template>
- <xsl:call-template name="pad-left">
<xsl:with-param name="str" select="MaxEndDateofContract" />
<xsl:with-param name="len" select="10" />
<xsl:with-param name="pad" select="0" />
</xsl:call-template>
- <xsl:call-template name="pad-left">
<xsl:with-param name="str" select="MinEndDateofContract" />
<xsl:with-param name="len" select="10" />
<xsl:with-param name="pad" select="0" />
</xsl:call-template>
- <xsl:call-template name="pad-right">
<xsl:with-param name="str" select="ModifVal" />
<xsl:with-param name="len" select="2" />
</xsl:call-template>
<xsl:text></xsl:text>
</xsl:template>
<xsl:template name="pad-left">
<xsl:param name="str"/>
<xsl:param name="len"/>
<xsl:param name="pad" select="' '"/>
<xsl:choose>
<xsl:when test="string-length($str) > $len">
<xsl:value-of select="substring($str, 1, $len)"/>
</xsl:when>
<xsl:when test="string-length($str) < $len">
<xsl:call-template name="pad-left">
<xsl:with-param name="str" select="concat($pad, $str)"/>
<xsl:with-param name="len" select="$len"/>
<xsl:with-param name="pad" select="$pad"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$str"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template name="pad-right">
<xsl:param name="str"/>
<xsl:param name="len"/>
<xsl:param name="pad" select="' '"/>
<xsl:choose>
<xsl:when test="string-length($str) > $len">
<xsl:value-of select="substring($str, 1, $len)"/>
</xsl:when>
<xsl:when test="string-length($str) < $len">
<xsl:call-template name="pad-right">
<xsl:with-param name="str" select="concat($str, $pad)"/>
<xsl:with-param name="len" select="$len"/>
<xsl:with-param name="pad" select="$pad"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$str"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:param name="separator" select="';'"/>
<xsl:param name="line-separator" select="' '"/>
</xsl:stylesheet>
|
|
|
|
|
RK11@2009 wrote: I am not able to create semi-colon values
I don't see you ever writing semi-colons or line separators to the output?
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
|
|
|
|
|
Hi All,
I need to generate dynamically .cs files in Dotnet 2.0 framework using XMl/XSLT. I went through many exmaples for .aspx page creation - one of the examples or links in this Forum is the below one
"http://www.codeproject.com/KB/XML/xmlxsltransformer.aspx". This exmaple was for .aspx page creation using XML/XSLT.
Like wise i need an example, code for .cs file creation through WINDOWS APPLICATION. TIA
Thanks,
Santa.
|
|
|
|
|
Hi,
I am not sure , Is this right section to place this question?
Where to find the specifications for the cross platform Data Format?
How do I submit my design?
Is it allowed to store the schema along with data in Same plain file?
Thanks,
Nagaraj
|
|
|
|
|
I think somethink like this:
<Data encryption="AES256">Some Encrypted Data</Data>
Is it safe to use it like this. And is there a chance that Encryption coud break xml format?
What other encrpytion coud i use?
And a if a user chose plain text, Are '< and '>' the only characters needed to parse?
|
|
|
|
|
Saksida Bojan wrote: Is it safe to use it like this. And is there a chance that Encryption coud break xml format?
Not safe - there is a good chance it could break.
Thing is - XML is a text format, and you're trying to embed an arbitrary byte stream in it. So, what you need to do is encode the encrypted byte stream as a character stream, using something like Base64[^] encoding. After that, you could mark the encoded text stream as CDATA[^] - wouldn't hurt...
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
|
|
|
|
|
In Other words. I Shoud encrypt with aes256 and then encode in Base64?
Will Base64 UTF-7 encode conflict with Xml UTF-8 encode?
|
|
|
|
|
Saksida Bojan wrote: In Other words. I Shoud encrypt with aes256 and then encode in Base64?
Yes
Saksida Bojan wrote: Will Base64 UTF-7 encode conflict with Xml UTF-8 encode?
No - UTF7 is an example of a system that uses base64. You'll also be using base64 to encode binary using 64 characters - you won't be using UTF7.
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
|
|
|
|
|
|
Hi All,
How can I control the layout of Windows forms using Xml file.
Thank you,
Devaang
|
|
|
|
|
I'am guessing you don't wanna use WPF. Use the classes in the System.xml namespace to parse the xml, and then dynamicly create and add controls to the form, setting the position, size, color, text and so on according to the data in the xml. (I am asuming you are using C#/.net). If you use c++/MFC you can do it with parsing the xml with a library like TinyXML and then create the controls dynamicly based on the data in the xml.
|
|
|
|
|
Hi,
yes I am using .Net/C#
I need something like this.
Suppose I have Xml like
<root>
;
Now When I render "Windows Form" it has lable like in given xml.
Thank you,
Devaang
|
|
|
|
|
well, lets asume you have created a class that contain the data parsed from the xml (lets call it LabelData) and that you have a list with objects of that type containing the data for all the lables you wants to add to the form (lets call the list LabelDataList). the code will look something like this.
public class LabelData
{
public string Name;
public string Text;
public int x,y;
public int width,height;
....
};
List<LabelData> LabelDataList;
LabelDataList=new List<LabelData>();
....
....
if (Node.NodeType == XmlNodeType.Element)
{
if (Node.Name == "Label")
{
XmlElement NodeElement = Node as XmlElement;
LabelData tmpLD=new LabelData();
LabelDataList.add(tmpLD);
}
}
....
....
foreach(LabelData ld in LabelDataList)
{
Label newLabel=new Label();
newLabel.Name=ld.Name;
newLabel.Text=ld.Text;
newLabel.Location=new Point(ld.x, ld.y);
newLabel.Size=new Size(ld.width, ld.height);
....
....
this.Controls.Add(newLabel);
}
ofcourse you can create the labels and add them to the form directly in the loop you use to parse the xml too, when it comes to parsing the XML there is many ways to do it, maybe the easiest one is to load the data into a DataTable and loop through the rows in the DataTable.
modified on Tuesday, August 11, 2009 4:11 AM
|
|
|
|
|
Hi Annathor
Thanks for your interest...
As I have to generate class from xml right for it Fist I have to create schema from xml and then have to generate class from it.
Can I use xml directly??
And second question is :
I want to bind control from xml file.
means suppose my xml like
<editcontrol datamember="address" editable.binding="={@registered_responsible_party}" type="TextBox" location="100,76" size="240,20" label.text="Address" label.location="10,76" label.size="90,20">
So it means "address" columns of database will be bind to textbox
|
|
|
|
|
English isn't my first language, so I don't understand your question.
Do you want to store the column name in a text box? if so you could make a control that inherit from the textbox class like this:
public class ExtendedTextbox:Textbox
{
public string ColumnName;
}
and use the ExtendedTextbox insted of the normal Textbox class.
and save the column name in the ColumnName varible like this:
ExtendedTextbox etb=new ExtendedTextbox ();
etb.Name="Something";
etb.ColumnName="Something";
...
...
this.Controls.add(etb);
|
|
|
|
|
Hi - Any help or guidance would be appreciated. I am trying a new xml file with the total of one of the specific elements - below is the original xml file:
<Report>
<Unit>
<Name>t1</Name>
<Price>32</Price>
<Other>sdasd</Other>
</Unit>
<Unit>
<Name>t1</Name>
<Price>42</Price>
<Other>dasdasd</Other>
</Unit>
<Unit>
<Name>t2</Name>
<Price>11</Price>
<Other>asdas</Other>
</Unit>
<Unit>
<Name>t3</Name>
<Price>21</Price>
<Other>dasd</Other>
</Unit>
<Unit>
<Name>t1</Name>
<Price>65</Price>
<Other>dasda</Other>
</Unit>
The xsl that I am trying to us is as follows: instead of giving me 1 value it gives me a list of all t1 values rather than a sumation
<test>
<xsl:if test="Name = 't1'">
<xsl:variable name="value1" select ="sum(Price)"/>
<xsl:value-of select="$value1"/>
</xsl:if>
</test>
thanks
|
|
|
|
|
This XSL stylesheet will output a single 'test' tag containing the total you want. Note that I construct a list of all the 'Price' tags (with //Price) and filter that list with a predicate on the sibling Name tag ([../Name='t1']).
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<test>
<xsl:value-of select="sum(//Price[../Name='t1'])"/>
</test>
</xsl:template>
</xsl:stylesheet>
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
|
|
|
|
|
I have created a program using vb.net which use xml database. I need to display the text as formatted like bold letter, italics, etc. Can it be done.
this character gives a newline, but I need to display my characters/words as bold, italics, etc. Is there anything I can do to display them as I desired.
Any suggestion would be highly appreciated.
Thank you.
|
|
|
|
|
you could add the font and display properties of a string as a attribute in the xml tag, then parse it and set the font properties of the control that displays the text according to the data in the xml-attributes, this is based on a wild guess on how you display the text, since you don't mention how you load and display the xml file, do you load it in a datatable and uses a datagridview to display it, do you parse it manualy with the System.xml namespace and display the text in a listview or what?
|
|
|
|
|
My xml code is as below :
<?xml version="1.0" encoding="utf-16"?>
<List>
<File Thumal="jukebox" Awmzia="jukebox
Thingrem zai thei" />
</List>
The newline character I can make using
but I want to display some of my word as italic, bold, etc. for example if I want to display jukebox as bold, or italic how do i do that. Would be very grateful if anyone lend me a hand here.
Thank you.
|
|
|
|
|
Hi
I have created a C# XML Reader and was wondering if someone could have a look at the code to see if I have done it right.
Thanks
Andrew
-------------------------------
using System;
using System.Xml;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace MyProject
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
System.IO.StreamReader stream = new System.IO.StreamReader ("About.xml");
XmlTextReader reader = null;
reader = new XmlTextReader (stream);
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Element: // The node is an Element.
Console.Write("<" + reader.Name);
while (reader.MoveToNextAttribute()) // Read attributes.
Console.Write(" " + reader.Name + "='" + reader.Value + "'");
Console.Write(">");
Console.WriteLine(">");
break;
case XmlNodeType.Text: //Display the text in each element.
Console.WriteLine (reader.Value);
break;
case XmlNodeType. EndElement: //Display end of element.
Console.Write("</" + reader.Name);
Console.WriteLine(">");
break;
}
}
}
}
}
Andrew McIntyre
|
|
|
|
|
Hi Andrew. This isn't the best way to ask a question on CodeProject. What you'll want to do instead is try out your code and if it isn't working the way you expect or want, ask a specific question that targets what is going wrong (for example, it's better for volunteers to read through four lines of code that target where you think the problem is, rather than go through a full dump of code... and if you make it easier for volunteers to help you, they will!)
[EDIT] - oh, and it's never a good idea to use "Help" for the subject line. Everyone already knows you're looking for help, otherwise you wouldn't be posting here. A subject line that helps focus on the specific question you have in mind is much better and easier for volunteers to work with.
|
|
|
|
|
Everytime I debug the project and when the client appear the XML document that I want to appear doesn't appear on screen for some reason. I get no error in the error list and thats why I have asked you guy's.
Andrew
Andrew McIntyre
|
|
|
|
|
|
Try using the debugger. Put a breakpoint on the first "Console.WriteLine" statement, then examine program variables and single step through the code to try and discover where you are going wrong.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
