Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListCalculated FieldCalculated Field
Previous
 
Next
New Post
8/13/2006 5:38 PM
 

Robert,

first study the generated XML, this will help you writing your stylesheet:
http://dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/56/threadid/57044/scope/posts/Default.aspx

You will discover that

  • the column names gets xml encoded -> [Transaction Type] will be <Transaction_x0020_Type>
  • you will find an addional element <Date_UDT_Value> which contains the formated date for your [Date] column respecting the current localization
 
New Post
8/16/2006 7:38 AM
 

Thanks for the rapid response. 

I was a little slow at understanding the <Date_UDT_Value> tip, but finally got it.  I was looking for a method to define the [date] as a date and was not seeing that that function was already done for me in the <Date_UDT_Value>.  Even though you told me...

I am curious as to why there is a difference in the time offsets highlighted below.  I would have expected the offset to be the same.

   <Data>
      <UserDefinedRowId>15</UserDefinedRowId>
      <CreatedBy>host</CreatedBy>
      <CreatedAt>2006-08-01T08:05:57-07:00</CreatedAt>
      <ChangedBy>host</ChangedBy>
      <ChangedAt>2006-08-01T08:05:57-07:00</ChangedAt>
      <Date>2004-12-31T00:00:00-08:00</Date>
  ...

 
New Post
8/16/2006 12:20 PM
 
rbelknap wrote

Thanks for the rapid response. 

I was a little slow at understanding the tip, but finally got it.  I was looking for a method to define the [date] as a date and was not seeing that that function was already done for me in the .  Even though you told me...

Localization of the date is rendered to the XML content because of missing date function in the .NET XSLT implementation.
Otherwise you would need to parse the date as string - which is ugly and don't support localization.

rbelknap wrote

I am curious as to why there is a difference in the time offsets highlighted below.  I would have expected the offset to be the same.

  
      15
      host
      2006-08-01T08:05:57-07:00
      host
      2006-08-01T08:05:57-07:00
      2004-12-31T00:00:00-08:00
  ...

Me too - very strange. I will think about.

 
New Post
12/9/2006 8:54 AM
 

Stefan Cullmann wrote
you will find an addional element <Date_UDT_Value> which contains the formated date for your [Date] column respecting the current localization

Brand new to XML/XSL, I don't understand how to code the date element above.   Would someone please show it used in a snippet of .xsl? Thank you.


If a problem can be solved, there's no use worrying about it.
If it can't be solved, worrying will do no good.
 
New Post
12/9/2006 9:55 AM
 
  1. XSL (without an EXSLT library) doesn't provide any date related functions, they are treated as strings.
  2. The data inside UDT is loaded into a dataset containing multiple tables. The main data is inside the table "data". UDT provides its own datatypes that provide some more features, they are not mapped build in into .Net. We help ourself adding some invisible columns, it depends on the current udt type.
  3. The date data type adds an invisible column containing the localized date as string. This helps you presenting a nice date using xml.
  4. These invisble colums are described in the documentation for UDT3.3.7. (unpublished), 
    and here http://www.dotnetnuke.com/tabid/795/forumid/56/threadid/69772/scope/posts/Default.aspx  

 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListCalculated FieldCalculated Field


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out