VFP9 - cursortoxml

Back to top

Re: VFP9 - cursortoxml

Author: Eyvind Axelsen

Posted: 2007-06-13 02:20:11 Link

An xsl is not the schema (while an xsd file is). The xsl is a style sheet, that as you mention allows for a browser to pretty-print the xml. To use an xsl style sheet, include a line like the following at the top (after the <?xml version="..."?> tag) of the xml file:

<?xml-stylesheet type="text/xsl" href="your_xsl_file_here.xsl"?>

For example:

<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="simple.xsl"?>

<breakfast_menu>

<food>

<name>Belgian Waffles</name>

two of our famous Belgian Waffles

</description>

</food>

</breakfast_menu>

And the corresponding xsl:

<?xml version="1.0" encoding="ISO-8859-1"?>

<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="" target="_blank">http://www.w3.org/1999/xhtml">

<body style="font-family:Arial,helvetica,sans-serif;font-size:12pt;

background-color:#EEEEEE">

<xsl:for-each select="breakfast_menu/food">

<xsl:value-of select="name"/></span>

- <xsl:value-of select="price"/>

</div>

<xsl:value-of select="description"/>

(<xsl:value-of select="calories"/> calories per serving)

</span>

</div>

</xsl:for-each>

</body>

</html>

>From http://w3schools.com/xml/xml_xsl.asp.

Now, show me the money! <g>

Eyvind.

-----Opprinnelig melding-----

Fra: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] PÃÂ¥ vegne av Sytze de Boer

Sendt: 13. juni 2007 00:11

Til: profox@leafe.com

Emne: VFP9 - cursortoxml

I previously posted a question re converting a small stand-a-lone dbf

to xml file, using a schema (xsl file) supplied by my client.

Creating an xml file is simple

What I can't get my head around is to use the schema "thingee" to ALSO

produce the xml file in a format so that when you double click on it,

it looks all neatly formatted.

almost like a (frx) report from a color printer.

Is there someone here who is prepared to assist me conclude this process.

I am willing to PAY for the help you provide.

Regards

Sytze

[excessive quoting removed by server]

New Search

Back to top

Re: VFP9 - cursortoxml

Author: Rafael Copquin

Posted: 2007-06-13 03:45:14 Link

Hi Eyvind

You seem to know how to create a schema in VFP 9

I want to use the xmladapter class with the following xmlfile, that I have to convert into a vfp cursor

<xml>

</cambio>

</cambio>

</xml>

I need the structure of the generated cursor to be:

articulo N(13)

origen N(13)

destino N(13)

cantidad N(4)

The above represents a quantity (cantidad) of a stock item (articulo) that is moved from one position on the shelf (origen) to another position on another shelf (destino).The values in those fields are the bar codes read from a data collector device

Would you kindly show me how the schema would look like?

And the commands necessary to generate this cursor using the xmladapter class with the schema?

I could use the xmltocursor function, but noticed that if the xml file contains only one record and the value in the CANTIDAD field is either a 1 or a 0, the field generated is of type logic, placing a .T. or a .F. instead of the 1 or the 0

Thank you very much in advance

Rafael Copquin

----- Original Message -----

From: Eyvind Axelsen

To: profoxtech@leafe.com

Sent: Wednesday, June 13, 2007 4:20 AM

Subject: Re: VFP9 - cursortoxml

An xsl is not the schema (while an xsd file is). The xsl is a style sheet, that as you mention allows for a browser to pretty-print the xml. To use an xsl style sheet, include a line like the following at the top (after the <?xml version="..."?> tag) of the xml file:

<?xml-stylesheet type="text/xsl" href="your_xsl_file_here.xsl"?>

For example:

<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="simple.xsl"?>

<breakfast_menu>

<food>

<name>Belgian Waffles</name>

two of our famous Belgian Waffles

</description>

</food>

</breakfast_menu>

And the corresponding xsl:

<?xml version="1.0" encoding="ISO-8859-1"?>

<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="" target="_blank">http://www.w3.org/1999/xhtml">

<body style="font-family:Arial,helvetica,sans-serif;font-size:12pt;

