Stack Exchange Network

Stack Exchange network consists of 174 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

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 ...

0
votes
2answers
17 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
36 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
0answers
18 views

Mass Export Reports from Org

I have to export 150 reports from my org. Can anyone please suggest best way to do it? I downloaded this package to mass export reports: https://myinstance.lightning.force.com/packagingSetupUI/...
0
votes
1answer
20 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
29 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
33 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
36 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
47 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
15 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
25 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
42 views

Export salesfoce to postgresql?

is there an option to export salesforce data into postgresql (in my local machine)? Is there an opensource one?
0
votes
0answers
27 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
36 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
77 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
0answers
59 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
81 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
158 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
223 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
27 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
43 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
31 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
25 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
41 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
164 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
72 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
146 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 ...
0
votes
0answers
173 views

Export data and import to another organization with DX?

I use SalesforceDX. I would like to export opportunities from scratchOrg and import them into another organization. However, I do not know how to export when lookup field and recordtype are set. I ...
0
votes
0answers
279 views

SFDX - How to export data with record types to reuse in a scratch

I able to export data with RecordRypes using this command. sfdx force:data:tree:export -q " SELECT Id, Name, RecordType.Id, RecordType.Name FROM Account " -u myscratch -d data But when I'm going ...
20
votes
1answer
879 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 ...
0
votes
1answer
171 views

Create a SOQL query by retrieving the field names

I am using data loader from command line to extract data in csv format. I have to hard code the SOQL query in the sfdc.extractionSOQL property. Is there a way to get the field names dynamically and ...
0
votes
1answer
246 views

Extract Data from Salesforce from command line

I want to extract data from Salesforce from command line. I can use data loader by creating process-config file but I need to automate this process using windows batch file. For example, I have 5 ...
2
votes
2answers
299 views

Workaround for SELECT * (SELECT all) in sfdx force:data:tree:export SOQL

In certain parts of our existing Apex code base, we've used dynamic soql in combination with object describe methods as a workaround to achieve the equivalent of SELECT * that's normally available in ...
7
votes
0answers
59 views

Is there a work around to allow binding of variables in the sfdx force:data:tree:export query file

When using sfdx force:data:tree export with an in-line query, you can bind variables by creating them in the cli before running the export command, like so: CURRENTYR=2017 sfdx force:data:tree:export ...
4
votes
1answer
199 views

SFDX force:data:tree:export Invalid SOQL Query When Using File Path to Supply Query

When using the sfdx force:data:tree:export command, the Salesforce Developer Documentation states you can specify a file path in place of an in-line typed query (either option would follow the -q flag)...
0
votes
1answer
272 views

VF Page export as CSV with asian file name

I have VF Page and I manage to export it as CSV file. However, when I try to name the file with asian characters (japanese, chinese etc ...) , it does not show. VF Page: <apex:page controller="...
0
votes
1answer
297 views

Export a DataTable generated by a function (HTML tables) to Excel

Based on the requirements, i have to generate 3 dataTable using a JQuery function like below and i need to implenet a button to export the result into an excel file. I'm currently using contentType="{!...
1
vote
0answers
26 views

Tool to extract Documents on basis of list of IDs [duplicate]

Does anyone know of a tool that if I have a list of Document IDs (from Document Object) I can download the files attached to them? Dataloader seems to just want to give me a body string of Bytes, not ...
0
votes
1answer
34 views

Exclude a trigger running when export data

I have few batch process to extract data. When I run them it hits the DML limit from a trigger. How can I exclude that trigger running when I run the batch
1
vote
1answer
531 views

Is there a custom direct link to download/export reports in one click in lightning?

Is there a link that allows you to directly download a report in LEX (lightning experience) using a single link? In classic, I would use https://org.my.salesforce.com/report_id?view=d&snip&...
0
votes
1answer
2k views

Using Automation Studio to Export a Data Extension

I am working with a client to try to create an automated subscriber list export process. Is there a way use Exact Target's Automation Studio to export data from a Data Extension to either FTP or sent ...
0
votes
0answers
81 views

How to export certain attachment files by Id?

Is it possible in salesforce export only certain attachment files by Id? As I know It is possible to save all Attachments through Data Export. Or Export through Data Loader as binary encoded text but ...
0
votes
1answer
264 views

How to export custom object list/details?

how to export custom object list/details? can we achieve this in apex coding? i want to know how many custom objects are there in org with their names in excel.
1
vote
2answers
238 views

Export all subscribers file content is in hexadecimal, I need it to be readable text

I have an automation to export all subscribers to fetch the "status" column. My shceduled automation extracts the all subscribers list and then drops the file on the dedicated FTP with correct name ...
0
votes
1answer
359 views

Export all contacts with automation issue

I want to export all subscribers to extract the "status" column on every subscriber. I want to automate the steps as in this official documentation. I know how i do it manually but it needs to be ...
0
votes
0answers
358 views

Export Data Extension to FTP

iam facing an issue and hope you can help me out. When exporting a data extension I get a blank error message when trying to export manually direct from DE see picture. As well as using Data Extract ...
0
votes
2answers
112 views

Exporting a data extension messes up the date format

I'm trying to export a Data Extension via a browser download. It is not a large data extension - around 2,000 records. When I open up the exported file (a csv file), I get a mixture of two date ...
0
votes
1answer
158 views

How to export all subscribers from data extension WITH the date of the most recent email they opened

How to export all subscribers from data extension WITH the date of the most recent email they opened? Is there a SQL query that could be used to create this type of Data Extension for export, so that ...