Invert & reload a task in AskiaVista
Summary | This article describes how to invert & reload a task in AskiaVista |
Applies to | AskiaVista |
Written for | Data processor |
Keywords | invert; reload; vista; askiavista |
Introduction
AskiaVista allows for near real-time data analysis for surveys conducted using AskiaField data collection solutions1, via the use of Scheduled Tasks.
As AskiaField enables you to collect data either in the native QES file format or in SQL, AskiaVista allows for specifying the source-type of the data.
If you don't remember whether your survey is collecting data in SQL or QES, you just need to log onto the CCA (via Supervisor), and in the Tasks view the relevant survey's Properties. On the General TAB, if Uses SQL Server is ticked, then the data is being collected in SQL. If unselected, it means the data is being collected in QES; specifically, in the QES indicated in the Path field of this same survey's Properties' General TAB.
Here below is a review of how to load your QES and/or SQL surveys onto AskiaVista for near real-time data analysis.
QES survey
AskiaVista's \AskiaQes\ should be the same as that used by your AskiaField's CCA.
Add survey
- Log onto AskiaVista.
- Go to Admin-view's Surveys Tab.
- Right-click and select Add Survey.
- Browse for the exact same QES file as that referenced on the survey's Path property in the CCA.
Add scheduled task
Now go to Configuration, Scheduled Tasks Management
Right-click and select New, and fill in the details - for example:
- Name: InvertReload _my survey_
- Type: Invert and reload survey
- Execute: Every day
- Hour: 03:00
- Survey: *my survey*
- Data storage: The data is stored in the QES file
- Timeout (in ms): 0
Click OK to save this scheduled task . . .
Now, upon creating a new scheduled task, AskiaVista immediately launches it via its AVTM component.
The Invert & Reload we just created will generate a .DAT folder for the survey, or update the .DAT if one already existed.
SQL survey
We recommend that AskiaVista's \AskiaQes\ be the same as that used by your AskiaField's CCA. In case it is not, you will need to manually get a copy of the AskiaField's CCA's QES, and paste it into AskiaVista's @\AskiaQes\ folder.
CCA SQL info
First, you will need your AskiaField's CCA's SQL connection string to its Surveys DB. The exact connection string can be found on the CCA server's Windows Registry keys2:
HKEY_LOCAL_MACHINE\SOFTWARE\Peter Holmes\Cca\SurveyDB\Connection
Survey's SQL ID
Now, check the survey's CCA's Properties' General Tab, and write down its ID number.
Add survey
- Log onto AskiaVista.
- Go to Admin-view's Surveys Tab.
- Right-click and select Add Survey.
- Browse for the survey's QES file.
Add scheduled task
Now go to Configuration, Scheduled Tasks Management.
Right-click and select New, and fill in the details - for example:
- Name: InvertReload _my survey_
- Type: Invert and reload survey
- Execute: Every day
- Hour: 03:00
- Survey: my survey
- Data storage: The data is stored in SQL Server
- Connection string: paste the SQL connection string copied in step II.1. above@
- Id of survey: paste the survey ID copied in step II.2. above
- Timeout (in ms): 0
Click Test to make sure the SQL connection is working.
Click OK to save this scheduled task.
Now, upon creating a new scheduled task, AskiaVista immediately launches it via its AVTM component.
The Invert & Reload we just created will create a .DAT folder for the survey, or update the .DAT if one already existed.
Notes:
1 AskiaFace, AskiaVoice and/or AskiaWeb.
2 Contact your AskiaField Administrator if required.