I'm setting up the process-conf.xml file to set up a series of Upsert processes and can't find a Configuraton Parameter for Related Objects...

'sfdc.externalIdField' allows me to specify the External ID field used for data matching which in the GUI corresponds to

Step 2a: Choose your field to use for matching --> sfdc.externalIdField

Step 2b: Choose your related objects --> ???

I can't find any mention of this in any of the Data Loader documentation...

Any help is greatly appreciated!

Mike

Since salesforce.com does not have native Excel processing libraries, a part of my app that processes Excel will be hosted on Heroku.
These Excels are typically loaded into the system by Guest (Sites) users without a username/password, so they don't have a secure session Id associated with them.

Currently I am thinking that admin user will login and schedule an apex job into which inject a session id of the admin login . This session id would be sent via https/ssl to Heroku Excel processer. The Heroku Excel processor which would use the session id for call back to salesforce (to grab the Excel and process data in it). The Heroku app would be stateless - it  would not store anything inside database on the Heroku end - essentially it would grab excel from salesforce, process them, and put data back in salesforce.com. It would be single multi-threaded single instance of Heroku app would serve all my salesforce customers.

I am worried that session would be a long living session - it could be months, creating a risk for session highjacking.

Any other alternatives I should consider? OAuth? Seems like I would have to Oauth tokens on Heroku side in db.







 

VF Page:

             <apex:pageBlockButtons > 
                <apex:commandButton action="{!Submit}" value = "Submit" />  
            </apex:pageBlockButtons>

    
Apex Code;

public pagereference Submit() { 
         
   //save to db code first
   //redirect now 
   landingPage = new PageReference('http://www.example.com');
   landingPage.setRedirect(true);
   return landingPage;

}