background-color:#EEEEEE">

<xsl:for-each select="breakfast_menu/food">

<xsl:value-of select="name"/></span>

- <xsl:value-of select="price"/>

</div>

<xsl:value-of select="description"/>

(<xsl:value-of select="calories"/> calories per serving)

</span>

</div>

</xsl:for-each>

</body>

</html>

>From http://w3schools.com/xml/xml_xsl.asp.

Now, show me the money! <g>

Eyvind.

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

New Search

Back to top

Re: VFP9 - cursortoxml

Author: Eyvind Axelsen

Posted: 2007-06-13 05:51:21 Link

I have not worked with the XMLAdapter, so I am afraid I can't help you much with that, but here's a sample xml schema that validates against your example - hope it helps!

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">

<xs:element name="articulo" type="xs:long"/>

<xs:element name="cambio">

<xs:complexType>

<xs:sequence>

<xs:element ref="articulo"/>

<xs:element ref="origen"/>

<xs:element ref="destino"/>

<xs:element ref="cantidad"/>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="cantidad" type="xs:int"/>

<xs:element name="destino" type="xs:long"/>

<xs:element name="origen" type="xs:long"/>

<xs:element name="xml">

<xs:complexType>

<xs:sequence>

<xs:element ref="cambio" maxOccurs="unbounded"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

Eyvind.

-----Opprinnelig melding-----

Fra: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] PÃÂ¥ vegne av Rafael Copquin

Sendt: 13. juni 2007 10:45

Til: profox@leafe.com

Emne: Re: VFP9 - cursortoxml

Hi Eyvind

You seem to know how to create a schema in VFP 9

I want to use the xmladapter class with the following xmlfile, that I have to convert into a vfp cursor

<xml>

</cambio>

</cambio>

</xml>

I need the structure of the generated cursor to be:

articulo N(13)

origen N(13)

destino N(13)

cantidad N(4)

The above represents a quantity (cantidad) of a stock item (articulo) that is moved from one position on the shelf (origen) to another position on another shelf (destino).The values in those fields are the bar codes read from a data collector device

Would you kindly show me how the schema would look like?

And the commands necessary to generate this cursor using the xmladapter class with the schema?

I could use the xmltocursor function, but noticed that if the xml file contains only one record and the value in the CANTIDAD field is either a 1 or a 0, the field generated is of type logic, placing a .T. or a .F. instead of the 1 or the 0

Thank you very much in advance

Rafael Copquin

----- Original Message -----

From: Eyvind Axelsen

To: profoxtech@leafe.com

Sent: Wednesday, June 13, 2007 4:20 AM

Subject: Re: VFP9 - cursortoxml

An xsl is not the schema (while an xsd file is). The xsl is a style sheet, that as you mention allows for a browser to pretty-print the xml. To use an xsl style sheet, include a line like the following at the top (after the <?xml version="..."?> tag) of the xml file:

<?xml-stylesheet type="text/xsl" href="your_xsl_file_here.xsl"?>

For example:

<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="simple.xsl"?>

<breakfast_menu>

<food>

<name>Belgian Waffles</name>

two of our famous Belgian Waffles

</description>

</food>

</breakfast_menu>

And the corresponding xsl:

<?xml version="1.0" encoding="ISO-8859-1"?>

<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="" target="_blank">http://www.w3.org/1999/xhtml">

<body style="font-family:Arial,helvetica,sans-serif;font-size:12pt;

background-color:#EEEEEE">

<xsl:for-each select="breakfast_menu/food">

<xsl:value-of select="name"/></span>

- <xsl:value-of select="price"/>

</div>

<xsl:value-of select="description"/>

(<xsl:value-of select="calories"/> calories per serving)

</span>

</div>

</xsl:for-each>

</body>

</html>

>From http://w3schools.com/xml/xml_xsl.asp.

Now, show me the money! <g>

Eyvind.

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]

New Search

Back to top

Re: VFP9 - cursortoxml

Author: Rafael Copquin

Posted: 2007-06-13 06:04:09 Link

