• chikpea
  • NEWBIE
  • 0 Points
  • Member since 2007

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 17
    Questions
  • 24
    Replies
We want to use the Excel Connector to download the PDF Attachments. After the download, whole attachment data is copied in BODY column. How can we create the attachment file again from that BODY column data?
 
  • September 30, 2009
  • Like
  • 0

I am trying to build a Search Page using SOSL query (just followed the example in VF guide book).

 

But the query doesn't reurn any row. Here is the Controller Code

 

 

public class woController {
String searchText;
List<Work_Order__c> workOrders = new List<Work_Order__c>();
public String getSearchText() {
return searchText;
}
public void setSearchText(String s) {
searchText = s;
}
public List<Work_Order__c> getWorkOrders() {
return workOrders;
}
public PageReference doSearch() {
workOrders = (List<Work_Order__c>)[FIND :searchText IN ALL FIELDS RETURNING
    Work_Order__c(Id, Name, Account__c, Service_Order__c, CreatedById, Work_Order_Status__c, CreatedDate)][0];
return null;
}
}

 

 

Here is the VF page code -

 

<apex:page controller="woController" tabStyle="Work_Order__c">
<apex:form >
<apex:pageBlock mode="edit" id="block">
<apex:pageBlockSection >
<apex:pageBlockSectionItem >
<apex:outputLabel for="searchText">Search Text</apex:outputLabel>
<apex:panelGroup >
<apex:inputText id="searchText" value="{!searchText}"/>
<apex:commandButton value="Go!" action="{!doSearch}" rerender="block" status="status"/>
</apex:panelGroup>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<apex:actionStatus id="status" startText="requesting..."/>
<apex:pageBlockSection title="Results" id="results" columns="1">
<apex:pageBlockTable value="{!workOrders}" var="wo" rendered="true">
<apex:column value="{!wo.Name}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

 

 

If I use SOQL query for any particular field search, then it works. Any help would be appreciated.

Is there any limitation on number of SOQL queries executed in a class? If so how much and whats the work around.

Hi,

 

We are looking for Tax software integration. Is there any pre-integration available? If not, any suggestion on Tax software to be integrated!

 

Thanks

Bhaskar

I used to create Work Order object using a Custom Button (create work order) in Service Order page. This used to call one S-Control which had sforce.connection.create([workorder]);

 

How can I do similar thing in visualforce, it seems I can't execute any DML like that.

 

Any suggestion would be appreciated.

 

Thanks

Bhaskar

Is there any datasheet on Batch job performance, like much time it would take to create 100,000 Objects with 20 fields in each object and having some validation/rule checking while creation.

 

Thanks

We have a managed application, where we used some Currency data type. When we created, we select default decimal 0, which we have to change now.

 

It seems Salesforce doesn't allow to do so, what's the way out.

 

Thanks

Bhaskar

I am trying to install a package in my Force.com developer org, but getting these errors -

 

Missing Organization Feature: Contact.RecordType          
Missing Organization Feature: Opportunity.RecordType          
Missing Organization Feature: Account.RecordType          
Missing Organization Feature: Contract.RecordType          
Missing Organization Feature: Contact.Sharing          
Missing Organization Feature: Opportunity.Sharing          
Missing Organization Feature: Account.Sharing          
Missing Organization Feature: MultiCurrency          
Missing Organization Feature: Contact.FieldHistoryTracking          
Missing Organization Feature: Opportunity.FieldHistoryTracking          
Missing Organization Feature: Account.FieldHistoryTracking          
Missing Organization Feature: GoogleDoc

 

I have no clue how to resolve these. Any help would be appreciated.

 

Thanks

Bhaskar

Hi,

 

I worked on Apex code more than 1 year before, developed some triggers and packages. Now I am finding that all those coding standards have been changed completely.

 

I can't compile my old trigger code, and Apex doesn't provide any correction hints. I am providing the code here, if someone can just validate, would be very helpful otherwise I am bit lost.

 

