Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

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
1 vote
1 answer
50 views

how to generate xlsx file from LWC

I am trying to generate an excel file in xlsx format and here is my code var element = 'data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,' + encodeURIComponent(doc); let ...
PARAG TALUKA's user avatar
-1 votes
1 answer
26 views

How do I resolve timeout error when pulling in a large object from Salesforce

I will preface this by saying that I am new to PowerBI, but experienced in Salesforce. I am trying to pull in several objects into a PowerBI report by going to Get Data>Salesforce Objects>Custom....
Laurel Link's user avatar
0 votes
1 answer
31 views

List view button on 'Products' (aka OLIs) related list in opportunity

I have an ask to add a button on the opportunitylineItem related list of the opportunity where that button will download all olis into a csv. I have hit 2 issues that i'll describe: I simply haven't ...
Langloic's user avatar
0 votes
1 answer
98 views

Salesforce Inspector crashing when copying large results

When trying to copy the results of a query (excel, csv, or JSON format), Chrome will crash completely. The query itself will complete successfully, only when copying will the browser crash. This is ...
janp's user avatar
  • 11
2 votes
0 answers
32 views

Data Loader - Unable to Proceed beyond Edit Your Query

I'm trying to export data using Data Loader but I keep running into the same issue. This seems to be happening regardless of which object I'm trying to export data for - no matter what I select, I'm ...
Charles Burns's user avatar
2 votes
1 answer
94 views

LWC Export query results to Excel/csv where rows > 2000 prior to delete

I have an LWC where I run a query to clean up/delete records. The LWC works fine for showing 2000 rows at a time in a datagrid (although 2000 is a bit of a big grid so I set 2000 as the max but ...
Irene's user avatar
  • 1,829
0 votes
1 answer
40 views

Tracking Email and SMS metrics with a custom field

My company sends order confirmation emails that each include an order number along with other transactional comms that also use this same order number. I need to be able to export the sent/bounced ...
JulieHurtz's user avatar
1 vote
2 answers
195 views

Downloaded data in excel format using LWC in salesforce. When i open the file it shows warning prompt: File format and extension do not match

Hi, Currently iam implementing functionality of downloading data using LWC by using following code: let doc = '<table>'; // Add styles for the table doc += '<style>'; doc +...
Murali AS's user avatar
0 votes
1 answer
113 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 ...
SFDCDeveloper's user avatar
-1 votes
1 answer
129 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 ...
JACOPO PARISI's user avatar
-2 votes
1 answer
128 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 ...
Ameer's user avatar
  • 21
0 votes
1 answer
68 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 ?
Preethi's user avatar
  • 17
0 votes
0 answers
142 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
Sandeept's user avatar
0 votes
0 answers
174 views

Export files of a particular object

Is there any way to export all the files of a particular object in an org?
user121495's user avatar
0 votes
1 answer
1k 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....
CPS's user avatar
  • 345
0 votes
1 answer
788 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 ...
Brad Davis's user avatar
0 votes
1 answer
246 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 ...
Shwetha Gowda's user avatar
1 vote
1 answer
1k 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.
Saz's user avatar
  • 11
0 votes
1 answer
842 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?
Fatma MABROUK's user avatar
0 votes
1 answer
592 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 ...
Ronald's user avatar
  • 1
3 votes
2 answers
970 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 ...
gorav's user avatar
  • 4,527
3 votes
1 answer
346 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 ...
Sohail's user avatar
  • 549
0 votes
2 answers
5k 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 ...
Terdivi's user avatar
  • 51
0 votes
0 answers
183 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 ...
Henrietta Martingale's user avatar
1 vote
0 answers
255 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 ...
Manjot Singh's user avatar
  • 3,516
0 votes
0 answers
130 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 ...
Keith C's user avatar
  • 136k
0 votes
2 answers
938 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 ...
melissajeanne's user avatar
1 vote
1 answer
389 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 ...
Laura Vasquez's user avatar
1 vote
1 answer
348 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 ...
georgebrindeiro's user avatar
1 vote
1 answer
303 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 ...
Bohemian's user avatar
  • 111
0 votes
1 answer
609 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 ...
ProgrammingLlama's user avatar
0 votes
1 answer
305 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 ...
Rahul's user avatar
  • 1
1 vote
1 answer
1k 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) . ...
Tarun teja's user avatar
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 ...
Tarun teja's user avatar
1 vote
1 answer
702 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 ...
zsirosjanos's user avatar
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?
Kostas Karagiannis's user avatar
1 vote
1 answer
686 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 ...
Praful Gupta's user avatar
0 votes
1 answer
191 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 ...
Maros's user avatar
  • 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 ...
Nico's user avatar
  • 11
0 votes
2 answers
844 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 ...
Sachi's user avatar
  • 69
1 vote
0 answers
54 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 ...
claxton's user avatar
  • 11
1 vote
1 answer
615 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 ...
ebar's user avatar
  • 447
1 vote
2 answers
3k 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 ...
JulieHurtz's user avatar
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?
Thomas Hockey's user avatar
1 vote
1 answer
180 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 ...
S.B.'s user avatar
  • 2,071
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 "...
Josephine's user avatar
1 vote
2 answers
968 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. ...
Hunt's user avatar
  • 245
1 vote
1 answer
1k 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 ...
plemoineptccom's user avatar
0 votes
2 answers
465 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 ...
deanna's user avatar
  • 11
2 votes
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 ...
Hunt's user avatar
  • 245

1
2 3 4 5 6