topic Re: Need help on Macro which is used for Exporting into .CSV format..! in QlikView

Need help on Macro which is used for Exporting into .CSV format..!

Anonymous — Mon, 31 Aug 2015 13:58:57 GMT

Hi Experts,

According to our Project Requirement we have to Export one Table Box into .CSV file..

which is working fine in Desktop and Exporting to .CSV file , but when we are reloading the application in QMC the .CSV file is not generated...

please check the below macro which we are using, and let us know incase of any changes

SUB ExportObjectToCSV

SET sObject = ActiveDocument.GetSheetObject("TB02")

sObject.Export "D:\QlikView_Dev\UserDocuments\DOB\New folder\DOB1.CSV", ", "

END SUB

and did some settings in the QMC like 1) allow unsafe macros ,2) allow macros in the QMC and

3) ctrl+shift+m - tick on radio button for give system access to module script

4) and tried by giving the server name before the path - \\ servername\D:\QlikView_Dev\UserDocuments\DOB\New folder\DOB1.CSV", ", ".

none of the above are working...

please help us to solve this issue as it is very imp to implement...

thanks in advance..

Regards

Anusha

Re: Need help on Macro which is used for Exporting into .CSV format..!

petter — Mon, 31 Aug 2015 14:05:12 GMT

The path that looks like:

\\servername\D:\QlikView_Dev\UserDocuments\DOB\New folder\DOB1.CSV

Will never work - since this is not a valid UNC-path - it has to look like this:

\\<servername>\D$\QlikView_Dev\UserDocuments\DOB\New folder\DOB1.CSV

Or simply:

D:\QlikView_Dev\UserDocuments\DOB\New folder\DOB1.CSV

But make sure that there is a D-drive on the server with this entire directory tree. Since you just copy it from a client PC structure it might not exist ...

Re: Need help on Macro which is used for Exporting into .CSV format..!

Anonymous — Mon, 31 Aug 2015 15:30:03 GMT

hi petter , thanks for ur quick response...

tried with this path also \\<servername>\D$\QlikView_Dev\UserDocuments\DOB\New folder\DOB1.CSV.

getting error while checking the macros in the edit module like " cannot open file " \\<servername>\D$\QlikView_Dev\UserDocuments\DOB\New folder\DOB1.CSV " for writing....

regards

anusha

Re: Need help on Macro which is used for Exporting into .CSV format..!

petter — Mon, 31 Aug 2015 15:49:17 GMT

That is my point exactly - you will have to validate that that there is proper access rights to the folder and that the folder and the file really exists. The error message confirms more or less that there is no error in QlikView or the Macro but rather file system access...

Re: Need help on Macro which is used for Exporting into .CSV format..!

Anonymous — Tue, 01 Sep 2015 05:14:11 GMT

hi petter , thanks again

in QMC am reloading the application in the following way - QMC --> Documents --> user Documents ----> Reload..

in our QMC we don't find Source Document Option in Documents Folder - is this kind of any access issue ?...

can you please elaborate more on the Access related issues....

Regards

Anusha

Re: Need help on Macro which is used for Exporting into .CSV format..!

jagan — Tue, 01 Sep 2015 05:40:07 GMT

Hi Anusha,

I think you do not have access to the path which you are referring, try creating a file or updating in that path with the user which you are using for Qlikview server.

Regards,

Jagan.

Re: Need help on Macro which is used for Exporting into .CSV format..!

petter — Tue, 01 Sep 2015 06:08:25 GMT

If you mean the "Source Documents" in QMC it is only available and created if you have installed and licensed the QlikView Publisher. Publisher will load a source document (QlikView application) from the Source Document folder and distribute it by creating a task in the QMC that has been specified to execute a "distribution".

Re: Need help on Macro which is used for Exporting into .CSV format..!

petter — Tue, 01 Sep 2015 06:10:10 GMT

This is not really related or dependent on the issue you have ... The important thing is to make sure that the service account that the QlikView Server or if you are using the QlikView Publisher - has the necessary folder and file access rights to the folders that you are using in your Macro.