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 records of data using 1 XML File with different structure in the same file

3 posts in XML Last posting was on 2008-05-19 18:26:03.0Z
Alfredo Santibáñez Posted on 2008-05-18 21:12:58.0Z
Reply-To: "Alfredo Santibáñez" <asantibanez@ng.co.cr>
From: "Alfredo Santibáñez" <asantibanez@ng.co.cr>
Newsgroups: sybase.public.powerbuilder.xml
Subject: Import records of data using 1 XML File with different structure in the same file
Lines: 30
Organization: RMO-NKG
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48309bda$1@forums-1-dub>
Date: 18 May 2008 14:12:58 -0700
X-Trace: forums-1-dub 1211145178 10.22.241.152 (18 May 2008 14:12:58 -0700)
X-Original-Trace: 18 May 2008 14:12:58 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1740
Article PK: 767919

Hi, I need help finding a way to import records in our database from an XML
file that contains, in the same file, different type of data. I would
like something like fill different data sources and then process them.

For example, 1 file contains invoice headers and invoice details in a
structure like:

<invoice>
<Id>1</Id>
<Customer>01</Customer>
</invoice>
..
more invoices
...
and then,
<details>
<Id>1</Id>
<ProductID>P01</ProductID>
<Quantity>01</Quantityr>
</details>
..
more details.
...

Thanks for any help,
Regards

Alfredo Santibáñez


Bruce Armstrong [TeamSybase] Posted on 2008-05-19 16:58:23.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.xml
References: <48309bda$1@forums-1-dub>
Subject: Re: Import records of data using 1 XML File with different structure in the same file
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4831b1af$1@forums-1-dub>
Date: 19 May 2008 09:58:23 -0700
X-Trace: forums-1-dub 1211216303 10.22.241.152 (19 May 2008 09:58:23 -0700)
X-Original-Trace: 19 May 2008 09:58:23 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1741
Article PK: 767921

Two datawindows (or the same datawindow) with two different XML import
schemas. Import the file and then save to the database.

"Alfredo Santibáñez" <asantibanez@ng.co.cr> wrote in message
news:48309bda$1@forums-1-dub...
> Hi, I need help finding a way to import records in our database from an
> XML file that contains, in the same file, different type of data. I
> would like something like fill different data sources and then process
> them.
>
> For example, 1 file contains invoice headers and invoice details in a
> structure like:
>
> <invoice>
> <Id>1</Id>
> <Customer>01</Customer>
> </invoice>
> ..
> more invoices
> ...
> and then,
> <details>
> <Id>1</Id>
> <ProductID>P01</ProductID>
> <Quantity>01</Quantityr>
> </details>
> ..
> more details.
> ...
>
> Thanks for any help,
> Regards
>
> Alfredo Santibáñez
>
>


Alfredo Santibáñez Posted on 2008-05-19 18:26:03.0Z
Reply-To: "Alfredo Santibáñez" <asantibanez@ng.co.cr>
From: "Alfredo Santibáñez" <asantibanez@ng.co.cr>
Newsgroups: sybase.public.powerbuilder.xml
References: <48309bda$1@forums-1-dub> <4831b1af$1@forums-1-dub>
Subject: Re: Import records of data using 1 XML File with different structure in the same file
Lines: 49
Organization: RMO-NKG
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4831c63b@forums-1-dub>
Date: 19 May 2008 11:26:03 -0700
X-Trace: forums-1-dub 1211221563 10.22.241.152 (19 May 2008 11:26:03 -0700)
X-Original-Trace: 19 May 2008 11:26:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1742
Article PK: 814297

Thanks for your answer, I used in the past for export, did not know it would
work for import and it would skip records not associated with template.

Regards
Alfredo


"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
escribió en el mensaje news:4831b1af$1@forums-1-dub...

> Two datawindows (or the same datawindow) with two different XML import
> schemas. Import the file and then save to the database.
>
> "Alfredo Santibáñez" <asantibanez@ng.co.cr> wrote in message
> news:48309bda$1@forums-1-dub...
>> Hi, I need help finding a way to import records in our database from an
>> XML file that contains, in the same file, different type of data. I
>> would like something like fill different data sources and then process
>> them.
>>
>> For example, 1 file contains invoice headers and invoice details in a
>> structure like:
>>
>> <invoice>
>> <Id>1</Id>
>> <Customer>01</Customer>
>> </invoice>
>> ..
>> more invoices
>> ...
>> and then,
>> <details>
>> <Id>1</Id>
>> <ProductID>P01</ProductID>
>> <Quantity>01</Quantityr>
>> </details>
>> ..
>> more details.
>> ...
>>
>> Thanks for any help,
>> Regards
>>
>> Alfredo Santibáñez
>>
>>
>
>