Download Extracting the Data

Transcript
CleverQ™ Extractors Manual
The Data Package - Excel Extractor (DPXE) File ................................................ 35
Creating a New DPXE File ................................................................................... 36
Starting the DPXE................................................................................................. 36
CleverQ Data Format ............................................................................................ 37
Templates .............................................................................................................. 37
Extracting Data ..................................................................................................... 40
Viewing Extracted Data ........................................................................................ 40
Viewing the Log ................................................................................................... 41
Automating the Extraction .................................................................................... 41
Adding a Source to the Data Load ............................................................................ 41
Keeping History ........................................................................................................ 44
Automatic Loading ................................................................................................... 44
QBD Merge ....................................................................................................................... 44
Extracting the Data ........................................................................................................... 47
Extract Now on the Navigator .................................................................................. 47
Schedule Extraction .................................................................................................. 47
Using the Data................................................................................................................... 47
Viewing Extracted Data Using the PivotGrid ................................................................... 49
Sorting ........................................................................................................................... 50
Filtering ......................................................................................................................... 50
Grouping ....................................................................................................................... 52
Expanding and Collapsing Groups ............................................................................... 53
Printing.......................................................................................................................... 54
Exporting....................................................................................................................... 54
Copyright © 2008-2012, CleverQ
Patent Pending
Designed for use with QuickBooks®
QuickBooks® is a trade mark and service mark of Intuit Inc., registered in the United
States and other countries.
Microsoft Excel® and Microsoft Access® are trademarks and service marks of
Microsoft., registered in the United States and other countries
CleverQ is a trade mark and service mark of CleverQ and Better Days Enterprises, LLC