Publié Sun, 10 Feb 2019 11:06:39 GMT par David Miguel Trujillo

Hello everyone, 

I would like to know how could I obtain the number of pages of a document in DW Cloud, I tried trough a Workflow but I cant find any global variable that contains the number of pages, 

Thanks in advance, David.

Publié Sun, 10 Feb 2019 13:22:05 GMT par Josef Zayats

David,

here is how this can be achieved using AutoIndex Job.

Make sure you know name of your File Cabinet database table (here we use fctable) and your Filecabinet has a numeric field to accept docuement total pages(doctotalpages)

Create an AIX job - I recommend scheduled job with selection criteria 'doctotalpages is empty'

On Match Data Tab - Configure Data Source, select connection GUID_autoindex, SQL Command, type in the following statement

select docid,sum(totalpages) as doctotalpages from fctable_sec group by docid

Match FIlefd : Doc ID is equal docid

Assign Data: doctotalpages - Field - doctotalpages

Run the job - it should fill you doctotalpages column with total number of pages for the document.

 

 

Publié Wed, 13 Feb 2019 10:12:26 GMT par David Miguel Trujillo

Great Josef it works!

Thanks a lot for your help, it's very well explained, 

Best regards, David.

You must be signed in to post in this forum.