Gee, that's very good !!

I have no clue on how you did that, but I will use it and see if this is what I need.

BTW, where can I read what is necessary to understand this schema thing and how to accomplish what you did, on my own? I read the VFP9 help on this subject, but it shows no examples and deciphering the meaning, at least to a newbie on XML as me, is a humongous task!!

Rafael

----- Original Message -----

From: Eyvind Axelsen

To: profoxtech@leafe.com

Sent: Wednesday, June 13, 2007 7:51 AM

Subject: Re: VFP9 - cursortoxml

I have not worked with the XMLAdapter, so I am afraid I can't help you much with that, but here's a sample xml schema that validates against your example - hope it helps!

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">

<xs:element name="articulo" type="xs:long"/>

<xs:element name="cambio">

<xs:complexType>

<xs:sequence>

<xs:element ref="articulo"/>

<xs:element ref="origen"/>

<xs:element ref="destino"/>

<xs:element ref="cantidad"/>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="cantidad" type="xs:int"/>

<xs:element name="destino" type="xs:long"/>

<xs:element name="origen" type="xs:long"/>

<xs:element name="xml">

<xs:complexType>

<xs:sequence>

<xs:element ref="cambio" maxOccurs="unbounded"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

Eyvind.

-----Opprinnelig melding-----

Fra: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] PÃÂ¥ vegne av Rafael Copquin

Sendt: 13. juni 2007 10:45

Til: profox@leafe.com

Emne: Re: VFP9 - cursortoxml

Hi Eyvind

You seem to know how to create a schema in VFP 9

I want to use the xmladapter class with the following xmlfile, that I have to convert into a vfp cursor

<xml>

</cambio>

</cambio>

</xml>

I need the structure of the generated cursor to be:

articulo N(13)

origen N(13)

destino N(13)

cantidad N(4)

The above represents a quantity (cantidad) of a stock item (articulo) that is moved from one position on the shelf (origen) to another position on another shelf (destino).The values in those fields are the bar codes read from a data collector device

Would you kindly show me how the schema would look like?

And the commands necessary to generate this cursor using the xmladapter class with the schema?

I could use the xmltocursor function, but noticed that if the xml file contains only one record and the value in the CANTIDAD field is either a 1 or a 0, the field generated is of type logic, placing a .T. or a .F. instead of the 1 or the 0

Thank you very much in advance

Rafael Copquin

----- Original Message -----

From: Eyvind Axelsen

To: profoxtech@leafe.com

Sent: Wednesday, June 13, 2007 4:20 AM

Subject: Re: VFP9 - cursortoxml

An xsl is not the schema (while an xsd file is). The xsl is a style sheet, that as you mention allows for a browser to pretty-print the xml. To use an xsl style sheet, include a line like the following at the top (after the <?xml version="..."?> tag) of the xml file:

<?xml-stylesheet type="text/xsl" href="your_xsl_file_here.xsl"?>

For example:

<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="simple.xsl"?>

<breakfast_menu>

<food>

<name>Belgian Waffles</name>

two of our famous Belgian Waffles

</description>

</food>

</breakfast_menu>

And the corresponding xsl:

<?xml version="1.0" encoding="ISO-8859-1"?>

<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="" target="_blank">http://www.w3.org/1999/xhtml">

<body style="font-family:Arial,helvetica,sans-serif;font-size:12pt;

background-color:#EEEEEE">

<xsl:for-each select="breakfast_menu/food">

<xsl:value-of select="name"/></span>

- <xsl:value-of select="price"/>

</div>

<xsl:value-of select="description"/>

(<xsl:value-of select="calories"/> calories per serving)

</span>

</div>

</xsl:for-each>

</body>

</html>

>From http://w3schools.com/xml/xml_xsl.asp.

Now, show me the money! <g>

Eyvind.

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]

New Search

Back to top

Re: VFP9 - cursortoxml

Author: Alan Bourke

Posted: 2007-06-13 06:06:40 Link

Sytze de Boer wrote:

> Is there someone here who is prepared to assist me conclude this process.

> I am willing to PAY for the help you provide.

