[SalesForce] Test.loadData() static resource text/csv vs. text/comma-separated-values

I am trying load a csv of User data for an Apex test from a static resource using Test.loadData(). When I upload the csv as a static resource, Salesforce gives is a MIME type of text/comma-separated-values which is not a MIME type supported by Test.loadData() ( http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_methods_system_test.htm#apex_System_Test_loadData ) and so I get an error telling me as much when I run the test.

System.TypeException: Content type not allowed for Test.loadData():
text/comma-separated-values

Has anyone encountered this? Does my static resource need a MIME type of text/csv instead of text/comma-separated-values in order to use it with Test.loadData() or do I have another problem? Is there any trick to forcing this MIME type?

Best Answer

I can reproduce the error (which is a pretty clear anyway) so you will need to use ContentType of "text/csv".

I can think of 2 ways of getting the ContentType (labelled "MIME Type" in the UI) to be the required "text/csv":

Install a different browser and use that to do the uploads as AFAIK it is the browser that infers the content type from the file extension and/or file content; Chrome on a Mac uploads a CSV file with the file extension .csv as "text/csv".
Use the Force.com IDE or the Ant migration tools to download the static resource(s), then fix the contentType element in the .resource-meta.xml file(s), then upload them. (I used the Force IDE to turn my working "text/csv" static resource into a failing "text/comma-separated-values" one.)

Related Solutions

[SalesForce] Can’t get Test.loadData method to run

As I remember, I discovered 3 details about the file to get this working. Ended up with 120 records in 14KB, UTF-8 without BOM file uploaded as txt/csv in Static Resources.

For "System.UnexpectedException" error, the size had to be <20k. I reduced the number of records to 120, making it ~14K in size.
"System.StringException: Unknown field:" - parser was reading the BOM; saved file without. That is probably what happened for line 11 (in the posted code). //but i have no idea what i did to the csv file
"System.StringException: CSV Parse error:" - yep, found one buried in the data; there are a LOT of fields in these records (don't ask).

still waiting for that well placed smack on the head

[SalesForce] bulk api text/csv CRLF error

change the Request body of Job Creation as follows.

{
  "operation" : "insert",
  "object" : "Product2",
  "contentType" : "CSV",
  "lineEnding" : "LF"
}

It worked for me.Also ensure that the delimiter of your CSV file is only comma.You must include all required fields when you create a record. You can optionally include any other field for the object.Files must be in UTF-8 format.

Best Answer

Related Solutions

[SalesForce] Can’t get Test.loadData method to run

[SalesForce] bulk api text/csv CRLF error

Related Topic