Salesforce Developer Community

Chatter

Feed
0

Best Answers
1

Likes Received
0

Likes Given
7

Questions
9

Replies

Post a chatter feed with auxiliary body from apex

Hi everyone,

I have a requirement to post a chatter feed on case feed stream and chatter tab, when a specific task was created under a case.

I know how to post a txt msg from apex code, but I am wondering how to post a chatter feed with auxiliary body as below

User-added image

Appreciate if you have any idea.

Regards,
Thomas

Tomas.Ray
March 10, 2016
Like
0

SOLVED

4 replies

Deploy Salutation field of Contact

I changed picklist values in Salutation field on Contact. Trying to deploy the change to other sandbox via Force.com IDE.

But I could not find Salutation field in the contact object file.

Does anybody know how to get this Salutation field deployed?

Thanks
Tom

Tomas.Ray
July 22, 2015
Like
0

3 replies

Report : Open activites of customers / accounts in my territory

Hi,

I want to create a report to view all open activities related to accounts in my territory.

But there is no such standard/custom report type to get all the 3 objects together.

Any idea from any talent? Thanks.

Regards,
Thomas

Tomas.Ray
June 30, 2015
Like
0

4 replies

dataloader and commandline issue - java.net.ConnectException: Connection refused: connect

I have written windows batch script to run apex data loader job every hour. I has run for 2 months without issue.
Today I am deploying the script to new windows 7 and used the lastest Dataloader v34.

Then the script got an issue as below:

15-06-24 15:27:26,841 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from URL [file://C:/dataloader/config/process-conf.xml]
2015-06-24 15:27:29,236 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: SFDCBuyerOrder configuration from config file: C:\dataloader\config\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from URL [file://C:/dataloader/config/process-conf.xml]; nested exception is java.net.ConnectException: Connection refused: connect
   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)
   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174)
   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
   at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
   at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
   at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
   at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:522)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436)
   at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:140)
   at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:84)
   at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:105)
   at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
   at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287)
   at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273)
   at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246)
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.DualStackPlainSocketImpl.connect0(Native Method)
   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at sun.net.ftp.impl.FtpClient.doConnect(Unknown Source)
   at sun.net.ftp.impl.FtpClient.tryConnect(Unknown Source)
   at sun.net.ftp.impl.FtpClient.connect(Unknown Source)
   at sun.net.ftp.impl.FtpClient.connect(Unknown Source)
   at sun.net.www.protocol.ftp.FtpURLConnection.connect(Unknown Source)
   at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(Unknown Source)
   at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:125)
   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)
   ... 17 more

At first, I suspect it was a server issue. But finally after google the whole afternoon, I changed to old version of Dataloader 32. The error is gone.

Just wanna share with you, dont use dataloader 34 for command line job.

Regards,
Thomas

Tomas.Ray
June 24, 2015
Like
1

0 replies

How to use apex data loader in batch mode to delete records in oracle database

Hi All,

I have a business challenge:

Customer wanna maintain master data in sfdc. Master data can be created, updated and deactivated in SFDC. They want to sycn any change to oracle database. If master data record is deactivated in SFDC, the same record should be deleted in oracle database.

Proposal is to use apex data loader to query in sfdc to insert, update or delete records in oracle database accordingly. The proposal is based on the sample database-conf.xml in apex dataloader installation folder.

<bean id="updateAccountSql"
class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
<property name="sqlString">
<value>
update TableOwner.Accounts accounts
set accounts.account_name = @account_name@,
accounts.business_phone = @business_phone@,
accounts.sfdc_account_id = @sfdc_account_id@,
accounts.annual_revenue = @annual_revenue@,
accounts.account_number = @account_number@
where
accounts.ACCOUNT_EXT_ID = @account_ext_id@
</value>
</property>
<property name="sqlParams">
<map>
<entry key="account_name" value="java.lang.String"/>
<entry key="business_phone" value="java.lang.String"/>
<entry key="sfdc_account_id" value="java.lang.String"/>
<entry key="annual_revenue" value="java.lang.Double"/>
<entry key="account_ext_id" value="java.lang.String"/>
<entry key="account_number" value="java.lang.String"/>
</map>
</property>
</bean>

Really appreciate it if you can advise whether the proposal is possible.

Regards,
Thomas

Tomas.Ray
March 19, 2015
Like
0

