Field management

Extraction of data

Data may be extracted at any time from the CallWeb data base and formatted for use with popular data analysis software. CallWeb can create:

  • four data files:
    • a comma-delimited file suitable for use in Excel (.csv extension);
    • a fixed-column file suitable for use in statistical data analysis software like SPSS, SAS, StatXP and R (.dat extension);
    • a tab-delimited file suitable for re-population of a CallWeb data base (.tcw extension);
    • a comma-delimited file of the open-end parts along with the associated question name and _telkey (.opn extension).
  • five program statement files:
    • an SPSS code file for reading the fixed-column data file, including the assignment of variable and value labels (.sps extension);
    • an R code file for reading the fixed-column data file, including the assignment of variable labels and variable formats (.r extension);
    • a SAS code file for reading the fixed-column data file, including the assignment of variable labels and variable formats (.sas extension);
    • an ASCQUE instruction file for the creation of a VoxCo Interviewer questionnaire which can then be converted to a StatXP format for reading the fixed-column data file, including the assignment of long labels and category labels (.asc extension);
    • a Classic 1.1 Triple-S instruction file (.sss extension).
    • an XML Triple-S 2.0 instruction file (.ssx extension).
    • a Stata code file for reading the fixed-column data file, including the assignment of variable labels and variable formats (.stt extension);
  • and a copy of the CallWeb question (.scw file).

The cwExtr (which stands for Extraction) tool is called from the integrated interface. cwExtr compresses the files it extracts into a zip archive. It either sends this zip file by e-mail to the address identified in # Send extractions to or it leaves the extraction on the server. The destination is selected in the cwExtr parameter interface.

In database-to-database mode (requested from the integrated interface, cwExtr can copy data from one CallWeb data base directly into another CallWeb data base. The source and destination data bases can reside in separate servers but they can also be in different instances of CallWeb on a single server or in the same CallWeb instance. In this mode, new data records can be added to the destination data base and existing data records can be updated with the data in the source data base. It is possible to select only a subset of fields to be transferred but system fields (the name of which starts with an underscore) are always transferred. All fields selected for transfer from the source data base must exist in the destination data base but the data base structure may differ between the two CallWeb projects otherwise.

Field management

Extraction of data

Data may be extracted at any time from the CallWeb data base and formatted for use with popular data analysis software. CallWeb can create:

  • four data files:
    • a comma-delimited file suitable for use in Excel (.csv extension);
    • a fixed-column file suitable for use in statistical data analysis software like SPSS, SAS, StatXP and R (.dat extension);
    • a tab-delimited file suitable for re-population of a CallWeb data base (.tcw extension);
    • a comma-delimited file of the open-end parts along with the associated question name and _telkey (.opn extension).
  • five program statement files:
    • an SPSS code file for reading the fixed-column data file, including the assignment of variable and value labels (.sps extension);
    • an R code file for reading the fixed-column data file, including the assignment of variable labels and variable formats (.r extension);
    • a SAS code file for reading the fixed-column data file, including the assignment of variable labels and variable formats (.sas extension);
    • an ASCQUE instruction file for the creation of a VoxCo Interviewer questionnaire which can then be converted to a StatXP format for reading the fixed-column data file, including the assignment of long labels and category labels (.asc extension);
    • a Classic 1.1 Triple-S instruction file (.sss extension).
    • an XML Triple-S 2.0 instruction file (.ssx extension).
    • a Stata code file for reading the fixed-column data file, including the assignment of variable labels and variable formats (.stt extension);
  • and a copy of the CallWeb question (.scw file).

The cwExtr (which stands for Extraction) tool is called from the integrated interface. cwExtr compresses the files it extracts into a zip archive. It either sends this zip file by e-mail to the address identified in # Send extractions to or it leaves the extraction on the server. The destination is selected in the cwExtr parameter interface.

In database-to-database mode (requested from the integrated interface, cwExtr can copy data from one CallWeb data base directly into another CallWeb data base. The source and destination data bases can reside in separate servers but they can also be in different instances of CallWeb on a single server or in the same CallWeb instance. In this mode, new data records can be added to the destination data base and existing data records can be updated with the data in the source data base. It is possible to select only a subset of fields to be transferred but system fields (the name of which starts with an underscore) are always transferred. All fields selected for transfer from the source data base must exist in the destination data base but the data base structure may differ between the two CallWeb projects otherwise.