How to extract data from Enterprise Resource Planning (ERP) software with WebSnip

Learn how to use WebSnip Extension to capture evidence from your client’s portal for data reconciliation.

About WebSnip Extension

Seamlessly extract and validate data from web pages. WebSnip Extension increases the credibility of your evidence by capturing the URL and timestamp of your screenshot and syncing them directly to your Excel Desktop. By eliminating manual steps and third-party apps, you can now quickly import data, reduce the chance of human error, and create consistency in data capturing and documentation from web pages.

Prerequisites

  • DataSnipper version 6.0 or later
  • DataSnipper or Private OCR
  • DataSnipper Enterprise package
  • Chrome or Edge Browser

Step-by-step Guide

Before you begin, ensure that the toggle "Sync Snips to Excel" is turned on.Screenshot 2024-08-15 143447

  1. Open your Excel workbook on your desktop where you want the data to be extracted.
  2. Choose an empty cell where you'd like the data to be placed.
  3. Go to your web browser and navigate to the ERP containing the data you want.Screenshot 2024-08-15 143740
  4. Click on the WebSnip Extension icon in your ribbon. This will bring up the Snipping toolbar at the bottom of your screen.
    1. You can select Text, Validation, Exception, Sum, or Table Snips to extract data.Recording 2024-08-15 at 14.39.47
  5. Use the Sum Snip from the Snipping toolbar to select the data you want to extract by drawing a rectangle around it.Recording 2024-08-15 at 14.42.07
  6. WebSnip will automatically capture the selected data and transfer it directly to your Excel workbook.
  7. Return to your Excel workbook to view the extracted data in the chosen cell.Screenshot 2024-08-15 144444
  8. The Document Viewer will display additional information, including a screenshot of the captured evidence, the URL of the webpage, and the timestamp of the extraction.
  9. The extracted data and source evidence are now cross-referenced in your Excel workbook on your desktop.