By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,584 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,584 IT Pros & Developers. It's quick & easy.

Standard for simple database exchange?

P: n/a
This has got to be a FAQ some place, but....

Say I've got a table in some database some place, like so:
(Actually, it's several tables kind of turned sideways, but
for purposes of this question it may as well be this, because
this is the intended target)

PERSONS
-------------------
UID FNAME LNAME
flast First Last
At first it looks like a tab file would work, (and indeed, it would,
except that data may contain \n or \t)

What I'm looking for is a *standard* way to produce something simple,
like this:

<table name="PERSONS">
<row>
<field label="User ID" name="UID">flast</field>
<field label="First Name" name="FNAME">first name</field>
<field label="Last Name" name="LNAME">last name</field>
</row>
</table>
But I want the XML to follow a DTD that is commonly used for importing
simple data. Something I can just hand someone and ideally their database
already handles it, or, they can install a tool in <2 minutes for it.

Would be nice if it allowed for file attachments, like:

<field label="Extra documentation" name="description" content_type="application/pdf" filename="somefile.pdf">
... base64 encoded data ...
</field>

But it's not strictly required, I'd rather produce simple XML with just the
filename. (Simplicity is the key here, 99% of the time there won't be files,
and if the format allowed base64 encoding and BLOBS, I could always generate
additional fields for that purpose)

Where would I find a specification for that? I've tried google, but all I've
found are tools designed to be *configured* for a wide variety of XML.
Jamie
--
http://www.geniegate.com Custom web programming
gu******@lnubb.pbz (rot13) User Management Solutions
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.