XML feed

MickB · External Since: Oct 22, 2009 Posts: 2

Hi, thanks for taking the time to look at my question....
There is another website (estate agent type) who is able to send me an xml
feed of their property details. I want to display these details on an asp
page if possible, and even better to manipulate it into a format consistant
witht my web site.
Example snip of xml feed

<?xml version="1.0" encoding="UTF-8" ?>
- <root>
- <property>
<id>{8437427A-EE7E-4F55-99A3-9228BE6BA1D8}</id>
<ref>A3VI0002</ref>
<complex>LOS SERENOS</complex>
<beds>3</beds>
<baths>2</baths>
<interior>122</interior>
<exterior>100</exterior>

I would normally use an access databse as the data source for the asp page,
and can (with previous help from this group!) draw the data from the database
and format it ok on an asp page, but just dont know where to start with an
xml feed.
many thanks Mick

Ronx · External Since: Dec 12, 2003 Posts: 5967

As an initial step - Access 2007 (and probably earlier versions) can import
an XML file as a new table.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.

"MickB" <MickB.DeleteThis@discussions.microsoft.com> wrote in message
news:A5A05F60-7EF6-4266-9E30-92A560815C4B@microsoft.com...
> Hi, thanks for taking the time to look at my question....
> There is another website (estate agent type) who is able to send me an xml
> feed of their property details. I want to display these details on an asp
> page if possible, and even better to manipulate it into a format
> consistant
> witht my web site.
> Example snip of xml feed
>
> <?xml version="1.0" encoding="UTF-8" ?>
> - <root>
> - <property>
> <id>{8437427A-EE7E-4F55-99A3-9228BE6BA1D8}</id>
> <ref>A3VI0002</ref>
> <complex>LOS SERENOS</complex>
> <beds>3</beds>
> <baths>2</baths>
> <interior>122</interior>
> <exterior>100</exterior>
>
> I would normally use an access databse as the data source for the asp
> page,
> and can (with previous help from this group!) draw the data from the
> database
> and format it ok on an asp page, but just dont know where to start with an
> xml feed.
> many thanks Mick
>

Ronx · External Since: Dec 12, 2003 Posts: 5967

There is a tutorial at
http://www.sourcecodesworld.com/articles/XML-Datasource.asp

I have never tried it, so cannot comment.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.

"MickB" <MickB RemoveThis @discussions.microsoft.com> wrote in message
news:A5A05F60-7EF6-4266-9E30-92A560815C4B@microsoft.com...
> Hi, thanks for taking the time to look at my question....
> There is another website (estate agent type) who is able to send me an xml
> feed of their property details. I want to display these details on an asp
> page if possible, and even better to manipulate it into a format
> consistant
> witht my web site.
> Example snip of xml feed
>
> <?xml version="1.0" encoding="UTF-8" ?>
> - <root>
> - <property>
> <id>{8437427A-EE7E-4F55-99A3-9228BE6BA1D8}</id>
> <ref>A3VI0002</ref>
> <complex>LOS SERENOS</complex>
> <beds>3</beds>
> <baths>2</baths>
> <interior>122</interior>
> <exterior>100</exterior>
>
> I would normally use an access databse as the data source for the asp
> page,
> and can (with previous help from this group!) draw the data from the
> database
> and format it ok on an asp page, but just dont know where to start with an
> xml feed.
> many thanks Mick
>

MickB · External Since: Oct 22, 2009 Posts: 2

Thanks Ron very much, import into Access worked fine, and I can take it from
there, many thanks again, Mick

"Ronx" wrote:

> There is a tutorial at
> http://www.sourcecodesworld.com/articles/XML-Datasource.asp
>
> I have never tried it, so cannot comment.
> --
> Ron Symonds
> Microsoft MVP (Expression Web)
> http://www.rxs-enterprises.org/fp
>
> Reply only to group - emails will be deleted unread.
>
>
>
> "MickB" <MickB.DeleteThis@discussions.microsoft.com> wrote in message
> news:A5A05F60-7EF6-4266-9E30-92A560815C4B@microsoft.com...
> > Hi, thanks for taking the time to look at my question....
> > There is another website (estate agent type) who is able to send me an xml
> > feed of their property details. I want to display these details on an asp
> > page if possible, and even better to manipulate it into a format
> > consistant
> > witht my web site.
> > Example snip of xml feed
> >
> > <?xml version="1.0" encoding="UTF-8" ?>
> > - <root>
> > - <property>
> > <id>{8437427A-EE7E-4F55-99A3-9228BE6BA1D8}</id>
> > <ref>A3VI0002</ref>
> > <complex>LOS SERENOS</complex>
> > <beds>3</beds>
> > <baths>2</baths>
> > <interior>122</interior>
> > <exterior>100</exterior>
> >
> > I would normally use an access databse as the data source for the asp
> > page,
> > and can (with previous help from this group!) draw the data from the
> > database
> > and format it ok on an asp page, but just dont know where to start with an
> > xml feed.
> > many thanks Mick
> >
> .
>