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
0
votes
0answers
15 views

Is their any way by which we can Export Content from a Salesforce CMS workspace and Import the same content to another Workspace?

I have a requirement, In which I need to export content of one salesforce CMS workspace to another CMS workspace, I crawled the internet but found nothing helpful. Their were some ideas regarding ...
0
votes
0answers
21 views

Is there a way to export all process builder Nodes and actions information in a sandbox? [closed]

Is there a way to export all process builder Nodes and actions information in a sandbox? I have tried exporting the process builder information from Workbench but it will give you only the information ...
0
votes
0answers
15 views

How are api limits calculated for data export using data loader tool?

I want to export a million records into csvs using data loader, but as precautionary step I would like to know how the api limits would be calculated to export these million records?
0
votes
2answers
40 views

Exposing Data through REST API

I need to expose certain SFMC data to a third party app that doesn't have a ready-made Salesforce integration. I'm considering using REST API to expose the data and this action should be triggered ...
1
vote
0answers
26 views

The best practice of download objects with millions of records [duplicate]

We are looking for a scalable & performant way to download Salesforce Objects which can support objects with tens of millions records. I have two approaches in mind: Use Bulk Query API 2.0: It's ...
0
votes
1answer
27 views

Retrieve contacts based on a list of external IDs

I have a csv with 126,000 External Ids for contacts coming from another system. I need to export all of the contacts from salesforce where the id is in the CSV. I was thinking of doing an update with ...
0
votes
1answer
30 views

Trouble with sfdx force:data:bulk:upsert to do a basic import

We are looking to automate the creation of demo orgs using Scratch orgs. We have a very light data set that we want to include in our scratch org, but it is highly relational. We are looking to get ...
0
votes
1answer
51 views

Specify a fie path for External SFTP Marketing Cloud

I need to drop a file on an External SFTP from Marketing Cloud which I know I can do with a file transfer activity but I can only choose a pre-defined file destination. In that destination setup in ...
1
vote
1answer
51 views

Extract Type - Tracking Extract - Journey name

I've created a series of Tracking Extracts on my account. Which field should I use to export the Journey Name that is associated with the email data of each extract?
0
votes
1answer
28 views

What is the difference between supported Salesforce, Apex, and Dataloader text encodings?

If I export a file of Custom_Object__c with a Custom_Field__c (developer console and salesforce page layout displayed) value of: XX – XYZ I receive an exported CSV with: XX � XYZ If I open that ...
0
votes
2answers
68 views

How can I export a report in “Printable View” from URL

I know I can do a one-click download for a report using "?export=1&enc=UTF-8&xf=xls" (thanks to Daniel Ballinger for sharing this here ), but does anyone know how I can download the "...
1
vote
2answers
43 views

Exporting data from partial sandbox to developer sandbox for related objects

I am trying to export Account and Opportunity data using data loader from partial sandbox to the developer sandbox. Currently, the hurdle is that in Opportunity Account is a lookup and required field. ...
0
votes
1answer
27 views

URL to export to csv with parameters doesn't work anymore in Lightning whereas it works well within classic

we use a url like this one to export data from a SFDC report to CSV, by sending parameters : https://www.salesforce.com/?pv0=123&pv2=1/1/2020&export=1&enc=ISO-8859-1&xf=localecsv ...
0
votes
2answers
24 views

Exporting 2 address lines - eliminating line feed error [closed]

Mailer service provider here... We have regular problems with data coming from SalesForce users. Your software is intended to support only a single street address line. But against your advice, some ...
0
votes
1answer
150 views

Dataloader stuck while exporting object

I have installed dataloader version 48 in my mac, I too have installed Zulu Java Sdk. I am trying to export Account object data from the sandbox and so far I am able to login using Password ...
3
votes
1answer
96 views

Is it impossible to export more than 2000 records from an aggregate SOQL query?

It seems odd to me that this would be simply impossible to do, but the aggregate query below returns more than 2000 records, and it appears that there is no possible way to even run the query, let ...
0
votes
1answer
57 views

Import/Export Hierarchical Data to Custom Object in as few steps as possible

Is there a Salesforce standard (or open source) approach to importing hierarchical data into a "custom" object? Suppose all UserRole records are exported to .csv (assume the org has/uses a UserRole ...
0
votes
2answers
17 views

Incorrect signature for a SchedulableContext

I'm trying to create a daily export of a .csv report on Salesforce Apex. The problem is I can't test this code beacause I dont know what to put instead of "sc" when i try to excute it. Here is my ...
0
votes
1answer
36 views

Create an Automation that exports Data Extension data only from the previous day

I have an Automation containing a Data Extract and File Transfer that exports the contents of a Data Extension each day. Is there a way to only export data from the previous day, rather than ...
0
votes
0answers
28 views

Managed package field is not available to extract or SOQL query

I have this custom field (Other Source 3) that I want to data extract out as below : It is a Managed Package custom field available on Salesforce environment that is Not editable and of type Lookup(...
0
votes
0answers
16 views

Deactivate Data Connector for Salesforce Google Sheets

I know this is somewhat of a reverse question, but it there a way to block Data Connector for Salesforce. Users can view their data in the platform, and have all the tools to manipulate it, but we don'...
0
votes
0answers
55 views

Export CSV using Custom buttons

i need to export search result CSV from my custom object view. Custom button can activate javascript, so i think if i could use it. i know that i can get CSV from report or Dataloader, but for ...
0
votes
0answers
53 views

Command Line data loader; is an .SDL needed for extract?

I'm going through and creating the xml doc for an automated data loader extract. I put in the extractSOQL query and i'm wondering if i need a .sdl mapping? I just need the extract in a CSV in no ...
0
votes
1answer
19 views

Opportunity Detail Export

Does anyone know of a simple way to export details from an opportunity record into a styled form? Our sales team export all the details to Docusign to create a client contract. We're trying to ...
0
votes
2answers
112 views

Problem with CSV file format from Marketing Cloud SFTP

I don't know if someone will be able to solve my problem but let's try it anyway. Here is my situation : I have an automation that contains a filter activity (step 1), a data extract activity (...
0
votes
0answers
30 views

How to import records of 2 parent objects and a junction object inbetween them using Data:Tree in SFDX?

I created some test data in a scratch org for a Trailhead project and i wanted to try to export it and then import it into my Devhub. I ran three different export queries and then created my own plan ....
1
vote
0answers
48 views

Report Rest API (asynchronous run and excel export)

I'm trying to use Report Rest API to filter and export some of my reports. My first approach with synchronous report runs works pretty well, but I bumped into 500 batches' run per hour limitation. I ...
0
votes
1answer
113 views

Is there a way to default the Export CSV file origin of dataloader to UTF-8?

I export Salesforce data out to CSV on a frequent basis especially in a foreign language like Mandarin. Even if I check the UTF-8 options on Dataloader settings : The file that gets exported out ...
1
vote
0answers
23 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
41 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 ...
0
votes
2answers
843 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
9 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
60 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
823 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
38 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
122 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
87 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
281 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
25 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
220 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
139 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
124 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
181 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
48 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 ...
3
votes
0answers
137 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 ...
4
votes
0answers
67 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
74 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
16 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
55 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
534 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
2 3 4 5 6