I have workflow rule that fires, updates some due dates (e.g today + 30 days) and send out an e-mail alert that includes the due date. The workflow rule documentation say that field updates are evaluated before other actions (http://login.salesforce.com/help/doc/en/workflow_rules_considerations.htm)

1. When I use a visualforce e-mail template, the due dates are NOT populated in the e-mail send out. When I test the VF template using  "Send Test and Verify Merge Fields", it works perfect - so my merge field syntax for the due dates is okay. 

2. When I use a non-VF e-mail template, the due date merge field is populated correctly.

3. I worked around the issue by having two workflow rules - the first one that sets the due dates and checked "Re-evaluate Workflow Rules after Field Change". The second workflow rule fires when due date is set and hence fires in sequence.  

So, is something going on with order of execution when VF templates are used?

I have a VF table in which one of the columns is "Show Activity History". In each row, that is a hyperlink in this column called "View All" meant to show activity history.

When the end user clicks "View All", I want to insert the activity history in-line below the current row - before the next row.. Of course the row hyperlink would then say "Hide All".

Any ideas?

I have a Sites VF page. Whenever there is a bug in the code leading to a crash, the end user gets "Down for Maintenance" message which is  confusing to say the least.

I thought I could change this message by modifying the settings as described at . http://login.salesforce.com/help/doc/en/sites_error_pages.htm

I set the "Maintenance Page(500/503)" and "Generic Error Page" to a custom page I created , but I still see the "Down For Mainenance".

Any ideas?

Uploading documents DIRECTLY to S3 in a secure fashion is easy: Amazon S3 supports uploading the documents directly to S3 via HTTP POST as described in http://wiki.apexdevnet.com/page/Using_Force_for_Amazon_Web_Services.  This also allows for large attachments to be sent directly to S3 without involving salesforce as intermediary.

However, I am wondering how one would get the documents directly to the browser in a secure fashion. I don't want the document to first be brought to salesforce.com servers - besides the overhead, SFDC supports only 3 MB for a  Web Service request size. Amazon S3 supports Query String Request Authentication (adding the amazon username(key) and signed password (signature) directly as a URL parameter. However the problem with this approach is that the URL can be copied by anyone and they can then directly access the document. I can add an expiration time as a URL parameter, but even then this is an insecure method, since someone can access the document for a few seconds.

Any thoughts?

	//preq already exists with pending approval status
	Custom_Obj__c pr = [select Status__c from Custom_Obj__c where id = :preq.id];
        System.ASSERT(pr.Status__c == 'Pending Approval'); 
        Test.setCurrentPage(new PageReference('/apex/customObjpage'));
        ApexPages.currentPage().getParameters().put('id',preq.id); 
        stdController = new ApexPages.StandardController(preq);
        customObjController controller = new customObjController(stdController);
        System.ASSERT(controller.customObj.Status__c == 'Pending Approval'); //fails

The status__c field is included in the customObjPage. The status is Pending Approval, but the assert at the end fails. All fields referenced in VF page are supposed to be loaded?

CustomObject__History[] histories = [Select Id, CreatedDate, CreatedBy.user_id__c, Field, OldValue, NewValue FROM CustomObject__c 

In Apex query, the system does not recognize the CUSTOM field on user called user_id and gives an error: No such column 'user_id__c' on entity 'Name'.

If I change it to SOME standard field like CreatedBy.Name, CreatedBy.Email or CreatedBy.UserName it works. It does NOT work for some standard fields such as Department, CommunityNickName etc.  At first it appeared that it doesn't work for Nillable fields, but it works for FirstName and Title which is Nillable!

I am logged in as system admin and have all fields visible.

This doesn't work. Any ideas?

COb__c c = [select Parent__r.Name fro Cobj__c limit 1];

String parentName = c.get('Parent__r.Name');

I am trying to filter out list views that have more than 10K records.

When I ask setController.getCompleteResult(), it returns true. However, when I cycle through the records (using  a while loop with getRecords(), .next(), and getHasNext()), I count till 10K and then it exits the loop! So there are more than 10K records in the set.

When I use outputField, the title (hover) does not show.

If I change it to outputText, it does show.

The documentation allows for titles on outputField.

I have Object X with field foo. I have field history tracking turned on and I am tracking history of foo__c.

I would like to get a record set which has the LAST CHANGE to foo across all instances of X - i.e (XId, LastFooValue, LastUpdateTime,LastUpdatedBy>. . Is there a way of doing it using SOQL WITHOUT writing any code? Note that I need this query for data loader export, which has it's limitations as mentioned below.

X_History[] hist = [select Parent.Name, NewValue,CreatedDate,CreatedBy.Name from X_History where Field = 'foo__c'] => if there are 3 changes for a specific record, I get three entries. The history table supports GROUP BY  ParentId, but not NewValue. Even if it did, I can't get the latest <NewValue,CreatedDate> using Max function. I could get Max(CreatedDate), but not the NewValue asssociated with Max(CreatedDate)

X__c[] Xhist = [select Name, (select NewValue,CreatedDate CreatedBy.Name from Histories where Field = 'foo__c' ORDER By CreatedDate DESC Limit 1) from X__c] => returns all X records, including those  that have NO change to foo.  Besides, I need this for dataloader export. Nested queries NOT supported by dataloader export. 

I have a Extension Controller pages where a user go through a 3 step form. On 4th step they  review and submit the form.

On page 1, I ask them to select a lookup field called department. I create a new record when they go to page 2. On Page 4 (review and submit), I show them the department using department__r.Name.

The department name shows up as empty on page 4. If I do an <outputField department__c/>, I can see the name, but I don't want to do this, since this page is exposed as a sites page as well and a clickable link would error out.

If I directly access page 4 at this point (by just typing in the page URL inthe browser), I CAN see the department name. So it doesn't appear to be a security setting issue. The issue happens whether I access the page using sites or as a logged in Admin user.

I tried adding department__r.Name as a rendered = "false" on page 1. But it did not work.

. What could it be?

I have a controller extension and a VF page X that binds to it. This Page X displays all the information about the Object. On Page X, I have a custom button 'Approve/Reject' which takes me another VF page Y that binds to same controller extension (i.e there is no redirect).

Now I am writing a separate "Items To Approve" page Z that has a Approve/Reject link. I would like the take the user directly to Page Y.  I am running into following issues:

1.  When I directly go to Page Y, I get the error "...SOQL without querying the requested field". Essentially it is complaining that fields that are referenced on Page X have not been loaded - that's how controller extensions work.

2. I tried action = "{!redirectToApprovalPage}" on Page X. Essentially on load, if "gotoapproval=true", I want to redirect to the approval page.  However, it doesn't redirect - I get to Page X - less any salesforce styling.

3. In #2, if I say page.setReDirect(true), I loose all the state

Any thoughts?

I have set the delegated approver (X)  for a user (Y). In User X's setting, I have set "Receive Approval Request Emails: If I am an approver or delegated approver".

I don't see any notification sent to X. When X logs in, they can approve/reject. When X logs in, when they go to their Activity Reports->"My Delegated Approval Requests", the request does not show. It doesn't show when I log in as Y either.

What's going on?

Uploading documents DIRECTLY to S3 in a secure fashion is easy: Amazon S3 supports uploading the documents directly to S3 via HTTP POST as described in http://wiki.apexdevnet.com/page/Using_Force_for_Amazon_Web_Services.  This also allows for large attachments to be sent directly to S3 without involving salesforce as intermediary.

However, I am wondering how one would get the documents directly to the browser in a secure fashion. I don't want the document to first be brought to salesforce.com servers - besides the overhead, SFDC supports only 3 MB for a  Web Service request size. Amazon S3 supports Query String Request Authentication (adding the amazon username(key) and signed password (signature) directly as a URL parameter. However the problem with this approach is that the URL can be copied by anyone and they can then directly access the document. I can add an expiration time as a URL parameter, but even then this is an insecure method, since someone can access the document for a few seconds.

Any thoughts?

VF Page:

             <apex:pageBlockButtons > 
                <apex:commandButton action="{!Submit}" value = "Submit" />  
            </apex:pageBlockButtons>

    
Apex Code;

public pagereference Submit() { 
         
   //save to db code first
   //redirect now 
   landingPage = new PageReference('http://www.example.com');
   landingPage.setRedirect(true);
   return landingPage;

}

I have a Sites VF page. Whenever there is a bug in the code leading to a crash, the end user gets "Down for Maintenance" message which is  confusing to say the least.

I thought I could change this message by modifying the settings as described at . http://login.salesforce.com/help/doc/en/sites_error_pages.htm

I set the "Maintenance Page(500/503)" and "Generic Error Page" to a custom page I created , but I still see the "Down For Mainenance".

Any ideas?

	//preq already exists with pending approval status
	Custom_Obj__c pr = [select Status__c from Custom_Obj__c where id = :preq.id];
        System.ASSERT(pr.Status__c == 'Pending Approval'); 
        Test.setCurrentPage(new PageReference('/apex/customObjpage'));
        ApexPages.currentPage().getParameters().put('id',preq.id); 
        stdController = new ApexPages.StandardController(preq);
        customObjController controller = new customObjController(stdController);
        System.ASSERT(controller.customObj.Status__c == 'Pending Approval'); //fails

The status__c field is included in the customObjPage. The status is Pending Approval, but the assert at the end fails. All fields referenced in VF page are supposed to be loaded?

CustomObject__History[] histories = [Select Id, CreatedDate, CreatedBy.user_id__c, Field, OldValue, NewValue FROM CustomObject__c 

In Apex query, the system does not recognize the CUSTOM field on user called user_id and gives an error: No such column 'user_id__c' on entity 'Name'.

If I change it to SOME standard field like CreatedBy.Name, CreatedBy.Email or CreatedBy.UserName it works. It does NOT work for some standard fields such as Department, CommunityNickName etc.  At first it appeared that it doesn't work for Nillable fields, but it works for FirstName and Title which is Nillable!

I am logged in as system admin and have all fields visible.

This doesn't work. Any ideas?

COb__c c = [select Parent__r.Name fro Cobj__c limit 1];

String parentName = c.get('Parent__r.Name');

I am trying to filter out list views that have more than 10K records.

When I ask setController.getCompleteResult(), it returns true. However, when I cycle through the records (using  a while loop with getRecords(), .next(), and getHasNext()), I count till 10K and then it exits the loop! So there are more than 10K records in the set.

I have a text field on a visualforce page, and when someone types in two white spaces - as in: "test  white"- upon saving it automatically corrects it to one white space - as in: "test white". The issue is we DON'T want this to happen. Does anyone know if this is typical behavior for a text field, or maybe it's part of our settings? I didn't set up the visualforce page, so I'm not very familiar with it. I believe this is the code for the section that I'm having this issue with though. If anyone could let me know if they could see what is causing this issue, that would be great. Thank you!

  
    <apex:pageBlockSection title="{!IF(pageMode == 'new', 'Step 2. Specify ', '')}Matching Pattern" columns="1" rendered="{!pageMode != 'view'}">
        <apex:pageBlockSectionItem >
            <apex:outputPanel >
                <table id="filters" class="declarativeFilterTable">
                    <tr>
                        <th scope="col">&nbsp;</th>
                        <th scope="col">Type</th>
                        <th scope="col">Attribute</th>
                        <th scope="col">Value</th>
                    </tr>
                    
                    <apex:variable value="{!1}" var="index" />
                    <apex:repeat value="{!matchingPatternRules}" var="rule">
                        <tr style="{!IF(index > 5 && (ISBLANK(rule.Type__c) || LEN(rule.Type__c) < 1) && (ISBLANK(rule.Attribute__c) || LEN(rule.Attribute__c) < 1) && (ISBLANK(rule.Value__c) || LEN(rule.Value__c) < 1), 'display: none;', '')}" class="filterRow">
                            <td><span class="textBox hide">{!FLOOR(index)}.</span></td>
                            <td><apex:inputField value="{!rule.Type__c}"/></td>
                            <td><apex:inputField value="{!rule.Attribute__c}"/></td>
                            <td><apex:inputText value="{!rule.Value__c}" size="80"/></td>
                            <td>
                                <apex:outputPanel layout="none" rendered="{!index < 5}">
                                    <span id="and{!FLOOR(index)}" class="textBox">AND</span>
                                </apex:outputPanel>
                            </td>
                        </tr>
                        
                        <apex:variable var="index" value="{!index + 1}" />
                    </apex:repeat>
                </table>

OK, I have made extensive research on StandardSetController before implementing quite a complex page with features not supported by <apex:listView> or <apex:enhancedList>.

I have implemented pagination and column ordering, as well as some client-side multi-line selection and actions.

I have implemented dynamic read/write or readonly control line by line, depending on the Approved status of each line.

On this path, I have encountered the bug setting page size :

http://boards.developerforce.com/t5/Visualforce-Development/StandardSetController-setPageSize-does-not-work/td-p/202018

or here

http://boards.developerforce.com/t5/Visualforce-Development/bug-StandardSetController-or-QueryLocator-ignores-SOQL-where/td-p/99500

so I do not change page size.

I have another problem, and think I have the solution.

My StandardSetController is on a Parent/Children page, so filtered (by a where clause) to the id of the parent :

SELECT ID Rep__c STATUS_Done__c, isReadWrite__c, LastModifiedDate
FROM   CE_Line__c
WHERE  Rep__c = :repid

When I apply a filter in my VF page like this

<apex:panelGroup id="listViewFilterGrp">
    <apex:outputLabel value="Filter: "/>
    <apex:selectList value="{!CELines.filterID}" size="1">
        <apex:actionSupport event="onchange" action="{!updateMyLines}" rerender="table"/>
        <apex:selectOptions value="{!CELines.ListViewOptions}"/>
    </apex:selectList>
</apex:panelGroup>

and apply a filter, the 'WHERE Rep__c = : cerepid' clause gets wiped out : the returned list is filtered according to the definition of the filter, but across all RepIds !

Now I have spotted this person's problem with a WHERE clause being added to their Database query when filtering :

http://boards.developerforce.com/t5/Apex-Code-Development/ERROR-at-Row-1-Column-132-unexpected-token-WHERE/td-p/118177

This actually shows that the filter simply removes your own WHERE clause and *replaces* it with the equivalent clause from the filter.  How silly !!!  The filter clause should be *added* to my existing clause with AND, and everything would be fine.

Salesforce, please fix this bug to make StandardSetController filtering work on a Parent/Children page.

Thanks,

Rup

Hello -

I am trying to add a visualforce page to my custom object that will show the related products.

So my "Sales Checklist" object is housed on the opportunity, sales fills all the information out then the object is sent to a queue.

But to save time i want to pull in the opportunityLineItems in to the sales checklist?

Is this possable? I know very little visualforce.

This is as far as I have gotten:

<apex:page StandardController="Sales_Checklist__c">
<apex:relatedList list="Opportunity__r" />

<apex:pageBlock title="{!Sales_Checklist__c.Opportunity__r.Name}"/>

  <apex:dataTable value="{!Sales_Checklist__c.Opportunity__r}" var="opp" cellPadding="4" border="1">
                
           <apex:column ><apex:facet name="header">Product Name</apex:facet></apex:column>
                
                
           <apex:column><apex:facet name="header">Quantity</apex:facet></apex:column>
                
                
           <apex:column ><apex:facet name="header">Unit Price</apex:facet></apex:column>
                
              
           <apex:column ><apex:facet name="header">Total Price</apex:facet></apex:column>
  </apex:dataTable>
</apex:page>

any help would be greatlt appriciated

Thanks,

Niki

Hi,

We have a process where customers need to submitted / upload scanned documents via a force.com app

Is it possible to store the documents externally via Google Docs OR Amazon S3 services?

There will be 100's of jpg scanned docs per week uploaded via the application.

Appreciate any advise on best practice.

Many thanks

Matt