>

>spits coffee<

Money? I'll be around in 10 minutes.

New Search

Back to top

RE: VFP9 - cursortoxml

Author: Eyvind Axelsen

Posted: 2007-06-13 06:32:05 Link

XML schemas are not that difficult to understand once you get over the initial learning barrier. A starting point could be http://www.w3schools.com/schema/default.asp. However, if you are going to work more than a little bit with XML, I would highly recommend getting hold of a tool for the purpose. As you can see from the comment in the example below, I use xml spy from altova, and I find it very helpful in dealing with xml files, schemas etc.

Eyvind.

-----Opprinnelig melding-----

Fra: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] PÃÂ¥ vegne av Rafael Copquin

Sendt: 13. juni 2007 13:04

Til: profox@leafe.com

Emne: Re: VFP9 - cursortoxml

Gee, that's very good !!

I have no clue on how you did that, but I will use it and see if this is what I need.

BTW, where can I read what is necessary to understand this schema thing and how to accomplish what you did, on my own? I read the VFP9 help on this subject, but it shows no examples and deciphering the meaning, at least to a newbie on XML as me, is a humongous task!!

Rafael

----- Original Message -----

From: Eyvind Axelsen

To: profoxtech@leafe.com

Sent: Wednesday, June 13, 2007 7:51 AM

Subject: Re: VFP9 - cursortoxml

I have not worked with the XMLAdapter, so I am afraid I can't help you much with that, but here's a sample xml schema that validates against your example - hope it helps!

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">

<xs:element name="articulo" type="xs:long"/>

<xs:element name="cambio">

<xs:complexType>

<xs:sequence>

<xs:element ref="articulo"/>

<xs:element ref="origen"/>

<xs:element ref="destino"/>

<xs:element ref="cantidad"/>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="cantidad" type="xs:int"/>

<xs:element name="destino" type="xs:long"/>

<xs:element name="origen" type="xs:long"/>

<xs:element name="xml">

<xs:complexType>

<xs:sequence>

<xs:element ref="cambio" maxOccurs="unbounded"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

Eyvind.

-----Opprinnelig melding-----

Fra: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] PÃÂ¥ vegne av Rafael Copquin

Sendt: 13. juni 2007 10:45

Til: profox@leafe.com

Emne: Re: VFP9 - cursortoxml

Hi Eyvind

You seem to know how to create a schema in VFP 9

I want to use the xmladapter class with the following xmlfile, that I have to convert into a vfp cursor

<xml>

</cambio>

</cambio>

</xml>

I need the structure of the generated cursor to be:

articulo N(13)

origen N(13)

destino N(13)

cantidad N(4)

The above represents a quantity (cantidad) of a stock item (articulo) that is moved from one position on the shelf (origen) to another position on another shelf (destino).The values in those fields are the bar codes read from a data collector device

Would you kindly show me how the schema would look like?

And the commands necessary to generate this cursor using the xmladapter class with the schema?

I could use the xmltocursor function, but noticed that if the xml file contains only one record and the value in the CANTIDAD field is either a 1 or a 0, the field generated is of type logic, placing a .T. or a .F. instead of the 1 or the 0

Thank you very much in advance

Rafael Copquin

----- Original Message -----

From: Eyvind Axelsen

To: profoxtech@leafe.com

Sent: Wednesday, June 13, 2007 4:20 AM

Subject: Re: VFP9 - cursortoxml

An xsl is not the schema (while an xsd file is). The xsl is a style sheet, that as you mention allows for a browser to pretty-print the xml. To use an xsl style sheet, include a line like the following at the top (after the <?xml version="..."?> tag) of the xml file:

<?xml-stylesheet type="text/xsl" href="your_xsl_file_here.xsl"?>

For example:

<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="simple.xsl"?>

<breakfast_menu>

<food>

<name>Belgian Waffles</name>

two of our famous Belgian Waffles

</description>

</food>

</breakfast_menu>

And the corresponding xsl:

<?xml version="1.0" encoding="ISO-8859-1"?>

<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="" target="_blank">http://www.w3.org/1999/xhtml">

