473,233 Members | 2,866 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 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 1038
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Predrag | last post by:
Hello. Does anybody have any sample code of altering the crystal report with ..NET (VB or C#) in run-time? Let's say, is it possible to add new section in the report, to create new cross-tab...
16
by: Jay | last post by:
I've been using Travis's Expanding Menu (http://www.squidfingers.com/code/dhtml/expandingmenu/) for a site i'm working on. The problem is I need to add some functionality to it. I need the the...
5
by: benmorganpowell | last post by:
In the last few months many personal website owners (such as myself) have found that spammers have been using their domain names to masquerade as valid users to send spam, normally in the form of:...
4
by: pierre.bru | last post by:
hello, I have a page made of a frameset that contains 2 frames. if in that page I insert a new function in Document.prototype, will this function be available in the already loaded frames ? if...
1
by: Ahmed Zammar | last post by:
I need a bit of a hand here. I was a connection to a live database. It is being displayed in a data grid I'm using a dataset to grab the changes. Once the modifications are done, how do I send...
1
by: tomjbr.32022025 | last post by:
Can anyone recommend a good framework (preferably open source) that can be used for database testing ? The thing I want to be able to do is the following: (1) Define the expected database...
5
by: =?UTF-8?B?TWFydGluIFDDtnBwaW5n?= | last post by:
Hello, I´ve a general question about the visibility and modification of an object. I will try to explain it in my code, where I have the problem: DocumentList dList =...
2
by: Rob Dob | last post by:
Hi, I have several reports ( .rdl) that I created using report designer, how can I let the end user make modifications to the text in some of these reports. As I am unable to use Report Builder...
4
by: raghunadhs | last post by:
Hi all! in my v.b application, i am changing the color of a picture, now i want to save the picture that has been altered in v.b as a ".bmp" so that i can re use it in the same application as...
0
by: Tim Zych | last post by:
We have a .Net solution that our clients are using. When we change something, tweak the code for example, what's the easiest way for us to manage/re-deploy the change? We use the installer...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.