I would like to define
  Code:

class MyContact < ActiveRecord::Base
    include ActiveSalesforce::ActiveRecord::Mixin
    set_table_name("Contact")
end

 but to do this, I need to be connected to salesforce.com *before* including the set_table_name (or set_table_name connects automatically).

What I need is to be able to set up my classes, and *then* to initiate connection(s). Especially in a test rig where connecting to salesforce.com is part of the tested methods, in which I would like to use pre-recorded test results for offline testing, just as Asf is unit-tested.

Would it be possible to postpone connection in set_table_name to later ?

I have a custom object defined with a namespace/custom prefix : the resulting classname is something like ALT__Myklass__c

I wish to define Myklass in ActiveSFDC :
Code:

class Myklass < ActiveRecord::Base
    include ActiveSalesforce::ActiveRecord::Mixin
    set_table_name("ALT__Myklass__c")
end

This does not work : ActiveSFDC looks for ALT_Myklass (notice only 1 underscore), or defaults back to ALT_Myklass__c (still only 1 underscore). This does not work either if we do not set_table_name : AsctiveSFDC goes llooking for Myklass__c, with no prefix.


ActiveSFDC needs to handle namespace prefixes correctly, just as it handles custom '__c' suffixes.

Hi,

I wanted you to know that I was taking part in the mydreamapp.com competition to design (and get developed) the greatest Mac application !
My idea is macForce, salesforce.com on the Mac : the idea is presented here, copied below.

Please cross-post discussions about this idea on the mydreamapp forum.
If you wish to support this idea, please vote for it starting 1/2 september on mydreamapp.com.


So just imagine, now, having salesforce.com on your Mac.

You can use already the salesforce.com OnDemand service online ?
That's true, but here are the drawbacks :
. online : precisely, you have to be online to use salesforce.com
. speed : the reactivity of your web browser, through the internet, is much less good than any Mac app you are used to using locally
. usability : any Mac app, with great user interfaces and integration with your other Mac desktop applications, will be more usable, sexy and productive than salesforce.com through your web browser, even with the best Ajax UI (which salesforce.com does not have).

So what exactly will macForce offer ?


Feature 1 : sync your data between the OnDemand salesforce.com platform and your Mac, locally

You now have all your salesforce.com on your Mac; you can walk away from the net, use the data offline, and sync it back later on. Data is mapped to the MacOSX data model thanks to the introspection features of the salesforce.com API : Accounts and Contacts mapped to AddressBook addresses, Tasks and Events mapped to iCal, Documents stored in the Finder as files, etc.
Are you getting it now ?  You will be able to read, update, create, delete and link all this data offline, on your own Mac, and those actions will be reflected, after the next sync, in salesforce.com
You use several salesforce.com accounts ?  That's OK, macForce will tag your data with your salesforce.com userid, and store your passwords in KeyChain, if you want.
On MacOSX Server, this sync engine will run as a service : that means it will just run on its own, without your assistance - the same is true for the MacOSX client platform, of course.
Just like any sync service, conflicts will be managed and resolved. macForce will used the Mac's SynServices; there is a difficulty here, which is discovering how the "server" value of Client Description type is managed ...
Data is stored locally in a CoreData database. The sync engine will be extended with engine-plugins, developed by third-party partners, to connect to other OnDemand services. They will also be able to develop data-plugins to sync your own salesforce.com custom data objects (e.g. pulled in from the AppExchange).


Feature 2 : macForce integrated with Spotlight

This is not as straightforward as it seems, since Spotlight does not search databases (currently), but only searches file metadata. Depending on the advances of Spotlight in Leopard, we will either implement this feature rather like Delicious Library (i.e. create a small file for each salesforce.com object), or use the hoped-for Leopard feature of Spotlight for CoreData databases.
An API will be standardized around this service, in the first case, so that any Mac developer can developer his own local Mac application to handle your salesforce.com data on the Mac !  In the second case, the API will be simple Leopard CoreData+Spotlight : what could be more simple ?
So just imagine searching through your heap of salesforce.com contacts : they are all there; find them in Spotlight, in Mail, in AddressBook, etc.


Feature 3 : macForce integrates salesforce.com with the Mac

There is currently no Mac client for salesforce.com, because they provide a client component based on .Net which does not run on our favorite platform. No worries; with macForce, you will be using Mac apps !
Send an SMS to a salesforce.com contact from AddressBook; fix a meeting with him in iCal; send him an email and add it to his current Opprotunity from within Mail.app - all this on your Mac, offline : it will all sync up to the salesforce.com OnDemand service later on. macForce will be integrated with Skype for IP-calls, Gmail for storage if necessary, Google Maps and Earth for locations, Growl for notifications, etc., etc. Your imagination is the limit, your data is now on your Mac with macForce.


