Not Pulling in All the Text

[mda1125]

Using Adobe DC on a MacOS
Saved as txt
The script runs without any errors

INFO:root:Total lines: 50061
INFO:root:Written Rows: 16

When I open it in Excel it's nicely formatted but 16 rows? Not sure why it's stopping short.

Text file looks good

Excel file looks great but incomplete
CSV file starts great and then just dumps to text as if the lines are broken

Using the CIS Microsoft Windows Server Benchmark 1.4.0.pdf

[mda1125]

I did download the older version that matches what's listed here

CIS_Microsoft_Windows_Server_2016_RTM_Release_1607_Benchmark_v1.1.0.txt

INFO:root:Total lines: 32672
INFO:root:Written Rows: 39

It didn't match what I see as the benchmarks Total lines or Written Rows here.. figured maybe it was a newer version of the CIS PDF that changed something but it doesn't seem to work with the original archived one

[mda1125]

It's because the 1.1 sections.. if they have any WRAPPING on them from the export from Adobe, it gets skipped. There's no options in Adobe Acrobat DC to select UFT-8 and it might be something CIS did with the PDF anyway.

Fix for me has been to go thru and upwrap the lines for the CIS # sections so that at least it gets imported. The descriptions, rationate and such seem to come over and you can work some magic with Excel or Google Sheets

But if there is a wrap on the CIS #... then it can get skipped entirely

[justin376802]

Can confirm this issue also occurs in CIS Google Chrome Benchmark v3.0.0.pdf. Removed wrap-around for this file:
CIS_Google_Chrome_Benchmark_v3.0.0_no_wrap_around.txt