Alaska Software Inc. - How to download DBF-files via WAA-server
Username: Password:
AuthorTopic: How to download DBF-files via WAA-server
DieterHow to download DBF-files via WAA-server
on Mon, 25 Sep 2006 20:57:41 +0200
Hello
normally the dbf-files hosted by a waa-server are located in an area, where 
the (remote-)users dont have direct access.
Is there a possibility to build a Xbase++-function to download a dbf-file 
via the WAA-Server to the client-station, where is running the 
internet-explorer?
thanks for help. Dieter
Vladimir IahnencoRe: How to download DBF-files via WAA-server
on Tue, 26 Sep 2006 15:18:27 -0400
Dieter,
I think you may create a function with will copy required dbf to a web 
shared folder and then you may redirect the user to that folder and file.
Regards,
Vladimir

"Dieter" <q@aa.de> wrote in message 
news:5470e5e4$5768ec9d$9e15a@news.alaska-software.com...
> Hello
> normally the dbf-files hosted by a waa-server are located in an area, 
> where the (remote-)users dont have direct access.
> Is there a possibility to build a Xbase++-function to download a dbf-file 
> via the WAA-Server to the client-station, where is running the 
> internet-explorer?
> thanks for help. Dieter
>
DieterRe: How to download DBF-files via WAA-server
on Tue, 26 Sep 2006 23:07:22 +0200
Hi Vladimir,

all the binary functions and copy functions are disabled when using the 
waa-server. Further I dont know, how my provider map the directories on his 
physical server. So I cannot copy a file, because I dont know to what place.
Dont you have another idea?
regards
Dieter

"Vladimir Iahnenco" <iahnenco@yahoo.com> schrieb im Newsbeitrag 
news:5e883b73$3afe5545$aa3f0@news.alaska-software.com...
> Dieter,
> I think you may create a function with will copy required dbf to a web 
> shared folder and then you may redirect the user to that folder and file.
> Regards,
> Vladimir
>
> "Dieter" <q@aa.de> wrote in message 
> news:5470e5e4$5768ec9d$9e15a@news.alaska-software.com...
>> Hello
>> normally the dbf-files hosted by a waa-server are located in an area, 
>> where the (remote-)users dont have direct access.
>> Is there a possibility to build a Xbase++-function to download a dbf-file 
>> via the WAA-Server to the client-station, where is running the 
>> internet-explorer?
>> thanks for help. Dieter
>>
>
>
Vladimir IahnencoRe: How to download DBF-files via WAA-server
on Tue, 26 Sep 2006 18:17:28 -0400
If your dbf files not big ones, you may try to use them on the server, 
export to xml string and return  xml with WAA response. But you have to 
write a kind of client, to download and convert back to dbf.

Regards,
Vladimir

"Dieter" <q@aa.de> wrote in message 
news:24336117$65c74a76$aa45c@news.alaska-software.com...
> Hi Vladimir,
>
> all the binary functions and copy functions are disabled when using the 
> waa-server. Further I dont know, how my provider map the directories on 
> his physical server. So I cannot copy a file, because I dont know to what 
> place.
> Dont you have another idea?
> regards
> Dieter
>
> "Vladimir Iahnenco" <iahnenco@yahoo.com> schrieb im Newsbeitrag 
> news:5e883b73$3afe5545$aa3f0@news.alaska-software.com...
>> Dieter,
>> I think you may create a function with will copy required dbf to a web 
>> shared folder and then you may redirect the user to that folder and file.
>> Regards,
>> Vladimir
>>
>> "Dieter" <q@aa.de> wrote in message 
>> news:5470e5e4$5768ec9d$9e15a@news.alaska-software.com...
>>> Hello
>>> normally the dbf-files hosted by a waa-server are located in an area, 
>>> where the (remote-)users dont have direct access.
>>> Is there a possibility to build a Xbase++-function to download a 
>>> dbf-file via the WAA-Server to the client-station, where is running the 
>>> internet-explorer?
>>> thanks for help. Dieter
>>>
>>
>>
>
>
DieterRe: How to download DBF-files via WAA-server
on Wed, 27 Sep 2006 13:51:56 +0200
Vladimir,
of course it is possible to send the data in any a DBF-file via HTML to any 
internet browser. From there of course it is possible to cut and paste it to 
an excel-sheet. From there it is possible export the data to an dbf-file. 
But things like this is not want I want. I want to download the dbf-file.
Does anybody has an idea, how it is possible?
Dieter


