Ask Search:
r rr r 

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) 
r rr r
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 ChanJoey Chan
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
r rr r
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 ChanJoey Chan
You may try this one:
https://sites.secure.force.com/appexchange/listingDetail?listingId=a0N30000003Iz0jEAC
r rr r
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 ChanJoey Chan
Do you also have Apex Data Loader installed?

You might be able to use windows for automatic scheduling of a batch file to run.
r rr r
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
r rr r

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 ChanJoey Chan
Awesome! Can you post a link?
r rr r
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
r rr r
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
SysadminSysadmin

Thank you rr,

After months of struggling with the data export I found this post and downloaded and installed FuseIT to download all of our 35 backup files á ~500MB a piece in one go. A hopeless task to do manually. Now they all were being downloaded while I was out having dinner with a friend. Nice!

Julia SalemJulia Salem
It's a good idea to have a backup snapshot files, but what happens if the data gets lost or corrupted? Here's a helpful guide from OwnBackup that goes through the 7+ steps for restoring lost data using .CSV files: http://pages.ownbackup.com/salesforce-weekly-export 

Good luck and hopefully you never have to go through a data loss/corruption!