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

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:

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 

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

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?