471,310 Members | 1,017 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,310 software developers and data experts.

xml modifications

hi there...i'm a begginer level user and i've stumbbled upon a problem a
bit beyond my knowledge. i hope that somebody will be able to help me with
my problem...

the problem is: i'm transforming an Access database to XML with some
adjustements. basicaly i have one main table in which i have my main data
and keys to other tables containing other relevant data.
after exporting my main table to xml i have in some tags only keys to other
tables. and now i want to change those keys to meaningful data.
for instance: after exporting, i have a line like this: <tagZ>1</tagZ>, and
i want to change it to be just an opening tag for something else; <tagQ
attr1="xx" attr2="yy">.the data which must be written in attr1 and attr2
depends upon the number (in this case number 1) inside

the tag (tagZ).
Sep 29 '07 #1
2 992
dcleaner a écrit :
hi there...i'm a begginer level user and i've stumbbled upon a problem a
bit beyond my knowledge. i hope that somebody will be able to help me with
my problem...

the problem is: i'm transforming an Access database to XML
<ot>Strange idea IMHO, but anyway...</ot>
with some
adjustements. basicaly i have one main table in which i have my main data
and keys to other tables containing other relevant data.
after exporting my main table to xml i have in some tags only keys to other
tables. and now i want to change those keys to meaningful data.
for instance: after exporting, i have a line like this: <tagZ>1</tagZ>, and
i want to change it to be just an opening tag for something else; <tagQ
attr1="xx" attr2="yy">.the data which must be written in attr1 and attr2
depends upon the number (in this case number 1) inside
the tag (tagZ).
And where's your problem exactly ?-)

More seriously: you don't explain how you export your database to XML,
so it won't be easy to help.

What I'd personnaly do would be to use the db-api (or whatever
appropriate for accessing a .mdb) and a templating system (like genshi
or mako or...) to build the xml file. In which case there's no problem
accessing the related tables (that's what SQL is for, isn't it ?).

Now if you hope to get some serious help, you probably want to give more
details...
Oct 1 '07 #2
Bruno Desthuilliers <br********************@wtf.websiteburo.oops.com >
wrote in news:47***********************@news.free.fr:
dcleaner a écrit :
>hi there...i'm a begginer level user and i've stumbbled upon a
problem a bit beyond my knowledge. i hope that somebody will be able
to help me with my problem...

the problem is: i'm transforming an Access database to XML

<ot>Strange idea IMHO, but anyway...</ot>
>with some
adjustements. basicaly i have one main table in which i have my main
data and keys to other tables containing other relevant data.
after exporting my main table to xml i have in some tags only keys to
other tables. and now i want to change those keys to meaningful data.
for instance: after exporting, i have a line like this:
<tagZ>1</tagZ>, and i want to change it to be just an opening tag for
something else; <tagQ attr1="xx" attr2="yy">.the data which must be
written in attr1 and attr2 depends upon the number (in this case
number 1) inside the tag (tagZ).

And where's your problem exactly ?-)

More seriously: you don't explain how you export your database to XML,
so it won't be easy to help.

What I'd personnaly do would be to use the db-api (or whatever
appropriate for accessing a .mdb) and a templating system (like genshi
or mako or...) to build the xml file. In which case there's no problem
accessing the related tables (that's what SQL is for, isn't it ?).

Now if you hope to get some serious help, you probably want to give
more details...
the tool i used to transform from mdb to xml was the microsoft's access itself (2007
version). i only exported one table for now which is my main table, from the others i
want to extract data so that i could put in inside the newly formed xml. hmm... in
short.... i want to have everything in one xml file...
about sql database... i'm using xml because i want it to be able to run offline.
Oct 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Jay | last post: by
5 posts views Thread by benmorganpowell | last post: by
4 posts views Thread by pierre.bru | last post: by
1 post views Thread by Ahmed Zammar | last post: by
5 posts views Thread by =?UTF-8?B?TWFydGluIFDDtnBwaW5n?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.