Skip to main content
主题#Data Management

#Data Management94 人正在讨论

提问...
Nasim Ahmed
6月29日 11:53
I have 1M+ Attachments and ContentVersion files across multiple objects in Salesforce. Is there any scalable way to: bulk download all files, and directly store them in Google Drive (without local storage)?

I’m currently working with a Salesforce org that has over 1 million+ Attachments and ContentVersion files across multiple objects.

I’m looking for a scalable way to bulk download all files and directly store them in Google Drive, without first saving them locally.

So far, I’ve tried:

  • dataloader.io, but it has a limitation of 10k files per month
  • Salesforce Data Export, but it doesn’t provide actual file downloads (only metadata)

Has anyone implemented a solution for this at large scale?   Any recommendations around tools, integrations, or best practices would be really helpful.

Thanks in advance!

4 个回答
  1. Nikita Meshram (Satrang Technologies)
    今天，08:15

    Hi @Nasim Ahmed

     

    Yes, it's definitely possible to handle this at scale, but I'd recommend using a purpose-built solution instead of relying on Data Loader or Salesforce Data Export, especially when you're dealing with 1M+ files. 

     

    One option worth considering is Mass File Download from the Salesforce AppExchange. It's designed for bulk downloading Attachments, Salesforce Files (ContentVersion), Notes, Documents, and more

     across both standard and custom objects. You can filter records using SOQL and download files in batches, making it a much more scalable approach for large data volumes. 

     

    Regarding Google Drive, while the app doesn't directly upload files to Google Drive, you can simply choose your download location. If you have Google Drive for Desktop

     installed on your system, you can select your Google Drive folder as the download destination. The files will be downloaded directly into that folder and automatically sync to your Google Drive, eliminating the need to first download them elsewhere and then upload them manually. 

     

    AppExchange App: 

    https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EcsAOUAZ

    Product Website: 

    https://satrangtech.com/salesforce-mass-file-download/

     

    Disclaimer: I work at Satrang Technologie, the publisher of this Mass File Download AppExchange App.

撰写回答...
0/9000
Shakti Jadon (Salesforce 的 Engineer)
2019年10月4日 10:00
How to write formula for this?
Hi All i was trying towriting a condition in formula field .

 

we have two dates started_date and end_date so according to my conditon 

 

here i am trying to calculate total bonous 

 

1> if end date is not there we can consider as the current date 

 

2>if end date is there .

 

for rough idea i have return if but the return type should be true or false 

 

here is my code ::::

 

IF(Last_Day_at_job__c, (Salary__c/ABS(((Today()-Starts_from__c)/365)*12)) *100, (Salary__c/    Total_Months_of_service__c) *100)

 

can anyone help me how to achive this and return if or else  values as number 
3 个回答
  1. Priyanka Dadhe
    2019年10月4日 10:50
    Hi Shakti,

     

    As you said "return if or else  values as number " then you can use formula with data type as Number.

     

    IF(Last_Day_at_job__c, (Salary__c/ Total_Months_of_service__c) *100, (Salary__c/ABS(((NOW()-Starts_from__c)/365)*12)) *100)

     

    Hope this helps.

     

    Thanks
撰写回答...
0/9000
Olga Mendscheritski
2013年3月10日 23:00
Confusing error message at creating lookup relationship
At creating a Lookup Field to standard object Product from a custom object, I get an error concerning the master-detail relationship:

 

Cannot Create Master-Detail Relationship

You cannot create a new Master-Detail relationship on an existing custom object if records already exist. You must first create a Lookup relationship, populate the lookup field with data in all records, and then change the relationship type to Master-Detail. 

 

Anyway, I have an absolutely new object with no records at all and I DO trying to create a lookup relationship. Did somebody experience this problem already?

 

Thanks a lot!

 

Olga
8 个回答
  1. Olga Mendscheritski
    2013年3月10日 23:07
    Ok, I found the answer. You create a lookup to Product-Object only if you allow to clear the field if the Product is deleted: 

     

    Error: Invalid Data.

     

    Review all error messages below to correct your data.

     

    Cannot add a lookup relationship child with cascade or restrict options to Product2

     

    The initial error message is misleading.
撰写回答...
0/9000
Clair Coutts
6月30日 10:18
Im trying to do a bulk upload to creat Accounts and contacts in those accounts. For some reason the upload keeps creating an account for each contact

Im trying to do a bulk upload to creat Accounts and contacts in those accounts.  I have a CSV  file and have mapped the columns but for some reason the upload keeps creating an account for each contactCan someone please point me in the right direction for this. I am literally tearing my hair out. THanks   

