topic Re: By using nprinting in qlik we can export data into Excel Automatically in Qlik NPrinting

By using nprinting in qlik we can export data into Excel Automatically

Mon, 10 Jul 2017 09:17:32 GMT

Hi,

By using nprinting in qlik we can export data into Excel Automatically

Is it Posiible?

Thanks,

Kumar.V.

Re: By using nprinting in qlik we can export data into Excel Automatically

Ruggero_Piccoli — Mon, 10 Jul 2017 09:33:50 GMT

Yes, Qlik NPrinting is designed to export data from QlikView and Qlik Sense to Excel.

Please refer to the official help site to find more details Excel reports ‒ Qlik NPrinting. In the help site you will find also training videos.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: By using nprinting in qlik we can export data into Excel Automatically

Mon, 10 Jul 2017 09:41:06 GMT

Hi Ruggero,

What i need daily bases I need to Export data to Excel Automatically not Manually,

Please Suggest me how to do,

Best Regards,

Kumar.V.

Re: By using nprinting in qlik we can export data into Excel Automatically

Ruggero_Piccoli — Mon, 10 Jul 2017 09:48:20 GMT

Refer to the chapter Scheduling reports of the help site at the page Scheduling reports ‒ Qlik NPrinting.

I strongly suggest you to check the official Qlik NPrinting help site. It covers all these topics.

Best Regards,

Ruggero

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

Re: By using nprinting in qlik we can export data into Excel Automatically

vinod_nallapaneni — Mon, 10 Jul 2017 10:32:45 GMT

Hi Kumar,

Which connection you are using currently for your app local or server connection? If you are connected through server connection the it easy to export your data automatically. Recommended you to refer this for server connection. Hope this will help.

Good Luck.

-Vinod.

Re: By using nprinting in qlik we can export data into Excel Automatically

vvvvvvizard — Mon, 10 Jul 2017 10:34:39 GMT

Yes

Re: By using nprinting in qlik we can export data into Excel Automatically

vvvvvvizard — Mon, 10 Jul 2017 10:35:36 GMT

You will add the object ID to the report template excel file , and you can schedule the report to automatically export the data directly

Re: By using nprinting in qlik we can export data into Excel Automatically

Mon, 10 Jul 2017 10:53:46 GMT

Hi Vinod,

I am using Qliksense Server Connection 3.2 Version , But I need Daily Basis Automatically Export data to Excel,

Please tell me How to achive this thing

Thanks,

Kumar.V

Re: By using nprinting in qlik we can export data into Excel Automatically

vinod_nallapaneni — Mon, 10 Jul 2017 11:03:09 GMT

Hi kumar,

You can assign a trigger in Tasks--> publish task--> click on task --> Triggers --> Create trigger

-Vinod.

Re: By using nprinting in qlik we can export data into Excel Automatically

Lech_Miszkiewicz — Tue, 11 Jul 2017 00:05:37 GMT

Hi Kumar,

can evaluate your question? Please. What do you exactly mean by "Export data to excel"? Does it mean export datamodel to excel, export source qliksense table to excel? or what? be precise!

I am under impression that you would like to export on daily basis your RAW data as you constanltly repeat " Export data to Excel" phrase which i assume is different than export QlikSense / QlikView object table to Excel.

All above answers are based on an assumption that your data will be in one of the visualisation objects ( say: straight table). This also mean that your data will have an aggregate applied or will be shown as a distinct line in your table which may not be what you want.

provide more details and we will take it from there

cheerse

Lech

Re: By using nprinting in qlik we can export data into Excel Automatically

Tue, 11 Jul 2017 04:37:09 GMT

Hi,

Export app (Table) from qlik sense server to Excel Automatically on daily Basis.

Best Regards,

Kumar

Re: By using nprinting in qlik we can export data into Excel Automatically

Lech_Miszkiewicz — Tue, 11 Jul 2017 04:41:31 GMT

Mate ...

put a screenshot of your table here - without detailed information we will not be able to help you.

your explanation is too vage

cheers

Lech

Re: By using nprinting in qlik we can export data into Excel Automatically

Tue, 11 Jul 2017 05:07:12 GMT

Hi cheers,

I need daily basis automatically export data from Published App in Qliksense to Excel.

Thanks,

Kumar.

Re: By using nprinting in qlik we can export data into Excel Automatically

Lech_Miszkiewicz — Tue, 11 Jul 2017 05:21:41 GMT

Ok thanks - all clear

this is a process you need to do:

Go to NPrinting Admin Console and create a App - this will be just a App with a connection to your Qlik Sense application which has a table you presented above Creating a new app ‒ Qlik NPrinting
once app is created - you need to create connection to this app Creating connections ‒ Qlik NPrinting
once connection is created you need to go to report and create new Excel Report Developing reports ‒ Qlik NPrinting - then edit a template
- when you are editing template that is where yopu are pointing to your QlikSense table and chosing columns you want to export
- please refer to help document how to do it Creating Excel reports ‒ Qlik NPrinting
Once you are done with report you need to create "Publish Task" Managing tasks ‒ Qlik NPrinting
- In publish task you follow step-by step instruction to attach your report to it as well as setting recipients, destination and what you really want a daily trigger Creating a new app ‒ Qlik NPrinting (go to trigger part)

voila

cheers

Lech

This is not a process which we can describe in few words. Building whole thing may take you a day if you are doing it first time. Once you are more familiar with how NPrinting works it will take you less and less time

Re: By using nprinting in qlik we can export data into Excel Automatically

Tue, 11 Jul 2017 05:45:11 GMT

Hi Lech,

I tried this thing yesterday but here there is no Nprinting App here and

Qlik Sense Extension for NPrinting 17 On-Demand

also tried but we need NPrinting Server host name here this is Also not Available.

That's why i am asking any other possibility is there to Achieve,

Thanks,

Kumar.

Re: By using nprinting in qlik we can export data into Excel Automatically

Lech_Miszkiewicz — Tue, 11 Jul 2017 06:00:18 GMT

Did you actualy buy NPrinting? It is not part of QlikSense - It is separate product which you install on server (usualy dedicated server). It requires separate license and very strict requirements need to be applied when you install it.

Do you have NPrinting Installed and configured?

If the answer to above is "Yes" then:

Can you explain this:

"I tried this thing yesterday but here there is no Nprinting App here and"

Where you do not have app? You need to create App!! according to this:

Can you explain step by step which of my bulletpoints is not working for you?

and First of all:

what version of NPrinting are you using
is NPrinting installed and configured properly based on detailed help document
- make sure you read everything in regards to service account running NPrinting service
provide as much screenshots as possible of what you are doing. Your explanations are very vage and it is extremly difficult to understand what you want to do

happy to help - but we need your help here to, to understand your problem.