Chef Workflow Review Error Uploading to Supermarket Invalid Json

---

The feedback y'all submit here is used simply to aid improve this page.

That's great! Cheers for your feedback!

Cheers for your feedback!

---

About CSV/TSV Upload Bug

While CSV files can use either UTF-8 or ASCII encoding, Qualtrics only supports CSV with UTF-viii encoding and TSV. This discrepancy between encoding can sometimes cause issues when importing or exporting data from CSV / TSV files into Qualtrics.

Although in that location are many places in the platform where CSV / TSV files are used, the nearly common include:

• Uploading a contact list
• Importing responses
• Importing files for drill downwardly questions
• Downloading data

This page outlines possible errors that may occur and the steps that can exist taken to overcome these problems.

Problem Importing CSV/TSV Files

There are a few bug that normally arise when importing files:

• All data displays in the starting time column, or cavalcade breaks are not obeyed correctly when you import the file. This is caused by anwrong delimiter.
• Bug with special characters displaying correctly. In full general, "special characters" refers to any symbols or letters except for numbers or the English alphabet.
• The file doesn't match thestandard formatting required.

Incorrect Delimiter Problems

The delimiter is the character that separates fields and values in a spreadsheet file. When the importer does not recognize the right delimiter, it tin read the file in a style that combines columns altogether, or breaks out columns at incorrect intervals. When dealing with an incorrect delimiter, the delimiter setting must be changed.

Example: Below is a possible error message that might occur when importing a contact list with an incorrect delimiter. Find how all of the information about John Doe is running together, separated only by commas.

We resolve this issue by changing the delimiter to "Comma." Now notice how John Doe'southward information is separated into different fields instead of being bunched together.

Changing Delimiters When Importing Information

When importing data, Qualtrics generally picks a delimiter based on your data file's format. However, you can follow these steps if you lot are nonetheless having upload issues.

1. Navigate to the Import Data menu.
   
2. Click Browse and select your file.
3. Change the Delimiter to Tab (for TSV files) or Comma (for CSV files that are delimited using the , symbol), as required.
   

Changing Delimiters When Importing Contacts

1. Navigate to the Add together Contacts card.
2. Select Show Options.
   
3. Change the Delimiter to Tab (for TSV files) or Semicolon (for CSV files that are delimited using the ; symbol), as required.
   

Qtip: If your account is not in English, you may have to manually enter the delimiter every bit a symbol (east.g. ; for the semicolon).

Special Graphic symbol Issues

When dealing with special character encoding issues, the file blazon must exist changed.

Qualtrics supports UTF-eight encoding for CSV files. This can crusade issues with special characters when uploading CSV files from Excel (which defaults to ASCII encoding) into Qualtrics. For example, without reformatting, special characters like 是 or ñ may not show correctly upon import.

Example: Notice how in row 2 and in row 4, the characters' in these contacts' names take been replaced with random symbols.

At that place are 2 possible solutions for issues related to special characters:

Using Microsoft Excel

1. Select File and so Save As.
2. Change your file type to either Unicode Text (*.txt) if you are using Excel on Windows or CSV UTF-eight (Comma delimited) (.csv) if you are using Excel on Mac.
3. Select Save.
4. Upload the new file to Qualtrics.

Using Google Sheets

1. Import this file to Google Sheets.
2. In Google Sheets, select File, then selectDownload as, and choose Comma-separated values.
3. Practice not open the file in Excel again.
4. Upload the file direct to Qualtrics.

Qtip: If you make whatsoever changes to the CSV file on your figurer before uploading, exist certain to go through the steps once more in gild to upload the edited file.

Standard Formatting

Remember, when importing data to whatever part of Qualtrics, brand sure yous are following the standard formatting. This means:

• The file is CSV or TSV, non XLS or any other Excel format.
• If the file'south a CSV, it is UTF-8 encoded.
• The headers of the file are correctly formatted.

Header Formatting

Qualtrics will oft provide case files right within the product when you open up the importer, which tin be used as a reference for importing data. Y'all tin also see the following back up pages for guidance on how to format the headers, depending on the feature you are using:

CoreXM / Survey Software:

• Importing Survey Response Data
• Importing Contacts (Not XM Directory)
• Importing Contact List Updates (Non XM Directory)
• Survey Translations
• Importing Drill Down Answers

XM Directory

• Importing Contacts (XM Directory)
• Importing Contact List Updates (XM Directory)

CX Dashboards:

• Importing a CSV equally a CX Dashboard Source
• CX Dashboard Translations

EmployeeXM:

• Importing Hierarchies and other EX Participants
• Importing 360 Participants
• EX Dashboard Translations
• Importing EX Responses
• Importing 360 Responses
• Importing Units

  Qtip: This is not the same as creating a hierarchy.

PX

• Importing Conjoint Designs

Please annotation that not all the features listed in a higher place are available in all licenses.

Problem With Exported CSV Files

If you're having problems with a CSV file you lot downloaded from Qualtrics, it may be due to how the file is formatted. There are two common problems:

• All data displays in the showtime column, or column breaks are not obeyed correctly when you import the file. This is caused by anincorrect delimiter.
• Issues with special characters displaying correctly. In general, "special characters" refers to any symbols or letters except for numbers or the English alphabet.

Incorrect Delimiter Issues

1. Download your CSV file from Qualtrics. See Exporting Response Data for detailed instructions on downloading survey responses.

   Qtip: You can technically download a CSV in many different places in Qualtrics, such every bit a contact list, and XM Directory mailing list, or an employee participant list, just downloading response information is the most common example. Note that the pages linked in this Qtip may reference features but available in some licenses.

