Donwload multiple documents from multiple BOs

srufini

Hello,

I would like to download the document attribute of many BO as result of a quey

this is the process code:

RULE1: PICK FROM Milestones

RULE 2:
FIND Deliverables WHERE Deliverables.Milestone=ThisAppointment
DOWNLOAD DOCUMENT Deliverables.Doc_Version.PDF

but it downloads only one PDF document.
I tried using OtherDeliverables.Doc_Version.PDF without success, still just one.
I also try to move the command DOWNLOAD DOCUMENT to another subprocess, but no success as well.

How can I feed the DOWN DOC with all the result of my query? It woul dhave been nice to use FOR EACH but is not applicable.

somebody mentioned also creating a zip file first, but I understood you need a plugin and I would like to avoid that path for now.

Thanks

Sergio

kklosson

Use the test log to see how many items are found in the query.

srufini

kklosson wrote
Use the test log to see how many items are found in the query.

Hi kklosson,

many thanks for the quick reply!

I used the debugger and the test log and I can confirm all the results of the query are put in context:

I have 4 results in my query.
In the debugger I can see that:
1 result goes to ThisDeliverable
1 result goes to ThatDeliverable
last 2 results are assigned to OtherDeliverable

so they are in the context but the command DOWNLOAD DOCUMENT is exectuted only on one.

cheers

Sergio

aware_support

Hard to say without knowing what's in your document and what you want to achieve.

However, you can merge PDF documents in one - check out the DISPLAY DOCUMENT action in the Rule Language Guide. You should find an option to merge documents. Maybe it can be a solution to your problem.

srufini

Hi,

documents are PDF files only. I want the user to to download them all at once as separate files on the user computer.

Unfortunately, merging them is not a solution for me.

I tried a simplier approach:

I created a process DownloadDataPackage with only one line

DOWNLOAD DOCUMENT Doc_Version.PDF

The in the user Query of deliverable I let manually select the user the deliverables that I want to download and added in Top Bar a start process command with multiple selection and call to process DownloadDataPackage.

It should have been starightforward, but unfortunately still only one document pdf is downloaded.

It is a limitation in the DOWNLOAD DOCUMENT command ? (DISPLAY DOCUMENT also open just one window).

Cheers

Sergio

aware_admin

What if for the sake of experiment, you create a process with several DISPLAY DOCUMENT actions = one after the other.

DISPLAY DOCUMENT ...
DISPLAY DOCUMENT ...
...

This should work in theory. If it does, maybe you can somehow use it - for example, if each DISPLAY DOCUMENT can be associated with a condition you could have something like:
IF Condition1 Holds
DISPLAY DOCUMENT ...
IF Condition2 Holds
DISPLAY DOCUMENT ...

etc

srufini

Hi,

I did use a;ready
DOWNLOAD DOCUMENT ThisDeliverable....
DOWNLOAD DOCUMENT ThatDeliverable...
DOWNLOAD DOCUMENT OtherDeliverable...

and it worked but only 3 times. Being result on 4 BO, and 2 are "Other" ( confirmed in the debugger) I was hoping that last DOWNLOAD would run 2 times.

You suggest I should use a counter of query result and decrease for each iteration of the IF cycle?

Moreover, I tried EXPORT DOCUMENT, this works on many documents at the same time, unfortunately is saves them on the server drive (no workaround, right?)

Cheers

Sergio

aware_admin

A workaround with EXPORT may work. Yes, it exports to the server drive only, but you can export into the web application folder or a sub-folder, where these files become accessible by the browser. So then they can be downloaded to the client by a Javascript that can run at the end of the process

srufini

ok,

the path seems clear, even if it seems cannot be solved in the zero-code fashion.
i don't have javascript capabilities for now (waiting for an extra colleague to help for this but will take some months).
I believe the best approach is to download in a temp folder of the server and create a zip file.
Then use DISPLAY DOCUMENT xxx.zip to download the zip.

I saw this mentioned in the forum several times, but not sure how to implement.
Is there a guide/how to on how to use 7zip to compress a folder via AwareIm command ?

Thanks

Sergio

kklosson

Can you configure a report rather than a document?

srufini

no, these are attachment files from different sources.

aware_support

If you know the command line of the zip tool you can use the EXECUTE action to execute it. I

We will make a note to either allow downloading multiple documents or add a zipper command to our list of actions.

srufini

Thanks support,

that will be very useful, not only for me I believe.

In the meantime I managed to make it work.
HERE MY SOLUTION FOR THE RECORDS:

I installed the 7-zip on the server
Added in the PATH enviromental Variable of windows the path of the installation folder of 7-zip
Created the Process (using Session variables for the path and filename) with following rules:

RULE 1:
MySession.TempPath=SystemSettings.RepositoryPath+'temp\'+REPLACE_PATTERN(ThisAppointment.Subject, ' ', '_')+'\'
MySession.TempFileName=SystemSettings.RepositoryPath+'temp\'+REPLACE_PATTERN(ThisAppointment.Subject, ' ', '_')+'\'+REPLACE_PATTERN(ThisAppointment.Subject, ' ', '_')+'_'+AS_STRING(CURRENT_DATE)+'.7z'
RULE 2:
EXECUTE PROGRAM '7z a '+MySession.TempFileName+' '+MySession.TempPath
RULE 3:
IMPORT DOCUMENT MySession.tempfile FROM MySession.TempFileName
DISPLAY DOCUMENT MySession.tempfile IN WINDOW
RULE 4:
DELETE FILE MySession.TempPath
DELETE MySession.TempFileName
DELETE MySession.tempfile

IMPORTANT!: z-zip will mess around if there are spaces in the file path or file name, so I had to substitute them with underscore.

Cheers

Sergio