<body style="font-family:Arial,helvetica,sans-serif;font-size:12pt;

background-color:#EEEEEE">

<xsl:for-each select="breakfast_menu/food">

<xsl:value-of select="name"/></span>

- <xsl:value-of select="price"/>

</div>

<xsl:value-of select="description"/>

(<xsl:value-of select="calories"/> calories per serving)

</span>

</div>

</xsl:for-each>

</body>

</html>

>From http://w3schools.com/xml/xml_xsl.asp.

Now, show me the money! <g>

Eyvind.

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]

New Search

Back to top

VFP9 - cursortoxml

Author: Sytze de Boer

Posted: 2007-06-13 07:10:37 Link

I previously posted a question re converting a small stand-a-lone dbf

to xml file, using a schema (xsl file) supplied by my client.

Creating an xml file is simple

What I can't get my head around is to use the schema "thingee" to ALSO

produce the xml file in a format so that when you double click on it,

it looks all neatly formatted.

almost like a (frx) report from a color printer.

Is there someone here who is prepared to assist me conclude this process.

I am willing to PAY for the help you provide.

Regards

Sytze

New Search

Back to top

Re: VFP9 - cursortoxml

Author: Wayne Sobers

Posted: 2007-06-13 09:50:38 Link

This a good resource - plus some examples.

http://foxcentral.net/microsoft/WhatsNewInVFP9_Chapter10.htm

"Rafael Copquin" <rcopquin@ciudad.com.ar>

Sent by: profoxtech-bounces@leafe.com

06/13/2007 04:45 AM

Please respond to

profox@leafe.com

To

profoxtech@leafe.com

cc

Subject

Re: VFP9 - cursortoxml

Hi Eyvind

You seem to know how to create a schema in VFP 9

I want to use the xmladapter class with the following xmlfile, that I have

to convert into a vfp cursor

<xml>

</cambio>

</cambio>

</xml>

I need the structure of the generated cursor to be:

articulo N(13)

origen N(13)

destino N(13)

cantidad N(4)

The above represents a quantity (cantidad) of a stock item (articulo) that

is moved from one position on the shelf (origen) to another position on

another shelf (destino).The values in those fields are the bar codes read

from a data collector device

Would you kindly show me how the schema would look like?

And the commands necessary to generate this cursor using the xmladapter

class with the schema?

I could use the xmltocursor function, but noticed that if the xml file

contains only one record and the value in the CANTIDAD field is either a 1

or a 0, the field generated is of type logic, placing a .T. or a .F.

instead of the 1 or the 0

Thank you very much in advance

Rafael Copquin

----- Original Message -----

From: Eyvind Axelsen

To: profoxtech@leafe.com

Sent: Wednesday, June 13, 2007 4:20 AM

Subject: Re: VFP9 - cursortoxml

An xsl is not the schema (while an xsd file is). The xsl is a style

sheet, that as you mention allows for a browser to pretty-print the xml.

To use an xsl style sheet, include a line like the following at the top

(after the <?xml version="..."?> tag) of the xml file:

<?xml-stylesheet type="text/xsl" href="your_xsl_file_here.xsl"?>

For example:

<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="simple.xsl"?>

<breakfast_menu>

<food>

<name>Belgian Waffles</name>

two of our famous Belgian Waffles

</description>

</food>

</breakfast_menu>

And the corresponding xsl:

<?xml version="1.0" encoding="ISO-8859-1"?>

<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns="" target="_blank">http://www.w3.org/1999/xhtml">

<body style="font-family:Arial,helvetica,sans-serif;font-size:12pt;

background-color:#EEEEEE">

<xsl:for-each select="breakfast_menu/food">

<xsl:value-of select="name"/></span>

- <xsl:value-of select="price"/>

</div>

<xsl:value-of select="description"/>

(<xsl:value-of select="calories"/> calories per serving)

</span>

</div>

</xsl:for-each>

</body>

</html>

>From http://w3schools.com/xml/xml_xsl.asp.

Now, show me the money! <g>

Eyvind.

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]

New Search