Hello Folks,

I have to remove all Chars from an Field so .. whats the Similar Code  from the
Apex Code: replaceAll('[0-9]', '')
in an Formula? 

best regards john 

SF.Professional 
API/Workflow 

Hello Community,

I want to search an Modified Date in the Whole Salesforce Org. 

How can i achieve this easily ?  Could i do this with an SOQL Browser ( Force com explorer) or sth. like that ? 

regards john 

SF.-Professional 
Standard-Sandbox
Hello

I want to migrate some Contacts from my SF-Prod to my SF-Sandbox.

so which external id i should take .. i tried this with the ID itself but there comes an error with " invalid crosse reference id"

is use talend .. but this should doesn't really matter in this case 

regards john 



 

SFO 3.22 
Hello Community, 
 
Is it possible to trigger the Sync Command " Sync Now"  in the Taskbar  from  an Link like an batch file or sth like that? 
 
regards john 

Salesforce Professional 
SFO 3.22 

Hello Community,

We have some Contacts in our Exchange and we want tio sync these with SFO.
Unfortunately we have several Sub-Companies and the Mathching Algorythm from SF doesn't hit eyerytime  the right Account.

So we want to assign our Contacts to the right Account with an Account Number.
I tried to create some Custom Fields in the Outlook Forms and mapped these with the related Fields in Salesforce.

But this seems not to work, the Field Value won't be recognized from Salesforce.

Furthermore should the assignment running in an automatic way ... i hope  this can be achieved with Process Builder 

So.. does anyone has some experiences  ?  
Thanks for help 

regards john 







 



 

SF. Prof: 
Api Package 

Hello Guys 

First of all .. Sorry for the maybe stupid Questions cause my konwledge about developing is very well 

Whats the best practice to test the domain before the domain is deployed on the org. 

Could i test...   for example the soap endpoint in "testing Mode" ?

I'm as little bit scared cause were using Talend in fomrer times we had some issues with that. 

Any help or advices are appriciated 

thanks in advance 
regards john 



 

Salesforce prof:
Supp. Soap Version in Talend: 34.0

Hello Community 

First of all I'm not really firm in things like development .. so plz.  bear with me a little bit if sth. is wrong or i provide the wrong infos...

We use Talend to intagrate out ERP Data in Salesforce.

But nowadays when i try to connect with Salesforce, it comes the following error:

Exception in component tSalesforceInput_1
java.lang.RuntimeException: [LoginFault [ApiFault  exceptionCode='INVALID_LOGIN'
 exceptionMessage='Invalid username, password, security token; or user locked out.'

I don't want to recreate the security token cause then i have to rebuild all Jobs and 3 Party Addons 

Any other ideas hoe i can fix this ? 

Or do you need more infos ?

regards john 




 

SF-Edition: Prof.
Packages: Worfklow and API

Hello Community

We try to Import our ERP Data Records to Salesforce   with the Help of the ETL Tool Talend.

But when i try to start the Job, there come the following error on the 2000 Record.
 

Exception in component tSalesforceOutput_1
org.apache.axis2.AxisFault: Invalid null character in text to output
	at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
	at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:78)
	at org.apache.axis2.transport.http.AxisRequestEntity.writeRequest(AxisRequestEntity.java:84)
	at org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:499)
	at org.apache.commons.httpclient.HttpMethodBase.writeRequest(HttpMethodBase.java:2114)
	at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1096)
	at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
	at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
	at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
	at org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:621)
	at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:193)
	at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
	at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:404)
	at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:231)
	at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
	at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406)
	at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
	at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
	at com.salesforce.soap.partner.SforceServiceStub.upsert(SforceServiceStub.java:19013)
	at org.talend.salesforce.SforceConnection.upsert(SforceConnection.java:110)
	at org.talend.salesforce.SforceManagementImpl.upsert(SforceManagementImpl.java:462)
	at sf_csv.sf_prod_data_migration_lookup_sf_all_companies_working_splitted_query_0_1.SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.tOracleInput_1Process(SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.java:4382)
	at sf_csv.sf_prod_data_migration_lookup_sf_all_companies_working_splitted_query_0_1.SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.runJobInTOS(SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.java:6312)
	at sf_csv.sf_prod_data_migration_lookup_sf_all_companies_working_splitted_query_0_1.SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.main(SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query.java:6150)
