I've found several instances of people having similar problems to the one that two of my users are having, but I haven't seen any solutions to these problems, yet.

My users are able to click the log-in to Salesforce and enter a username & password, but they get the error dialog:  "Unable to send request to server. The system cannot find the file specified."

They are using the security token.  As a matter of fact, the same happens no matter what you type in the username/password fields, so I don't think any connection is actually being made to saleforce to do validation.

I've totally uninstalled the add-in and reinstalled it again, but it made no difference.

Searching the Salesforce help, all I could find was reference to proxy settings in IE, which seemed odd to me, but I tried it anyhow... no help there, either.

Has anyone actually ever resolved this?

Any suggestions on where I should look?

I tried to edit the add-in code to see what was happening there, but it is password protected.

I've found several instances of people having similar problems to the one that two of my users are having, but I haven't seen any solutions to these problems, yet.

My users are able to click the log-in to Salesforce and enter a username & password, but they get the error dialog:  "Unable to send request to server. The system cannot find the file specified."

They are using the security token.  As a matter of fact, the same happens no matter what you type in the username/password fields, so I don't think any connection is actually being made to saleforce to do validation.

I've totally uninstalled the add-in and reinstalled it again, but it made no difference.

Searching the Salesforce help, all I could find was reference to proxy settings in IE, which seemed odd to me, but I tried it anyhow... no help there, either.

Has anyone actually ever resolved this?

Any suggestions on where I should look?

I tried to edit the add-in code to see what was happening there, but it is password protected.

Hi All,

If anyone is using the connector with API version 7.0 or higher and you encounter issues with queries including a date field, or if you want to increase the batch size to 200, try the following:

 Tweaking sforce excel connector
Do at your own risk.
These modifications are unsupported.

Modify query format for queries with date fields
• Only necessary if you use API 7.0 or higher and your query includes a date field (query returns an error)
• Open the Script editor from Excel (Alt + F11)
• In the Project sforce_connector, double-click “utils”
• In the upper right drop down menu, navigate to the function “sfQueryValueFormat”
• Change the line Case "datetime", "date": to Case "datetime":
• Add the following code block above the line Case "double", "currency", "percent":

Case "date":
If (InStr(LCase(vlu), "today")) Then
Dim today2 As Date: today2 = Date
Dim daychange2 As Variant, incr2%: incr2 = 0
If (InStr(LCase(vlu), "-")) Then
daychange2 = Split(vlu, "-")
incr2 = 0 - Int(daychange2(1))
End If
If (InStr(LCase(vlu), "+")) Then
daychange2 = Split(vlu, "+")
incr2 = Int(daychange2(1))
End If
vlu = DateAdd("d", incr2, today2)
End If ' 5.12 end

sfQueryValueFormat = Format$(vlu, "yyyy-mm-dd")

• Close the editor

Increase batch size of queries,inserts and updates
• Open the Script editor from Excel (Alt + F11)
• In the Project sforce_connector, double-click “s_force”
• Find the line Const maxBatchSize As Integer = 50 and change the value 50 to 200
• More than 200 will not work

Is it possible to use multiple controllers in the same page?

Any examples?

Hi,

I've run into a very annoying problem. I have a simple visualforce page that displayes an organizations address pulling from the organization fields, like so:

<apex:outputText value="{!SUBSTITUTE($Organization.Street, '\n', '<br />')}" escape="false" /><br /> <apex:outputText value="{!$Organization.City}" />, <apex:outputText value="{!$Organization.State}" />&nbsp;<apex:outputText value="{!$Organization.Country}" />&nbsp;&nbsp;&nbsp;<apex:outputText value="{!$Organization.PostalCode}" /> <br />

As you can see I'm tyring to replace the new line character with html break tags. Unfortunately it doesn't seem to be picking up the newline character. I really don't want to write custom controller just to generate a string with proper line breaks (this is all the controller would do for this page, I have no need for anything else). Is there a different character for line breaks that I'm missing? 

Can a VF component on say the contact record trigger a refresh/reload of one of the contact's related lists?

For example, I have a VF page I placed in a section on the contact layout. I click a VF button and it creates an activity/task. Can I trigger a partial page refresh to refresh the list of activities, or do I have to reload the entire record page?

Thanks,

DSL

we are planning to send emails to the case contacts based on a list view.

I created a listview button called Send Email.

Also a list view is created which lists all the cases closed in last 5 days.

When GO button is clicked the records will be displayed. I selected 3 records (by checking the checkbox)

Now when send email button is clicked i want to send email to case contacts for the 3 selected records.

