You are ing to use the email notification (by trigger) and exporting variables to a txt file.

Requirements:

  • PC Client or MFP Client
  • Random Testing document
  • Email server
  • Northwind Database (Copy it to your C‐Drive, somewhere)
  • AD server
  • There must be an existing user with an email address defined

How to do:

  1. Create a new workflow with the name: “Scan to MyCRM” (note that ‘MyCRM’ is just a random name)
  2. Drag a client capture module (PC client or MFP based on the used client)
  3. Create Selected question with a SQL‐based item list:
    1. Question/Buttonname: Customer
    2. Variable: CUSTOMER
    3. Item list:
      1. Name: nwind customers
      2. Type: SQL
      3. Connection string: Use the button to create it. Use “Microsoft Jet 4.0 OLE DB
      4. Provider”‐driver and the location where you copied the database.
      5. At the SQL‐query, click the (3‐dots) button and select “Customers”
      6. Select Column Displayed: CompanyName
      7. Select Column Returned: CustomerID
  4. Drag the “Windows File System” Connector and configure it with the following settings:
    1. Folder: CutputScanToMyCRM
    2. Filename: Document %YY%‐%MM%‐%DD% %HH24%.%NN%.%SS%.%FFF%
  5. As output profile we select a normal PDF, so not a Searchable PDF (edit the default selected output profile and uncheck OCR)
  6. Drag the Data Export module and configure it with the following settings:
    1. Export all variables: unchecked
    2. Contents:
      1. CustomerId=%CUSTOMER%
    3. Folder: CutputScanToMyCRM
    4. Filename: Document %YY%‐%MM%‐%DD% %HH24%.%NN%.%SS%.%FFF%
  7. Add a Mail trigger on the Windows File System route with the following settings:
    1. From: test@mail.com
    2. To: %USEREMAIL%
    3. Subject: Your document was processed
    4. Body:
    5. Your document with the following details was processed: Filename: Document %YY%‐%MM%-%DD% %HH24%.%NN%.%SS%.%FFF%.pdf The document will be imported automatically into MyCRM.
  8. Make sure “User Single Sign On” in Users section is enabled with at least 1 AD profile enabled (AD users require to have the email address set as well otherwise variable will be empty)
  9. Save the settings

Now you can use the PC Client or the MFP client to import or scan a document to the workflow “Scan to MyCRM”.

There will be a PDF and a TXT created. There are a lot of applications that supports importing files by using a TXT of XML file with the additional information. The workflow will also send an email to the user who scanned the document.