Caused by: com.ctc.wstx.exc.WstxIOException: Invalid null character in text to output
	at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:467)
	at org.apache.axiom.util.stax.wrapper.XMLStreamWriterWrapper.writeCharacters(XMLStreamWriterWrapper.java:100)
	at org.apache.axiom.om.impl.MTOMXMLStreamWriter.writeCharacters(MTOMXMLStreamWriter.java:325)
	at org.apache.axiom.om.impl.llom.OMTextImpl.writeOutput(OMTextImpl.java:249)
	at org.apache.axiom.om.impl.llom.OMTextImpl.internalSerialize(OMTextImpl.java:400)
	at org.apache.axiom.om.impl.util.OMSerializerUtil.serializeChildren(OMSerializerUtil.java:556)
	at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:846)
	at org.apache.axiom.om.impl.llom.OMSerializableImpl.serialize(OMSerializableImpl.java:120)
	at org.apache.axiom.om.impl.llom.OMSerializableImpl.serialize(OMSerializableImpl.java:108)
	at com.salesforce.soap.partner.sobject.SObject.serialize(SObject.java:311)
	at com.salesforce.soap.partner.sobject.SObject.serialize(SObject.java:218)
	at com.salesforce.soap.partner.Upsert.serialize(Upsert.java:169)
	at com.salesforce.soap.partner.Upsert.serialize(Upsert.java:126)
	at org.apache.axis2.databinding.ADBDataSource.serialize(ADBDataSource.java:90)
	at org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(OMSourcedElementImpl.java:638)
	at org.apache.axiom.om.impl.util.OMSerializerUtil.serializeChildren(OMSerializerUtil.java:563)
	at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:846)
	at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(SOAPEnvelopeImpl.java:267)
	at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SOAPEnvelopeImpl.java:229)
	at org.apache.axiom.om.impl.llom.OMSerializableImpl.serializeAndConsume(OMSerializableImpl.java:188)
	at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:74)
	... 22 more
Caused by: java.io.IOException: Invalid null character in text to output
	at com.ctc.wstx.api.InvalidCharHandler$FailingHandler.convertInvalidChar(InvalidCharHandler.java:51)
	at com.ctc.wstx.sw.XmlWriter.handleInvalidChar(XmlWriter.java:629)
	at com.ctc.wstx.sw.BufferingXmlWriter.writeCharacters(BufferingXmlWriter.java:497)
	at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:465)
	... 42 more
[statistics] disconnected
[trace] disconnected
Job SF_Prod_Data_Migration_Lookup_SF_All_Companies_working_splitted_query ended at 13:16 13/01/2016. [exit code=1]

I'm not sure but i think the reason is on the SF side and not one the Talend one ... otherwise correct me if I'm wrong 

So does anyone has an clue or an idea where i have to start to resolve my problem  ?

Thanks in advance for any help 

regards john 

SF.-Professional 
Standard-Sandbox
Hello

I want to migrate some Contacts from my SF-Prod to my SF-Sandbox.

so which external id i should take .. i tried this with the ID itself but there comes an error with " invalid crosse reference id"

is use talend .. but this should doesn't really matter in this case 

regards john 



 

SF. Prof: 
Api Package 

Hello Guys 

First of all .. Sorry for the maybe stupid Questions cause my konwledge about developing is very well 

Whats the best practice to test the domain before the domain is deployed on the org. 

Could i test...   for example the soap endpoint in "testing Mode" ?

I'm as little bit scared cause were using Talend in fomrer times we had some issues with that. 

Any help or advices are appriciated 

thanks in advance 
regards john 



 

Salesforce prof:
Supp. Soap Version in Talend: 34.0

Hello Community 

First of all I'm not really firm in things like development .. so plz.  bear with me a little bit if sth. is wrong or i provide the wrong infos...

We use Talend to intagrate out ERP Data in Salesforce.

But nowadays when i try to connect with Salesforce, it comes the following error:

Exception in component tSalesforceInput_1
java.lang.RuntimeException: [LoginFault [ApiFault  exceptionCode='INVALID_LOGIN'
 exceptionMessage='Invalid username, password, security token; or user locked out.'

I don't want to recreate the security token cause then i have to rebuild all Jobs and 3 Party Addons 

Any other ideas hoe i can fix this ? 

Or do you need more infos ?

regards john 




 

1. I have used Salesforce Napili template to create a new Community. 
2. I have created a new page in this template where I am exposing a new Lightning Component I created. 
3. The lightning component accepts email and phone as two attributes. 
4. These attributes should be passed to the lightning component embedded in the community as URL parameters. I am not able to do this today. 
 
I would like to pass pass parameters to the lightning component inside community using URL parameter like: 
http://<<communityURL>>/<<communityName>>?&email=rama@test.org&phone=999-999-9999 
 
The email and phone parameters from the community URL should be passed to the component included in the community. 
 
I know a way of doing this through lightning applications. I have seen this link: 
http://salesforce.stackexchange.com/questions/106543/lightning-app-getting-url-parameter 
 
But, my usecase is different. I don't have a lightning application. I only have a lightning component embedded in a Salesforce Lightning Community.
 
Please suggest, if this can be done.

Where can I download SFO?

I have an escalation rule in case objects.After 1 day i triggering my escalation rule. Is Escalated is getting set on case.
How I will change the status of case to "Escalated" after escalation automatically.
Please provide me your suggestions.

Hi,

I'm fairly new to formula fields and am having trouble with this one. I want to display various images depending on which picklist value is chosen.  Here is one formula I've tried, and am getting a very confusing error message :( 

Error: Incorrect number of parameters for function 'ISPICKVAL()'. Expected 2, received 9

Could anyone guide me in the right direction? Thanks!

IMAGE (
ISPICKVAL (
Contact_Status_Data__c,
   "Active", "img/msg_icons/confirm32.png",
   "Inactive", "img/msg_icons/error32.png",
   "Non-Serviced", "img/msg_icons/warning32.png",
   "No Volume", "img/msg_icons/info32.png"
))

Hi,

 

We have dupe catcher installed for our organization. I have batch loaded a list of leads using the import wizard. Dupecatcher did not stop the duplicate records from entering into salesforce. In appexchange I found that dupe catcher will not stop the duplicate records when a mass upload using data loader or import is done. What is the solution for me to upload a batch of loads and still want the dupe catcher working?

 

 

Thank You for your help in advance.

Hi,

 

How can I manage /Access /Update 100 millions of records in Apex .

 

Is it Possible using Batch Apex?

 

I think batch apex can Process 50 millions of records.

 

how can I do this?

 

any help?

 

Thanks

 

 

Hi,

 

I was just wondering, is there a way to query to the items in the recycle bin in our organization. If so, any samples are appreciated.

 

Also, Can i export items out of recycle bin using a data loader?? Any stpes regarding the same would be appreciated.

 

Thanks.

I'm new to Visualforce and APEX;

 

Here is some background on what I am trying to do - Each Account is assigned either "Agency" or "Client" picklist values under the "Type" field. (I am using Professional edition, so I am not able to create different Account Record Types). My company's Opportunities always relate to TWO Accounts - one of each type. I currently have the Opportunity Account Name field looking up Agency Accounts and a custom look up field to assign the Client Account.

 

The issue I have is displaying redundant Related Lists on the Account Page - for "Agency" accounts, this is fine.. the Opportunities show up under "Opportunities" related list. For Client Accounts, however, the related Opportunities display on a separate related list created by the custom look up field.

 

Any direction on the best way to tackle this is appreciated - below I've listed my ideas, but I don't know how to execute any of them (I'm shuffling around in the Visualforce inline page documentation but quite confused...) Also - please let me know if what I am trying to do requires Enterprise.

-HIDE empty related list

-DISPLAY related list based on Account Type Field value (using an inline visualforce page?)

-restructure how i point opportunities to multiple accounts..

Is there any setting that allows you to disable the Identity Confirmation  (the email activation link) sent to a user when logging in from a new computer?

 

thanks!