We are designing an Integration leveraging Bulk API & Enterprise WSDL. The target Force.com Object has few Lookup Fields. Wanted to understand how to automatically resolve the Foreign Key.

For instance we have a Master Object "Geo Area" with values like 'APAC', 'EALA' etc.... Another Force.com Object called "SAP OM" which is the actual Object into which the integration upserts data has a lookup Field called "Client Geo Area" which looks up to "Geo Area" Master Object. The source system will only push values like 'APAC' or 'EALA' etc via the integration which we need to store into the lookup Field. However the Lookup Field expects the Row Id of the Master Values and not the actual Values.

How do we resolve this?

I am designing a solution which requires the Portal Team (front end team) to display top Level information as clickable link (Year On Year financial data) pulled-out from Force.com App. When the end user clicks the Year (say 2012) on the Portal he should be presented with the Monthly summary which should also be pulled from Force.com custom App.

I am planning to share the Enterprise WSDL and ask the Portal Team (.NET developers) to create Web-Parts leveraging the Enterprise WSDL as its Data Source. Is this solution viable? What are the gotchas' to lookout for?

I am designing a solution which requires the Portal Team (front end team) to display top Level information as clickable link (Year On Year financial data) pulled-out from Force.com App. When the end user clicks the Year (say 2012) on the Portal he should be presented with the Monthly summary which should also be pulled from Force.com custom App.

I am planning to share the Enterprise WSDL and ask the Portal Team (.NET developers) to create Web-Parts leveraging the Enterprise WSDL as its Data Source. Is this solution viable? What are the gotchas' to lookout for?

The ask is to sync the event details from Salesforce Public Calendar with SharePoint Calendar. This should happen when an event is created in SF. I would like your views on the feasibility of using Outbound Messages to achieve this. The SharePoint is internal to the Enterprise and the users are authenticated via the directory.

I had also investigated on the Sunlight search which is in Pilot but seems it is to search documents across SF & SharePoint. I could not make much headway. Any pointers would certainly help.

Is it possible to add invitees automatically when a Calendar Event is created? The requirement is to automatically create invitees based on a custom Event Field (Contract Value). The List of Invitees are maintained in a custom Object (Fields: Min Contract Value, Max Contract Value, Invitee Email etc..).

Depending on the data value entered in the Custom Field (Contract Value) the Invitee(s) should be automatically created.

The requirement is to read the contents of a xls/xlsx file (upon typical browse button) and insert the rows into a custom Force.com Object. Is it possible, found a post related to this as below, but it does not work when embedded wit-in VFP, also it is based on ActiveX and browser specific.

Reading Excel File

Can anyone suggest an approach/tools to handle this case? These operations are supposed to be permormed by End Users and not admins.

I have a requirement as below:

The Object Relationship is: DEAL (Parent, Private) -> WPV (Child) -> CHECKLIST (G Child) [All Master – Detail relationship]

The CHECKLIST Grand Child Object has a Field called Governance Lead which looks up to the standard USER Object.

I would like to share the CHECKLIST record with the User chosen in Governance Lead Field automatically when the record is saved. Can I achieve this?

Hi All,

I was told by Salesforce Support that they Support AES256bit encryption via TEXT (Encrypted) Field Type. My understanding is SFDC supporty only AES128 bit via TEXT (Encrypted) type? Even the documentation mentiones the same (https://na11.salesforce.com/help/doc/en/fields_about_encrypted_fields.htm)

In case if AES256 is supported it only applies to TEXT fields as above. How would Currency/Number Fields be stored? For Math can I TypeCast them?

If the only Option is to use Crypto Class, in which Field Type to store the encrypted value? I presume the steps are as below:

1. Get the Input value via VF Page
2. Use APEX Crypto Class to encrypt 
3. But using which Field Type the Encrypted Value (seems to be a Blob) be stored in Salesforce?

Thanks

Is it possible to display Parent -> Child -> Grand Child -> Great Grand Child Details in Parent Detail Page Layout. Out Of the Box it seems only Parent -> Child be displayed.

In case if this feature is not possible OOB without defining direct relationships, Could this design be achieved via Visual Force? If so could Standard controllers be used for CRUD operations?

Does Salesforce support encryption of attachments (does it automatically encrypt attachments), if not could it be implemented? If so how?

Does Salesforce supports Encryption of Types other than Text, I need to encrypt a Number/Currency Field?

Salesforce supports only 128 bit encryption (Text (Encrypted) Type), could 256 bit encryption be enforced?

Does Salesforce Support Database Encryption (encrypting the entire DB)?

Is it possible to add invitees automatically when a Calendar Event is created? The requirement is to automatically create invitees based on a custom Event Field (Contract Value). The List of Invitees are maintained in a custom Object (Fields: Min Contract Value, Max Contract Value, Invitee Email etc..).

Depending on the data value entered in the Custom Field (Contract Value) the Invitee(s) should be automatically created.

The requirement is to read the contents of a xls/xlsx file (upon typical browse button) and insert the rows into a custom Force.com Object. Is it possible, found a post related to this as below, but it does not work when embedded wit-in VFP, also it is based on ActiveX and browser specific.

Reading Excel File

Can anyone suggest an approach/tools to handle this case? These operations are supposed to be permormed by End Users and not admins.

I have a requirement as below:

The Object Relationship is: DEAL (Parent, Private) -> WPV (Child) -> CHECKLIST (G Child) [All Master – Detail relationship]

The CHECKLIST Grand Child Object has a Field called Governance Lead which looks up to the standard USER Object.

I would like to share the CHECKLIST record with the User chosen in Governance Lead Field automatically when the record is saved. Can I achieve this?

Hi All,

I was told by Salesforce Support that they Support AES256bit encryption via TEXT (Encrypted) Field Type. My understanding is SFDC supporty only AES128 bit via TEXT (Encrypted) type? Even the documentation mentiones the same (https://na11.salesforce.com/help/doc/en/fields_about_encrypted_fields.htm)

In case if AES256 is supported it only applies to TEXT fields as above. How would Currency/Number Fields be stored? For Math can I TypeCast them?

If the only Option is to use Crypto Class, in which Field Type to store the encrypted value? I presume the steps are as below:

1. Get the Input value via VF Page
2. Use APEX Crypto Class to encrypt 
3. But using which Field Type the Encrypted Value (seems to be a Blob) be stored in Salesforce?

Thanks

Does Salesforce support encryption of attachments (does it automatically encrypt attachments), if not could it be implemented? If so how?

Does Salesforce supports Encryption of Types other than Text, I need to encrypt a Number/Currency Field?

Salesforce supports only 128 bit encryption (Text (Encrypted) Type), could 256 bit encryption be enforced?

Does Salesforce Support Database Encryption (encrypting the entire DB)?

I have a user who just installed the Office Connector from inside SF (in the Desktop Integration section of Personal Setup), and it appears to have installed a version 4.0 of the toolkit.

He's getting the "Can't find project or library" error that others have reported getting as a result of a mismatch between Version 2.0 of the toolkit and Version 6.16 of the Excel Connector.

Has there been an updated version of the Excel Connector that will work with Version 4.0 of the toolkit? If not, how do I downgrade him back to Version 3.0, since the only version that will download from SF setup is version 4.0?  

This is not the most technical of users, and I'm supporting him from 200 miles away, so I can't just go to his computer and do it for him. So asking him to go to the Developer Toolkit type sites and figure out what to do is asking for disaster. Please help!