Import export dati per call center e telemarketing

The surveys may also be exported into specific formats for the analysis of CATI surveys The formats that are currently supported are: SPSS, Quantum ASCII, Triple-S 1.1, Triple-S 1.1 XML.

Data import wizard

	The first step is to choose the type and the file to import. There are many formats available, including Microsoft Access, Microsoft Excel, DBF, MySql, Oracle, Sql Server.
Choosing the file to be imported

	Later you associate the fields of import table with Telmar2000 fields, and choose custom fields to be imported
Mapping fields

	To avoid importing duplicate names you can tell Telmar2000 which field(s) is(are) a unique key during the import. If for example the input list is made of residential telephone users, usually you can set the phone number as the key. If the input list already contains an unique identifier is advisable to indicate that.
Selection of the key fields

In the final step you import the data. A progress bar shows the status of of the operation, a panel displays the amount of names added, the number of names changed because existing and identified by primary key defined in previous step, the records that are not valid because, for example, they have no phone number, and the number of records that have been ignored if it is chosen to ignore any duplicates.

Final Step

Data Export Wizard

To export data from a list or group of lists worked in Telmar2000, there is a wizard that allows you to do this in just a few steps and without specific knowledge on issues related to the database. The supervisor is asked to choose which interviews will export with the possibility of applying filters (for example, the interviews ended with a certain status, or interviews that contain a certain response, interviews conducted by certain operators in a given date range, etc. ...). The process is similar if the supervisor wishes to export the appointments of agents, information on productivity of call center, or even multiple types of data in a single export transaction.

Choosing the file to be exported

The wizard lets you set filters without the need to have computer skills, such as language Sql. In order to obtain the data output in the format you want, Telmar2000 provides a range of export models. These models are in fact real query. You can customize and / or create your own. Again it is not necessary to know the language Sql. If you have Microsoft (r) Access 2000 or higher you can use the visual query editor of Microsoft (r) Access directly with a click. Before you export a model, you can see a preview

Choice of export models.

After selecting models for export, we pass the final stage. After choosing the format database output (text format, Microsoft Access, Microsoft Excel, SPSS, Quantum ASCII, Triple-S, Triple-S XML, etc.), You proceed with export. Telmar2000 will automatically create the output file if it does not exist. If the output file already contains tables with the same name, Telmar2000 ask if overwrite the existing tables or appending data. During export, a progress bar shows the progress of the operation, which finished you can open the file directly with the application owner (Access, Excel ...)

Final step

Telmar2000 is made by SiB srl. All rights reserver.