We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [data-export]

This tag is used for questions about extracting data from a Salesforce Org's database. There are a variety of means of accomplishing this task. Which method one might choose to use will depend on several factors that would include both the final destination of the data and the purpose behind the data export/extraction.

Filter by
Sorted by
Tagged with
1
vote
0answers
20 views

Providing a list of data to non-users securely [closed]

We have a requirement to send data to a list of people who are not users. This data is, and should be treated as, highly secure. These people are owed this data and are allowed to view it but it ...
2
votes
0answers
22 views

How to export data tree using SFDX with User object lookup field

I've a custom object with a custom User lookup field. When I use force:data:tree:export command results into following errors: Reference User not found for UserLookupField__c. Skipping record ...
1
vote
1answer
28 views

Extracting all contacts from Marketing Cloud Contact Builder

I am looking to clean up the contacts in Contact Builder. There are many records (about 5x the amount) than I am actually using in my Marketing Cloud Email Studio instance (All Subscribers). We ...
0
votes
0answers
8 views

Salesforce CLI data tree command load Account with User lookup

I want to export and import an account record that has a custom field lookup to User table. I was able to do that with Account and Contact. But I am not able to get User- Account relationship.Is there ...
0
votes
0answers
19 views

Exceeded max length for one record data loader

How can I spot which record exceeds the limit shown by data loader when I try to insert the CSV in my 'to' salesforce environement? The same files export fine in my 'from' environment. I have tried ...
2
votes
1answer
40 views

Export and Import of Salesforce Files and Notes from one production org to another production org

I have completed a data export of an org we acquired through the following steps: In Setup, navigate to Data Management | Data Export Click on either Export Now or Schedule Export button, whichever ...
0
votes
0answers
12 views

Content Version export file names

I am attempting to export all of the attachments in our Chatter. I tried to use Data Export to export ContentDocument, ContentFolder, and ContentVersion but the files I got in the ContentVersion ...
0
votes
0answers
29 views

export CSV without redirect to a blank page

i am trying to export my data as csv file using another csv VF page, but the problem is that it redirect automatically to a blank page, and i want to staty in the same page after export. i have tried ...
2
votes
1answer
21 views

SFDX CLI export more than 10k records

I'm trying to export records from an object that holds 20k records, and I'm using the sfdx force:data:tree:export command but it returns a max of 10k records. How do I export the remaining records, ...
0
votes
2answers
73 views

Optimal way to transfer data from marketing cloud to external server? [closed]

I'm trying to extract data from Salesforce MC to my server so that i could apply my custom machine learning algorithm..What is the optimal way to do it.currently i'm using Rest and SOAP API
0
votes
0answers
14 views

Visualforce after excel file export, broken file name issue

Now im trying to appoint an excel export name dynamically like this. but after export this source of code, <apex:page standardController="Account" extensions="registerForm" sidebar="false" ...
0
votes
1answer
40 views

Export list from Journey Builder

We have a Reactivation Journey targeting inactive customers. I want to export a list of customers who have not been reactivated by the end of the Journey so I can pass on csv file to our Outbound team ...
0
votes
1answer
61 views

Archive master-detail relationship Custom Objects with Attachments into Big Objects

We are running into a problem when querying and reporting performance is degrading due to having huge number of records on org of some specific custom objects. Basically in our use case, we are not ...
1
vote
1answer
44 views

SFDX FORCE:DATA:TREE:EXPORT Nested __r Relationship Query

I am attempting to export data using the FORCE:DATA:TREE:EXPORT CLI command, using a nested query like the following (for use in our Scratch-Orgs): SELECT ...,(SELECT ... FROM My_Custom_Object__r) ...
1
vote
1answer
27 views

force:data:tree:export / force:data:tree:import across __r relationships

I am still fairly new to SaleforceDX. I have been tasked with putting together a sample data plan matching a small portion of our production data, for our new Scratch-Orgs. With foreign-key type ...
-1
votes
1answer
31 views

Salesforce Data Loader OAuth not taking another email address

