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.

ImportFile on web site's XML

3 posts in XML Last posting was on 2008-02-14 17:47:06.0Z
Jonathan Posted on 2008-02-05 01:00:01.0Z
Reply-To: "Jonathan" <jonathan_leffingwell@hotmail.com>
From: "Jonathan" <jonathan_leffingwell@hotmail.com>
Newsgroups: sybase.public.powerbuilder.xml
Subject: ImportFile on web site's XML
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a7b511$1@forums-1-dub>
Date: 4 Feb 2008 17:00:01 -0800
X-Trace: forums-1-dub 1202173201 10.22.241.152 (4 Feb 2008 17:00:01 -0800)
X-Original-Trace: 4 Feb 2008 17:00:01 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1707
Article PK: 814281

I'm using PB 10.5, and I have a question about ImportFile:

I want to import an XML file from a web site instead of my local drive.In
the code below, importing from "localpath" works but importing from"webpath"
does not. How can I do it? Thanks!

int rc = 0
string webpath = "http://www.somewhere.com/xmlfile.xml"
string localpath = "C:\DATA\xmlfile.xml"

dw_1.setTransObject(SQLCA)rc = dw_1.ImportFile(XML!, localpath) //*** Works!

//rc = dw_1.ImportFile(XML!, webpath) //*** Doesn't work!

MessageBox("rc", "rc = " + String(rc))

P.S. I get an error along the lines of "cannot find
C:\DATA\http://www.somewhere.com/xmlfile.xml"

jonathan_leffingwell AT hotmail DOT com


Jonathan Posted on 2008-02-14 03:49:38.0Z
Reply-To: "Jonathan" <jonathan_leffingwell@hotmail.com>
From: "Jonathan" <jonathan_leffingwell@hotmail.com>
Newsgroups: sybase.public.powerbuilder.xml
References: <47a7b511$1@forums-1-dub>
In-Reply-To: <47a7b511$1@forums-1-dub>
Subject: Re: ImportFile on web site's XML
Lines: 26
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b3ba52$1@forums-1-dub>
Date: 13 Feb 2008 19:49:38 -0800
X-Trace: forums-1-dub 1202960978 10.22.241.152 (13 Feb 2008 19:49:38 -0800)
X-Original-Trace: 13 Feb 2008 19:49:38 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1712
Article PK: 814282

Anyone?

"Jonathan" <jonathan_leffingwell@hotmail.com> wrote in message
news:47a7b511$1@forums-1-dub...
> I'm using PB 10.5, and I have a question about ImportFile:
>
> I want to import an XML file from a web site instead of my local drive.In
> the code below, importing from "localpath" works but importing
> from"webpath" does not. How can I do it? Thanks!
>
> int rc = 0
> string webpath = "http://www.somewhere.com/xmlfile.xml"
> string localpath = "C:\DATA\xmlfile.xml"
>
> dw_1.setTransObject(SQLCA)rc = dw_1.ImportFile(XML!, localpath) //***
> Works!
>
> //rc = dw_1.ImportFile(XML!, webpath) //*** Doesn't work!
>
> MessageBox("rc", "rc = " + String(rc))
>
> P.S. I get an error along the lines of "cannot find
> C:\DATA\http://www.somewhere.com/xmlfile.xml"
>
> jonathan_leffingwell AT hotmail DOT com


Jim O'Neil [Sybase] Posted on 2008-02-14 17:47:06.0Z
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Newsgroups: sybase.public.powerbuilder.xml
Subject: Re: ImportFile on web site's XML
Message-ID: <qgv8r39j4tf68tjqs5ncqaksj4cqop8cfv@4ax.com>
References: <47a7b511$1@forums-1-dub> <47b3ba52$1@forums-1-dub>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 14 Feb 2008 09:47:06 -0800
X-Trace: forums-1-dub 1203011226 10.22.241.152 (14 Feb 2008 09:47:06 -0800)
X-Original-Trace: 14 Feb 2008 09:47:06 -0800, vip152.sybase.com
Lines: 32
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1713
Article PK: 814286

I'm pretty sure ImportFile doesn't support URLs. What about using the
Inet object to issue the GetURL and then use ImportString on the
resulting content (which would be the XML)?

On 13 Feb 2008 19:49:38 -0800, "Jonathan"

<jonathan_leffingwell@hotmail.com> wrote:

>Anyone?
>
>"Jonathan" <jonathan_leffingwell@hotmail.com> wrote in message
>news:47a7b511$1@forums-1-dub...
>> I'm using PB 10.5, and I have a question about ImportFile:
>>
>> I want to import an XML file from a web site instead of my local drive.In
>> the code below, importing from "localpath" works but importing
>> from"webpath" does not. How can I do it? Thanks!
>>
>> int rc = 0
>> string webpath = "http://www.somewhere.com/xmlfile.xml"
>> string localpath = "C:\DATA\xmlfile.xml"
>>
>> dw_1.setTransObject(SQLCA)rc = dw_1.ImportFile(XML!, localpath) //***
>> Works!
>>
>> //rc = dw_1.ImportFile(XML!, webpath) //*** Doesn't work!
>>
>> MessageBox("rc", "rc = " + String(rc))
>>
>> P.S. I get an error along the lines of "cannot find
>> C:\DATA\http://www.somewhere.com/xmlfile.xml"
>>
>> jonathan_leffingwell AT hotmail DOT com