FP2003 and XML

[cja]

I have a question on working directly with XML in FP 2003. Please let me
konw if this is not the right newsgroup.

I'm experimenting with using FP2003 to insert and format XML directly in a
WSS web page. I'm doing this using XML created from an Excel worksheet.

It is easy enough to insert the XML spreadsheet through the Data View
taskpane. Beyond that, for formatting the data the Design wysiwyg is almost
unusable. The DV insert operation doesn't seem to give me any options for
selecting columns or rows, just dumps the entire sheet into the page. I can
do some font formatting, select and delete, resize coulmns and rows, etc in
the wysiwyg but it is incredibly slow and tedious. The help files provide no
useful information that I can find.

Am I missing something: some feature in the product that I haven't found?
tutorial, help file etc to help explain how to do this? should I not be
trying to do this (it *is* an advertised feature of the product)? did I do
something wrong or was there something else I needed to do when I exported
the XML from Excel?

THanks in advance for the help.

 

[Cowboy \(Gregory A. Beamer\)]

The majority of the XML features in FP2K3 are used in conjunction with
SharePoint, so the real bang for the buck comes when you are connected to a
SharePoint site. What you are trying to do is something you can do w/o
SharePoint, so SharePoint is not a problem.

A couple of things for your problem

1. Excel makes rather weighty XML. This is not a major problem, but
something to be considered.
2. You are working with a beta. The RTM product is always faster than the
betas.

As far as the DataView functionality, even Visual Studio .NET is a bit weak
in filtering information rather than spitting the entire set of data out.
You can tweak the code or tweak the spreadsheet, but you are stepping a bit
outside the box when you are attempting to filter the data.

I do not have a tutorial on DVs in FP2K3 yet, nor do I know of one. If I
find one, I will pass it on. Watch the FrontPage community site. In the next
month or so, there should be some articles on FP2K3 on the site that can
help you out.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge

****************************************************************************
****
Think Outside the Box!
****************************************************************************
****