trigger getOrderLines on Service_Order__c (before insert, after insert) {
Double discount = 0;

if (Trigger.new.oss__quote__c != null) {
  if (Trigger.isBefore) {
     Trigger.new.total_plan_rate__c = [select oss__quote__c.oss__total_plan_rate__c from oss__quote__c where id = :Trigger.new.oss__quote__c].oss__total_plan_rate__c;

       try {              
                  discount = [select oss__quote__c.oss__charge_discount__c from oss__quote__c where id = :Trigger.new.oss__quote__c].oss__charge_discount__c;
        } catch (Exception e) { discount = 0; }

      Trigger.new.oss__total_charges__c = [select oss__quote__c.oss__total_charges__c from oss__quote__c where id = :Trigger.new.oss__quote__c].oss__total_charges__c - discount;

      Trigger.new.oss__total_equipment_rental__c = [select oss__quote__c.oss__total_equipment_rental__c from oss__quote__c where id = :Trigger.new.oss__quote__c].oss__total_equipment_rental__c;
}

  if (Trigger.isAfter)
       util.copyLineItemsFromQuote(Trigger.new.clone());
}
}

This code was compiled before, now I cant. If there is any document, which can show, what are the things have been changed, that would be helpful.

 

Thanks in advance!

Bhaskar

www.chikpea.com

I added some triggers to the custom objects, but after uploading to AppExchange, while creating the test drive, I couldn't see any trigger code for the eval user, also those functionalities were not working.
 
Any idea on this problem, it seems bit weird, any suggestion will be helpful.
I would like to know, how to set the test drive data, since the eval user is readonly, so there is no New button to see the screens also.
 
Any suggestions???
 
Thanks
Bhaskar Roy
www.chikpea.com
We want to publish our first app - Telecom Order Management, we have uploaded to appexchange, the status shows Unlisted - New.
 
Is there anything else we have to do? or it will be reviewed after this point? If yes, how long it may take.
 
Thanks & Regards
Bhaskar Roy
www.chikpea.com
How can I upload Help document or User document for the Apps we have created?
 
Regards
Bhaskar Roy
www.chikpea.com
Is there any way to show a Javascript Message from the trigger when New Object is created?
 
Also I am looking for a guide line for releasing App as our first App is ready.
 
Any help would be appreciated.
 
Regards,
Bhaskar Roy
as per doc I think its - Trigger.new.fieldname__c but this is showing some junk, looks like some object string value
 
Any idea????
I am new in Apex Coding and stuck!!! Here is our simple application, I have a custom object - Service Plan (Service_Plan__c), which has field - Price Rate (Rate__c).
 
Now I want to create Quote for customers, which has Quote Lines (Quote_Line__c), each Quote Line has direct relationship with one Service Plan.
 
Now I want to get that Price Rate field value in Quote Line, insert that Price Rate field value in each Quote Line Value (Value__c) field.
 
How can do this? I tried with (before insert) trigger, but every time it shows syntax error.
 
How can I get the plan name in trigger code to find the corresponding rate.
 
Thanks in Advance!
 
Bhaskar
 
 
I am looking for some precise document for connecting Oracle Apps/Financials with SFDC, to fetch data from Oracle Apps in SFDC.
 
Any pointer or help would be appreciated, I looked around, most of the documents I found, are generic, I want some exact Tech. doc.
 
Thanks
bhaskar.roy@chikpea.com

Hi -

 

I am looking for the fastest way possible to mass delete all records for a given custom object. I developed a very simple Batch Apex class which is described below.  The code works but it performs very slowly. Yesterday it took 40 minutes to delete 34,000 records, although I did not run into any governor limits.  It seems that the execute() call is only receiving a few records at a time.  Is there any way to coax it to process large groups of records?

 

Any help would be greatly appreciated.

 

