Hello !

I want to Split an Existing Attachment on Account into several PDF files.

What I want is to be able to click a button on Accountet that loads an apex page where you select a PDF and click "Split PDF" that saves down result in multiple PDF files at Accountet.

I would be very grateful if anyone out there has knowledge of this and can give input to how this can be resolved!

Existing pdf : attachments 1.pdf

Result:
attachments 1.pdf
attachments 2.pdf
attachments 3.pdf

Hello ! 

 

I have an Integration plattform, that talks to SalesForce thru Enterprice WSDL, and gets the following error !

 

I guess its has to do with "LAST_N_DAYS:33" any one out there who nows ?

 

Could not mediate request due to an error in provider. SOAP fault: 'sf:MALFORMED_QUERY' :: 'MALFORMED_QUERY: only aggregate expressions use field aliasing' :: 'missing fault actor'. :: Details: <?xml version="1.0"?>

<sf:MalformedQueryFault xsi:type="sf:MalformedQueryFault">

<sf:exceptionCode>MALFORMED_QUERY</sf:exceptionCode>

<sf:exceptionMessage>only aggregate expressions use field aliasing</sf:exceptionMessage>

<sf:row>-1</sf:row>

<sf:column>-1</sf:column>

</sf:MalformedQueryFault>”

 

Question:

 

Select
o.Span_Order_Id__c,
o.Installation_ID__c,
o.Status__c,
o.Opportunity.Account.Id,

o.Opportunity.Account.Account_Legal_name__c,

o.Opportunity.Account.Churned_inactive__c,

o.Opportunity.Account.Organisation_Id__c,

o.Opportunity.Account.WS_Organisation_ID__c,
o.Opportunity.Account.Owner.Phone,

o.Opportunity.Account.Owner.Email,
o.Opportunity.Account.Phone,
o.Opportunity.Account.Account_Owner_Name__c,

o.Opportunity.Account.Account_SM_Owner__r.name
From OpportunityLineItem o
where
     (
  (o.Installation_ID__c != '' and LastModifiedDate = LAST_N_DAYS:33) or
  (o.Opportunity.StageName = 'Agreement Validated' and o.Installation_ID__c != '' and
   o.Opportunity.LastModifiedDate = LAST_N_DAYS:33)
  )

 and o.Account_Location__c != ''

   

Hello ! 

 

I have an Integration plattform, that talks to SalesForce thru Enterprice WSDL, and gets the following error !

 

I guess its has to do with "LAST_N_DAYS:33" any one out there who nows ? 

 

Could not mediate request due to an error in provider. SOAP fault: 'sf:MALFORMED_QUERY' :: 'MALFORMED_QUERY: only aggregate expressions use field aliasing' :: 'missing fault actor'. :: Details: <?xml version="1.0"?>

<sf:MalformedQueryFault xsi:type="sf:MalformedQueryFault">

<sf:exceptionCode>MALFORMED_QUERY</sf:exceptionCode>

<sf:exceptionMessage>only aggregate expressions use field aliasing</sf:exceptionMessage>

<sf:row>-1</sf:row>

<sf:column>-1</sf:column>

</sf:MalformedQueryFault>”

 

Question:

 

Select
o.Span_Order_Id__c,
o.Installation_ID__c,
o.Status__c,
o.Opportunity.Account.Id,

o.Opportunity.Account.Account_Legal_name__c,

o.Opportunity.Account.Churned_inactive__c,

o.Opportunity.Account.Organisation_Id__c,

o.Opportunity.Account.WS_Organisation_ID__c,
o.Opportunity.Account.Owner.Phone,

o.Opportunity.Account.Owner.Email,
o.Opportunity.Account.Phone,
o.Opportunity.Account.Account_Owner_Name__c,

o.Opportunity.Account.Account_SM_Owner__r.name
From OpportunityLineItem o
where
     (
  (o.Installation_ID__c != '' and LastModifiedDate = LAST_N_DAYS:33) or
  (o.Opportunity.StageName = 'Agreement Validated' and o.Installation_ID__c != '' and
   o.Opportunity.LastModifiedDate = LAST_N_DAYS:33)
  ) 

 and o.Account_Location__c != ''

<apex:pagestandardController="Opportunity"extensions="customer_operations"

.

.

.

<apex:outputPanel id="TelephoneNumber" rendered="{!ShowTelephoneNumber}" layout="block" >     
       <apex:pageBlock title="Edit TelephoneNumbers">
                 <apex:pageBlockTable value="{!EditTelephoneNumbers}" var="e">
                  <apex:column >
            <apex:facet name="header">Mobile Number</apex:facet>
            <apex:inputText id="eTelephoneNumber" value="{!e.TelephoneNumber}"/>
         </apex:column> 
         <apex:column >
            <apex:facet name="header">Length</apex:facet>
            <apex:inputText id="eLength" value="{!e.Length}"/>
         </apex:column> 
         <apex:column >
            <apex:facet name="header">Companyname</apex:facet>
            <apex:inputText id="eCompanyname" value="{!e.Companyname}"/>
         </apex:column>           
        </apex:pageBlockTable>
        
        <apex:pageBlock id="block">
                <apex:pageBlockSection >
                   <apex:pageBlockSectionItem >
                       <apex:commandButton value="Save" action="{!save}"  rerender="block">
            <apex:param name="myParam1" value="{!$Component.frm.eCompanyname}"/>
                       </apex:commandButton>            
                   </apex:pageBlockSectionItem>
                </apex:pageBlockSection>
        </apex:pageBlock>   
       </apex:pageBlock>
      </apex:OutputPanel>

 

public void save() {
     string myParam = apexpages.currentpage().getparameters().get('myParam1');
     system.debug('************************************************');
     system.debug( myParam);
     system.debug('************************************************');
     //Here a want to create a new instance of my custom object <Phone_Numbers__c>
     // with information from params.
     }

 

How can a get the value of myParam to be the value of <apex:inputText id="eCompanyname" value="{!e.Companyname}"/> ?

Save Email created with email template on opportunity - I use trigger on lineitem that calls a class to send email.

In that class i want to save the email to opportunity as attachment. I need this so the salesrep can edit the sent mail and resend the mail, if something is missing.  Please need help.

Hello ! Now we have Richtext field in Beta version. When will it be implemented in API and Apex Explorer, anyone?

 

Best regards

Peter Björkén

Hello !

 

I want to send email to users, WF rule on (statusInProd__c from external system,value  Planned, revise, ok ) on opportunitylineitem.

 

I have 9 diffrent emails deppending on status and produkt.

 

I was thinking of email templates with apex code.  I dont have much knowlege with SalesForce, so please help me, what is the best way to go, if you want some kind of error handling?

 

Best regards

Peter   

Hello !

 

I need to feed an old billing system with information from SalesForce.

 

What is the best way for creating files in SalesForce?

 

What is the best way to connect to an FTP server in SalesForce?

 

Best regards

Peter

Hello !

I want to Split an Existing Attachment on Account into several PDF files.

What I want is to be able to click a button on Accountet that loads an apex page where you select a PDF and click "Split PDF" that saves down result in multiple PDF files at Accountet.

I would be very grateful if anyone out there has knowledge of this and can give input to how this can be resolved!

Existing pdf : attachments 1.pdf

Result:
attachments 1.pdf
attachments 2.pdf
attachments 3.pdf