PDF to XFDF to EDT Comments/ Annotations

Hello, I have a mental block on this one. I write engineering reports, PDF them and issue them to my clients. They will take a PDF report and annotate lots of comments (sticky notes, highlighter, strikethrough, etc), and send the report back to me. I need to take these comments and write them up in Excel and then write responses to them. I can export these comments from the PDF to XFDF (XML Forms data Format) and take the XFDF into EDT for transformation (I tried “Use schema” for the first time and it was great cutting out a whole lot of unnecessary columns and aligning what I needed for processing). So I now have nearly everything working great. What I’m missing is I have a count of the total number of comments on a PDF page, and I would like to create a column numerating each comment per PDF page. So I want to go from the first figure, to include the red-highlighted column in the second figure. Any help appreciated. Thanks in advance.



EDT PDF XFDF Extraction.csv (2.1 KB)

Total will do it.

total.transform (2.2 KB)

2 Likes

@Admin was faster :grinning:

here the same with your data and remove of temporary data …
Comment numbering.transform (3.1 KB)

2 Likes

Crikey. I was messing about with Offset and Fill trying to see if I could fill incrementally.
Don’t think I’ve used Total before, so simple, and a wee revelation.
Many thanks everyone.

1 Like