Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Import

3 posts in XML Last posting was on 2003-09-04 12:13:30.0Z
Victor Habib Posted on 2003-06-26 15:44:52.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Victor Habib" <zzz@ggg.com>
Subject: Import
Date: Thu, 26 Jun 2003 11:44:52 -0400
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 136.181.195.9
Message-ID: <373_uCR12r$ODHA.356@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:145
Article PK: 813220

I want to import an xml file that has a nested detail element. I have
successfully created an export template that exports from a flattened table.
I cannot use this template for import because it only imports the detail
part of the datawindow. (the elements below 'starts detail')

Is there a way to import such an xml file, or do I need
to code the import with PBDOM?

Thanks.


Roy Kiesler [TeamSybase] Posted on 2003-06-27 14:22:16.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Roy Kiesler [TeamSybase]" <SPAM_FREE_roy.kiesler@teamsybase.com>
Subject: Re: Import
Date: Fri, 27 Jun 2003 10:22:16 -0400
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: host131.percussion.com 208.252.62.131
Message-ID: <373_ednHciLPDHA.185@forums-2-dub>
References: <373_uCR12r$ODHA.356@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:147
Article PK: 813217

Have you tried implementing group headers in your XML template?

--
<hopethishelps/>
Roy Kiesler [TeamSybase]
SDN CodeXchange -- http://codexchange.sybase.com

"Victor Habib" <zzz@ggg.com> wrote in message
news:uCR12r$ODHA.356@forums-2-dub...
> I want to import an xml file that has a nested detail element. I have
> successfully created an export template that exports from a flattened
table.
> I cannot use this template for import because it only imports the detail
> part of the datawindow. (the elements below 'starts detail')
>
> Is there a way to import such an xml file, or do I need
> to code the import with PBDOM?
>
> Thanks.
>
>


Patrick OLIVERI Posted on 2003-09-04 12:13:30.0Z
From: "Patrick OLIVERI" <oliveri_patrick@hotmail.com>
Newsgroups: sybase.public.powerbuilder.xml
References: <373_uCR12r$ODHA.356@forums-2-dub> <373_ednHciLPDHA.185@forums-2-dub>
Subject: Re: Import
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: porta04.segi.ulg.ac.be
Message-ID: <3f572cb8$1@forums-2-dub>
X-Original-Trace: 4 Sep 2003 05:14:48 -0700, porta04.segi.ulg.ac.be
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 Sep 2003 05:11:16 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 Sep 2003 05:13:30 -0700
X-Trace: forums-1-dub 1062677610 10.22.108.75 (4 Sep 2003 05:13:30 -0700)
X-Original-Trace: 4 Sep 2003 05:13:30 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:187
Article PK: 813257

Hello all,

I have an XML file wich looks like this :

<?xml version="1.0" encoding="ISO-8859-1"?><shiporder orderid="889923"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="shiporder.xsd">
<orderperson>John Smith</orderperson>
<shipto>
<name>Ola Nordmann</name>
<address>Langgt 23</address>
<city>4000 Stavanger</city>
<country>Norway</country>
</shipto>
<item>
<title>Empire Burlesque</title>
<note>Special Edition</note>
<quantity>1</quantity>
<price>10.90</price>
</item>
<item>
<title>Hide your heart</title>
<quantity>1</quantity>
<price>9.90</price>
</item>
</shiporder>

I just want ot import it in a datawindow a get this

orderperson name adress city
country title note
quantity price
John Smith Ola Nordmann Langgt 23 4000 Stavanger Norway
Empire Burlesque Special Edition 1 10.90
John Smith Ola Nordmann Langgt 23 4000 Stavanger Norway
Hide your heart 1 9.90


right now i can only get THIS

orderperson name adress city
country title note
quantity price

Empire Burlesque Special Edition 1 10.90

Hide your heart 1 9.90


or THIS (but with an error in the second row)
orderperson name adress city
country title note
quantity price
John Smith Ola Nordmann Langgt 23 4000 Stavanger Norway
Empire Burlesque Special Edition 1 10.90

Hide your heart 1 9.90



How to get what I want ?


Thanks