Start a new topic

Insert large number of files in Cloud Drop through Data Loader

Steps to insert the large number of files in Cloud Drop through Data Loader:


1) Transfer files from local drive to Rackspace Server.


2) Record and file creation/mapping in salesforce.


Steps to transfer files from Local drive to Rackspace:


1. Bulk Rename Utility


Download the Utility from http://www.bulkrenameutility.co.uk/Download.php


Follow the instructions to remove special characters and space from files and folder names.

a) Select the Folder from Highlighted panel where all your files are placed. Note : Check the Highlighted checkbox as well. Refer screenshot_1.


b) Enter the criteria in the highlighted panel i.e. replacing the blank-Space with Underscore. Refer screenshot_2 for more explanation.


c) Select the Files and Folders from Highlighted Panel. Utility will automatically take the Sub Files and Folders as well. Utility will show you the new file and folder names there itself. Refer Screenshot_3.


d) Click on Rename button and you can continue with the process for other special characters till you satisfied with Rack-Space filename conventions. Refer screenshot_4.


2) FireUploader – FireFox Addon


Download http://www.fireuploader.com/release/latest/fireuploader_v0.4.4.xpi


a) Click on Manage Account and setup your rackspace.

i. Username

ii. Password (API Access Key) - You can find it in "Your Account" -> "API Access" after you login in Rackspace Control Panel


b) Select the Production container on right hand panel.


C ) Select the Folder where your files are located and upload the files by clicking the Right Arrow. It will take all the files and folders from the selected folder and upload it to rackspace. Refer screenshot_5.


Steps to make file mapping in Cloud Drop:


Following are the steps for associating Rackspace file with cloud drop :

a) Log in into Rackspace Server with your login credentials by navigating to the URL : https://mycloud.rackspace.com/


b) A list of available container would be displayed under File Section. Now search for the container name  matches with your salesforce org Id i.e. if your salesforce org id is 00D90000000tt6D then two container would be listed their as shown below. Refer Screenshot_6.


c) There will be two container available with the same initials but have one major difference  viz one container will contain private keyword in its name which means that container is not publically accessible by CDN Url while the another container is publically accessible.


d) Let’s say for example the Rackspace file user want to associate with cloud drop contains in  the public container viz(00DU0000000Hs8AMAS). Then click on the associated container. 


e) Now , Search for the file that you want to associate with clouddrop and then click on that file as  shown screenshot_7.


Cloud drop fields                                                   Description


i)   NAME                                                                   file name

ii)  CLOUDROP__ACCESS__C                                  Public/Private

iii) CLOUDROP__FILE_PATH__C                             Mandatory

iv) CLOUDROP__SOURCE__C                                  Manual

v)  Cloudrop__ObjectId__c                                     Must contain the object id of  the cloud                                                                                              drop object if user wants to associate file with cloud drop object. Otherwise contains the 18 digit id of the salesforce object record that have cloud drop page associated with.


vi) CLOUDROP__EXTERNAL_PATH__C                  Sample cdn url (as shown in screenshot_7).


f) Now enter these details in csv file as shown in screenshot_8.


g) After entering the required value, save the changes made in the csv file. And then use the  appropriate data loader software to insert record in Cloud Drop Object (Cloud_Storage__c).




Login or Signup to post a comment