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.

Importing XML string using ImportString

3 posts in XML Last posting was on 2003-07-29 16:08:33.0Z
Hari Posted on 2003-07-29 14:52:07.0Z
Sender: 57dc.3f26887b.1804289383@sybase.com
From: Hari
Newsgroups: sybase.public.powerbuilder.xml
Subject: Importing XML string using ImportString
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f268a17.5838.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Jul 2003 07:52:07 -0700
X-Trace: forums-1-dub 1059490327 10.22.241.41 (29 Jul 2003 07:52:07 -0700)
X-Original-Trace: 29 Jul 2003 07:52:07 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:170
Article PK: 813239

Hi,

I wish to import an XML string into a datawindow. Am able to
do this with a string of only around 30 kbs. Any size
greater than this fails.

I would need to be able to import a string as large as 500
kbs. Will appreciate any help / suggestions.


Paul Horan[TeamSybase] Posted on 2003-07-29 15:25:12.0Z
From: "Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom>
Newsgroups: sybase.public.powerbuilder.xml
References: <3f268a17.5838.846930886@sybase.com>
Subject: Re: Importing XML string using ImportString
Lines: 25
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: vcimail.vcisolutions.com
X-Original-NNTP-Posting-Host: vcimail.vcisolutions.com
Message-ID: <3f2691d8$1@forums-1-dub>
Date: 29 Jul 2003 08:25:12 -0700
X-Trace: forums-1-dub 1059492312 66.103.10.5 (29 Jul 2003 08:25:12 -0700)
X-Original-Trace: 29 Jul 2003 08:25:12 -0700, vcimail.vcisolutions.com
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:171
Article PK: 813241

What's the error message when it fails? Are you sure that the larger file parses correctly, and matches the import
template?

In the Data Import tab, you can turn on XML import logging. That may help shed some light on the error.

--
Paul Horan[TeamSybase]
VCI Springfield, MA
www.vcisolutions.com

Techwave2003 is coming!
http://www.sybase.com/techwave2003
PWB515 - Introduction to Source Code Control with PB9

<Hari> wrote in message news:3f268a17.5838.846930886@sybase.com...
> Hi,
>
> I wish to import an XML string into a datawindow. Am able to
> do this with a string of only around 30 kbs. Any size
> greater than this fails.
>
> I would need to be able to import a string as large as 500
> kbs. Will appreciate any help / suggestions.


7/29 Posted on 2003-07-29 16:08:33.0Z
Sender: 5c1b.3f26995c.1804289383@sybase.com
From: Hari (7/29)
Newsgroups: sybase.public.powerbuilder.xml
Subject: Re: Importing XML string using ImportString
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f269c01.5c86.846930886@sybase.com>
References: <3f2691d8$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Jul 2003 09:08:33 -0700
X-Trace: forums-1-dub 1059494913 10.22.241.41 (29 Jul 2003 09:08:33 -0700)
X-Original-Trace: 29 Jul 2003 09:08:33 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:172
Article PK: 813243

Hi Paul,

Thanks a bundle for your help. I used 'FileOpen' in a loop
and got the entire file into a string variable. I was then
able to 'ImportString' that variable into a datawindow
without a hitch!