• Arman
  • NEWBIE
  • 0 Points
  • Member since 2006

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 12
    Questions
  • 10
    Replies
I'm trying to migrate some data from an existing db to Salesforce. I do this by creating Custom-Objects first. Within the existing tables there are document fields, but salesforce doesn't allow creating document fields (BLOB). Am I supposed to use the Documents object? or there is some other way of building a custom-object for documents and build relationships.

Any help is appreciated.
Does anyone know how the relaltionship between Cases and Solutions is implemented in salesforce?

Thanks in advance.
I tried to ask support, and they just said they don't support s-controls.

I created a new S-control that is just html. I'm using the xmlhttp object to fetch an rss feed. It works great if I create it as a link, but I want it as a section. My html is all nice and pretty, and trims the result set down to a maximum of 5 items, and its even formatted to match the HTML layout.

How do I create this as a component and add it to the accounts page layout? I basically want to do the same thing you can do to the home page.

Please help, I spent forever making this html / javascript and now can't do anything with it. Very frustrating.

Message Edited by caseyp on 09-26-2006 05:31 PM

I've been scratching my head for two days over this problem. One of our people here tends to access salesforce through http://emea.salesforce.com URL. Logging in through this URL results in IE7 rc1 and Firefox 1.5.0.7 crash when ever I want to load any of my S-Controls. IE returns "permission denied" and "Uncaught exception: Permission denied to call method XMLHttpRequest.open" for firefox.

Has anyone else had this problem?
I get this error when I call the sforceclient.create function with my array of records: "The system cannot locate the resource specified".

From what I read on the web, it has to do with incorrect path to the xml file. Has anyone else had this issue? BTW I'm testing my scontrol on the local machine and not on the salesforce yet, would this have anything to do with the problem?
All,
I've tried everything but Dynabean.save doesn't return anything.  I've tried sforceClient.create and it returns zip too.

I know that "set" and "create" calls are being made because the API complains if there is an invalid field on "sets" and the callback fires when I use "create" (I've tried both .save() and create() but neither works or returns anything in the saveResult.)

Here are the relevant code snippets.  Any help appreciated.

<script language="javascript" src="https://www.salesforce.com/services/lib/ajax/beta3.3/sforceclient.js?browser=true"
            type="text/javascript"></script>
...

sforceClient.init("{!API_Session_ID}", "{!API_Partner_Server_URL_70}");
sforceClient.registerInitCallback(getOpportunity);

...

var renewalOppty = new Sforce.Dynabean("opportunity");
    try
    {
        renewalOppty.set("Name", document.OpptyForm.OpptyName.value);
        //renewalOppty.set("Description", document.OpptyForm.OpptyDesc.value);
        renewalOppty.set("Description", "My Description");
       renewalOppty.set("Type",document.OpptyForm.OpptyType.value);
       renewalOppty.set("Amount", m_amount);
       renewalOppty.set("LeadSource", m_leadSource);
       renewalOppty.set("OwnerId", m_ownerId);
       
       var oCloseDate = new Date("12/31/2006");
       renewalOppty.set("CloseDate", oCloseDate);
       renewalOppty.set("StageName", m_stageName);
       renewalOppty.set("ForecastCategory", "Pipeline");
       renewalOppty.set("CurrencyIsoCode", "USD - U.S. Dollar");
       //renewalOppty.set("Country", "US");
       
       //var opptyArray = new Array();
       //opptyArray[0] = renewalOppty;
       saveResult = renewalOppty.save();
       alert(typeof saveResult);
        //sResult = sforceClient.create(opptyArray,dummy);
Could someone please explain to me why I can't stop this message in Firefox: uncaught exception: Permission denied to call method XMLHttpRequest.open

I've tried the solution that everyone here suggests (sforceclient.apptype = sforce.application.type.firefox) and thats not helping either.

This is my code:

function scontrolmain(IsStatic)
{
   try
   {
       sforcecleint=GetSForceClient();
   }
   catch(ExceptObject)
   {
       sforcecleint=null;
   }
   if(sforcecleint != null)
   {
       if(window.XMLHttpRequest)
       {
           sforcecleint.appType=GetSForceFFApplicationType();
       }
       loginresult=sforcecleint.login("xxx@xxx.com","xxx",null);
       showmessage(loginresult.toString());
       showmessage(sforcecleint.query("Select Id, LastName, FirstName From Contact",null).toString(null));
   }
   else
   {
       window.setTimeout(scontrolmain,100,"javascript");
   }
}


Message Edited by Arman on 08-27-2006 06:54 PM

Message Edited by Arman on 08-27-2006 06:54 PM

1. I was displaying Case data via the API and wanted to show the Solutions associated with a particular case.  I couldn't see anything about the Solution in the Case object or vice-versa.  I notice from the standard GUI that this appears to be a many-to-many relationship.  Thus, we need access to the MTM table to show these.  Any ideas/comments?

2. I remember before seeing something about putting your knowledgebase (your solutions) online in a searchable format for your customers.  What would you recommend as the best way of doing this?  Is there a way to do this via the API?  Is there a traditional (i.e. non-API) method for doing this?

THANKS!!