Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
21 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
88 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
15 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-...
2
votes
1answer
33 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
27 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 ...
0
votes
1answer
43 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
20 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
24 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
14 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
42 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
73 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
39 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
45 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
23 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
36 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 ...
8
votes
0answers
128 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
55 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
22 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
96 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
27 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
141 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
47 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
129 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" ...
2
votes
1answer
30 views

export xls limits [closed]

I have to implement an export of a custom table to an Excel (xls) file. I have created a custom Visualforce page and set "contentType =" application / vnd.ms-excel # {! TableExcel.Name} .xls " and ...
0
votes
1answer
65 views

Retrieve data from “FeedTrackedChange” table between particular time period

I want to retrieve data from "FeedTrackedChange" table between particular time period. For Example: select * from FeedTrackedChange where CreatedTime >= jan 2000 But the problem here is there is ...
1
vote
1answer
70 views

Creating a Backup or Archive of a Marketing Cloud Account

After an account migration what would be the best way to "download" and archive as much of the data as possible from an account before it gets shut down? Would everything that can be extracted be ...
1
vote
2answers
68 views

exporting Google sheets into SF Data Extension

my newsletter briefing is managed in google sheets (Links, prices etc.) and I would like to export these data directly into the data extension (UTF8) without c&p, converting and importing. ...
0
votes
1answer
36 views

How to track salesforce report exports

I would like to be able to track exports of reports including the filters of the reports. Do you know of any way that this is possible outside of manual recording?
0
votes
1answer
69 views

Obtaining Values Instead of API Names when Building a DataFlow in Einstein Analytics

I am trying to build a dashboard for my company. However, in order to do that I need to create a dataset. One of the fields that I need to draw for my dataset is an object of picklist type, which ...
0
votes
1answer
90 views

Export salesforce to postgresql?

is there an option to export salesforce data into postgresql (in my local machine)? Is there an opensource one?
-1
votes
0answers
28 views

Methods to export data from professional edition?

We have professional edition of Salescloud and need to do some integration. This could be as simple as a regular data export where a certain field equals a certain value. Is this possible with ...
0
votes
0answers
16 views

How can I export LineItemSchedule IDs and tie them to the Opportunity Product they are associated with in Workbench

I am new to Workbench and don't have any SOQL experience. I am trying to find out the steps (if possible) to export all LineItemSchedule ID's and the related Oppotunity Product Line ID. Any help on ...
0
votes
0answers
56 views

Sending KPIs from Marketing Cloud to Sales Cloud

We're tracking information about - Open performance (open rate): Delivered, total opens, unique opens - Inbox activity: Opens (total + unique), clicks (total + unique), forwards (total + unique), ...
0
votes
1answer
13 views

Can I have Data Exported into Shared device automatically

I have a requirement where I should be able to export users on weekly basis and keep them in shared Device. By going through the salesforce docs it says that we can able to schedule data export but ...
0
votes
0answers
95 views

ANT Migration Tool not pulling correct query fields from Salesforce

I'm using the ANT Migration Tool to obtain a list of all available query fields for several Standard and Custom Objects in my Salesforce environment and I'm running into an issue where the query ...
2
votes
1answer
134 views

SFDX and Powershell script - querying knowledge article version returns SOQL malform error, but it runs fine in DEV Console

I am trying to download a specific knowledge article version (standard - not lightning) using SFDX and powershell. My query gets dynamically generated in the script... and the relevent line of the ...
0
votes
2answers
215 views

How to trigger a phone field to format a phone number

Our Custom_Object__Primary_Phone__c field (type: phone) has tens-of-thousands of numbers not formatted and I am looking for a way to touch this field to initiate an update so the result will be a ...
1
vote
1answer
379 views

Setting parent id of attachment object

I'm trying to write an Apex class that queries data from an sObject and then writes that data to a csv file that is downloaded locally so that it can be uploaded to a big object. I'm adapting the ...
2
votes
1answer
425 views

sfdx data:tree:export objects with relation

Here is the scructure I have: Condition__c: ... fields Account: Lookup to Condition ... fields Invoice__c: Master detail to Account ... fields Invoice_Line__c: Master detail to Invoice ... ...
1
vote
0answers
33 views

Customising the “Export Report” / “Export Details” dialog?

We have a number of changes planned to internal and external-facing systems to achieve greater compliance with GDPR. I have been asked to add a message or pop-up whenever personal data is exported ...
0
votes
1answer
49 views

Broken CSV exports

I've exported several csvs to ftp from synchronized data extension and it appears that they are broken (ie. there are blank rows or certain rows that bleed into the next row. Wondering if this is a ...
0
votes
1answer
40 views

Export Users with group membership

Is there a SOQL query or a method to extract all users, their profiles and group membership from Salesforce?
1
vote
1answer
26 views

How to get the evidence of the email sent for weekly data export?

I configured the Weekly Data Export process logged in as another user with the proper permissions. Now such user is telling me that he didn´t received any email. I also have the data export configured ...
0
votes
2answers
47 views

Data Dump of Attachments

I am trying to do an export of approx 30,000 attachments in our Salesforce Org, Would anyone have been through a similar exercise and can advise best practice or the best way / tool to do this? Kind ...
0
votes
1answer
355 views

Scheduled Data Export: how to obtain ContentVersion linking data

I've used the Data Export feature to pull down ContentVersion data for Files and (Enhanced) Notes from a Salesforce org that's being migrated into a different org. I've been unable to locate the ...
3
votes
1answer
98 views

SFMC Soap API Retrieve existing Tracking DataExtract

i am trying to retrieve an existing DataExtract filtering by CustomerKey but the API returns me a Status OK without any objects. Also tried to retrieve without filter bu i get the same result. I am ...
1
vote
2answers
207 views

Salesforce relational data backup and reload after sandbox refresh

I have a specific situation. There is an important relational data set (data spanning across more than 5 tables) in full sandbox which I do not want it to be deleted when I do the sandbox refresh with ...
1
vote
1answer
30 views

Quick export of newly added custom objects to external app/database

Our account managers create items in SF(sObjects, if that matters), which soon afterwards need to be used in our web app(Ruby on Rails with PostgreSQL). The data sync should happen as soon as ...
21
votes
1answer
1k views

SFDX -How to Export data with record types to put in a scratch / qa org

So i am trying to automate some of the data tasks and Export data from an org to be imported into scratch orgs on creation. The records I am trying to export have record types. The record types are ...