3 replies

Ajax Tookit error "Sforce not defined" in customer community

I have a custom list button called New Form, Here is the code

=========================================

{!REQUIRESCRIPT("/soap/ajax/28.0/connection.js")}
{!REQUIRESCRIPT("/soap/ajax/28.0/apex.js")}

var url = top.window.location.href;

var profile = '{!$Profile.Name}';

var IsAuthorized = false;

if(profile.indexOf("Admin") != -1 || profile.indexOf("FAE/FTS") != -1 || profile.indexOf("Portal") != -1){
IsAuthorized = true;
}

if(!IsAuthorized){
alert("Not right to create BX-041 form.");
}else{

var deviceId = url.substr(url.indexOf('.com/')+5,15);

var queryString = "SELECT id FROM BX_041__c where Device__c = '" + deviceId + "'";

var queryResult = sforce.connection.query(queryString);

if(queryResult.size > 0 ) {
alert("You can't Create another BX-041 record.");
}else {
window.open("{!URLFOR($Action.BX_041__c.New, null,null,false)}","_parent");
}

}

=================================================================

It is working for internal users, but when customer portal user click this button in customer community, it says "sforce not defined". Even not working for system admin. So i doubt ajax toolkit is not supported in community.

Anyone has any idea?

Regards,

Thomas

Tomas.Ray
October 01, 2013
Like
0

4 replies

Live Agent - how to block new chat request when it is out of business hours

Hi,

Here is the scenario:

Business hours are defined in SFDC.

Live agent is deployed in external website.

Agent forgot to turn his/her status into offline when it is out of business hours.

How to block new chat request?

There are two approaches:

1. Turn the agent's status into offline automatically when it is out of business hours.

2. Show offline button on the external website when out of business hours even if agent is still online.

Any hints or suggestion to implement it?

Regards,

Thomas

Tomas.Ray
February 27, 2013
Like
0

4 replies

dataloader and commandline issue - java.net.ConnectException: Connection refused: connect

Tomas.Ray
June 24, 2015
Like
1

SOLVED

23 replies

The campingListItem JavaScript controller isn't setting the 'Packed' value correctly.

Working the "Handle Actions with Controllers" trailhead module and I'm not getting past the validation.
If I put the component in a test jig, I can see the button function and set the check box as expected.

Here is the code I'm using to set the item as packed...

component.set("v.item.Packed__c", true );

I'm assuming the validator does not like my syntax. Can you give me a hint to get past this?

Thanks.
John

John Lay 9
June 08, 2016
Like
0

SOLVED

4 replies

Deploy Salutation field of Contact

Tomas.Ray
July 22, 2015
Like
0

3 replies

Report : Open activites of customers / accounts in my territory

Tomas.Ray
June 30, 2015
Like
0

SOLVED

5 replies

Dataloader and command line interface issues

I have a client that I implemented nightly batch load process for years ago using the dataloader command line interface. It has worked every night for 7 years without an issue. They now need to upgrade the server it is running on and at the same time want to upgrade dataloader. They installed dataloader 34.0 and I cannot get it to connect to salesforce and I am starting to think there is a bug in dataloader 34.

Here is the error:

C:\Program Files (x86)\salesforce.com\Data Loader\bin>process "C:\Program Files (x86)\salesforce.com\Data Loader" tempCont
2015-06-23 11:19:54,373 INFO  [main] controller.Controller initLog (Controller.java:389) - Using built-in logging configuration
\salesforce.com\Data Loader\bin\log-conf.xml
2015-06-23 11:19:54,373 INFO  [main] controller.Controller initLog (Controller.java:391) - The log has been initialized
2015-06-23 11:19:54,373 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configurat
)\salesforce.com\Data Loader\process-conf.xml
2015-06-23 11:19:54,443 INFO  [main] support.AbstractApplicationContext prepareRefresh (AbstractApplicationContext.java:495) -
ort.FileSystemXmlApplicationContext@13bd574: startup date [Tue Jun 23 11:19:54 PDT 2015]; root of context hierarchy
2015-06-23 11:19:54,474 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loadi
/Program Files (x86)/salesforce.com/Data Loader/process-conf.xml]
2015-06-23 11:19:59,029 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process:
\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from URL [file://C:/Program Fi
s-conf.xml]; nested exception is java.net.UnknownHostException: C
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableAppl
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.jav
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436)
        at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:140)
        at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:84)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:105)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246)
