+ Start a Discussion
ritijoshiritijoshi 

Bulk upload of attachments

hi

 

I want to automate the process of uploading large amount of attachments ( say 1000 attachmnets). 

Want a script which can automatically create a csv / xml  containg  attchment name , path , and parent id of abject.

 

If anybody has worked on similar requirement, please let me know.

 

 

Thanks in advance

riti joshi

 

Best Answer chosen by Admin (Salesforce Developers) 
Rick.BanisterRick.Banister

Relational Junction has an attachment import feature. It detects new attachments in a file system directory and pulls them into a database, where you can then use a sql script to associate them with other objects, name them, etc. The final step is to send them to Salesforce.

 

Contact me directly for more info.

All Answers

Rick.BanisterRick.Banister

Relational Junction has an attachment import feature. It detects new attachments in a file system directory and pulls them into a database, where you can then use a sql script to associate them with other objects, name them, etc. The final step is to send them to Salesforce.

 

Contact me directly for more info.

This was selected as the best answer
gsmithfarmergsmithfarmer

We deal with this sort of problem with http://code.google.com/p/sqlforce/wiki/SQLForceForJython

Though you will need to do the base64 conversion yourself, the final SOQL bit in Jython is:

 

session.runCommands( "INSERT Attachment SET body='" + yourBody +'"')