G
Guest
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
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