Data Capture
Track and share from anywhere. Secure and configurable platform-optimised apps turn any smart device into a powerful data entry system. Connect all your enterprise business systems with intelligent, context-sensitive tools, ensuring clean & valid data every time.
Use the Sharperlight Excel® Addin to bulk load data or the Web-Channel to capture data in a browser.
- Configure Data sends and writeback operational data into solutions using secured and configurable Interface layer
- Capture data on mobiles and tablets using configurable Web forms, from basic forms to custom advanced Java script support
- Enter data using enhanced tools like ADE that extend Excel® to deliver touch screen data entry
Sharperlight has a Writeback window available from its Excel Add-in, that can source worksheet data and write this data back through a Datamodel to a target system. Datamodel authors decide if Writebacks will be available in a Datamodel and they control the validate and operation of the Writeback. The Writeback form simplifies the selection of feeder cell ranges and it allows Writeback templates to be saved and reused.
The Sharperlight Writeback interface in Microsoft Excel saves the column and row layout of a Writeback in the workbook. These templates can then be reused and executed using macro buttons. Active Data Entry (ADE) also uses these Writeback templates to assist with the worksheet data entry, it can pop-up valid codes and automate the flow of manual input.
Active Data Entry uses the cell referencing and the field order in the Writeback template, and it adds its own layer of settings to navigate worksheet data entry. There are settings to skip columns (in cases where formulas are used to calculate the input values) and the default lookup can be disabled for direct input. The common practice of taking workbooks out of the office and disconnected from the Sharperlight Service is also handled in ADE, lookup lists are cached locally in the workbook and they will continue to work even if the Sharperlight XL Add-in is not logged in.
To further enhance the Active Data Entry experience, there is a navigation bar with movement buttons which can be used instead of the keyboard movement arrows. This is particularly useful with Windows Tablets, that rely on a virtual keyboard.
Use the Sharperlight Web-Channel to writeback data using the predefined definitions in the Datamodel.
Create forecasts, collect budgets and update data for new Sharperlight solutions built in Foundry.
Sharperlight provides a full data cycle, capture and reporting.
Components found in Data Capture
Data Capture uses the Writeback features of any datamodel and are accessible using the Sharperlight XL addin or through the Web-Channel. Writebacks are created in Studio, Foundry or Materialised Query and Scheduler can automatically query and call and writeback.