global class MassDeleteCustomObject implements Database.Batchable<Sobject>

{

  global final String query = 'select Id from <my custom object>';

 

  global Database.QueryLocator start(Database.BatchableContext BC)

  {

 

       return Database.getQueryLocator(query);

  }

 

    global void execute(Database.BatchableContext BC, List<Sobject> records)

   {

        delete records;

   }

 

  global void finish(Database.BatchableContext BC)

  {

  }

 

}

We want to use the Excel Connector to download the PDF Attachments. After the download, whole attachment data is copied in BODY column. How can we create the attachment file again from that BODY column data?
 
  • September 30, 2009
  • Like
  • 0

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?

 

I have created a VF page that renders as PDF file. Now I want to save that PDF file onclick of same button to static resource. Is that possible? Means I have a button on click of which I got a VF page as PDF file. Instead of popping up this page as PDF file I want this PDF to save in my static resource.

 

Thanks,

I am trying to build a Search Page using SOSL query (just followed the example in VF guide book).

 

But the query doesn't reurn any row. Here is the Controller Code

 

 

public class woController {
String searchText;
List<Work_Order__c> workOrders = new List<Work_Order__c>();
public String getSearchText() {
return searchText;
}
public void setSearchText(String s) {
searchText = s;
}
public List<Work_Order__c> getWorkOrders() {
return workOrders;
}
public PageReference doSearch() {
workOrders = (List<Work_Order__c>)[FIND :searchText IN ALL FIELDS RETURNING
    Work_Order__c(Id, Name, Account__c, Service_Order__c, CreatedById, Work_Order_Status__c, CreatedDate)][0];
return null;
}
}

 

 

Here is the VF page code -

 

<apex:page controller="woController" tabStyle="Work_Order__c">
<apex:form >
<apex:pageBlock mode="edit" id="block">
<apex:pageBlockSection >
<apex:pageBlockSectionItem >
<apex:outputLabel for="searchText">Search Text</apex:outputLabel>
<apex:panelGroup >
<apex:inputText id="searchText" value="{!searchText}"/>
<apex:commandButton value="Go!" action="{!doSearch}" rerender="block" status="status"/>
</apex:panelGroup>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<apex:actionStatus id="status" startText="requesting..."/>
<apex:pageBlockSection title="Results" id="results" columns="1">
<apex:pageBlockTable value="{!workOrders}" var="wo" rendered="true">
<apex:column value="{!wo.Name}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

 

 

If I use SOQL query for any particular field search, then it works. Any help would be appreciated.

Hi,

 

I heard that Salesforce charge for security review of force.com native applications.

Is it true ?

 

If remember correctly, they did not charge force.com native applications before.

When did they started charging for security review of force.com native applications ?

 

Viraj

 

 

  • August 24, 2009
  • Like
  • 0

Some one help how the third party bill system and salesfrorce.com appExchange works if somebody know the business scenario please explain how to work with

 

LMA and ISV website and billing system any documentation it will helpful to us I did't find any documentation please post some of yours experience it will help us.

  • July 30, 2009
  • Like
  • 0
Is there any limitation on number of SOQL queries executed in a class? If so how much and whats the work around.

Hello all.

 

I'm rather new to posting on the Discussion Boards, but I have found them extremely useful in cutting my teeth on force.com development.  Big thanks to everyone who has helped me out so far...

 

I have a general question about future methods (ie Callouts):

 

I have a trigger in my sandbox that calls a method which calls out to a webservice I'm hosting.  This was working great yesterday.  The calls were almost instantaneous.  This morning I start testing again, and I get the following error:

 

 

Failed to invoke future method 'public static void makeCallout(String)' Debug Log: System.CalloutException: Read timed out

 

 

Afterwards, everytime I called the method from my trigger, nothing would happen.  No error messages, no activity on my web service, nothing.  I even put some System.Debug lines in my method, and they never show up in the System Log.  Also, I have in no way reached the 200 per licence per 24 hours limit.  In addition, my web service is working great.  I can call it using a SOAPUI client.

 

