Hi,

 

I know I have posted this question a few months ago but I am having trouble excepting that there is not a non-additional 3rd party tool cost to achieve the same results.

 

If I can do to the SFDC Weekly Export Service page and click a download link why wouldn't their be an ability to call an API call to iterate through the files and download them to a client machine.  Are we certain that there is no functionality available to a developer that allows us programmatic ability as oppose to logging in each week and clicking through 10 or more links to save the files to a client side drive? 

I have found a SFDC Instance where the following two calls give a different list fields for table abc_c.

DescribeSObjectResult rr[] = partnerAPI.describeSObjects( new String[] { "abc__c" });
DescribeSObjectResult rr[] = partnerAPI.describeSObjects( new String[] { "abc__c", "def__c" });

The answer is correct when a single object is described but sometimes contains phantom fields (LastViewedDate and LastReferencedDate are the two examples)  when multiple objects are described in a single call. 

Naturally I have an short application (in an eclipse project) that demonstrates the problem.  Getting a response from standard SFDC support is a different issue.  I have seen this issue once before, around a year ago, from a client in South Africa. They had premier support and after a few weeks SFDC fixed the issue. My current client does not have premier and SFDC's response is the basic "post it to the forums and maybe development will see it"

I've done a lot of java API SFDC work (3 are commercial products -- CopyStorm, CopyStorm/Restore, and SQLForce) and absolutely sure that the API is returning inconsistent field lists.

I have a short java program (using WSC) that fetches DescribeSObjectResult for all SObjects in an instance. The results returned for certain SObjects have a different # of fields returned when objects are fetched 1 at a time and 100 at a time.  The extra fields returned when fetching 100 at a time do not actually exist.  The little java program is only 100 lines. It's output shows the problem (the # of fields differs by 2 sometimes; the same phantom fields are always the same).

Initialize: describeGlobal() -- read the names of all SObjects
Phase 2A: Read SObject descriptors one at a time (this will take a while).
Phase 2B: Read SObject descriptors 100 at a time (this will take less time).
Phase 3: Look for SObject descriptors that differ.
ERROR: SCMC__Customer_Address__c has 42 fields not buffered and 44 when buffered.
     : The buffered descriptor has the following extra fields:
     : LastReferencedDate
     : LastViewedDate
ERROR: SCMC__Unit_of_Measure__c has 14 fields not buffered and 16 when buffered.
     : The buffered descriptor has the following extra fields:
     : LastReferencedDate
     : LastViewedDate
ERROR: SCMC__Warehouse__c has 24 fields not buffered and 26 when buffered.
     : The buffered descriptor has the following extra fields:
     : LastReferencedDate
     : LastViewedDate
ERROR: SCMQT__Option__c has 22 fields not buffered and 24 when buffered.
     : The buffered descriptor has the following extra fields:
     : LastReferencedDate
     : LastViewedDate

I am happy to provide the little java program to SFDC tech -- once I know who to send it to.   Note: the problem DOES not occur on every instance. The last time I saw it was around 10 months ago (and I see a lot of instances at the CTO of Capstorm).

On cs13 the source for an custom ApexPage is loaded from c.cs13.visual.force.com and wrapped in an IFRAME.  If the controller for this page returns a PageReference to a standard SFDC page the page host is set to cs13.salesforce.com. Because the custom ApexPage is in an IFRAME and the next page is in a different doman a "...cannot be displayed in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'." hijacking type error and fails to load.  Oddly enough, on our production instance the code generated for the ApexPage DOES NOT use an IFRAME.

On the cs13 sandbox, generated HTML code is:
<iframe frameBorder="0" id="contentPane" name="contentPane" onload="initContentFrame('https://c.cs13.visual.force.com/apex/Software_License_Validation?id=a085000000BovnNAAR&amp;restrictTo=02i500000096LclAAE&amp;type=auth&amp;core.apexpages.devmode.url=1', true, false , 'https://cs13.salesforce.com' );" src="/blank.html" style="width: 100%; height: 100%" title="Content Pane"></iframe>

On production, their are no IFRAMEs in the generated HTML code.

