Upload data

Overview

One way to get feedback data into VoC Mine or VoC Visual is to create a custom upload. Custom upload is an .xls, .xlsx or .csv file which contains feedback data as well as certain metadata if provided in that same file.

Since VoC Hub 8.1.0 it is now possible to upload data captured from external sources with less modifications. The process is now more flexible and is detailed below.

A special gadget is built-in to VoC Visual to visualize your data as well. Please note that External Data Upload functionality only works with Super Gadget right now.

The "Upload data" section allows the user to upload new data.

Supported files

File format: .xls, .xlsx, .csv

Structure:

Column Description

[TEXT] This column will be flagged as text column and can then be used to create a custom query in VoC Mine

[LANG]

Allows to specify the language of the upload on per-row basis without selecting the language in the dropdown of the UI during the upload. If multiple languages were provided you can then filter responses by language during custom query creation.

Please make sure to only include values of languages which are supported in VoC Store. To check the supported languages list, click the Language dropdown list on the main upload page.

Supported languages:

Language	ISO 639-1 code
English	EN
Italian	IT
German	DE
French	FR
Dutch	NL
Spanish	ES
Catalan	CA
Galician	GL
Portuguese	PT
Polish	PL
Romanian	RO
Greek	EL
Danish	DA
Basque	EU
Russian	RU
Bulgarian	BG
Slovenian	SL
Serbian	SR
Croatian	HR
Macedonian	MK
Arabic	AR

[DATE]

Allows to specify the capture date for the upload in the same fashion. As with [LANG] it is row-specific. Date information can be then used in VoC Mine date filter and in date range picker in VoC Visual.

For files in xlsx or xls format, date should be specified with a "Date" cell category in Excel:

Any "Type" is supported.

Please find the list of supported Date formats for CSV uploads here.

[NPS] VoC Store will try to parse this column as an NPS column. This will produce a special system column with the NPS category for associated entry which can then be exported.

[NUMERIC] This column is allowed to have math functions applied to it in Super Gadget in VoC Visual. Math functions are disabled for non-numeric columns.

[CHOICE] This column will be flagged as the column that may contain more than one entry in a cell. If your upload file contains a [CHOICE] column, please consider setting a choice delimiter.

Please note that columns with [TAGS] can contain other text as well. During processing a partial lookup is performed where it's enough for the column title to just contain the exact sequence of the tag's name, i.e. My column with [TEXT] or [TEXT] will both work.

Other columns are treated as metadata.

File size: Recommended < 100 MB of data.

Upload new file

In the upload new file view, you can provide a new Excel or CSV file for an import.

Before initiating an upload you will be prompted to fill out the fields that are necessary for submitting a file. Here's a quick overview of them:

Title	The title of your upload for future reference
Captured at	You can select the exact date when the data from your upload file was captured. It is set to be the current date of the upload by default.
Language	In case your file contains data in only one language, you can select this particular language from the drop-down menu. The system will consider all the text data from the file to be in this language. If there are several languages in the file - there is no need to change "Language" field, since this option is set by default.
Choice delimiter	If you have several answers to a multichoice question in the file, you can select how these answers are separated from each other in a cell in order for the upload process to be accurate. The choice delimiter is set to be "\|" (pipe) by default.
CSV delimiter	In this field a delimiter for a CSV file can be chosen. Set to be comma by default.

Basic text file upload

A provided file should contain a [TEXT] column. You then need to choose the language of text cases in the provided file in the "Language" drop-down menu.

Example file contents:

[TEXT]

A lot of promises

Called you 4 times and still have no answers

Especially in the evening there is no chance to reach anybody of yours

The agents have to act much friendlier

Text file upload with specified languages

In case you've selected "There are several languages in the file" in the "Language" drop-down menu the upload file also should contain a column called [LANG] where an ISO 639-1 code (EN, DE, etc) of the language is specified for each feedback. See table at the beginning of this document for a list of supported languages.

Example file contents:

[TEXT]	[LANG]
A lot of promises	en
Called you 4 times and still have no answers	en
Sehr freundlich	de
Der Service ist großartig	de

Text file upload with pre-specified languages, date and other metadata

Additional columns (other than LANG and TEXT) will be treated as metadata.

Example file contents:

[TEXT]	[LANG]	[DATE]	Country	Segment
A lot of promises	en	4/12/2015	UK	0
Nicht glücklich	de	4/12/2015	Germany	1

In this case, the metadata columns are: [Country], [Segment]

Initiating upload process

To initiate an upload follow these steps:

1. Provide a title for the upload e.g. "Relational NPS wave 1 analysis" for future reference.

2. (Optional) Provide a specific date when the data was captured. This makes sense when you are importing several data sets from different dates and you want to use the date filters in VoC Mine queries or in VoC Visual Super Gadget. In other cases, current upload date will be used as "Captured at".

3. Click on the floppy disc icon on the right side to choose a file or drag and drop the file there.

4. Wait for the system to analyze your file and try to find the system columns such as [TEXT], [NPS], etc.

After the analysis is done you will see a screen similar to this one:

As you can see, the detected system columns ([TEXT], [LANG], [DATE], [NPS] NPS Score, [NUMERIC] values) has their type automatically preselected.

Additional columns (City, opinion text from customers) are treated as metadata by default. In order to instruct the system to use metadata columns as system columns just click the type of the column next to its name. It will become highlighted in the same way as preselected ones.

To turn the system column into metadata just click the blue button of the column type again and it will become deselected which will instruct VoC Mine to use the column as metadata column.

You can (de)select as many system columns of any type as you need.

5. Start the upload by clicking on the Submit button.

The upload will now be shown in the Uploads list menu. You can also monitor the progress there and manage your uploads. You can find more reference on Uploads list menu here.

Articles in this section

Upload new file

Comments

Articles in this section

Upload new file

Related articles