FP2003 / DataView / XML data -> Hyperlink

[Jeff Richardson]

Hi,
I have a XML data source that contain a description and a URL. When I
select the two fields and put them in a Data View, FP creates a table with
two columns, one for each field. How do I modify the Data View so that it
only has one column that combines the description and URL into a single
Hyperlink?

Thanks in advance
Jeff.

 

[John Jansen \(MSFT\)]

Hi Jeff,

Thanks for the question. I am excited to see posts here concerning the new
data features!

You should select the column that contains the data you don't want and
delete it
(table > select > column; table > delete > column).

Then you should select the data value you want to serve as the link and
click Insert > Hyperlink.

From the Hyperlink dialog, click on the Parameters button. From the
Parameters dialog, click on 'Insert Field Value' and then choose the XML
field from the list.

I hope that makes sense to you. Remember, even though you are looking at an
XSLT rendering of your XML data, you can still use all of the formatting and
table tools available.

Thanks for the post!
-John Jansen
Microsoft

 

[Jeff Richardson]

John,
That worked great! Thanks. Now I can integrate RSS feeds into my
SharePoint site!

Is there any kind of Windows Help for FrontPage 2003 that is targeted at
developers? I have found the documentation that I have no where near good
enough for me to have figured this one by myself. I think FP's XML / XSLT
support to be a fantastic, now I need more technical information on how to
use it.

Thanks again!
Jeff.

 

[Stefan B Rusynko]

In addition to MSDN at
http://msdn.microsoft.com/office/
try
http://www.sharepointcustomization.com/resources/sdks.htm




| John,
| That worked great! Thanks. Now I can integrate RSS feeds into my
| SharePoint site!
|
| Is there any kind of Windows Help for FrontPage 2003 that is targeted at
| developers? I have found the documentation that I have no where near good
| enough for me to have figured this one by myself. I think FP's XML / XSLT
| support to be a fantastic, now I need more technical information on how to
| use it.
|
| Thanks again!
| Jeff.
|
| | > Hi Jeff,
| >
| > Thanks for the question. I am excited to see posts here concerning the
| new
| > data features!
| >
| > You should select the column that contains the data you don't want and
| > delete it
| > (table > select > column; table > delete > column).
| >
| > Then you should select the data value you want to serve as the link and
| > click Insert > Hyperlink.
| >
| > From the Hyperlink dialog, click on the Parameters button. From the
| > Parameters dialog, click on 'Insert Field Value' and then choose the XML
| > field from the list.
| >
| > I hope that makes sense to you. Remember, even though you are looking at
| an
| > XSLT rendering of your XML data, you can still use all of the formatting
| and
| > table tools available.
| >
| > Thanks for the post!
| > -John Jansen
| > Microsoft
| >
| >
| >
| > | > > Hi,
| > > I have a XML data source that contain a description and a URL. When I
| > > select the two fields and put them in a Data View, FP creates a table
| with
| > > two columns, one for each field. How do I modify the Data View so that
| it
| > > only has one column that combines the description and URL into a single
| > > Hyperlink?
| > >
| > > Thanks in advance
| > > Jeff.
| > >
| > >
| >
| >
|
|

 

[Jeff Richardson]

One other question.

Another field that I am displaying is a date. It is formatted as following:

Wed, 05 Nov 2003 08:00:00 GMT

How can I have the Data View treat this as a date and not plain text? I
want to sort and group by date.

 

[John Jansen \(MSFT\)]

Hi Jeff,

Since we don't get Schema information from XML files this release, we rely
on 'standard' formatting to tell us what to do. For SharePoint list data
and SQL data, we do get schema, so this only applies to generic XML files
and (it sounds like) your RSS feed data.

If you select the data value and right click it, you will see a "Format item
as..." menu. Select this menu item. If it says "Date & Time" then your XML
is of a format that we recognize as a Date field and you can format it in
many many different ways.

If Date & Time is not available, then you would basically need to write some
XSLT on your own, unfortuately.

Here is the pattern we recognize as a date field: 2003-11-13T15:41:37

-John