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.
279
questions
-2
votes
0
answers
46
views
How to export All Salesforce Files and Attachments
I have a requirement to take backup of all Files and Attachments in Salesforce and I can't use the Export option available on Salesforce UI as it is disabled now (As I have already used export now ...
0
votes
1
answer
40
views
How to insert predefined amount of blank spaces after a word
I have a situation where I need to export the data from salesforce object and generate the txt or csv file for our client to read and process.I can not use data loader beacuse file should be of a ...
-1
votes
1
answer
59
views
Transfer Metadata Only from a Production Org to another production Org (in trial)
I saw others threads speaking about this topic but they didn't really help me or I must not have understood them!
I need to transfer a batch (the whole existing ORG) of metadata to a newly opened SF ...
-2
votes
1
answer
86
views
Gridlines in excel sheet are disappearing by default after table export from vf page into excel sheet
I have successfully exported the table in visualforce page into an excel sheet, but after opening the sheet grid lines are disappearing by default.
How to show gridlines automatically when the file is ...
- 11
0
votes
0
answers
80
views
How to export ContactID list using email addresses and Dataloader
I am very, very new to Salesforce and DataLoader, so I apologize in advance if my question is very basic.
Objective: Obtain ContactID's based on CSV list of emails
I have a large list of emails, and I ...
0
votes
0
answers
62
views
Salesforce CLI Export Error sObject type 'Product2' is not supported
I logged into CLI successfully with the command
sfdx force:auth:web:login -r https://login.salesforce.com
And tried exporting using the below command and below is the error
C:\Users\xxxxx>sfdx ...
0
votes
1
answer
37
views
Monitor Data Loader Exports [closed]
We have few users with Data loader access. I would like to track their activity especially how do I monitor their exports please ?
- 9
0
votes
0
answers
87
views
Exporting selected column in marketing column DE without SQL
Is there any way to export a selected column from marketing cloud DE with multiple columns.
This can be done with SQL but I am looking for a way without using it as it is for marketers.
Thank you
- 31
0
votes
0
answers
129
views
Export files of a particular object
Is there any way to export all the files of a particular object in an org?
- 31
0
votes
1
answer
789
views
Unknown field error when importing records with Inspector
I'm trying to import records from one sandbox to another that is a exact copy withouth records.
I export CSV records with Inspector from one sandbox. Problem is when I paste CSV data in Import Records....
- 305
0
votes
1
answer
495
views
How can I calculate daily active users for salesforce logins?
We are exporting data from salesforce into our data warehouse, and I need to be able to calculate
daily active users
daily sessions
in order to be able to combine it with metrics calculated from ...
- 101
0
votes
1
answer
152
views
Missing records after Marketing Cloud FTP Export in my local file
Today I did an Enhanced FTP export from a Data Extension that was holding 8,498,752 records with 166 MB.
In the Enhanced FTP directory, a file for it was generated with the size of 203,632 KB.
I ...
1
vote
1
answer
875
views
Export and Import Macro & MacroInstructions
Can anyone please share how to export Macro & It's instructions together and import them in another org? I'm using Salesforce dataloader tool.
- 11
0
votes
1
answer
621
views
Export results from Query Studio in excel file or SFTP
I am trying to export the results I get in Query Studio to Excel files without importing them into a data extension. Is there a way to do so?
0
votes
1
answer
428
views
Automation Studio - I need Data Extract file UTF8 Without BOM
In our automation we are creating a txt file with all of our unsubscribes and put it on our SFTP server. Now the problem is that the data extract activity in SFMC automation says that the file is ...
- 1
3
votes
2
answers
781
views
Using Access Token from OAuth 2.0 Username-Password Flow to access data export page
Experimenting with whether we can easily automate downloading the weekly backup files, based on Enrico Murru's approach here
We are trying to use c# because we use that a lot already and dont want to ...
- 4,465
0
votes
0
answers
954
views
Export all documents in content document / content version
We have a requirement where we need to periodically export all documents out of salesforce.
I tried the following:
Data loader / dataloader.io but then these gives export in csv file and the content ...
3
votes
1
answer
251
views
Exporting more than 12 billion Data Extension records
What's the best practice/solution to export more than 12 billion records from SendLog DE in the marketing cloud. As per MC help document suggestion, it should be no more than 30 Million records per ...
- 549
0
votes
2
answers
4k
views
Export data and download file
I am exporting some data into csv from org and want to download that file. Now i can just send it to email. Any ideas?
List<Account > acclist = [Select id,name , CreatedDate , lastModifiedDate ...
- 51
0
votes
0
answers
136
views
Using python to export from pardot when pypardots won't do
I finally got authentication to work and I can get the access token and the reset token which I knwo got pypardotsf to work. However pypardot doesn't seem to support export. So, I tried it au ...
1
vote
0
answers
204
views
Roll up summary field max value in database
I want to export Roll up summary fields to external system. What should be database column length. Should i use int, bigint or any other data type. I was just doing testing in my org and roll up ...
- 3,404
0
votes
0
answers
129
views
Joining up data from multiple sfdx force:data:tree:export outputs [duplicate]
I have a 3 level deep graph of records that I would like to export: parent records, child records and a grand-child records.
Reading this Example: Export and Import Data Between Orgs, I was interested ...
- 134k
0
votes
2
answers
714
views
Unable to create File Locations in SFMC
The documentation for Create a File Transfer Location (https://help.salesforce.com/articleView?id=sf.mc_overview_create_file_transfer_location.htm&type=5) says to navigate to:
Click Setup.
Under ...
1
vote
1
answer
307
views
Data Extension or Data Export log
I would like to see who has been exporting data from our data extensions in the past year but I am not sure if this functionality is available in Marketing Cloud.
I have tried with Audit Trail (I have ...
1
vote
1
answer
279
views
How can I export all my Salesforce Community data? [closed]
My team is currently attempting to migrate out of Salesforce Community, but we are having a really hard time figuring out how we could:
Export all discussions
Export all users
The documentation for ...
- 111
1
vote
1
answer
243
views
How do I export setup info from one salesforce system and import it into another?
I have created some custom case page layouts that I want to export as a file on my PC.
I want to do this to:
manage the case type definition with source control
deploy on another salesforce server by ...
- 111
0
votes
1
answer
537
views
Error exporting data: Didn't understand relationship 'customObject__r' in FROM part of query call. If you are attempting to use a custom relationship
I'm trying to export some data from my sandbox org for import into a scratch org, but I seem to be encountering an issue with my query:
MediaQualitySetJunction__c looks like this:
And this is the ...
- 271
0
votes
1
answer
226
views
Export records from Salesforce to deploy to another org which are useful for configurations like Custom Settings
I have retrieved the metadata from sandbox to deploy it to the higher org using ANT. ANT have created folders for all the components like objects, classes, etc.
But, it did not retrieved many records ...
- 1
1
vote
1
answer
911
views
Issue with Export to Csv when name consists of comma
we are trying to export data into csv file using Apex and Visualforce page in Salesforce .
The data is being exported but we have an issue .
Here we are exporting record from an object(Text Fields) .
...
- 25
1
vote
0
answers
1k
views
Empty Column in Csv , when exporting data as csv using Lwc component
I'm very new to salesforce and lwc , i'm trying to Export some static and some dynamic data in a csv using LWC Salesforce and succeeded in that( except with a new column has been added from the
...
- 25
1
vote
1
answer
505
views
Is there a way to export what "where is this used?" details?
I'm trying to collect and analyze field metadata. It would be extremely helpful if there was a way to mass export (e.g. all account fields) with the details around where the fields are used (same view ...
- 13
0
votes
1
answer
3k
views
Export custom settings data
is there any simple way to export custom settings' data? I can import them by Data Import Wizard, but how can export them as a .csv?
1
vote
1
answer
530
views
Personally identifiable information (PII) safeguard while exporting case data
I have a requirement where a customer will export their case data however, they also want to remove/mask any PII data from the case export.
All that I have read on this topic is platform encryption or ...
- 11
0
votes
1
answer
162
views
Salesforce report truncation via external tool
I have a question. Our users are using Excel that they connect to Salesforce report but Salesforce truncate the long texts to 255 chars. I have tried some other tools but there seems to be the same ...
- 11
1
vote
1
answer
1k
views
Transferring data from Salesforce MC to GCS
My company asked me to find a way to transfer a data extract from Salesforce Marketing Cloud in a Google Cloud Storage bucket, so that they can bring it into Data Studio or Analytics.
I've done some ...
- 11
0
votes
2
answers
556
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 ...
- 69
1
vote
0
answers
51
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 ...
- 11
1
vote
1
answer
512
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 ...
- 447
1
vote
2
answers
2k
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 ...
- 377
1
vote
1
answer
1k
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?
- 113
1
vote
1
answer
164
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 ...
- 2,039
1
vote
2
answers
2k
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 "...
- 13
1
vote
2
answers
775
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.
...
- 215
1
vote
1
answer
884
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
...
-1
votes
2
answers
384
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 ...
- 1
1
vote
1
answer
2k
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 ...
- 215
4
votes
1
answer
1k
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 ...
- 918
0
votes
1
answer
454
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 ...
- 1,090
0
votes
2
answers
36
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 ...
- 1
0
votes
1
answer
516
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 ...
- 113