[ic] XML and Interchange?

Ton Verhagen ton@verhagen.net
Sat, 02 Dec 2000 09:18:54 +0100


The problem is in the white space. The xml-generator tag is very particular 
about white space.

Try this:
Put everything on one line except for [/query][/xml-generator]. They should 
be on the second line.
The [xm--param field] tags list should be separated by a tabs.

Good luck.

Ton

At 07:54 AM 12/2/00 +0900, you wrote:
>Thank you for your example. I tried something below.
>I am confusing now. Why case1 don't generate xml content?
>Case2 don't generate tags for each fields.
>
>I could not find any document or mail list about xml-generator user tag.
>Could you please tell me more description?
>
>
>
>{case1}
>[xml-generator type="delimited" toplevel_tag="products" field_names="sku
>title price"][query list=1 sql="select sku, title, price from products"
>prefix=xml][xml-param sku]     [xml-param title]       [xml-param price]
>[/query][/xml-generator]
>
>generates
>
><products>
>  </products>
>
>{case2}
> >>>>>This is an example of XML generator Interchange user tag.
>
>[xml-generator type="delimited" toplevel_tag="products" field_names="sku
>title price"][query list=1 sql="select sku, title, price from products"
>prefix=xml][xml-param sku]     [xml-param title]       [xml-param price]
>[/query][/xml-generator]
>
><BR>
>[xml-generator type="delimited" toplevel_tag="products" field_names="sku
>title price"][query list=1 sql="select sku, title, price from products"
>prefix=xml][xml-param sku]     [xml-param title]       [xml-param price]
>[/query][/xml-generator]
>
>generates
>
> >>>>>This is an example of XML generator Interchange user tag.
>
><products>
>  <record key="os28005    aaaaaaaaaaa 900">
>   <sku>os28005     aaaaaaaaaaa 900</sku>
>   <title></title>
>   <price></price>
>  </record>
>  <record key="os28113     bbbbbbbbbbbbbbb 1500">
>   <sku>os28113     bbbbbbbbbbbbbbb 1500</sku>
>   <title></title>
>   <price></price>
>  </record>
>  <record key="os28085      cccccccccccccccc 3700">
>   <sku>os28085     cccccccccccccccc 3700</sku>
>   <title></title>
>   <price></price>
>  </record>
>
>{deleted}
>
>
>----- Original Message -----
>From: Ton Verhagen <ton@verhagen.net>
>To: <interchange-users@minivend.com>
>Sent: Saturday, December 02, 2000 12:53 AM
>Subject: Re: [ic] XML and Interchange?
>
>
> > Try something like:
> >
> > [xml-generator type="delimited" toplevel_tag="products"
>field_names="sku
> > title price"][query list=1 sql="select sku, title, price from
>products"
> > prefix=xml][xml-param sku]     [xml-param title]       [xml-param
>price]
> > [/query][/xml-generator]
> >
> >
> >
> > At 11:42 PM 12/1/00 +0900, you wrote:
> > >I would like to export transaction and order data as XML file to our
> > >production system.
> > >Could you please let me know some example how to use
> > >[xml-generator]tags?
> > >
> > >I could not get xml output of products database.
> > >
> > >[loop more=1 search="ra=yes/tf=category/tf=title"]
> > >[list]
> > >[xml-generator type="values" values="sku title"][/xml-generator]
> > >[/list]
> > >[/loop]
> > >
> > >genetates below.
> > >
> > ><session>
> > >  <values>
> > >   <sku></sku>
> > >   <title></title>
> > >  </values>
> > ></session>
> > >
> > ><session>
> > >  <values>
> > >   <sku></sku>
> > >   <title></title>
> > >  </values>
> > ></session>
> > >
> > >  .
> > >
> > >I'm sorry but I could not understand description in xmg-generator
> > >usertag code.
> > >
> > >S.Murahashi
> > >
> > >----- Original Message -----
> > >From: Cameron B. Prince <cameron@akopia.com>
> > >To: <interchange-users@minivend.com>
> > >Sent: Thursday, November 30, 2000 6:07 AM
> > >Subject: RE: [ic] XML and Interchange?
> > >
> > >
> > > > We have a couple of catalogs that generate an XML log using the
> > >usertag.
> > > > A backend order processing system reads these files and imports
>the
> > >data.
> > > >
> > > > I have also heard of others using an XML file to be imported into
>a
> > >program
> > > > for EDI transmission.
> > > >
> > > > Good luck,
> > > >
> > > > Cameron
> > > >
> > > > -----Original Message-----
> > > > From: interchange-users-admin@minivend.com
> > > > [mailto:interchange-users-admin@minivend.com]On Behalf Of Bennett
> > > > Grassano
> > > > Sent: Wednesday, November 29, 2000 2:44 PM
> > > > To: interchange-users@minivend.com
> > > > Subject: [ic] XML and Interchange?
> > > >
> > > >
> > > > I recently came accross the usertag "xml_generator" and realized
>that
> > >this
> > > > seems to be the only utterance of XML in the archive. Is
>Interchange
> > > > compatible with XML or are they competing open standards? Is
>anyone
> > >out
> > > > there currently integrating XML and Interchange?   I know that
> > >interfaces
> > > > exist between Perl and XML but I'm having difficulty picturing
> > >Interchange
> > > > and XML working in concert.  Anyone else out there been wondering
>the
> > >same
> > > > thing?
> > > >
> > > >
> > > > _______________________________________________
> > > > Interchange-users mailing list
> > > > Interchange-users@www.minivend.com
> > > > http://www.minivend.com/mailman/listinfo/interchange-users
> > > >
> > > >
> > > > _______________________________________________
> > > > Interchange-users mailing list
> > > > Interchange-users@www.minivend.com
> > > > http://www.minivend.com/mailman/listinfo/interchange-users
> > > >
> > >
> > >
> > >_______________________________________________
> > >Interchange-users mailing list
> > >Interchange-users@www.minivend.com
> > >http://www.minivend.com/mailman/listinfo/interchange-users
> >
> >
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@www.minivend.com
> > http://www.minivend.com/mailman/listinfo/interchange-users
> >
>
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@www.minivend.com
>http://www.minivend.com/mailman/listinfo/interchange-users