As an analyst, I am always keen for other's point of view in how they
go about doing things. It's my way of learning.
So here's a situation, which i would appreciate your thoughts on:
You, as an XML developer, are given an XSD by a third party
organisation. You've got to Import and Export data from your
'database' using MSXML, conforming to this schema.
At the moment, *my* way of doing this would be to get XMLSpy to
generate a sample xml doc, create an XSLT which maps the xml output
against fields in my db, and use ADO to transform the database data
into a transformed xml doc. And THEN worry about validation.
What methods, or approaches would you use to go from XSD to XML?
With regards, 1 1143
SiJP wrote: As an analyst, I am always keen for other's point of view in how they go about doing things. It's my way of learning.
So here's a situation, which i would appreciate your thoughts on:
You, as an XML developer, are given an XSD by a third party organisation. You've got to Import and Export data from your 'database' using MSXML, conforming to this schema.
At the moment, *my* way of doing this would be to get XMLSpy to generate a sample xml doc, create an XSLT which maps the xml output against fields in my db, and use ADO to transform the database data into a transformed xml doc. And THEN worry about validation.
What methods, or approaches would you use to go from XSD to XML?
With regards,
Just use an editor that supports xsd, then when i am typing that
editor will give hints wich elements i can choose from.
The editor gets that info from the xsd file. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: kyancy |
last post by:
Hello All.
We have several XML schemas to describe common component document
parts. We then create new XML schemas as necessary that use "xsd:import
schemaLocation=whateverLocation.." to include...
|
by: btober |
last post by:
Whenever I create a temporary table, with something like
CREATE TEMPORARY TABLE temptable1 AS SELECT * FROM paid.ad_hoc_query;
New schemas appear, with names like "pg_temp_1". I guess the...
|
by: Roderick A. Anderson |
last post by:
I'm looking for some input on a configuration I'm implementing. The long
term goal is to providing hosting for companies and organizations with a
basic/generic set of applications that use...
|
by: anonymous |
last post by:
When I use the schema collection to apply many schemas to
one XML instance document, I get an error if I do not
qualify every element with the appropriate namespace.
Both the W3C site and this...
|
by: John Jenkins |
last post by:
Hi,
I have a lot of schemas to load into a schema collection. I load them in
by reading each one into a XMLTextReader from disk and add them into a
schema collection. I have a couple of issues to...
|
by: CSN |
last post by:
I have two machines between which I exchange dumps a
lot. On the first (Windows/cygwin), pgsql was set up
with "Administrator" as the main superuser - who owns
all schemas in template0 and...
|
by: Dennis Gearon |
last post by:
This post is as much about getting some questions answered as leaving
the following definitions in the archives for the next person.
After a quick perview of the web, I came up with the...
|
by: Net Virtual Mailing Lists |
last post by:
I've been spending the last few days converting many databases into a
single schema and have completed the process, but now I'm at somewhat of
an impasse as to the best way to proceed forward....
...
|
by: Sami Marzouki |
last post by:
Hi,
What I'm trying to do is:
- To write a Web.config with custom sections. (Done)
- To write a xsd schema for this custom sections.(Done)
- Tell the Web.config to take the two schemas.
When...
|
by: vihrao |
last post by:
I am designing wsdl that uses multiple schemas. I can do this in two
ways: 1) use multiple schema imports in one wsdl or 2) use multiple
schema imports in to one common schema and then import a...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |