JasperHG90
commented
7 years ago Thanks for your comment.
When importing survey data into R, is there a delay between what is current in the Qualtrics system and what is being downloaded?
I'm not aware of such a delay. Essentially, you're just making a call to the Qualtrics API in which you request a csv file of the response exports.
Is it possible that the data is having problems importing?
Yes, that is possible. (see e.g. #13). In this case, I'm guessing there are special characters in your csv file. I googled that error and found the following:
- Invalid Input causes read.csv to cut off data
- Invalid multibyte string in read.csv
- Reading in data with unusual characters
As you can see here, the readSurvey() function uses UTF-8 for the 'fileEncoding' argument.
Here's what I suggest you try:
- Re-run your code until you see the error
- Execute the following:
# Get temp dir
td <- tempdir()
# List files and show
list.files(td)
# Copy the name of your survey
file_name <- paste(td, "/", "<YOUR-SURVEY>.csv")
# Read it into R
surv <- read.csv(file=file_name,
header = FALSE,
sep = ',',
stringsAsFactors=FALSE,
fileEncoding = "latin1",
skip = 3)- Let me know if that worked. If it does, I'll add 'fileEncoding' as an optional argument.
Best,
J.
cmbohn
When importing survey data into R, is there a delay between what is current in the Qualtrics system and what is being downloaded?
Is it possible that the data is having problems importing? I enter the following into R:
loyperc <- getSurvey("SV_5nIBD5iRalXmdNz", useLabels=FALSE, useLocalTime=TRUE, dateWarning=FALSE, convertStandardColumns=TRUE, force_request=TRUE)I get the following warning:Warning message: In scan(file = file, what = what, sep = sep, quote = quote, dec = dec, : invalid input found on input connection 'C:/Users/cb37543/AppData/Local/Temp/RtmpeEgLjr/Loyalty perceptions (Jamie).csv'I can only import 88 observations, when there is actually much more than this.