Feature 4 : macForce comes with its own Mac client apps

(sync) engines are nice, but Mac user interfaces are much nicer. macForce comes with its own client applications for you to update your own salesforce.com data on your Mac : a Sales and a Support console. These are designed like iSale or Delicious Library, and integrate all the possible operations on your standard salesforce.com data : Opportunity, Product, Solution, Contract, Campaign, as well as Document in Finder, Account and Contact in AB, Task and Event in iCal.
Your favorite Mac developer will also be able to add specific plugins into macForce to develop the perfect GUI (graphical user interface) to handle your own custom data from salesforce.com.


Feature 5 : macForce syncs your salesforce.com data with .Mac

A second sync engine keeps all your data synced with .Mac : your Accounts and Contacts data will sync with the rest of your AddressBook data, salesforce.com Events and Tasks will go with your iCal data, salesforce.com Documents (files) will go on iDisk, and all the rest will be synced as a new SalesForce.com data class in .Mac

So now, you can access all that business data from all your Macs : at home, at work, on your MacBook pro you want to take to the beach, etc.


Finally, a bit about this competition. How will judges evaluate macForce ?


A) Innovation and Creativity : ***** (5/5)?

This has never been done. I have been waiting for this app for 2 years, and not seen anyone mention anything like it. That is why I have started prototyping it, spending most of my time looking out for the technologies (now available) to implement it with.


B) Use of OS X and Leopard technologies : ****. (4.5/5)

Integrated with many desktop mac applictions, macForce will also rely on lower-level Tiger and Leopard technologies like Spotlight, CoreData, TimeMachine, etc.


C) Feasibility of Development : ****. (4.5/5)

This has already been prototyped - e.g. for calling the salesforce.com API, have a look at ActiveSalesforce which I run with client-only RubyOnRails.

D) Mass-Market Appeal : ***** (5/5)

I hope that macForce will simply be the Trojan Horse we have been waiting for to introduce the Mac massively into the entreprise : that is what I have been waiting for for 2 years now.


Beyond bringing valuable on-demand services right to your Mac, the "sync to on-demand" concept of macForce is the door open to a stream of Mac apps working locally with seamlessly-synced business services data and turns the salesforce.com service platform into an extension of the Mac and its .Mac/iDisk sync model.

Just posted on mydreamapp.com.
Mac users, and OSX (Tiger, Leopard) lovers, look out !


STOD is Sync to OnDemand

---

On-demand (hosted) web services are great : you may be using one professionnally, or may also be a Web 2.0 service-addict for your own personal use. They have numerous advantages : hosted, usually good/excellent availability, you always have the latest version, free or low monthly subscription, no installation on your site, no maintenance on your site, no hardware on your site, etc.

However, they do have their drawbacks :
. online : you need to be online to use these services, except for those which offer a sync feature
. performance (speed) : although it is usually very good for a web site, it is low compared to local client applications running on your own Mac
. usability : although Web 2.0 has much improved (vs. HTML) user interaction possibilities with web sites, you are still stuck in a very basic user interface limited by your browser(s) capabilities and the web-page concept; this is much, much less nice than your usual applications on your Mac.

So, just imagine if you could join the great advantages of on-demand services with the perfect (no less !) usability, power, beauty of your Mac desktop : you have a STOD app (sync to on-demand).
This is a sync engine which sucks the data from your favorite on-demand service(s) onto you personal Mac, syncs them with .Mac on the way to give you access on all your different home/work/play Macs. It is delivered with CRUDL (create, read, update, delete, link) user-interface consoles tuned for the specific service you usually use online, but with the best design of a Mac user-interface. Imagine a Mac app designed like Delicious Library or iSale, but for your favorite on-demand web service !


Here is my rating for my idea vs. the MyDreamApp competition's criteria :

A) Innovation and Creativity : ***** (5/5)
This has never been done. I have been waiting for this app for 2 years, and not seen anyone mention anything like it. That is why I have started prototyping it, spending most of my time looking out for the technologies (now available) to implement it with.

B) Use of OS X and Leopard technologies : ****. (4.5/5)
Integrated with many desktop mac applictions, STOD apps will also rely on lower-level Tiger and Leopard technologies like Spotlight, CoreData, TimeMachine, etc.

C) Feasibility of Development : ****. (4.5/5)
This has already been prototyped - more in future posts

D) Mass-Market Appeal : ***** (5/5)
I hope STOD apps (for business on-demand services) will simply be the Trojan Horse we have been waiting for to introduce the Mac massively into the entreprise.


Look out for future posts detailing each feature.

---

Beyond bringing valuable on-demand services right to your Mac, the STOD concept is the door open to a stream of Mac apps working locally with seamlessly-synced business services data and turns those service platforms into an extension of the Mac and its .Mac/iDisk sync model.

