topic How can I sort this folder ? in Qlik NPrinting

How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 11:09:04 GMT

Hi,

i am stuck with this problem.

Hope some one can help me on this pls.

My scenario is I have to generate reports in nprinting for 28 organisations

Each organisation should have File1 to File 5. either as PDF or Excel format.

At present ,I am generating the report for 5 files by cycling 28 organisations.

Now my client is going on all these files fetching file 1 to File 5 for all the organisations which is time consuming.

We want to produce a 28 pack of organisations that should have all these files with in it which is easy to go through.

How can output the File 1 to File 5 to all the respective organisations.

Any help is highly appreciated.

Regards,

Vamsi.

Re: How can I sort this folder ?

RonaldDoes — Fri, 09 Jun 2017 12:06:03 GMT

Hi Vamsi,

If you use dynamic naming of the reports, you kan compose the filenames yourself, for example:

"[date yyyymmdd] [cycle group (company name)] 1.pdf"

"[date yyyymmdd] [cycle group (company name)] 2.pdf"

"[date yyyymmdd] [cycle group (company name)] 3.xls"

"[date yyyymmdd] [cycle group (company name)] 4.pdf"

"[date yyyymmdd] [cycle group (company name)] 5.xlsx"

Is that what you're looking for?

Re: How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 12:36:57 GMT

Hi,

Thanks for your reply.

I have created 28 folders for all the organisations , Each folder should have these files.File 1 to File5

Is that possible with the dynamic naming?

Re: How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 12:40:57 GMT

I have tried outputting 5 files to 28 folders by using custom folders.

It is running the task but stuck with this error.

Re: How can I sort this folder ?

RonaldDoes — Fri, 09 Jun 2017 12:46:31 GMT

Hi Vamsi,

Sure, just add a Custom text with a number or letter to the front of each report name.

Re: How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 12:52:54 GMT

Hi,

I am sorry i didnt get that.

Can you explain how does it do that?

Re: How can I sort this folder ?

RonaldDoes — Fri, 09 Jun 2017 13:00:31 GMT

Well, you have n folders, one for each company, right?

Within each folder, you put 5 separate (xls/pdf) reports, but want to sort the reports so that they appear in some specific order.

My suggestion changes the name into:

1 blah.xls
2 blahblah.pdf
3 blah2.xls
4 really_important.xls
5 checkthisout.pdf

by adding custom text to the dynamic naming of the report.

Re: How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 13:07:09 GMT

Ok I understood that.

But why i am getting error when i am using custom folder in the pic attached.

Re: How can I sort this folder ?

RonaldDoes — Fri, 09 Jun 2017 13:17:15 GMT

Do you maybe have a company name with special characters in it, or a really long name that exceeds the file/pathlenght your system supports?

Re: How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 13:31:01 GMT

Ok .

Well I have used the recepient folder with the output to given path. its working fine now.

Now my challenge is how can I place all these files in one excel file with 5 sheets .

Any ideas ronald.

Re: How can I sort this folder ?

RonaldDoes — Fri, 09 Jun 2017 13:36:46 GMT

So some of your reports are currently in PDF, but should be in an Excel file?

Create a new Excel report and add your various fields to the corresponding sheets of the Excel report?

There is no way to combine multiple reports in NPrinting into one report without rebuilding it.

Re: How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 13:45:56 GMT

I have a mixture of excel , Pdf and png files. all clubbed into an excel file with sheets .

So it will be easy for all the organisations . only file is going with many sheets . easy to read.

No idea if i can able to do that.

Re: How can I sort this folder ?

Anonymous — Fri, 09 Jun 2017 14:26:58 GMT

Oops!!

I have given the recipient folder and output the folder path.

I have run the task and cycle through the organisation and expecting those files to the respective folders.

But i am seeing all the files in the one organisation.

What am i doing wrong?

Re: How can I sort this folder ?

Anonymous — Fri, 16 Jun 2017 14:10:50 GMT

Hi ronald,

Can I insert every file into the One Excel file having respective sheets like sheet 1 to sheet 5.

How can I able to do that?

regards,

vamsi.,

Re: How can I sort this folder ?

RonaldDoes — Fri, 16 Jun 2017 14:20:37 GMT

Create a new Excel report and add your various fields to the corresponding sheets of the Excel report?

There is no way to combine multiple reports in NPrinting into one report without rebuilding it.

Re: How can I sort this folder ?

Anonymous — Fri, 16 Jun 2017 14:51:13 GMT

Can you please explain of adding fields to the corresponding sheets of the excel report.

I didnt get that how to do it on nprinting.

Re: How can I sort this folder ?

RonaldDoes — Fri, 16 Jun 2017 14:54:02 GMT

Hi Vamsi,

Try out How to Create Excel Reports

Re: How can I sort this folder ?

Anonymous — Fri, 16 Jun 2017 15:35:40 GMT

Hi,

Accidentally i stumbled across your point and i got reply from you.

Thats brilliant.

My only apphrension is I have different filters for each report . how can i add this and how does the system take it.