2. Open the file in Excel.
3. Select the first column in your spreadsheet.
   
4. Select the Data tab.
5. Select Text to Columns.
6. Cull Delimited and select Next.
   
7. Change the delimiter value to the value that is being used in the Excel document. In our case, you can see that the data is separated past semicolons, then the delimiter value must be fix to Semicolon.
   
8. Select Finish and then continue working with your file equally normal.

Special Character Issues

Qualtrics supports UTF-8 encoding for CSV files. This can cause issues with special characters displaying properly when opening CSV files in Excel, which defaults to ASCII encoding.

At that place are two possible solutions for issues relating to special characters:

Using a TSV File

Just choose the TSV file format when downloading your data from Qualtrics. Qualtrics' TSV files are UTF-8 encoded, which prevents the problem of special characters not displaying properly. For a guide on how to use TSV files, delight see the Opening TSV Files department below.

Using Google Sheets

You tin also use Google Sheets to convert your CSV file into an XLS file. This file blazon is specifically designed for Excel and will open without outcome. Delight annotation that XLS files cannot be imported back into Qualtrics.

1. Download your CSV file from Qualtrics. See Exporting Response Information for detailed instructions on downloading survey responses.

   Qtip: You can technically download a CSV in many dissimilar places in Qualtrics, such equally a contact list, and XM Directory mailing list, or an employee participant list, only downloading response data is the almost common case. Notation that the pages linked in this Qtip may reference features only available in some licenses.

2. Open the CSV file in Google Sheets.
3. In Google Sheets, salvage your file as an XLS file.
4. Download the file to your reckoner and proceed as normal in Excel.

Opening TSV Files

TSV files and TXT files are tab delimited text files. About computers default to opening TXT files in text editors, such equally Microsoft Word or Notepad. If you click on your TSV file and it opens in a text editor, you can follow these steps to open the file in Excel instead.

Using "Open With…" to Open TSV Files with Excel

1. Download your TSV file from Qualtrics.
2. Navigate to the folder the file was saved in.
3. Right-click on the file.
4. Select Open With and select Excel.
5. You lot tin at present use the file in Excel.

Qtip: Depending on your operating arrangement and setup, Excel might not exist in the default list of programs. Try clicking Open With and selecting More Options. If you still do non come across Excel as an selection, so your calculator is not configured to recognize TSV files as a valid file type for Excel. To set up Excel as a default option for TSV files, follow these steps from the Microsoft Support Website. This merely needs to be fix upwards once and volition and then allow yous to open all future TSV files with Excel. Alternately, you can employ the steps found under Text Import Into Microsoft Excel below.

Text Import Into Microsoft Excel

Sometimes users may not have Open With every bit an pick to select their default program for a file. In this case, you would want to follow the below steps.

1. Download your TSV from Qualtrics. Run across Exporting Response Data for detailed instructions on downloading survey responses.

   Qtip: Yous tin can technically download a TSV in many different places in Qualtrics, such equally a contact listing, and XM Directory mailing list, or an employee participant list, but downloading response information is the most common example. Note that the pages linked in this Qtip may reference features just bachelor in some licenses.

2. Open Excel.
3. Select File and Open up.
   
4. Locate and select your file. Select Open.
5. The Text Import Sorcerer will open. Select the Delimited file type and click Next.
   
6. On Step ii of the Wizard, make certain the only delimiter selected is Tab.
   
7. On Footstep 3 of the Wizard, select Finish.
8. Depending on your file and the version of Excel you're using, you may be finished. Otherwise, the Import Data window may open and requite y'all the choice to add the data into the Existing sheet or a New canvass.
9. If you select Existing sheet, add $A$1 (which refers to the upper-left meridian cell) and click OK.
   
10. You can now continue to work with the file in Excel.

Qtip: If you desire Excel to read data in a certain format (e.g. dates), you lot can specify the information formatting in Pace three of the Text Import Wizard. Look at the data preview in the bottom of the Text Import Wizard window. Select a column that needs formatting and choose the format in the peak right. You accept the pick to cull General, Text or Date. You can repeat this stride with several columns.

Qtip: If some of your data is displayed as "NAME?", Excel detected a symbol (e.chiliad. +) at the kickoff of the data and causeless you lot are entering a formula. To fix this issue, select Text in Step 3 of the Text Import Sorcerer to display your data commonly.

Setting Excel as the Default App for All TSV Files On Your Computer

Sometimes, even if you've already opened a TSV file in Excel, your calculator will still try to open a text editor instead when you endeavour to open a new TSV on your estimator. If you notice this happening to you, here'due south how to resolve the issue by making Excel the default app for TSVs:

On Windows

1. Find a TSV file on your computer. Do not double-click it or open up it.
2. Correct-click on the TSV file.
3. Click Open with.
4. Select Choose an app.
5. Select E'er use this app to open .tsv files.
6. Select Excel from the list of apps, or search for Excel if it's not listed there.
7. Click OK.

On a Mac

1. Observe a TSV file on your estimator. Do non double-click it or open it.
2. Correct-click on the TSV file.
3. Click Get Info.
4. Select Open up With.
5. Select Excel from the list of apps, or search for Excel if it's non listed there.
6. ClickChange All.
7. Click Keep.

FAQs

Related Articles

richardbeirate.blogspot.com

Source: https://www.qualtrics.com/support/survey-platform/contacts/csv-upload-issues/

Share this post