topic Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load? in QlikView

is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

sherazade — Thu, 20 Oct 2011 11:33:36 GMT

Hi I wrote TWO documents :

- one loads data from a local file ( binary x:\dir\xxx.qwv) when the user is connected to the intranet

- one loads the same data from a binary ftp://user:pwd@ftp.site.com/xxx.qwv when the user id connected via internet

is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

Tue, 29 May 2012 08:36:04 GMT

hi,

do you got any solution on this ?

Thanks in advance.

Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

Tue, 29 May 2012 08:46:39 GMT

Hi rav,

Try this:

if filetime('x:\dir\xxx.qvw') then

//local load

else

//ftp load

endif

Regards,

Xue Bin

Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

sherazade — Tue, 29 May 2012 09:15:33 GMT

uhmmmmm since binary load must be first statement of the script this solution doesn't work?

Date: Tue, 29 May 2012 04:46:42 -0400

From: qliktech@sgaur.hosted.jivesoftware.com

To: alsailor@hotmail.com

Subject: - Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

QlikCommunity

Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load? created by jackyxuebin in Development (QlikView Desktop) - View the full discussion

Hi rav,

Try this:

if filetime('x:\dir\xxx.qvw') then

//local load

else

//ftp load

endif

Regards,

Xue Bin

Reply to this message by replying to this email -or- go to the message on QlikCommunity

Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity

Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

sherazade — Tue, 29 May 2012 09:16:09 GMT

not yet.... I did change from binary load to loading a qvd sigh

Date: Tue, 29 May 2012 04:36:14 -0400

From: qliktech@sgaur.hosted.jivesoftware.com

To: alsailor@hotmail.com

Subject: - Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load?

QlikCommunity

Re: is it possible to create a script looking IF the LOCAL file ( i.e. x:\dir\xxx.qwv) is available to execute the binary load or - otherwise - execute the FTP load? created by rav 1234 in Development (QlikView Desktop) - View the full discussion

hi,

do you got any solution on this ?

Thanks in advance.

Reply to this message by replying to this email -or- go to the message on QlikCommunity

Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity