Creating Document Based Load Files from Page Based Load Files

Do the following steps to create a document based .opt file:

    1. In the production LOADFILES folder, locate the VOL001.lexbeloadfile.xlsx file.

      1. Create a copy of this file (by selecting it and then doing a Crtl+C followed by Crtl+V).

      2. Open the new file “VOL001.lexbeloadfile - Copy.xlsx” in Excel by double clicking on it.

    2. Delete all columns except for:

      1. BEGDOC

      2. PAGES

      3. VOLUME

      4. PDFPATH

    1. The resulting Excel should look similar to this:

Untitled.png

    1. Add the following formula to cell E2:

=A2&","&C2&","&SUBSTITUTE(D2,"\PDF\","PDF\")&",Y,,,"&B2

    1. Copy down the formula (by dragging the bottom right hand corner of the cell) so there is a formula for every row with data.

Untitled.png

    1. The resulting Excel should look similar to to this:

    2. Open a new file in NotePad. Copy and Paste the data content of the E column into this new file.

    3. The resulting NotePad should look similar to this:

Untitled 2.png

9. Save the NotePad file in the Production LOADFILES folder as VOL001.PDF.opt