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

learn more… | top users | synonyms

0
votes
1answer
26 views

Control and/or monitor who does data exports from salesforce

besides our Sales department doesn't have the Export Report option they can still ctrl+C -> ctrl+V into an excel sheet if they wanted to take some information for other companies or whatever. I ...
1
vote
1answer
25 views

How to change the design of the exported Excel or PDF files?

I'm providing an export links to export some result into a PDF or Excel files. The tables, in the exported files, don't look that good and I had tried to add some style to my VF page but it didn't ...
3
votes
1answer
27 views

Exporting large set of data out of Salesforce and integrate with third party system

I am implementing for an approach to integrate from Salesforce to our 3rd party system. Usually our customer has a large set of Contact data and they want to integrate to our system. Meanwhile, our ...
0
votes
1answer
21 views

Export attachments from sfdc to SFTP server

Reference question - Export an attachment from sfdc to SFTP server We have a requirement to keep the attachment(like pdf,doc,etc) in salesforce and also in a SFTP server. Just assume, we are ...
1
vote
1answer
38 views

export files from salesforce? [closed]

we have an excel file that you previously exported from Salesforce. What feature of Salesforce did you use to create the file? The Excel file includes 2000 Opportunity records representing 800 ...
1
vote
1answer
15 views

Weekly Scheduled Exports

I have exports set up weekly using the weekly export service. I have it set up for Monday in the middle of the night. But it is Thursday and I just received an email saying that my export was ready. ...
0
votes
1answer
16 views

Export or Import data directly from share point

Is it possible from Data loader CLI to export data directly into share point and import directly from share point.
0
votes
2answers
48 views

How to backup salesforce data?

I have to take daily backup of my Salesforce records and store at a particular location . How can we take daily backup of records from Salesforce and also , store the backup taken at a particular ...
0
votes
1answer
16 views

Why stage duration and amount report comes with multiple zeros when export it

I am facing a very unusual problem. When I creates any report and add any number or currency field like stage duration, Age, Amount and export it in excel so all numbers fields come with additional ...
1
vote
0answers
30 views

Error in data loader cliq

I am using data loader from command line but I'm getting one error when I'm trying to verify if my password generated is correct or not Command: encrypt.bat -v generatedPassword secretKey Error: ...
0
votes
0answers
19 views

Data Extract Fails intermittently

