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
a) Click on Manage Account and setup your rackspace.
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).