Data Management | Salesforce Trailblazer Community

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!

3 respuestas

Nasim Ahmed Ansary (LTIMindtree)
2 jul, 08:34
Hi @Eileen Gentile, Thanks for your response. You suggested using the API endpoint /services/data/vXX.0/sobjects/ContentVersion/{Id}/VersionData to retrieve documents. However, my requirement is to download files from the Attachment object. I have been testing the Attachment APIs, but they are not working as expected. The request returns an HTTP 200 status, yet no records or file content are returned. I am currently investigating the root cause and would appreciate any guidance on why this behavior might occur.

Agregar un comentario

Escribir una respuesta...

0/9000

10 mar 2013, 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 respuestas

Olga Mendscheritski
10 mar 2013, 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.

Agregar un comentario

Escribir una respuesta...

0/9000

30 jun, 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 respuesta

Vuk Stajic (MVRK Inc.) Forum Ambassador
30 jun, 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!

Agregar un comentario

Escribir una respuesta...

0/9000

19 jul 2019, 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 respuestas

Alpha MarkeX
12 jun, 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."

Agregar un comentario

Escribir una respuesta...

0/9000

16 ene 2018, 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 respuestas

Omar Rodriguez (Pina Records)
19 ene 2018, 06:42
https://success.salesforce.com/ideaView?id=08730000000BpVj

https://success.salesforce.com/ideaView?id=08730000000BpgjAAC

Agregar un comentario

Escribir una respuesta...

0/9000

16 jun, 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 respuestas

Keiji Otsubo
24 jun, 22:39
Hi ,

Here's what I did:
Deleted the state and country column as we dont map it during import and now it works.

https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000Ti9zK0AR

Agregar un comentario

Escribir una respuesta...

0/9000

14 may 2021, 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 respuestas

Jimmy petar
21 jun, 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.

Agregar un comentario

Escribir una respuesta...

0/9000

6 feb 2019, 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 respuestas

Sajid Sanadi (CGI)
24 jun, 10:40
We can do it by using 'Edit Page', Check 'Hide Follow/Unfollow Button(Desktop only)'

Agregar un comentario

Escribir una respuesta...

0/9000

24 abr 2014, 16:06

In a trigger there are 1000 records how can you execute 200 records for each batch?

4 respuestas

Ahmad Ali
24 jun, 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.