[SalesForce] Dataloader csv file size or record count limit

I want to upload attachments into Case record through Dataloader. To upload attachments I need to define only these 4 columns: ParentId, Name, Description and Body.

What is the limit of csv file size or record count per .csv file.

Can I upload the file which are in network drive (not in local machine) specifying the file path.

Note: I am not using CLI for dataloader and not going for Bulk API option.

Best Answer

First part is already answer with documentation link so I am addressing only 2nd question.

Yes we can refer file stored on network drive using data loader. The only think we need to consider is delay involved for reading file from network drive. If the delay is significant then your migration process will be slow. But technically its possible to do so.

Related Solutions

[SalesForce] Salesforce PHP API Attachment Upload

I have managed to figure out a solution to this.

I was using the wrong encoding, after finding this link - http://www.salesforce.com/developer/docs/api/Content/implementation_considerations.htm

And reading the sections around Internationalization and Character Sets and XML Compliance it become apparent that the string (body) that I was uploading was already in UTF-8, and just required Base64 Encoding.

Below is my working code - just in case you are experiencing issues too.

public function uploadAttachment($attachmentBody, $attachmentName) {
        $createFields = array(
            'Body' => base64_encode($attachmentBody),
            //    'ContentType' => $contentType,
            'Name' => $attachmentName,
            'ParentID' => 'AN OBJECT ID',
            'IsPrivate' => 'false'

        );
        $sObject = new stdclass();
        $sObject->fields = $createFields;
        $sObject->type = 'Attachment';

        echo "Creating Attachment";
        $upsertResponse = $this->SFConnection->create(array($sObject));
        print_r($upsertResponse);
    }

[SalesForce] Uploading 100,000 binary files as attachments to Case record – best approach

I would suggest you to go with data loader using SOAP API, which is by default (not Bulk API).

Why?

You do not need to write any code to use Data loader
It is tested solution, so no bugs
With SOAP API you will need around 500+ API (100000 records / 200 batch size = 500 API required) which is not too much (we have 100k API limit per 24 HRS for enterprise org).
Also depending on your data and schema you may face locking issue with Bulk API.
Bulk API does not allow zip file size more than 10 MB Ref: https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_concepts_limits.htm

Best Answer

Related Solutions

[SalesForce] Salesforce PHP API Attachment Upload

[SalesForce] Uploading 100,000 binary files as attachments to Case record – best approach

Related Topic