Opening an AskiaField task in AskiaAnalyse

This command, found on the file menu, allows you to open AskiaField data held in a SQL database. You will then be able to create charts and containing this data and export questions, but note that you will not be able to create variables. When you select the command, the following dialog appears:

Complete the fields as follows, then click OK.

• Connection to AskiaField database: Enter the DSN for the AskiaField CCA database. Examples:

  • dsn=askia_cca;

  • "Provider=sqloledb; Data Source=MATTVAIOSQLEXPRESS; Initial Catalog=CCA;Trusted_Connection=yes"
    
    Once you have entered an appropriate connection string, a list of the surveys at that location will be available in the surveys list.
    
    Note: If you specify the DSN here, then it is possible to create a variable from agent names, using the feature from interview information in the create variable dialog.

• Surveys: Select the survey task you want to open.

  Note that this list will be empty until you enter the appropriate DSN in connection to AskiaField database, whereupon the surveys list will be populated with the available surveys in the call centre database (the list is retrieved from the dbo.Surveys table).

  When you select a survey here, the fields Askia file, Survey ID and Uses SQL server will be automatically populated.

• Askia file: Type the path and file name of the QES file here, or click ... and select the QES file. Note that the pathname must refer to a local drive, or to a "mapped" drive on your network.

• Connection to surveys database: Specify the SQL connection string (DSN, password, etc.) to the surveys database. For example:

  "Provider=sqloledb; Data Source=MATTVAIOSQLEXPRESS; Initial Catalog=Surveys;Trusted_Connection=yes"

• Survey ID: Enter the Survey ID, as configured in AskiaField CCA. If you do not know the ID, you can obtain it by examining the survey task properties in AskiaField Supervisor or AskiaField CCA.

• Uses SQL server: Select this check-box if your data is stored on the SQL server (as specified on the relevant task). If, on the other hand, your data is stored in the QES, then ensure this box is not selected.