We have a schedule set up to produce a data extract of the "Response Send" data extension. There are 6 steps to this schedule: SQL Query (Response Data - Sent) Data Extract Transfer file SQL Query (...
4
votes
1answer
60 views

Data Loader CLI

I am trying to export data using CLI data Loader. Can I dynamically assign the export file name with the system date and time stamp. Any suggestions would be appreciated! Thanks!
0
votes
1answer
30 views

Data Extract for bounces in recurring program

Is it possible to build a data extract that would pull bounces for a set of welcome e-mails (which run daily as part of a program) and place the file on our ExactTarget FTP? I know with Tracking ...
0
votes
1answer
79 views

Export data to a word template

Is there a way I can export to a word document? I have a fair amount of government (difficult to change) forms that are auto-filled out by a legacy system. It's high value to the users to be able to ...
1
vote
0answers
26 views

Data Export weekly

I have scheduled my weekly data export every sunday evening 7.00 pm. For the last 2 weeks it's been successfully working, I was getting 65 files of 512 MB each. This sunday I had only one file of ...
2
votes
1answer
26 views

Schedule export data for a particular user

How can we schedule export data for a particular user only. So that when export data us ready it should be emailed to that user only. Do we have any option to customize it. Bec when I set the schedule ...
2
votes
0answers
12 views

Automate downloading of zipped files created on using export now functionality [duplicate]

How can i automate downloading of zipped files created on using export now functionality.I am using export now functionality and a zipped file is being created .I need to download that file to local ...
0
votes
0answers
26 views

Import Users from one Organization to another

I have few users in a salesforce organization and I need the same users in another org. It tells me that I cannot create the users with the same username because they are already present in another ...
0
votes
0answers
36 views

Data Export/Import with Bulk API

I have a task to export data for about 60 Salesforce users then to edit them and import it back again. I am not allowed to use specialised web sites for data export/import where you provide user/pass ...
1
vote
0answers
48 views

Any way to correctly escape quotes in a data extract activity?

We're currently using a combination of Data Extensions, Data Extracts, and File Transfer activities to pull data out of Marketing Cloud and import these files into our own internal data warehouse. ...
1
vote
1answer
85 views

How often can I do a data export

I wanted to test the data export functionality and I created an export of a small amount of data. After figuring out exactly what I wanted to do, I went back to the export page and the "Export Now" ...
0
votes
0answers
45 views

Advanced Data Export/Import with Bulk API

I have a task to export data for about 60 Salesforce users then to edit them and import it back again. I am not allowed to use specialised web sites for data export/import where you provide user/pass ...
3
votes
3answers
84 views

Auto downloading Salesforce weekly export files [duplicate]

We are looking for a way to auto download our Salesforce weekly export files to an internal server for long term storage. Has anyone successfully done this either custom, using a 3rd party tool or ...
1
vote
4answers
65 views

Automating the dataload

We use some client application named Rally tool where we extract the csv file daily and we need to update those records into salesforce on a daily basis. Now I need to make this process automated. I ...
1
vote
1answer
64 views

Send email to subscribers with content from external data

I am using the ExactTarget API to pass subscribers from my web application to a subscribers list in ExactTarget. On my website, we post video clips on a daily basis. We range anywhere from 20 - 30 ...
1
vote
1answer
41 views

Programatically download a report generated in Salesforce

I would like to download a report generated in Salesforce every month as a csv file and process it on our side. I explored the analytic api which has a limit of 2000 rows per call, writing a soql ...
6
votes
3answers
110 views

Way to check triggers on object

I am trying to import some data on a particular object, hence is there a way to check which of our objects are tied to triggers, flows, etc.
0
votes
2answers
25 views

Data Archiving and moving to externals in salesforce

Just want to know about archiving data and moving to external source in SalesForce. I want to archive data and want to move it to external MS SQL source. Is it possible? Do I need any app for it? ...
3
votes
1answer
49 views

Solution for backing up Salesforce data

We currently do a data backup of SFDC data every week via the Data Export feature in Salesforce. This process is very time consuming as the result of the data backup is 30+ files that all need to be ...
0
votes
0answers
127 views

export div contents to excel and pdf with html

I have a div (id=divtable) with number of records in table. I want to export whole table or div whichever is easier with CSS. So far I have code to export it to excel but I don't get html formatting ...
1
vote
1answer
157 views

html tables to worksheets excel (keep html format )

My excel files have images so when i export to xml type, these images are losed. I have 2 visualforce pages need export excel file which contains 2 page into 2 sheets. ( I tried use excel program ...
0
votes
1answer
22 views

Public Images to public sites

I create a page export my data to excel file, user download excel file. In this file has some images, when i download file then open it. when excel is opened, it will get images from my site. Excel ...
1
vote
1answer
81 views

Streaming API Subscription methods

We are working on a package where the data from salesforce needs to be exported to external database instantaneously on DML. The export can be configured such that the user can select the Standard/...
1
vote
1answer
338 views

Export Visualforce Page in Excel as .xlsx and not as a Web Page.

I'm writing a Visualforce page which downloads an Excel file onto the user's computer. I have done this by adding the following to the <apex:page> tag: contentType="application/vnd.ms-excel#My ...
1
vote
0answers
15 views

Data Usage Forecasting

The company I work for is quickly approaching their data storage limit. Thinking about upgrading their storage. However before hand they are trying to estimate out how much they might need. I can see ...
1
vote
1answer
189 views

Can we migrate rich-text-field-data between environments?

After searching on the SFSE website, it seems this question hasn't been asked. Can we migrate rich text field data between environments? Most records contain images embedded in rich text fields ...
0
votes
1answer
31 views

Remapping Custom objects to Standard Objects [closed]

I'm currently working with a company where we use Salesforce as a social platform; all the sales data & purchasing information is handled separately at the moment, with certain data available via ...
1
vote
0answers
49 views

ServiceMax Question - Problem Codes Export

I am not 100% sure this is the correct forum. However, hoping someone might be able to answer my question. I haven't been able to locate a way to do a data extract from ServiceMax for the "Problem ...
0
votes
0answers
16 views

Is it possible to do an Extract SentEvent with the FuelPHP-SDK?

I need to make a Extract SentEvent via SOAP API. It seems that on the developer portal, the example PHP code to do extract actions via SOAP API is deprecated.[1] My Hub App clientID and secret have ...
0
votes
0answers
21 views

Exporting a data restricting to a particular user

How do I change the settings of import and export wizard so that only a particular user can export and import data?
1
vote
1answer
71 views

How to move tracking History from one object to another?

Hi i am transferring the records from one object to another using data loader. I want to transfer the history tracking information for particular records also. How can i achieve this..?
0
votes
1answer
69 views

Extract Chatter Post and Image

Our company has a chatter group where we've captured all employees marriage and birth announcements. Our HR team would like to export all these post with images so they can make a book with them. ...
1
vote
2answers
254 views

SOQL query with Dataloader using List Literal in WHERE Clause

Is it possible to construct a SOQL query with a list literal in the WHERE clause? My use case is that the data loader cannot handle child relationships/subqueries needed for my search, but I can get ...
0
votes
0answers
128 views

Unica “Treatment Code” into and out of ExactTarget

We're installing UNICA and part of the installation will be the creation of "Treatment Codes" which identify what email a recipient received, and also connects any activity (Clicks, Opens) back to the ...
1
vote
0answers
104 views

Export Data to Excel File - Dump Data

I am using a VF Page that allows me to export some Record data with Related Records into Excel File Using : contentType="application/vnd.ms-excel#ExportFile-{!TODAY()}.xls" cache="true" Everything ...
0
votes
1answer
104 views

Mulesoft - Export Salesforce records Bulk mode

I have a project in Mule and I want to export thousands of records, I'm using the normal salesforce connector but it seems only are getting 100 records. What would be the best way to get thousands of ...
4
votes
1answer
47 views

Moving communities from QA to Production

I have created a site in our QA enviornment with contents, articles with zones, chatter with categories and various permission sets based on profile including branding. I would now like to move this ...
1
vote
1answer
40 views

Accessing Data Externally - Any tools?

Bit of a back story... We have a business requirement where out of a team of 50 people only 20 need actual SF licenses. The other 30 only need access to a very small portion of data and only need ...
-3
votes
1answer
29 views

On which criteria are some objects exported and some not?

When I go to "Export" in Salesforce, a list of objects which can be exported is available. Which rule do those objects follow? i.e. which properties does a Salesforce objects have which then make it ...
1
vote
2answers
102 views

Data export of contacts on Account

I need to export Data from Salesforce.The requirement is that I need to extract Accounts and only one contacT associated with the account. Let us say if i have to extract 1000 accounts I need to get 1 ...