Message Edited by Rup on 08-30-2006 08:00 AM

I am trying to ASF (v1.1.6) to retrieve data between the Opportunity standard object and Bag custom object, but I am having some problems. I am getting the following error message of

"Column not found for JXUTESTII__Opportunity__c!"

C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activesalesforce-1.1.6/lib/asf_adapter.rb:312:in `select_all'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activesalesforce-1.1.6/lib/asf_adapter.rb:307:in `gsub!'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activesalesforce-1.1.6/lib/asf_adapter.rb:307:in `select_all'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:427:in `find_by_sql'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:997:in `find_every'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:418:in `find'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/associations/has_many_association.rb:91:in `find'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/associations/association_collection.rb:159:in `find_target'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/associations/has_many_association.rb:123:in `load_target'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/associations/association_proxy.rb:122:in `method_missing'
C:/Ruby/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/associations/has_many_association.rb:98:in `method_missing'
#{RAILS_ROOT}/app/views/opportunities/show.rhtml:7:in `_run_rhtml_47app47views47opportunities47show46rhtml'

I have two objects:
Opportunity: Standard object
Bag: custom object which uses JXUTESTII__Opportunity__c field to look up to the opportunity.

opportunity.rb
class Opportunity < ActiveRecord::Base
has_many :bags,
:class_name => 'Bag',
:foreign_key => 'JXUTESTII__Opportunity__c'
end

bag.rb
class Bag < ActiveRecord::Base
include ActiveSalesforce::ActiveRecord::Mixin
set_table_name 'JXUTESTII__Bag__c'

belongs_to :opportunity,
:class_name => 'Opportunity',
:foreign_key => 'JXUTESTII__Opportunity__c'
end


the code that gives the error message:
<% for bag in @opportunity.bags %>
<p><%= bag.id %></p>
<% end %>


Any help will be greatly appreciated.

The activesalesforce plugin severely limits the names you are allowed to give to your custom classes. You cannot have any underscores in the API name for your custom object. So a name like "Core_Product" must be renamed to "CoreProduct", otherwise activesalesforce has a fit.

This class:


class SfCoreProduct < ActiveRecord::Base

set_table_name "Core_Product__c"
set_primary_key "id"
establish_connection "salesforce"

end


produces this error:


INVALID_TYPE: sObject type 'CoreProduct_c__c' is not supported


Setting the Salesforce object to "CoreProduct", and changing the "SfCoreProduct" class to the following code works.


class SfCoreProduct < ActiveRecord::Base

set_table_name "CoreProduct"
set_primary_key "id"
establish_connection "salesforce"

end


I have developed several S-Control's in the past using Javascript and Flex, and neither of those connectors changed the salesforce custom object names specified. I have two options:

1. Remove underscores from all of custom objects and the S-Controls that use them.
2. Hack activesalesforce to use the table name specified in "set_table_name".

Neither of these seem to appealing

First I'll say that I really appreciate Maildrop! Thanks for the OS X support.

I using Apple's Mail. Tiger-Intel. Here's my issues:
When I run the 'Add email' script it works fine for inbound mail from clients. But when I 'Add email' from my sent folder it has a problem when the message contains my signature which contains a jpg logo (an attachement displayed in message).

Here's what happens:
It identifies the contact fine. It logs the email fine. The subject is fine.
But the comment (email body) only show up as: ¿¿
(see attached pic)

Anyone else had this problem and knows the fix?

Unrelated: Here's a great website showing keyboard shortcuts within OS X
http://www.danrodney.com/mac/index.html

Thanks!
Stephen
Geoteaming
Seattle, WA