I am trying to log in to a production environment in Data Loader through OAuth and giving a custom domain, then it is taking my personal outlook account and directly giving an error without giving ...
2
votes
0answers
48 views

How to use sfdx force:data:tree:export to export CPQ Bundle Product for import into a new scratch org?

For starters I am trying to only export set of Products, Feature and Options that comprise a single bundle Product, but having problems because Product Option object has two lookup relationships to ...
0
votes
0answers
18 views

Get last automation activities

I bumped into an issue with getting the data of automation activities: In the Automation Studio there is the Activity tab with "Run Log". How I can get the data of Start/Completed time for the list of ...
3
votes
0answers
31 views

salesforce DX: Export/import products prices and price books with sfdx data:tree:export

I'm need to have a post refresh script that would migrate products with prices. I thought using DX could save me few hours and I tried the data:tree:export command and steps described in this thread ...
1
vote
2answers
45 views

Variance Alerts for Triggered Emails - Marketing Cloud Email Studio

Within email studio we have a set of triggered emails. While we can go data extract s to see how many emails have been sent, it's often difficult to see if a the variance of a particular send from the ...
0
votes
0answers
15 views

Security - See which user exported reports [duplicate]

Is there a way which I can know which user made export to report? Details about the user, date and time and the report name? (A free tool will be great). Thanks!
0
votes
2answers
28 views

Email alert to admin on account export through apex dataloader

I would like to know if there is any standard functionality or any possible custom solution for making an email notification to the admin of the org when any data on account or other object is being ...
0
votes
2answers
112 views

I need data backup and all metadata backup of salesforce org including Managed package

I need data backup and all metadata backup of salesforce org including Managed package. I need all components including managed package such as cloud sense .Please suggest
1
vote
1answer
107 views

How to perform data extract hourly for current day

When configuring a Data Extract Activity in Automation Studio there are two date options available : Rolling Date Range This option allows you to choose a 1 Day rolling range at it's most specific, ...
1
vote
1answer
260 views

Export from Data Extension to open in Excel columns

When doing a DE export using automation studio data extension export activity, I've exported data from a DE to a file to SFMC SFTP with tab delimitation. I've tried as .csv and and .txt but when I ...
0
votes
1answer
385 views

SFDX commands to export and import related objects

I have read everything in the documentation on how to export and import data between orgs using SFDX commands. But I am struggling to write a script which serializes all related objects. Here is the ...
0
votes
0answers
34 views

Why csv file exported from salesforce do not has the same column name with report?

I recently found the csv file exported by Salesforce do not have same column name with the report. Is it expected or an issue? For example, The column name in report is "Age": The column info in ...
0
votes
2answers
205 views

NullPointerException processing XML configuration for Salesforce Data Loader CLI

Unfortunately I am unable to get Data Loader CLI (v45.0.0 running on Windows) running properly. This is the command I am using: process "C:\Users\erik\dataloader\custom" Account Even when I use a ...
0
votes
0answers
72 views

How to use force:data:tree:export to export data with junction objects or with more than one level of master-detail? [duplicate]

I don't understand how to use sfdx force:data:tree:export with use cases slightly more complicated than the ones in the Salesforce DX Developer Guide. With simple data with at most one level of master-...
4
votes
1answer
498 views

DX CLI force:data:tree:export Query returned no results

Records are returned when I execute this sfdx force:data:soql:query -u Dev --json --query "SELECT Id, Name, (SELECT Id, Name, AccountId FROM Contacts) FROM Account WHERE Id IN ('0010z00001T1uXSAAZ','...
0
votes
1answer
89 views

Tracking who Exports Reports

Yesterday I exported a couple of reports and wanted to track these which has hit the 24hr mark. The following day I went to workbench and through Querying the EventLogFile Object and looking at the ...
1
vote
1answer
255 views

How to export the bulk of images in content in salesforce marketing cloud?

I need to export all images in content tab in marketing cloud. Here uploading option available. But I need to export/download. This option not available. Could anybody please tell me, How to export ...
0
votes
0answers
48 views

