Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: XML-lib for clipper

445 views
Skip to first unread message

pe...@nospam.demon.co.uk

unread,
Aug 16, 2009, 2:46:02 PM8/16/09
to
In article <b77jqz1p9i7n$.1prh7yl0...@40tude.net>
fk2...@web.de "Fabian Knauf" writes:

> is there a XML-lib for clipper available?
> All I found until now were links to non existent websites.
>
> Regards
> Fabian

I don't know if you managed to find a XML-lib, but if not I will
happily send you the code I've just created and which might help.
It is based on DBF2XML (written by Yamil Bracho) which was posted
here a while back, but enhanced to include a metadata section
that allows the xml to be used to recreate a DBF from it. The
only downside is that it is S87 source (not the ideal platform
for this task...) and would benefit from a 5.x conversion.

If you would like the sources for DBF2XML and XML2DBF just post
here and I'll email to you. Or, if there is a large demand I'll
put the code on a web page.

Pete
--
"We have not inherited the earth from our ancestors,
we have borrowed it from our descendants."

Fabian Knauf

unread,
Aug 20, 2009, 9:02:39 AM8/20/09
to

Hi Pete,

> I don't know if you managed to find a XML-lib, but if not I will
> happily send you the code I've just created and which might help.
> It is based on DBF2XML (written by Yamil Bracho) which was posted
> here a while back, but enhanced to include a metadata section
> that allows the xml to be used to recreate a DBF from it. The
> only downside is that it is S87 source (not the ideal platform
> for this task...) and would benefit from a 5.x conversion.
>
> If you would like the sources for DBF2XML and XML2DBF just post
> here and I'll email to you. Or, if there is a large demand I'll
> put the code on a web page.

No, until now I'm not a step further.

Actually I can create a XML-file myself easily by writing it step by
step. My problem is, how to read a xml-file into a dbase table.
Especially when there are multiple (but not known how many) tags within
one file.

For example:
<data>
<number>123</number>
<sub>
<first></first>
<second></second>
</sub>
<sub>
<first></first>
<second></second>
</sub>
</data>

How to get such a structure into an dbf file? Of course within dbase
files I either have to read in two tables (data and sub) or when only
one table is used, I have to create as many records as I have <sub>
entries.

But actually I don't really know where to start. So If you have some
lines for me that would be great.


Regards
Fabian

pe...@nospam.demon.co.uk

unread,
Aug 20, 2009, 1:27:12 PM8/20/09
to
Hi Fabian,

In article <23r3zxxx8zt9.1mxovlbchuxr2$.d...@40tude.net>
fk2...@web.de "Fabian Knauf" writes:

> Hi Pete,
>
> > I don't know if you managed to find a XML-lib, but if not I will
> > happily send you the code I've just created and which might help.
> > It is based on DBF2XML (written by Yamil Bracho) which was posted
> > here a while back, but enhanced to include a metadata section
> > that allows the xml to be used to recreate a DBF from it. The
> > only downside is that it is S87 source (not the ideal platform
> > for this task...) and would benefit from a 5.x conversion.
> >
> > If you would like the sources for DBF2XML and XML2DBF just post
> > here and I'll email to you. Or, if there is a large demand I'll
> > put the code on a web page.
>
> No, until now I'm not a step further.
>
> Actually I can create a XML-file myself easily by writing it step by
> step. My problem is, how to read a xml-file into a dbase table.

This is the same problem that taxed my brain :-)

> Especially when there are multiple (but not known how many) tags within
> one file.
>
> For example:
> <data>
> <number>123</number>
> <sub>
> <first></first>
> <second></second>
> </sub>
> <sub>
> <first></first>
> <second></second>
> </sub>
> </data>
>
> How to get such a structure into an dbf file? Of course within dbase
> files I either have to read in two tables (data and sub) or when only
> one table is used, I have to create as many records as I have <sub>
> entries.
>
> But actually I don't really know where to start. So If you have some
> lines for me that would be great.

The code I have written will create an xml file from a dbf, and
recreate that dbf from the xml. I doubt this code will do
exactly what you need -- in typical usenet fashion -- but might
give you some ideas on how to implement your own XML lib :-)

I'll send it to the email address with which you posted here.

Regards,

pe...@nospam.demon.co.uk

unread,
Aug 20, 2009, 2:17:56 PM8/20/09
to
In article <125078...@nospam.demon.co.uk> pe...@nospam.demon.co.uk writes:
[..]

> I'll send it to the email address with which you posted here.

And this elicited a "Benutzer nicht bekannt" failure :-(

Please send me your email address to my name at papadelta.co.uk
and I will try to resend...

pe...@nospam.demon.co.uk

unread,
Aug 23, 2009, 3:15:33 AM8/23/09
to
Fabian,

If you are still interested you can find it here:

<http://www.pdlhost.demon.co.uk/clipper/dbfxml.zip>

The source is not pretty but does appear to work...

József Erdesz

unread,
Aug 24, 2015, 8:05:12 AM8/24/15
to
Dear Pete,
I have old Clipper 5.2e program and (after 10 years) I must to create new function to data transfer in XML. I did't work XML yet, but I have to find solution this problem.

I have read your letter and ask you to send me your DBF2XML and XML2DBF sources to try that.

Thank you for your help.

:-) Jozsef (joz...@erdesz.hu)

dlzc

unread,
Aug 24, 2015, 9:58:00 AM8/24/15
to
Dear József Erdesz:

On Monday, August 24, 2015 at 5:05:12 AM UTC-7, József Erdesz wrote:
...
> I have old Clipper 5.2e program and (after 10 years)
> I must to create new function to data transfer in XML.
> I did't work XML yet, but I have to find solution
> this problem.
>
> I have read your letter and ask you to send me your
> DBF2XML and XML2DBF sources to try that.

http://www.the-oasis.net/ftpmaster.php3?content=ftpgenrl.htm
... down to TB2HTML.zip

Note this is just a formatted HTML document, that looks like an HTML table. With no possiblity to re-import.

If you get no response to this 6 year old thread...

David A. Smith

Klas Engwall

unread,
Aug 24, 2015, 3:21:15 PM8/24/15
to
Hi József,

> I have old Clipper 5.2e program and (after 10 years) I must to create new function
> to data transfer in XML. I did't work XML yet, but I have to find solution this problem.
>
> I have read your letter and ask you to send me your DBF2XML and XML2DBF sources to try that.

The code is still available, just follow the link in Pete's message

Regards,
Klas

--- news://freenews.netfront.net/ - complaints: ne...@netfront.net ---

pe...@nospam.demon.co.uk

unread,
Aug 24, 2015, 3:26:33 PM8/24/15
to
On 24th Aug 2015 at 05:05 "=?ISO-8859-1?Q?J=F3zsef_Erdesz?=" <jerd...@gmail.com> wrote:

> 2009. augusztus 16., vasárnap 20:46:02 UTC+2 idżpontban pe...@nos
> pam.demon.co.uk a következżt írta:
It looks like http://www.pdlhost.demon.co.uk/clipper/dbfxml.zip is
still available after all this time :-) Still S'87 but should still
work for 5.2, and the source is included in the zip if you feel like
updating it.

Pete
--
Believe those who are seeking the truth.
Doubt those who find it. - André Gide
0 new messages