[
Lists Home |
Date Index |
Thread Index
]
--- Neile Bermudes <Neile.Bermudes@ecb.co.uk> wrote:
> Hello all
>
>
>
> I have been asked to undertake a project at work: we
> have a Directory
> booklet with all the contact details for staff in
> our organization, which we
> create in Quark. I would now like to create a SQL
> database with the same
> information, and which can be searchable using ASP
> scripts from our company
> Intranet. Obviously it would be absolutely crazy to
> update both Quark and
> SQL separately every time contact details change.
>
>
>
> What I would like to do: first, export all the
> information in Quark into a
> SQL database, having exactly the same information in
> both. Then, as details
> change, just update the database. Once a year, when
> we print out the Staff
> Directory booklet, I would like to then like to get
> the updated information
> into Quark so it can be printed.
>
>
>
> The way to export info from Quark into a useable
> format is by using their
> product, Avenue, which exports to XML. From XML, I
> can get the info into
> SQL. Then, when I need to update Quark, I export
> from SQL into XML and then
> back into Quark.
>
>
>
> My main question is can I get the XML data into SQL
> columns and fields, like
> regular SQL data? And once it's in their, can I
> query it/mess with it like
> normal data for other purposes, like accessing it on
> my Intranet via ASP?
> How is this XML data treated once in SQL??
>
>
>
> Any info would be appreciated, even is just a
> pointer to some good
> resources/site/books etc
Hi,
ConnectTel has a product that allows access to several
Databases
using a XML interface, see site for details. It does
exactly what you described above. There is one
example using ASP.NET and MYSQL.
http://www.connecttel.com/index.php?link=_70_BankPortal.html
For more information, please visit the XQX web page
at:
http://www.connecttel.com/index.php?link=_XQX
It allows SOAP/HTTP access to remote databases, as
well as
local interface using function calls.
Rosimildo.
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
|