Export list of Automations from Automation Studio

Is it possible to export a data file containing all the Active Automations - as much detail as possible. We're actually migrating away from SF and I need to get an understanding of our existing ...
0
votes
0answers
70 views

Unable to extract Attachments and Files from Org

I am trying to move all the attachments and files from one org to another org but my attachments of account and opportunity are above 10000, I download the data loader but it is showing "Java heap ...
0
votes
1answer
112 views

Export records from Salesforce based on a CSV input

I have a report (.csv) from an external system with a list of 1000+ record ids. I'd like to extract information from this records in salesforce to another .csv file. I know there are some workarounds,...
0
votes
1answer
140 views

How can I batch rename attachments I've exported?

I'm trying to rename exported attachments using the mac instructions here: https://help.salesforce.com/articleView?id=000232859&type=1 But I'm receiving a No such file or directory error and I ...
0
votes
1answer
23 views

Why two exports would be different and How to identify the differences [closed]

I have two exports. One of the activity object at the end of November. One of the activity object at the end of December. Both are the same queries and neither have date restrictions(so they ...
0
votes
1answer
399 views

Export Users' list

Is there a way to export the list of users that we create in Marketing Cloud. I see an import option there, but don't see an export option. Either it is disabled for my account or it is not available ...
1
vote
1answer
83 views

Data view for A/B Tests?

I'm trying to export our Job data to a data warehouse and it'd be helpful to know which of the jobs we're exporting are associated with AB tests. I can definitely see that Marketing Cloud has some ...
1
vote
1answer
54 views

Best way to export records with attachments

I'm specifically trying to do this with cases. We have a script written internally to handle this but I just wanted to make sure there wasn't a better way.
1
vote
2answers
60 views

How to export limited rows from synchronized database from marketing cloud?

We've few synchronized databases integrated in marketing cloud from sales cloud like "Lead" , "Enquiry", "Opportunity" etc. This tables are huge and ranges around 2 GB. I want to export only some ...
3
votes
0answers
91 views

SFDX force:data:tree:export Document “Reference”

Since you cannot have a formal field relationship (Lookup) from an SObject to a Document object we have a SObject (let's call it "Settings") that "references" a Document object by simply storing a ...
11
votes
1answer
537 views

SFDX force:data:tree:export Beyond 1 Level Deep

How are people doing force:data:tree:export/import on data in their orgs when the object relationship runs more than 1 level deep? From the doc: In each specified relationship, only one level of ...
2
votes
1answer
96 views

Exporting Related Object Records - Bulk Api / DataLoader

I am looking to export only case comments and notes related to particular standard and custom objects. Ex: All CaseComments for cases of a particular record type. All notes for a custom object with a ...
0
votes
1answer
24 views

Bulk export opportunities related to multiple contacts

I have a list of ~200 different contacts (and their SF IDs) and I'd like to get a CSV of all their associated opportunities from SF. The only way I know how to do so is to create an Opportunities ...
0
votes
2answers
429 views

Restrict a User to export data

What and how a data export can be restricted for a user? I want user still have access to data from UI, but I don't want him to mass export data either through data export or API.
1
vote
1answer
28 views

Do deployments affect/remove data export files?

I am preparing to deploy a huge change set from Sandbox to Production. I have done a data export of Production which has generated 20+ .zip files = ~30gb. I am busy downloading these files, but don't ...
0
votes
2answers
470 views

Junk Characters in excel

I exported my client's data as .csv file but when i open it in excel then it will show junk characters for Blank spaces after any character like below but in csv file blank spaces treat same as blank ...
1
vote
2answers
77 views

Data Export using Data Loader

I am exporting data from Salesforce using Data Loader, now I am facing some issues with the exported CSV file. Let me give an example, In my custom object, I have some data stored as 23-02-07 which ...
0
votes
1answer
435 views

Data Loader not exporting notes despite records in system

While we are able to export other objects, and can see Notes in the system under Contact records, Data Loader exports only headers and no records under Export All. We are using the "Notes" and "Files" ...