topic Export Table box to Text File in QlikView

Export Table box to Text File

Wed, 09 Mar 2016 09:52:12 GMT

Hi All,

I have to export a table box from qlikview to Text file.For that i am using the macros.

'--------------------------

' Export QC Chart Routine

'-------------------------

sub ExportChart

output_dir="\\ntb\QlikView$\"

Filename="DataFile.txt"

set obj = ActiveDocument.GetSheetObject("CH01")

obj.Export (output_dir & Filename) , "|"

end sub

This is working fine in My local machine.

But i have to export the file to another server machine,which i have a UID and PWD through which i can login.

How can i achieve that?

I think i have to modify the script in such a way that the UID and PWd is specified.

Please suggest.

Thanks in adavance

Regards,

Reena

Re: Export Table box to Text File

kaushiknsolanki — Wed, 09 Mar 2016 09:58:39 GMT

Hi,

Macros are not supported in Browser.

Check this link.

Re : Macro Not working In Accesspoint

Regards,

Kaushik Solanki

Re: Export Table box to Text File

Kushal_Chawda — Wed, 09 Mar 2016 10:24:58 GMT

Create the shared folder on destination server machine. Now put this shared folder path in Macro (Output directory).

Re: Export Table box to Text File

Wed, 09 Mar 2016 11:12:57 GMT

Hi,

I don't need to publish this dashboard.This qvw is only required for exporting the file to txt and placing the file in the destination.

Re: Export Table box to Text File

petter — Wed, 09 Mar 2016 12:19:02 GMT

Macros are supported in the browser. But not all functionality is available. Please read the QlikView Reference Manual and it will clarify things for you.

Re: Export Table box to Text File

kaushiknsolanki — Wed, 09 Mar 2016 12:22:38 GMT

Thanks Petter I will make a note of this.

Regards,

Kaushik Solanki

Re: Export Table box to Text File

petter — Wed, 09 Mar 2016 12:25:39 GMT

You can use this:

Add a shared network drive mapping.

Syntax 
objNetwork.MapNetworkDrive(strLocalDrive, strRemoteShare, [persistent], [strUser], [strPassword]) 

Key 
objNetwork     : A WScript.network object 
strLocalDrive  : The drive letter (e.g. L:) 
strRemoteShare : The UNC path to the remote drive
\\MyServer\MyPrinter (String value)  
persistent     : True/False - store the mapping persistently in the users
profile default = false  
strUser        :  The user name. (Optional) 
strPassword    :  The password. (Optional)

Example

Dim objNetwork, strRemoteShare
Set objNetwork = WScript.CreateObject("WScript.Network")
strRemoteShare = "\\myserver\users"
objNetwork.MapNetworkDrive "H:", strRemoteShare, False, "userid", "passw"

This is taken from: ss64 . com /vb/mapnetworkdrive.html

Re: Export Table box to Text File

Tue, 15 Mar 2016 04:27:27 GMT

Hi Petter,

Could you please explain more?

How should i modify the script with this?