#DataTipOfTheDay 2011-05-17Q: "Does Data Loader accept non-CSV file formats?" A: Yes: Data Loader also accepts tab-delimited files. It's kind of weird; there's a comment in the Data Loader documentation that says "Note: If commas are not appropriate for your
locale, use a tab or other delimiter", but provides no further explanation. There isn't any setting in Data Loader that prompts us for a delimiter. But even though it's obscure, it works--and now it can be told!** Data Loader v21.00.4 also accepts tab-delimited files.
So there you have it. Data Loader accepts two different kinds of delimiters (commas and tabs) and one kind of text qualifier (a double-quotationmark). * Read more about "X? We don't need no stinking X!" here: http://spectrum.ieee.org/at-work/education/snowclone-is-the-new-clich ** That reminds me: when I was interning in Washington, DC in the summer of '91, I appeared on Geraldo Rivera's brief-lived newsmagazine show, "Now It Can Be Told". Underaged babyface that I was, I carried a hidden camera, then walked into three establishments whose liquor licenses were under threat of suspension and ordered a drink. One of them served me without carding. Is this at all interesting? No? oh well. |