Veröffentlicht Sun, 10 Feb 2019 11:06:39 GMT von 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.

Veröffentlicht Sun, 10 Feb 2019 13:22:05 GMT von 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.

 

 

Veröffentlicht Wed, 13 Feb 2019 10:12:26 GMT von David Miguel Trujillo

Great Josef it works!

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

Best regards, David.

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.