OpenRefine: error uploading data from csv, perhaps due to colon included in temp filename
I have Windows 7, OpenRefine 2.6rc2 and Oracle jdk 1.8u92 and I haven’t been able to upload data from a local csv file. The message is
Error uploading data: C:\Users\myuser\AppData\Local\Temp\Jetty_127_0_0_1_3333_webapp____4ulpc9\import\1\raw-data\C:\Users\myuser\Documents\datasets\Hartford\Incidents.csv (The filename, directory name, or volume label syntax is incorrect)
I already saw another thread mention that something similar could happen if you don’t have write permission to the temp folder, but in this case I’m running it from my account and the Local folder seems to be under my account. The problem here is more likely the colon in the filename (the "\C:" in the middle of the pathname). Has anyone else seen this?
The csv file is the exported csv from this public data set: https://data.hartford.gov/Public-Safety/Police-Incidents-01012005-to-Current/889t-nwfu
Thanks in advance, Jose Miguel
About this issue
- Original URL
- State: closed
- Created 8 years ago
- Comments: 18 (4 by maintainers)
@cameronstewart, read the most recent posts. The root cause of the problem is different than I supposed. It turned out that the full path should never have been replicated in the first place, therefore my proposed solution is not helpful. The workaround is to make Chrome your default browser.
I have this same issue, and it has nothing to do with the value of TMP or TEMP. Using the Browse button, I selected the file Librarygood.xml, which was in my Windows 7 home directory C:\Users\STAMPEL. When I tried to load it, I got this error, much like the others received:
It seems clear that OpenRefine was trying to copy the xml file in its own private temp directory ‘C:\Users\STAMPEL\AppData\Local\Temp\Jetty_127_0_0_1_3333_webapp____4ulpc9\import\2\raw-data’, replicating the original file’s path - i.e., C:\Users\STAMPEL.
The problem is that the colon character is not allowed in Windows file names. The colon needs to be removed or replaced with a legal character. That should fix the issue.