1

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.

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

  2. 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.

Improve this question
2
  • There's no limit aside from the storage limit Salesforce itself imposes. But it simply calculates 2KB per record, so I think you need 30M records before it becomes an issue. (I think the limit is 60GB...)
    – Adrian Larson ♦
    Sep 6, 2016 at 15:25
  • Can you please share any document reference
    – Santanu Boral
    Sep 6, 2016 at 15:27

2 Answers 2

Reset to default
1

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.

Improve this answer
3

I can't flag this question as a duplicate, but this question has already been asked on Stack Overflow. So I'll just quote the Data Loader Guide and @eyescream (emphasis mine):

Use Data Loader when:

  • You need to load 50,000 to 5,000,000 records. Data Loader is supported for loads of up to 5 million records. If you need to load more than 5 million records, we recommend you work with a Salesforce partner or visit the App Exchange for a suitable partner product.
Improve this answer
6
  • My question is bit different, I have gone through dataloader guide.
    – Santanu Boral
    Sep 6, 2016 at 15:36
  • @SantanuBoral But the answer is the same. Up to 5M records you're definitely good. After that, you may want to consider a different tool or break up your csv.
    – Adrian Larson ♦
    Sep 6, 2016 at 15:37
  • Can I breakup the csv file as 50,000 records per file?
    – Santanu Boral
    Sep 6, 2016 at 15:39
  • There's nothing stopping you. But there's also no need to go to that trouble for less than 5 million records.
    – Adrian Larson ♦
    Sep 6, 2016 at 15:39
  • So can I upload data from single csv file with 1 millon data?
    – Santanu Boral
    Sep 6, 2016 at 15:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .