Ask Search:
Rajwinder InternRajwinder Intern 

Automated Backup Downloader

Hi, I was wondering if anyone knew of an app on AppExchange, script, or trigger(in APEX maybe) that can used to automatically downloading zip files from SFDC to a local disk drive? 

Also, is there a way to schedule the automatic downloading to occur weekly?
Best Answer chosen by Moderator (salesforce.com) 
Rajwinder InternRajwinder Intern
Solution 1: Download FuseIT DataExport files. Essentially this uses login information you give it so it can securely access your org, then it uses login () SOAP methods, grabs your session ID and org ID which gets stored into a session cookie(if I am correct). Then it will use that session cookie to login, go to Setup->Data Management->Data Export and it actually downloads all the zip files. Use the link as they provide two forms of doing this. They will email you the download file, just make sure to request the one with the proxy fix.

URL: http://www.fuseit.com/Solutions/SFDC-Explorer/Help-Data-Exports.aspx

I
 also extended solution 1 with a VBScript that can be used to move files, rename them, and also delete any set of files that X amount of days old to help with memory management.

URL: http://www.codeproject.com/Articles/16173/How-to-Rename-Multiple-Files-with-VBS

P
lease pass this solution along as it would help many people! If other ask you question, you can direct them back to me!

All Answers

Joey - CloudJediJoey - CloudJedi
I've actually searched for a similar solution myself but at this time there isn't a good solution to automatically download the Salesforce backups
Rajwinder InternRajwinder Intern
Hi Joey. Yes, I have run into major road blocks because a lot of ways pull everything except the documents and attachment. 

Do you know of any ways to pull maybe just the documents and attachments, export them into a particalur folder called sample(maybe, located on local drive). Then use other applications to export the rest of the data into the same sample folder? 
Joey - CloudJediJoey - CloudJedi
You may try this one:
https://sites.secure.force.com/appexchange/listingDetail?listingId=a0N30000003Iz0jEAC
Rajwinder InternRajwinder Intern
Do you know if you can schedule that to make it automated? My goal is to make FileExporter to automatically download zip files weekly.

I cannot get FileExporter to work
Joey - CloudJediJoey - CloudJedi
Do you also have Apex Data Loader installed?

You might be able to use windows for automatic scheduling of a batch file to run.
Rajwinder InternRajwinder Intern
I have Apex Data loader installed, but again that is not my purpose. Data loader does not download attachments and documents so it useless in my scenario.

My main concern/question is if there anything out there that I could schedule to run weekly(automation) that can automatically download all the zip files that are provided when you go to Data management->Data Export->Export Now.

I am currently manually downloading each zip files that range from a set of 3-18. I want to download them automatically with either one click, application, or whatever script or solutions that are available
Rajwinder InternRajwinder Intern

So Joey, I did find a method to download zip files, change their names appropriately, delete very old backups, and timestamps everything. I will be posting an update on that on GitHub or Stack Overflow. 
 

Stay Tuned.
Thanks for all your help in the past!

Joey - CloudJediJoey - CloudJedi
Awesome! Can you post a link?
Rajwinder InternRajwinder Intern
Solution 1: Download FuseIT DataExport files. Essentially this uses login information you give it so it can securely access your org, then it uses login () SOAP methods, grabs your session ID and org ID which gets stored into a session cookie(if I am correct). Then it will use that session cookie to login, go to Setup->Data Management->Data Export and it actually downloads all the zip files. Use the link as they provide two forms of doing this. They will email you the download file, just make sure to request the one with the proxy fix.

URL: http://www.fuseit.com/Solutions/SFDC-Explorer/Help-Data-Exports.aspx

I
 also extended solution 1 with a VBScript that can be used to move files, rename them, and also delete any set of files that X amount of days old to help with memory management.

URL: http://www.codeproject.com/Articles/16173/How-to-Rename-Multiple-Files-with-VBS

P
lease pass this solution along as it would help many people! If other ask you question, you can direct them back to me!
This was selected as the best answer
Mary SmithMary Smith
Hi Rajwinder,

You might want to look at CopyStorm (www.capstorm.com) listed on the AppExchange to copy your Salesforce to a local database.

Regards,
Mary Smith
Rajwinder InternRajwinder Intern
Hi Mary.
As I told Joey, I already solved my problem through the methods discussed in my last posting. It turns out FuseIT has a free application that works similar to CopyStorm. With a little help from VBScripts, I was able to fill in the hole left by the FuseIT's applications.

Thanks for responding. Highly appreciate anyone taking the time to help!

Regards,
Rajwinder Ruprai