1 个回答
  1. Vuk Stajic (MVRK Inc.) Forum Ambassador
    6月30日 20:56

    heya! 

     

    Typically you must create the Accounts, export the new Account IDs, and create the Contacts under those new Accounts. 

     

    Feel free to message me if you want to review your current CSV file and process in details so I can guide you to a more successful approach!

撰写回答...
0/9000
Victoria Abrego (Potawatomi Hotel & Casino 的 Executive Sales Coordinator)
2019年7月19日 21:40
How do i change the amount of time for a cutoff date? We currently have 30 days for block room cut-offs but we want to make that 14
So I am very new to salesforce. I am trying to change the setting of a 30 day cutoff to a 14 day cut off. How do I do this? I feel like I found the right place when going into Delphi but it would not let me edit and change it. 
16 个回答
  1. Alpha MarkeX
    6月12日 08:19

     "You can usually change the room block cutoff by editing the event or group booking settings. Navigate to the room block details, locate the cutoff date setting (currently 30 days before arrival), and update it to 14 days. Save the changes, and the new cutoff should apply going forward." 

撰写回答...
0/9000
Stephen Edmonds (Worksoft, Inc. 的 Global Sales Operations Director)
2018年1月16日 20:03
How to keep inactive users historical closed won deals still in Customizable Forecasts?
If a user who was previously active closes some opportunities as wins and they show up under his/her management as set forth in the Forecast Hierarchy in Customizable Forecasting, how do you keep those historical won opportunities in the Closed portion of the Customizable Forecasting just for those quarters in which the user was active AFTER you have made the user inactive because he/she has left the company?  In other words, John Doe had won deals in 1Q17, 2Q17, and 3Q17 while an active user.  The person leaves in December 2017.  You make the user inactive.  You don't want that user showing up in the Forecast Hierarchy for 2018, but you want that user's won deals still showing up in the Closed values for 2017.  Appears that when you remove the user from the Forecast Hierarchy so that they don't show in in the 2018 rollup that it also removes all of their past wins from the historical years.
3 个回答
撰写回答...
0/9000
Sabir Ansari (NA)
6月16日 16:55
Use the Data Import Wizard, In last stage getting the error Records Failed

Verify step error :- The 'Lead' records from the CSV were not found. Please check the instructions. 

Import report file error :- 

 FIELD_INTEGRITY_EXCEPTION:There's a problem with this country, even though it may appear correct. Please select a country/territory from the list of valid countries.: Country:Country -- 

 

 

However, I confirmed accurate data and tried couple of times. Also checked the value in Salesforce State/Country Picklist validation. 

Also checked this instruction Note: If experiencing verification issues, make sure the Salesforce user which is used to import the data has English language and English (United States) location selected. 

Use the Data Import Wizard, In last stage getting the error Records Failed

 

 

 

#Data Management

5 个回答
撰写回答...
0/9000
Claude Douglas (Cloud Parish LLC 的 Salesforce Admin/Consultant)
2021年5月14日 15:57
Change Background color in rich text component
Currently Looking for a way to change the background color in a rich text component in lightning when displaying a custom message. Currently it is white but I would like to change the background to red. I can only change the text color.
3 个回答
  1. Jimmy petar
    6月21日 07:39

    You can change the background color in the rich text component by using the style or editor settings available in your platform. Choose a color that improves readability and matches your design theme. If you want a more creative appearance, pairing the background with a font unik style can make the content look more attractive and visually engaging.

撰写回答...
0/9000
Kyle Taylor (YouFit 的 IT & App Support Analyst)
2019年2月6日 16:58
How can I remove "mark complete" button in tasks highlight panel?
Salesforce Spring ’19 Release added a "mark complete" button/action to the tasks highlight panel. How can I remove that button? 
14 个回答
  1. Sajid Sanadi (CGI)
    6月24日 10:40

    We can do it by using 'Edit Page', Check 'Hide Follow/Unfollow Button(Desktop only)'We can do it by using 'Edit Page', Check 'Hide Follow/Unfollow Button(Desktop only)'

     

     

撰写回答...
0/9000
sales force
2014年4月24日 16:06
In a trigger there are 1000 records how can you execute 200 records for each batch?
4 个回答
  1. Ahmad Ali
    6月24日 05:13

    A Salesforce trigger executes on the entire batch it receives—you can't split 1,000 trigger records into batches of 200 within the trigger itself. If you need to process records in smaller chunks, use an asynchronous approach such as Batch Apex (batch size of 200), Queueable Apex, or process the records in manageable collections after the trigger fires.

    Always keep your trigger bulkified and avoid DML or SOQL inside loops to stay within governor limits.

    For developers looking to improve their Salesforce skills while exploring other online learning resources, QuranPakTutors.com demonstrates how well-structured educational platforms can make learning more effective through personalized guidance.

撰写回答...
0/9000