Questions tagged [salesforceexcelconnector]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
57 views

Fetch Files Related to opportunity in salesforce

I want to run a SOQL query that fetches files associated with opportunities(in a particular stage). If I am not wrong content version is the actual object I need to be querying on to fetch content? ...
0
votes
0answers
26 views

How to get column values properly in excel from vf?

We have created vf page that returns excel file. for 4 columns the values are updating randomly in excel. Please check the screen shots and code. The node1,machineid1, node2,MachineId2 columns are ...
0
votes
1answer
80 views

Excel VF Page change custom field labels

I have below VF Page that downloads the excel as I need. But I have further requirement to show A,B,C etc as header values in excel instead of the generic labels of the custom fields shown in excel. ...
0
votes
1answer
180 views

Bulk Updates - Salesforce Marketing Cloud - Excel Connector

I need to do a mass update to all of the email templates in Salesforce Marketing Cloud. From what I've researched, there are no built in app tools do allow this. I know a popular tool for exporting/...
0
votes
1answer
433 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
1answer
1k views

Data Loader for Professional Edition Salesforce That Does Not Use API?

I am working on a project to clean out old tasks and would like to be able to export all tasks including those which are archived and then upload a list of activity IDs for the ones which I would like ...
2
votes
0answers
211 views

Salesforce connector Excel Add in - auto refresh doesn't trigger a data connection download

I have an excel file which uses Salesforce connections (Salesforce Connector) to download the report file in csv format and updates the excel sheet with new data. When i use the option Refresh All ...
1
vote
0answers
988 views

Issue while exporting data in Excel format from Visualforce

There is a VF Page where we have Export button There is no issue when exporting single record excel opens but while exporting multiple records excel is getting corrupted . Please Help!!! This Class ...
0
votes
0answers
521 views

Export to Excel

I have VF page V1 with multiple page block table. I have a requirement to create a link to export one of the pageblocktable to excel. so decided to create separate VF page to render the page block ...
1
vote
0answers
472 views

Export Parsed Data To CSV Format From Visualforce?

I re-titled this so as to make it simpler in concept - JSON is not directly the issue, it's the ability to export data that appears in a VF page. We have a situation where, when Leads (or Accounts) ...
1
vote
1answer
137 views

Need to export data in excel and the after computing the data again need to store in salesforce

I have an excel file which contains several formulas. I need to take out some data from Salesforce into that excel file and after computing that data need to store the results back to Salesforce. Any ...
6
votes
2answers
3k views

Mass Delete Tens Of Millions Of Records

I have done my due diligence on this and simply cannot find an answer that does not involve Apex, which is what I'm trying to avoid for various reasons. Does anyone know how to adequately without a ...
1
vote
1answer
131 views

How to I identify the id's of opportunity fields other than the default ones so that I may fill these using a macro from Excel?

So the nature of my work means that I need to keep a record of our opportunities on an excel spreadsheet, and then these are then to be transferred to Salesforce so that management have a clear ...
0
votes
0answers
297 views

Limits on Salesforce Excel connector data

I have configured sforce_connect.xla add-in in excel to fetch data from salesforce to excel sheet. Now for query results I am getting maximum 790 records where it should be 1000 or more as I can ...
1
vote
1answer
835 views

Error in Connect Salesforce using Excel Connector

I have a requirement to connect to salesforce from excel by Salesforce connector add-ins. After installing and configuring the whole as mentioned here https://code.google.com/p/excel-connector/wiki/...
0
votes
2answers
565 views

Salesforce Excel Connector

I need to know about following conditions. 1) I need to run a query on excel connector with where clause and IN operator. Example - select id from pricebookentry where id IN (set of ids) 2) I ...