>I am getting my small firm up to speed on Salesforce, but am hoping
>for a quick tutorial on pocketsoap to allow me to fully integrate my
>Entourage with my salesforce activites. I have downloaded maildrop,
>and it seems to work fine (although I occasionally get a 'malformed
>search' message - perhaps because the contact is not in salesforce?).
>
>I am running Mac OS 10.4.9, and entourage 2004 11.3.3.
>
>Specific questions:
>
>What is the differences between outlook addition and what I will get
>with pocketsoap?
>
>I read that the information was all 2 way. How much info will move
>from Salesforce into my Entourage program? Is this all contacts,
>calendar and emails? My entourage already is very large (over 3GB) and
>occasionally freezes up.
>
>Is there a way to mark records private vs business?
>
>Will installing pocketsoap effect my ability to sync my Entourage with
>my Palm Treo?
>
>I am excited to fully integrate my activities with Salesforce, but I
>am concerned about what might happen to my Entourage when i first do
>the download and the sync. I will do a backup first, but any
>reassurances or tips would be appreciated.
>
>Thanks for your help.
>Andy

Just posted on mydreamapp.com.
Mac users, and OSX (Tiger, Leopard) lovers, look out !


STOD is Sync to OnDemand

---

On-demand (hosted) web services are great : you may be using one professionnally, or may also be a Web 2.0 service-addict for your own personal use. They have numerous advantages : hosted, usually good/excellent availability, you always have the latest version, free or low monthly subscription, no installation on your site, no maintenance on your site, no hardware on your site, etc.

However, they do have their drawbacks :
. online : you need to be online to use these services, except for those which offer a sync feature
. performance (speed) : although it is usually very good for a web site, it is low compared to local client applications running on your own Mac
. usability : although Web 2.0 has much improved (vs. HTML) user interaction possibilities with web sites, you are still stuck in a very basic user interface limited by your browser(s) capabilities and the web-page concept; this is much, much less nice than your usual applications on your Mac.

So, just imagine if you could join the great advantages of on-demand services with the perfect (no less !) usability, power, beauty of your Mac desktop : you have a STOD app (sync to on-demand).
This is a sync engine which sucks the data from your favorite on-demand service(s) onto you personal Mac, syncs them with .Mac on the way to give you access on all your different home/work/play Macs. It is delivered with CRUDL (create, read, update, delete, link) user-interface consoles tuned for the specific service you usually use online, but with the best design of a Mac user-interface. Imagine a Mac app designed like Delicious Library or iSale, but for your favorite on-demand web service !


Here is my rating for my idea vs. the MyDreamApp competition's criteria :

A) Innovation and Creativity : ***** (5/5)
This has never been done. I have been waiting for this app for 2 years, and not seen anyone mention anything like it. That is why I have started prototyping it, spending most of my time looking out for the technologies (now available) to implement it with.

B) Use of OS X and Leopard technologies : ****. (4.5/5)
Integrated with many desktop mac applictions, STOD apps will also rely on lower-level Tiger and Leopard technologies like Spotlight, CoreData, TimeMachine, etc.

C) Feasibility of Development : ****. (4.5/5)
This has already been prototyped - more in future posts

D) Mass-Market Appeal : ***** (5/5)
I hope STOD apps (for business on-demand services) will simply be the Trojan Horse we have been waiting for to introduce the Mac massively into the entreprise.


Look out for future posts detailing each feature.

---

Beyond bringing valuable on-demand services right to your Mac, the STOD concept is the door open to a stream of Mac apps working locally with seamlessly-synced business services data and turns those service platforms into an extension of the Mac and its .Mac/iDisk sync model.

Message Edited by Rup on 08-30-2006 08:00 AM

I'm trying to use ruby (soap4r) with the sforce API. I'm having no problems with SOQL queries, but I'm unable to get Retrieve working.

The wiretrace from my last attempt looked like:

= Request

POST /services/Soap/c/6.0 HTTP/1.1
SOAPAction: ""
Content-Type: text/xml; charset=utf-8
User-Agent: SOAP4R/1.5.4 (/114, ruby 1.8.2 (2004-12-25) [powerpc-darwin8.0])
Date: Wed Sep 21 11:55:27 PDT 2005
Content-Length: 877
Host: na1-api.salesforce.com


    xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  
                    xmlns="urn:partner.soap.sforce.com">
          O3kaG59yadahyadah.lRHax_wILyadahyadahzi4=
        
                    xmlns="urn:partner.soap.sforce.com">
          client
        
  
  
    
      Asset
      02i300000002tQIAAY
      Name
    
  


= Response

HTTP/1.1 500 Internal Server Error
Server: sfdc
Cache-Control: private
Content-Type: text/xml; charset=utf-8
Connection: close
Transfer-Encoding: chunked
Date: Wed, 21 Sep 2005 18:55:23 GMT

0496


 
  
   soapenv:Server
   INVALID_TYPE: sObject type '02i300000002tQIAAY' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.
   
    
     INVALID_TYPE
     sObject type '02i300000002tQIAAY' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.
     -1
     -1
    
   
  
 

This request looks correct to me. Why is sforce trying to interpret the Id as an SObject?
This Id was returned from a previous SOQL query.

What's wrong with this request?

I have a field called "Division Type" under account view. I would like to show SAME FIELD on opportunity view without duplicating data or field.

is there a way to achieve this ??

Thanks

Pat

 

 

 

So far I ahve only seen references to doing stuff in javascript by building the SOAP XML messages for the sforce API manually. I think it would be a huge boon to lite clients that can reside on Salesforce.com if someone would write an open source Javascript class, or library that talked the sforce api.

Just a suggestion:

Be nice if there was a way to link from a custom sforce web app into an area of a screen via an anchor link (for example, the Contact Roles related list section on the Opportunity screen).  I can easily link into an Opportunity, but the user must scroll to find the related section.

It seems that an contact can only have one account. why cant the contact have a one-to-many relationship with an account? Is there a way to do this?

Thank you.