Report rule creates doc attachment - no file in FTP

Hi,

The feature to save report PDF files in Docman only supports the Database repository. Is there some reason you want to keep this files on a FTP server?

/Mathias

@Mathias Dahl 

For us yes, FTP became a necessity because the document repository size was causing backups to take so long it was outside our maintenance window tolerance.

Hi,

Yes, database size become a problem for some customers with large volumes of document files, depending on backup and recovery strategy and Oracle competence.

You don't have a choice in this case though. What you can do is to keep these reports in a specific class which uses the Database repository and then regularly (depending on how fast your database grows because of these reports) move the documents to your FTP repository. It's a fairly simple process that you initiate manually but which then runs in the background until done.

Thanks!

/Mathias

Hello Mathias,
Thanks for your reply.
The reason we want to keep this on a FTP server is that the PDF document + other documents connected to the customer invoice, must be transfered to other applications (for example, Neotouch : a French mail supplier which have an OCR to scan invoices, pack/print them and send that to the postal address). Therefore, it is required to have these documents available from those applications in an FTP repository.
 

Thanks, I suspected as much :-)

Then you have two options: either take the manual approach I outlined above, or to make a small modification, or possibly configuration, to move the files from the database to the FTP. Most probably a custom even can do it (= configuration, even though you need to write some PL/SQL code), using PL/SQL APIs that we use ourselves for the “manual” move. You should look into what we do in Edm_File_API.Execute_Batch_Transfer, and the code that follows.

Good luck!

/Mathias

This is good info to know.  Thanks, there is no problem splitting out certain documents to a particular class and managing them differently, it is the ‘knowing’ that it needs to be done that way that is the problem.