Attribute Extraction

Video - XL Upload - Advanced

XL-Upload can extract the document attributes from Microsoft Office (Word, Excel and PowerPoint) files and PDF files in addition to AutoCAD DWG files. To use this feature, the attribute mapping needs to be set up in XL-Upload. The attribute mapping will map the fields on the attribute block to the fields.

AutoCAD Attribute Mapping

To set up attribute mapping for DWG files:

  1. Open XL-Upload from the desktop.

  2. Select Attribute Mapping from the XL-Upload menu.

  3. Click the field name that you wish to map.

  4. Enter AutoCAD Attribute values in the text box corresponding to the field name in the CAD title block for eg. DocumentNo Field name correlates to DRW_NO in the CAD title block.

  5. Click Update after each entry, once completed select OK.

  6. Add files to XL-Upload Spreadsheet then select Extract Attributes.

  7. Based off the attributes mapped data will be populated in XL-Upload.

PDF Attribute Mapping

If you have a number of PDF files that have document attributes such as Document No, Title, Rev etc. in a consistent location (E.g. based off the same title block), you can now use XL-Upload to read these attributes directly from the PDF files. 

To extract the attributes:

  1. Open XL-Upload from the desktop.

  2. From the XL-Upload menu, select Defaults.

  3. Set the Attribute Extraction method for PDF files to PDF Text Extraction, select OK.

  4. From the XL-Upload menu, select More, Define PDF Attribute Regions.

  5. List the coordinates from which the attributes need to be extracted for each field and paper size. This can be defined directly using a sample file.

  6. Select Define Co-ordinates using PDF file and open one of the PDF files.

  7. Draw a rectangle to mark the Field Names. Update for each Field Name until completed.

  8. Select OK.

  9. All Attributes marked will now be listed, select OK.

     

  10. From the XL-Upload menu add the pdf files and then Extract Attributes.

  11. From the attributes mapped data will be populated in XL-Upload.

See also:

XL Upload - Basic Video