"Vladimir Iahnenco" <iahnenco@yahoo.com> schrieb im Newsbeitrag 
news:75a81f51$657376d9$aa7c5@news.alaska-software.com...
> If your dbf files not big ones, you may try to use them on the server, 
> export to xml string and return  xml with WAA response. But you have to 
> write a kind of client, to download and convert back to dbf.
>
> Regards,
> Vladimir
>
> "Dieter" <q@aa.de> wrote in message 
> news:24336117$65c74a76$aa45c@news.alaska-software.com...
>> Hi Vladimir,
>>
>> all the binary functions and copy functions are disabled when using the 
>> waa-server. Further I dont know, how my provider map the directories on 
>> his physical server. So I cannot copy a file, because I dont know to what 
>> place.
>> Dont you have another idea?
>> regards
>> Dieter
>>
>> "Vladimir Iahnenco" <iahnenco@yahoo.com> schrieb im Newsbeitrag 
>> news:5e883b73$3afe5545$aa3f0@news.alaska-software.com...
>>> Dieter,
>>> I think you may create a function with will copy required dbf to a web 
>>> shared folder and then you may redirect the user to that folder and 
>>> file.
>>> Regards,
>>> Vladimir
>>>
>>> "Dieter" <q@aa.de> wrote in message 
>>> news:5470e5e4$5768ec9d$9e15a@news.alaska-software.com...
>>>> Hello
>>>> normally the dbf-files hosted by a waa-server are located in an area, 
>>>> where the (remote-)users dont have direct access.
>>>> Is there a possibility to build a Xbase++-function to download a 
>>>> dbf-file via the WAA-Server to the client-station, where is running the 
>>>> internet-explorer?
>>>> thanks for help. Dieter
>>>>
>>>
>>>
>>
>>
>
>
Thomas Braun
Re: How to download DBF-files via WAA-server
on Thu, 28 Sep 2006 13:49:49 +0200
Dieter wrote:

> But things like this is not want I want. I want to download the dbf-file.
> Does anybody has an idea, how it is possible?

To do a download, you need a server, a client and a protocol for the
download process.

As Vladimir already told you, the easiest way is to use a http-download
which is very convenient because all current browsers (and web servers)
support this and you do not need to install any additional client software
on the target machine or on the server side of the connection.

Any other method would need greater effort:

- Developing server side process 
- Developing client side application
- Distributing application to the client PC
- Training of users on the client side

I think it should be easier to talk to the internet provider how to solve
this problems...

> all the binary functions and copy functions are disabled when using the 
> waa-server.

Not sure what you are meaning by this?

> Further I dont know, how my provider map the directories on his 
> physical server. So I cannot copy a file, because I dont know to what place.

Ask your ISP!

regards,
Thomas
Hubert Brandel Re: How to download DBF-files via WAA-server
on Mon, 06 Nov 2006 16:25:01 +0100
Hi,

I do not use the WAA-Adapter, but plain CGI, so I do not know if this 
helps, but to send a file back to the requester (normaly a website 
calling a cgi program -> could be a waa-dll) a CGI EXE gives it back 
over STDOUT to the WWW-Server, which sends it to the requester.
With LoadFromUrl() you should be able to write the requester part too.

In this example it is a PDF, DBF should use maybe Phils ZIP class and
build a ZIP an send a ZIP, because a ZIP will know if the tranfer was 
correct. But you can try with other mimetype as well (octecstream ...)

#define CRLF chr(13)+chr(10)
cPDF := memoread(::cKundenPfad+cPDFFileName)  Datei einlesen
cTxt := "Content-type: application/pdf"+CRLF+;
         "Content-length: "+STR(len(cPDF))+CRLF+;
         "Content-disposition: attachment; "+;  NO CRLF
         "filename="+cPDFFileName+CRLF+CRLF+;
         cPDF
FWrite( FH_STDOUT , cTxt )

Bye
Hubert

----------------

Ich empfehle:  www.xbaseforum.de  (in deutsch)

Homepage:

German  - www.familie-brandel.de/index.htm
English - www.familie-brandel.de/index_e.htm
Olaf870Re: How to download DBF-files via WAA-server
on Thu, 24 May 2007 17:38:16 +0200
Hubert,
I tried to download a dbf-file with your method and with firefox, but I 
didn?t get any result.
Which mime-typ a have to use?
regards
Olaf870

"Hubert Brandel" <Hubert.Brandel@gmx.de> schrieb im Newsbeitrag 
news:750fa464$3424d35c$1d8a2f@news.alaska-software.com...
> Hi,
>
> I do not use the WAA-Adapter, but plain CGI, so I do not know if this 
> helps, but to send a file back to the requester (normaly a website calling 
> a cgi program -> could be a waa-dll) a CGI EXE gives it back over STDOUT 
> to the WWW-Server, which sends it to the requester.
> With LoadFromUrl() you should be able to write the requester part too.
>
> In this example it is a PDF, DBF should use maybe Phils ZIP class and
> build a ZIP an send a ZIP, because a ZIP will know if the tranfer was 
> correct. But you can try with other mimetype as well (octecstream ...)
>
> #define CRLF chr(13)+chr(10)
> cPDF := memoread(::cKundenPfad+cPDFFileName)  Datei einlesen
> cTxt := "Content-type: application/pdf"+CRLF+;
>         "Content-length: "+STR(len(cPDF))+CRLF+;
>         "Content-disposition: attachment; "+;  NO CRLF
>         "filename="+cPDFFileName+CRLF+CRLF+;
>         cPDF
> FWrite( FH_STDOUT , cTxt )
>
> Bye
> Hubert
>
> -- 
> ----------------
>
> Ich empfehle:  www.xbaseforum.de  (in deutsch)
>
> Homepage:
>
> German  - www.familie-brandel.de/index.htm
> English - www.familie-brandel.de/index_e.htm