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
1 answer
21 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....
user avatar
  • 165
0 votes
1 answer
32 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 ...
user avatar
0 votes
1 answer
20 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 ...
user avatar
0 votes
1 answer
185 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.
user avatar
  • 1
0 votes
0 answers
105 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?
user avatar
0 votes
1 answer
78 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 ...
user avatar
  • 1
2 votes
2 answers
156 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 ...
user avatar
  • 4,225
0 votes
0 answers
126 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 ...
user avatar
3 votes
1 answer
77 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 ...
user avatar
  • 525
0 votes
1 answer
227 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 ...
user avatar
  • 41
0 votes
0 answers
32 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 ...
user avatar
1 vote
0 answers
41 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 ...
user avatar
  • 3,299
0 votes
0 answers
25 views

Is there a way to control which fields are included in a Knowledge Base translation export?

I have followed the instructions to assign knowledge articles to a queue and export them, and it's working fine but it only exports 3 fields for each article: Question Answer Member Information (a ...
user avatar
  • 237
0 votes
0 answers
126 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 ...
user avatar
  • 130k
0 votes
2 answers
244 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 ...
user avatar
1 vote
1 answer
125 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 ...
user avatar
1 vote
1 answer
128 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 ...
user avatar
1 vote
1 answer
108 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 ...
user avatar
  • 111
0 votes
1 answer
188 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 ...
user avatar
0 votes
2 answers
2k views

Installing Data Loader Issue On Windows

I am following the instructions to install Data Loader here: https://help.salesforce.com/articleView?id=loader_install_windows.htm&type=5 I have met all of the requirements. I extract the zip and ...
user avatar
  • 3,179
0 votes
1 answer
135 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 ...
user avatar
  • 1
1 vote
1 answer
395 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) . ...
user avatar
1 vote
0 answers
526 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 ...
user avatar
1 vote
1 answer
218 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 ...
user avatar
0 votes
1 answer
1k 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?
user avatar
1 vote
1 answer
327 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 ...
user avatar
0 votes
1 answer
85 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 ...
user avatar
  • 11
1 vote
1 answer
532 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 ...
user avatar
  • 11
0 votes
2 answers
242 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 ...
user avatar
  • 13
1 vote
0 answers
46 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 ...
user avatar
  • 11
0 votes
1 answer
175 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 ...
user avatar
  • 427
0 votes
1 answer
511 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 ...
user avatar
1 vote
1 answer
1k 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 ...
user avatar
1 vote
1 answer
761 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?
user avatar
1 vote
1 answer
108 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 ...
user avatar
  • 1,838
1 vote
2 answers
1k 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 "...
user avatar
1 vote
2 answers
420 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. ...
user avatar
  • 197
1 vote
1 answer
382 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 ...
user avatar
-1 votes
2 answers
211 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 ...
user avatar
  • 1
0 votes
1 answer
535 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 ...
user avatar
  • 197
3 votes
1 answer
966 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 ...
user avatar
  • 648
0 votes
1 answer
287 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 ...
user avatar
  • 1,080
0 votes
2 answers
20 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 ...
user avatar
  • 1
0 votes
1 answer
224 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 ...
user avatar
0 votes
0 answers
194 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(...
user avatar
  • 1,078
0 votes
0 answers
216 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 ...
user avatar
  • 464
0 votes
1 answer
45 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 ...
user avatar
0 votes
2 answers
817 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 (...
user avatar
0 votes
0 answers
227 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 ....
user avatar
  • 33
1 vote
0 answers
199 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 ...
user avatar
  • 90

1
2 3 4 5 6