On our test Winter-15 sandbox generated page has an IFRAME where the same page on production does not. The IFRAME on the sandbox causes an x-frame-options error (because the framem is in c.cs13.visual.force.com and the page the SFDC code loads on a click a page on cs13.salesforce.com.

On production there are no IFRAMEs. On the sandbox this iframe appears:

<iframe frameBorder="0" id="contentPane" name="contentPane" onload="initContentFrame('https://c.cs13.visual.force.com/apex/Software_License_Validation?id=a085000000BovnNAAR&amp;restrictTo=02i500000096LclAAE&amp;type=auth&amp;core.apexpages.devmode.url=1', true, false , 'https://cs13.salesforce.com' );" src="/blank.html" style="width: 100%; height: 100%" title="Content Pane"></iframe>

The code in this page returns a PageReference under cs13.visualforce.com (not by design....this is the Site root the SFDC backend generates).

Help!

 

I have seen several cases where 'SELECT id FROM AccountShare ORDER BY LastModifiedDate ASC LIMIT 2000' never returns (e.g. on the developer console a time-out never happens; the query is in the Loading... stage forever.  

This seems to have happened as part of the the Sumner'14 release and does not appear to be happening on all instances.

Anyone else seen this bug in Summer'13:

 

An application using the Spring'13 protocol (27) against a Summer'13 sandbox instance will return meta data for the SObject OrganizationProperty even though this SObject is new in Summer'13. 

 

I tried to tell Salesforce about the bug via a case and got:

 

"I would like to inform you that we offer developer support to our customers and are sorry for the impact this may be having on you. We now provide developer support only to our premier customers and partners. If you have a developer support question, are looking for technical documentation, best practices, code samples and other ways to speed your development time, we have great resources that you can leverage within the developer community at http://developer.force.com/ ."

 

A funny response since I was not asking for developer support and was simply reporting a bug in the product. The text of my original case ended with "Unless you need help reproducing the problem, there is no need to respond."

 

 

 

I am having no luck using Burp as a proxy server for an API based application. 

 

+ Using a browser thru Burp I always get a  "invalid certificate. do you want to continue?" message when logging in via https://login.salesforce.com. I think I followed the instructions for installing the trusted portswigger root certificate. I am stumped. My guess is that I solve this problem my API program will just work  if I set the http.proxyHost and http.proxyPort values.

 

Anyone have a few lies of code they will share?  I need this to test & update the open source project CopyForce (https://code.google.com/p/sqlforce/wiki/CopyForce). 

 

 

Found at:  http://code.google.com/p/sqlforce/

Free.

Written because I needed it to save a lot of time. 

 

 

Command line tool that uses SOQL to manipulate a SalesForce database. Most importantly, the 200 record SOQL governing limit is managed and ANSI commands like:

• DELETE FROM Contact WHERE ...
• UPDATE Contact SET site="abc" WHERE ...
• INSERT Contact( LastName, FirstName) Values(....), (.....)
• INSERT Contact( LastName, FirstName) SELECT a,b, FROM ...
• SELECT DISTINCT ...
• SELECT ... UNION SELECT ...

are supported. Since the base tool is in Java, Python, Perl, and Ruby fans can integrate support easily.

Examples:

UPDATE Contact SET MailingCountry='USA'
WHERE MailingCountry IN ('United States', 'US', 'United States of America', 'America');

SELECT DISTINCT MailingCountry FROM Contact
UNION SELECT OtherCountry FROM Contact
UNION SELECT ShippingCountry FROM Account
UNION SELECT BillingCountry FROM Account
;

INSERT INTO Contact (FirstName, LastName) 
VALUES( 'George', 'Washington'), ('Thomas', 'Jefferson');

INSERT INTO Contact (FirstName, LastName) SELECT N1, N2 FROM CustomObject__c;

 

I have found a SFDC Instance where the following two calls give a different list fields for table abc_c.

DescribeSObjectResult rr[] = partnerAPI.describeSObjects( new String[] { "abc__c" });
DescribeSObjectResult rr[] = partnerAPI.describeSObjects( new String[] { "abc__c", "def__c" });

The answer is correct when a single object is described but sometimes contains phantom fields (LastViewedDate and LastReferencedDate are the two examples)  when multiple objects are described in a single call. 

Naturally I have an short application (in an eclipse project) that demonstrates the problem.  Getting a response from standard SFDC support is a different issue.  I have seen this issue once before, around a year ago, from a client in South Africa. They had premier support and after a few weeks SFDC fixed the issue. My current client does not have premier and SFDC's response is the basic "post it to the forums and maybe development will see it"

I've done a lot of java API SFDC work (3 are commercial products -- CopyStorm, CopyStorm/Restore, and SQLForce) and absolutely sure that the API is returning inconsistent field lists.

On our test Winter-15 sandbox generated page has an IFRAME where the same page on production does not. The IFRAME on the sandbox causes an x-frame-options error (because the framem is in c.cs13.visual.force.com and the page the SFDC code loads on a click a page on cs13.salesforce.com.

On production there are no IFRAMEs. On the sandbox this iframe appears:

<iframe frameBorder="0" id="contentPane" name="contentPane" onload="initContentFrame('https://c.cs13.visual.force.com/apex/Software_License_Validation?id=a085000000BovnNAAR&amp;restrictTo=02i500000096LclAAE&amp;type=auth&amp;core.apexpages.devmode.url=1', true, false , 'https://cs13.salesforce.com' );" src="/blank.html" style="width: 100%; height: 100%" title="Content Pane"></iframe>

The code in this page returns a PageReference under cs13.visualforce.com (not by design....this is the Site root the SFDC backend generates).

Help!

 

Hi Team,
We support an application called Mindshare. This application is built on Oracle database using Java.
Details of Saleforce contacts (or members, accounts, memberships, opportunities, participants ) are migrated to our database using a Sync process.
Similarly any changes made to the above in our database are migrated to Saleforce through the same Sync process.
This process runs once in every 15 mins runs for about 2-3 minutes.

Oflate, this process has been failing more often than it used to.

Log shows the below error. Can someone please tell me the reason for this error?

2014-08-11 06:40:53,291, ERROR, com.hackett.crm.step.FromSalesforce,
doSync, 265, An error occurred syncing from salesforce AxisFault
faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.net.SocketTimeoutException: Read timed out
faultActor:
faultNode:
faultDetail:
               {http://xml.apache.org/axis/}stackTrace:java.net.SocketTimeoutException: Read timed out
               at java.net.SocketInputStream.socketRead0(Native Method)
               at java.net.SocketInputStream.read(SocketInputStream.java:129)
               at com.sun.net.ssl.internal.ssl.InputRecord.a(DashoA12275)
               at com.sun.net.ssl.internal.ssl.InputRecord.read(DashoA12275)
               at com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
               at com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
               at com.sun.net.ssl.internal.ssl.AppInputStream.read(DashoA12275)
               at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
               at java.io.BufferedInputStream.read(BufferedInputStream.java:201)
               at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583)
               at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143)
               at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
               at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
               at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
               at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
               at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
               at org.apache.axis.client.Call.invoke(Call.java:2767)
               at org.apache.axis.client.Call.invoke(Call.java:2443)
               at org.apache.axis.client.Call.invoke(Call.java:2366)
               at org.apache.axis.client.Call.invoke(Call.java:1812)
               at com.sforce.soap.enterprise.SoapBindingStub.query(SoapBindingStub.java:4204)
               at com.hackett.crm.step.FromSalesforce.doSync(FromSalesforce.java:166)
               at com.hackett.crm.SalesforceSyncController.doSync(SalesforceSyncController.java:62)
               at
com.hackett.crm.SalesforceSyncController.main(SalesforceSyncController.java:112)

              
{http://xml.apache.org/axis/}hostname:hermes.answerthink.com

java.net.SocketTimeoutException: Read timed out
               at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
               at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:154)
               at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
               at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
               at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
               at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
               at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
               at org.apache.axis.client.Call.invoke(Call.java:2767)
               at org.apache.axis.client.Call.invoke(Call.java:2443)
               at org.apache.axis.client.Call.invoke(Call.java:2366)
               at org.apache.axis.client.Call.invoke(Call.java:1812)
               at com.sforce.soap.enterprise.SoapBindingStub.query(SoapBindingStub.java:4204)
               at com.hackett.crm.step.FromSalesforce.doSync(FromSalesforce.java:166)
               at com.hackett.crm.SalesforceSyncController.doSync(SalesforceSyncController.java:62)
               at
com.hackett.crm.SalesforceSyncController.main(SalesforceSyncController.java:112) Caused by: java.net.SocketTimeoutException: Read timed out
               at java.net.SocketInputStream.socketRead0(Native Method)
               at java.net.SocketInputStream.read(SocketInputStream.java:129)
               at com.sun.net.ssl.internal.ssl.InputRecord.a(DashoA12275)
               at com.sun.net.ssl.internal.ssl.InputRecord.read(DashoA12275)
               at com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
               at com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
               at com.sun.net.ssl.internal.ssl.AppInputStream.read(DashoA12275)
               at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
               at java.io.BufferedInputStream.read(BufferedInputStream.java:201)
               at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583)
               at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143)
               ... 13 more

Hi,

 I wrote java program to send email with salesforce report csv attachment. the salesforce report generate using activity object and have one of  field Duration in hours.
 Everything working fine. But, the attached csv file Duration field column values like "25,0000"(Comman separator) instead of "25.000"(Dot). if I export from salesforce the separator shows as .(dot) but in csv attachment the value is ,(comman).

 it is very difficult to delimit based on separator (comma) into excel file. 

 Any idea,how to fix this issue ? Thanks in advance.

how to update record in Lead using java program??

Hi,

We are trying to connect to SFDC instance thru SOAP API. Got the partner WSDL file but to convert the wsdl into Partner JAR file in windows environment ,
it needs force-wsc-30.0.0.jar. 
But when I go to download the jar from https://mvnrepository.com/artifact/com.force.api/force-wsc/  the link given but 30.0.0 version is not available.

Please help me to get the required JAR file.

Thanks

Anyone else seen this bug in Summer'13:

 

An application using the Spring'13 protocol (27) against a Summer'13 sandbox instance will return meta data for the SObject OrganizationProperty even though this SObject is new in Summer'13. 

 

I tried to tell Salesforce about the bug via a case and got:

 

"I would like to inform you that we offer developer support to our customers and are sorry for the impact this may be having on you. We now provide developer support only to our premier customers and partners. If you have a developer support question, are looking for technical documentation, best practices, code samples and other ways to speed your development time, we have great resources that you can leverage within the developer community at http://developer.force.com/ ."

 

A funny response since I was not asking for developer support and was simply reporting a bug in the product. The text of my original case ended with "Unless you need help reproducing the problem, there is no need to respond."

 

 

 

How to connect to to SQL Server database. What is the procedure

I have documents stored in SFDC and I would like to move them out.  Can I connect to FTP to move these files from SFDC..? Is so what is the URL and port to do this.  If not what are other alternatives in moving content out of SFDC?

 

Thank you!

-Cloudigy

Can I use stored procedure to get data from salesforce to my website ?

 

Actually, I need large amount of data from different different objects & for every object data I need to create connection in java to connect salesforce & it returns data and for another object data again i need to create connection that return data so is their any way so that I can send entire bunch of query at a time to salesforce that will retrieve all the data from set of query & return to my java code so i dont need to create many connection for each object ???

Hi,

Does anyone currently backup their SF database using DBamp or any similiar tool that is storing the backups through SQL Server?  I was thinking to get away from the manual download of backup zipfiles each week I could automate backups to a SQL Server database.nightly. In addition, perform a weekly complete backup to a separate backup database named with the date appended.  This give weekly snapshots just like the zipfiles.

 

I was hoping to get some feedback on computer purchases/architecture setup.  Keeping in mind that IT will not be involved.  In addition, do you know of any concerns that I should have

1. Purchase top end computer or stanard server (which is best)?

2. Purchase a backup drive for nightly incremental backups of the hard drive

3. Battery backup unit

4.  Install SQL Server Purchased version

5. Install DBamp

6. Right some SQL backup and restore stuff

7. Schedule the backups

 

Or would you recommend IT involvement?  IT currently does not support our SF ORG.

By know means am I a DBA but I have already set this all up on my own machine and it works with the exception of the actual scheduling.  Not being a DBA is what scares me because if I don't know much about the details of maintenance behind SQL Server and my primary job is being a developer then Admin.  I am just getting tired of manually downloading back up files every week.

 

Your feedback is appreciated as to help prevent any pit falls.

 

 Hi...

 

I am playing with a test Salesforce database and trying to figure out how to download its contents (i.e., do a full database "dump") into my machines memory, in SObject objects (returned from QueryResult.getRecords()).

 

I am using the Partner API and so far only access the standard Salesforce objects. As far as I can tell, there are 3 categories of those:

 

 

• Fully queryable (most of them, e.g. Account, Opportunity, Contract, User etc.).
• Partially queryable, i.e. queryable but restricted by implementation (Vote, UserProfileFeed)
• Non-queryable (FeedPost, AggregateResult, Name, NoteAndAttachment, ActivityHistory, FeedComment, OpenActivity, EmailStatus, ProcessInstanceHistory)

 

If, in a database with information only stored in standard objects, I download, with appropriate queries, all fully queryable objects, plus somehow (join-like) the remaining few ones (partially- and non-queryable), would that be a the equivalent of the "full dump" of the database, or would I be leaving data behind?

 

Also, how exactly should I go about downloading the partially- and non-queryable objects?

 

Thanks!

 

Hi,

 

Can any one help me.

 

How can we Integrate Salesforce with Java?

 

I don't know even a single step to do this. But i require to implement this in my project.

 

Please help me.

 

Thanks in Advance.....

 

 

Hi,

 

I know I have posted this question a few months ago but I am having trouble excepting that there is not a non-additional 3rd party tool cost to achieve the same results.

 

If I can do to the SFDC Weekly Export Service page and click a download link why wouldn't their be an ability to call an API call to iterate through the files and download them to a client machine.  Are we certain that there is no functionality available to a developer that allows us programmatic ability as oppose to logging in each week and clicking through 10 or more links to save the files to a client side drive? 

Hi guys i can't seem to get the hours and minutes to show in a datetime field in SFDC coming from an update from a java client app

 

        SimpleDateFormat timeStamp = new SimpleDateFormat("yyyy-MM-dd\'T\'HH:mm:ss");
        try {
            runRequest.setValue("Requested_Date__c", timeStamp.parse(timeStamp.format(new Date())));
        } catch (ParseException e) {
            System.out.println("Requested_Date__c Error : " + e.getCause());
        }

 

it updates the date time field but it never shows the hhmmss??

hi

 

I want to automate the process of uploading large amount of attachments ( say 1000 attachmnets). 

Want a script which can automatically create a csv / xml  containg  attchment name , path , and parent id of abject.

 

If anybody has worked on similar requirement, please let me know.

 

 

Thanks in advance

riti joshi

 

Hi,

 

I have a web application which is developed in apache tomcat 5.5, java, jsp, servelet.  Now i want to access data from force.com to my application. How I can access data and display into my application.  

 

If any document then please give a link and examples also.

 

Thanks

Sujeet Kumar

Hi,

    I am having trouble in upgrading to Axis2 since I wasn't the one who implemented our application using Axis version.

 

--> I see that every tutorial provided by sforce still uses "SoapBindingStub".Most of those methods are now removed.

 

--> Please provide me any basic material which contains Axis2 stuff. Atleast 2,3 operations like login, query, etc.

 

For ex:

 

How to login?  [this answer boosts me for time being and solves atleast 1/3rd part of the whole problem]

 

BTW, I am using partner.wsdl

 

Please help!!

Hey guys,

 

Just trying to figure out some problems with the data i have in a SQL server database this end and i found that i'm missing about 200 records.

 

Can i do this in SOQL against the API :

 

select field1, field2, fieldx

from Contact

where id in (id1, id2, id3, id4 idx)

 

I tried and the server threw a 500 internal server error at me.

I'm guessing that this is the wrong syntax for soql but what is the equivilent to this sql? 

 

Thanks in advance :)