Caused by: java.net.UnknownHostException: C
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at sun.net.NetworkClient.doConnect(Unknown Source)
        at sun.net.NetworkClient.openServer(Unknown Source)
        at sun.net.ftp.FtpClient.openServer(Unknown Source)
        at sun.net.ftp.FtpClient.openServer(Unknown Source)
        at sun.net.www.protocol.ftp.FtpURLConnection.connect(Unknown Source)
        at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(Unknown Source)
        at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:125)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)
        ... 17 more
2015-06-23 11:19:59,045 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: tempCont configuration from config f
Data Loader\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from URL [file://C:
ader/process-conf.xml]; nested exception is java.net.UnknownHostException: C
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableAppl
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.jav
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436)
        at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:140)
        at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:84)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:105)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        ... 3 more
Caused by: java.net.UnknownHostException: C
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at sun.net.NetworkClient.doConnect(Unknown Source)
        at sun.net.NetworkClient.openServer(Unknown Source)
        at sun.net.ftp.FtpClient.openServer(Unknown Source)
        at sun.net.ftp.FtpClient.openServer(Unknown Source)
        at sun.net.www.protocol.ftp.FtpURLConnection.connect(Unknown Source)
        at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(Unknown Source)
        at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:125)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)
        ... 17 more

The error is java.net.UnknownHostException: C

Here is the relevent bean in the process-conf.xml file:


        Test upsert

The reason that I think there is a bug in DL 34 is because I also have DL 30.0.0 installed on my machine and when I change this line in the process.bat file:

..\Java\bin\java.exe -cp ..\dataloader-34.0-uber.jar -Dsalesforce.config.dir=%1  com.salesforce.dataloader.process.ProcessRunner %PROCESS_OPTION%

to this:

..\Java\bin\java.exe -cp ..\dataloader-30.0.0-uber.jar -Dsalesforce.config.dir=%1  com.salesforce.dataloader.process.ProcessRunner %PROCESS_OPTION%

and keep everything else the same, I don't get the java.net.UnknownHostException: C error.

Can anyone shed any light onto this?

Thanks

MTBRider
June 23, 2015
Like
1

3 replies

Ajax Tookit error "Sforce not defined" in customer community

I have a custom list button called New Form, Here is the code

=========================================

{!REQUIRESCRIPT("/soap/ajax/28.0/connection.js")}
{!REQUIRESCRIPT("/soap/ajax/28.0/apex.js")}

var url = top.window.location.href;

var profile = '{!$Profile.Name}';

var IsAuthorized = false;

if(profile.indexOf("Admin") != -1 || profile.indexOf("FAE/FTS") != -1 || profile.indexOf("Portal") != -1){
IsAuthorized = true;
}

if(queryResult.size > 0 ) {
alert("You can't Create another BX-041 record.");
}else {
window.open("{!URLFOR($Action.BX_041__c.New, null,null,false)}","_parent");
}

}

=================================================================

Anyone has any idea?

Regards,

Thomas

Tomas.Ray
October 01, 2013
Like
0

4 replies

Live Agent - how to block new chat request when it is out of business hours

Hi,

Here is the scenario:

Business hours are defined in SFDC.

Live agent is deployed in external website.

Agent forgot to turn his/her status into offline when it is out of business hours.

How to block new chat request?

There are two approaches:

1. Turn the agent's status into offline automatically when it is out of business hours.

2. Show offline button on the external website when out of business hours even if agent is still online.

Any hints or suggestion to implement it?

Regards,

Thomas

Tomas.Ray
February 27, 2013
Like
0

SOLVED

9 replies

API Session Id for external integration

API Session Id

I've been trying to find a work around for this issue. Basically, if I use the merge field {!$Api.Session_ID} on a button, the session Id is value and works just fine. If I attempt to use the same Api.Session_ID within either a formula field on a sObject, or within the APEX VisualForce page as a standalone merge field the session is no longer valid and fails when an outside source attempts to use that session Id. Would anyone know why and/or a work around for this?

Alex.Acosta
November 14, 2011
Like
0

SOLVED

7 replies

login problem

What does the message:

Your request cannot be processed at this time. The site administrator has been alerted.

after I tried to register using the default login page.

MyGodItsCold
December 09, 2008
Like
0