I did notice in the Montoring section under Apex jobs, that there is a record for every single attempt I made today, showing Job type as Future, Status Completed and Errors 0.  So it appears that the method is getting called, but not being processed.  Is it possible that the sandbox is queuing these up for some reason today?  Can anyone point me in the right direction?

 

Thanks in advance!!!

 

Arnold

I used to create Work Order object using a Custom Button (create work order) in Service Order page. This used to call one S-Control which had sforce.connection.create([workorder]);

 

How can I do similar thing in visualforce, it seems I can't execute any DML like that.

 

Any suggestion would be appreciated.

 

Thanks

Bhaskar

How many emails can the sendEmail  Apex method send out per day?

 

I went through the documentation, and here is what is says:

a. "All mass email and single email messages sent with the sendEmail method count against the daily mass mail limit of the sending organization."

 

b. "You can send mass email to a maximum of 1000 external email addresses per day based on Greenwich Mean Time (GMT)."

 

Statement 'b', in my opinion means that you can send emails to maximum 1000 distinct email addresses per day, but it says nothing about the number of actual email messages being sent.

 

 

Thanks.

I am trying to install a package in my Force.com developer org, but getting these errors -

 

Missing Organization Feature: Contact.RecordType          
Missing Organization Feature: Opportunity.RecordType          
Missing Organization Feature: Account.RecordType          
Missing Organization Feature: Contract.RecordType          
Missing Organization Feature: Contact.Sharing          
Missing Organization Feature: Opportunity.Sharing          
Missing Organization Feature: Account.Sharing          
Missing Organization Feature: MultiCurrency          
Missing Organization Feature: Contact.FieldHistoryTracking          
Missing Organization Feature: Opportunity.FieldHistoryTracking          
Missing Organization Feature: Account.FieldHistoryTracking          
Missing Organization Feature: GoogleDoc

 

I have no clue how to resolve these. Any help would be appreciated.

 

Thanks

Bhaskar

Hi,

 

I've created a managed package with an object that has a custom text field with a limit of 20 characters. It turns out it's not enough. Is there anyway short of creating a new field that I can change this in the next release?

 

Thanks!

Scott

  • April 23, 2009
  • Like
  • 0
Hello All,
 
I looking for small help in regards to downloading attachments through SalesForce APIs.
 
I have few "Account" objects and some of these account objects have file attached with them. When I call "getUpdated' for "Account" object type, I get all the changed objects (for the given start and end time). However I am not able to retrieve the associated attachment.
 
I tried making use of the following call:
 

qr = binding.query("select Name, Body, ContentType from Attachment where ParentId='0018000000M34fSCCS");

Not sure if this is the correct way to download the file attachments. Does anyone knows what is the right way to download the file attachments using SalesForce API. Btw, I am using Partner WSDL for all my development.

Any help in this regard is greatly appreciated.

Thanks

-Vallabha

I added some triggers to the custom objects, but after uploading to AppExchange, while creating the test drive, I couldn't see any trigger code for the eval user, also those functionalities were not working.
 
Any idea on this problem, it seems bit weird, any suggestion will be helpful.
We want to publish our first app - Telecom Order Management, we have uploaded to appexchange, the status shows Unlisted - New.
 
Is there anything else we have to do? or it will be reviewed after this point? If yes, how long it may take.
 
Thanks & Regards
Bhaskar Roy
www.chikpea.com

I've downloaded the sforce_connector PE and it works GREAT on most machines. On a few however, it won't install. I get a message from Microsoft/VisualBasic that says "Can't find Project or Library. Then it asks me for the sforce_connector password.
Has this happened to anyone else before? Does anyone know the password to the XLA? Maybe I can debug it on my own.
Neither "ttytytytyty" nor "sett" work

Many Thanks. Phil