• indy_sfdc
  • NEWBIE
  • 75 Points
  • Member since 2009

  • Chatter
    Feed
  • 3
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 15
    Replies

Hi,

 

I use data loader for mass updating, deleting.

while using to mass update, i have an issue.

Lets say i have CSV file with Following Information:

 

Account ID           Old Value     New Value

 

00001234xyz       A                

 

New Value is of type picklist and has following values:

--None--

A

B

C

 

Now, when i use data loader to update the field, it does not update to empty, instead it retains its Old value i.e, A from above example.

 

I tried to use NULL in New Value field in CSV file, but when i update it creates a new value in the Picklist with NULL as another value.I dont want that to happen.

 

Any ideas would be of great help.

 

Thanks in advance,

Sales4ce

Hello All,

 

How do I enable  multi-currency support for my developer account?

 

any idea?

 

 

Thanks

Message Edited by Dowithforce on 10-20-2009 08:29 AM
Hi,
 
I have sent query to 'support@salesforce.com' for enabling my account (Single Sign on) SSO enabled.
I have not got any answer so far.
Generaly how long does it take to make it SSO enabled?
I want to try SSO from my company.
Can somebody help me?
 
Thanks
Servesh

Hi,

 

I need some tutorial to understand visualforce pages and tags.

If someone have this ind of tutorial please forward me on

 

manoj.jain4328@gmail.com

 

This would be really helpful for me.

 

Regards,

Manoj Jain

I'm recieving the following error message when trying to export data out of sfdc:

 

!LoadWizard.errorFileCreate!updateacontact.csv 

Hi All,

 

I am trying to modify a Custom S control to look at two separate objects as validation before a sales order is created. The original part of the code was as follows:

 

function success(qr) { 
//Create SO Header 
var it = new sforce.QueryResultIterator(qr); 
var OppId = "{!Opportunity.Id}"; 
var AccountId = "{!Account.Id}"; 
var records = qr.getArray("records"); 
while(it.hasNext()){ 
var record = it.next(); 

if (record.PBSI__hasSO__c == "1") 

window.parent.location.href="/" + OppId; 
failure("This opportunity has already been converted to a sales order!"); 

else 

var salesorder = new sforce.SObject("PBSI__PBSI_Sales_Order__c"); 
salesorder.PBSI__Customer__c = record.AccountId; 
salesorder.PBSI__Lead_Source__c = record.LeadSource; 
salesorder.PBSI__Created_From__c = record.Name; 
salesorder.PBSI__Opportunity__c = record.Id; 
salesorder.PBSI__Customer_Purchase_Order__c = record.PBSI__Customer_PO__c; 
salesorder.PBSI__Order_Discount__c=record.PBSI__Discount__c; 

result = sforce.connection.create([salesorder]); 

salesorder.id = result[0].id; 

 

This works fine. However, I am trying to add in a section to get it to look at the "account status" field on the account and if it has a value of either "On Hold" or "Gone Legal" it will also fail to create a sales order.

 

I came up with the following:

 

function success(qr) { 
//Create SO Header 
var it = new sforce.QueryResultIterator(qr); 
var OppId = "{!Opportunity.Id}"; 
var AccountId = "{!Account.Id}"; 
var records = qr.getArray("records"); 
while(it.hasNext()){ 
var record = it.next(); 

if (record.PBSI__hasSO__c == "1") 

window.parent.location.href="/" + OppId; 
failure("This opportunity has already been converted to a sales order!"); 

if (record.c2g__CODACreditStatus__c == "On Hold") 

window.parent.location.href="/" + AccountId; 
failure("Oi Dingbat, This account is On Hold!"); 


else 

var salesorder = new sforce.SObject("PBSI__PBSI_Sales_Order__c"); 
salesorder.PBSI__Customer__c = record.AccountId; 
salesorder.PBSI__Lead_Source__c = record.LeadSource; 
salesorder.PBSI__Created_From__c = record.Name; 
salesorder.PBSI__Opportunity__c = record.Id; 
salesorder.PBSI__Customer_Purchase_Order__c = record.PBSI__Customer_PO__c; 
salesorder.PBSI__Order_Discount__c=record.PBSI__Discount__c; 

result = sforce.connection.create([salesorder]); 
salesorder.id = result[0].id; 

 

As you can see I defined the "AccountId" variable but I am not a javascript programmer so I've obviously gone wrong somewhere.

 

Any help much appreciated.

 

All the best


David Quirke

 

 

In SF, is there any interface (API) to get connected SF API Version?

 

Chadnu

Hi,

 

I use data loader for mass updating, deleting.

while using to mass update, i have an issue.

Lets say i have CSV file with Following Information:

 

Account ID           Old Value     New Value

 

00001234xyz       A                

 

New Value is of type picklist and has following values:

--None--

A

B

C

 

Now, when i use data loader to update the field, it does not update to empty, instead it retains its Old value i.e, A from above example.

 

I tried to use NULL in New Value field in CSV file, but when i update it creates a new value in the Picklist with NULL as another value.I dont want that to happen.

 

Any ideas would be of great help.

 

Thanks in advance,

Sales4ce

Hy Guys,

 

I've a workflow rule with a field update as action.

My new field value shall be: Today() - 3 Business days.

How can I calculate that only Business days are subtracted?

Can anybody help me?

 

Thanks and best regards,

Freddy 

Message Edited by Freddy99 on 02-23-2010 12:21 AM

Hello,

 

Is it possible, via web-services, to create a new lead, and create a task in one step?

 

Currently we create the lead, retrieve the returned lead id, then create the task. However we have a new trigger in place which may merge the lead prior to the task create so we're getting errors.

 

Thanks,

-Rick

We need to create a cusomer portal user from a .NET code and not from Apex (so we cannot use the Site.CreateCusomerPortal method in Apex).

 

For some reason, when trying to create new user from the .NET API we keep getting the following error:

invalid cross reference id (Status code INVALID_CROSS_REFERENCE_KEY)

 

 

Any ideas\examples on how we can perfrom this task and why we keep getting this error?

Hello All,

 

How do I enable  multi-currency support for my developer account?

 

any idea?

 

 

Thanks

Message Edited by Dowithforce on 10-20-2009 08:29 AM
I have not been able to find where to enable this feature, your assistance is always welcome.

Hi,

 

I'm looking for a way to call an apex function every day at a particular time ( just like cronjob in linue ). Is this possible in salesforce?

 

The cookbook describes how to retrieve data for a particular division on page 110.

However, when I attempt to submit the query in Apex Explorer 8.0, I get:

SOSL Test returned and error:
INVALID_SEARCH: divisions are not enabled

How do I enable them?
Hi,
 
I have sent query to 'support@salesforce.com' for enabling my account (Single Sign on) SSO enabled.
I have not got any answer so far.
Generaly how long does it take to make it SSO enabled?
I want to try SSO from my company.
Can somebody help me?
 
Thanks
Servesh