Scroll

Invert & Reload task

Invert & Reload task

Follow
Summary This article describes how to invert & reload a task in askiavista.
Applies to askiavista
Written for Data processor
Keywords invert; reload; vista; askiavista

Table of contents:


I. 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.

II. QES survey

askiavista's \AskiaQes\ should be the same as that used by your askiafield's CCA.

1. 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

2. 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 are stored in *.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.



III. 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.

1. 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



2. Survey's SQL ID

Now, check the survey's CCA's Properties' General TAB, and write down its ID number.



3. 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

4. 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 are 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.

Have more questions? Submit a request

Comments