I am planning to do this in visualforce. like calling a visualforce page when send Email button is clicked.

But i am stuck how to get the record id's (I need the record id to grab the contactid and case number from case) for the selected records in the list view.

Can someone please provide me an idea how to achieve this?

Your help is greatly appreciated....please advise..thanks

Im working on a form where data is put in for an order. The data inputs are split into 5 separate pageBlockSections. How can I take each one of my pageBlockSections and make it a separate page. I want a next button down bottom but dont know how to override the save button and make it go to the next page. Heres the code:

<apex:page sidebar="false" standardController="lead"   showHeader="false" extensions="GLeadExtension"> 
<apex:composition template="{!$Site.Template}">
<apex:define name="body">
<h1>Conveyor Application Request</h1>
<apex:form >
                    <apex:pageBlock >
                        <apex:pageBlockButtons >
                                <apex:commandButton action="{!save}" value="Save"/>
                                <apex:commandButton action="{!cancel}" value="Cancel"/>
                        </apex:pageBlockButtons>
                        <apex:pageBlockSection title="Company Detail" columns="2">
                                <apex:inputField value="{!Lead.company}"/>
                                <apex:inputField value="{!Lead.website}"/>
                                <apex:inputField value="{!Lead.firstname}"/>
                                <apex:inputField value="{!Lead.lastname}"/>
                                <apex:inputField value="{!Lead.title}"/>
                   
                                <apex:inputField value="{!Lead.email}"/>
                                <apex:inputField value="{!Lead.street}"/>
                                <apex:inputField value="{!Lead.city}"/>
                                <apex:inputField value="{!Lead.state}"/>
                                <apex:inputField value="{!Lead.postalcode}"/>
                                <apex:inputField value="{!Lead.country}"/>
                                <apex:inputField value="{!Lead.phone}"/>
                                <apex:inputField value="{!Lead.fax}"/>
                                <apex:inputField value="{!Lead.status}"/>
                         </apex:pageBlockSection>    
                        
            
                     
                       <apex:pageBlockSection title="Product Conveyed - Additional Information" columns="2">

                                <apex:inputField value="{!Lead.Product_conveyed__c}"/>
                                <apex:inputField value="{!Lead.Chemical_formula__c}"/>
                                <apex:inputField value="{!Lead.Bulk_density_kg_dm3__c}"/>
                                <apex:inputField value="{!Lead.Particle_size_max_m__c}"/>
                                <apex:inputField value="{!Lead.Particle_size_min_m__c}"/>
                                <apex:inputField value="{!Lead.Majority_between_start__c}"/>
                                <apex:inputField value="{!Lead.end_m__c}"/>
                                <apex:inputField value="{!Lead.Is_the_product_abrasive__c}"/>
                                <apex:inputField value="{!Lead.Flowability__c}"/>
             
                                <apex:inputField value="{!Lead.The_product_is__c}"/>
                                <apex:inputField value="{!Lead.Aggressive_in_other_ways_additional_info__c}"/>
                                <apex:inputField value="{!Lead.Angle_of_repose__c}"/>
                                <apex:inputField value="{!Lead.Other_product_properties__c}"/>
                        </apex:pageBlockSection>
                    
         
                <apex:pageBlockSection title="Installation - Additional Information" columns="2">
                                <apex:inputField value="{!Lead.Capacity_ton_h__c}"/>
                                <apex:inputField value="{!Lead.Other_intervals__c}"/>
                                <apex:inputField value="{!Lead.Total_conveying_distance_m__c}"/>
                                <apex:inputField value="{!Lead.Horizontal_m__c}"/>
                                <apex:inputField value="{!Lead.Vertical_m__c}"/>
                                <apex:inputField value="{!Lead.Number_of_bends__c}"/>
                                <apex:inputField value="{!Lead.Type_of_pipe_system__c}"/>
                                <apex:inputField value="{!Lead.Diameter__c}"/>
                                <apex:inputField value="{!Lead.Humidity_of_the_product__c}"/>
                                <apex:inputField value="{!Lead.Hygroscopic_moisture__c}"/>
                                <apex:inputField value="{!Lead.Product_picked_up_from__c}"/>
                                <apex:inputField value="{!Lead.If_Others__c}"/>
                                <apex:inputField value="{!Lead.The_installation_is__c}"/>
                                <apex:inputField value="{!Lead.The_operation_is__c}"/>
                                <apex:inputField value="{!Lead.Other_information__c}"/>
                        </apex:pageBlockSection>                    
           </apex:pageBlock>
</apex:form>
</apex:define>
</apex:composition>
</apex:page>