Hi

 

I need a solution to export attachments from SFDC which are mainly in pdf format. There is a about 7 gigs worth and we are wanting to store these on the local network. Does any one have any ideas on how to export this data? Then where to import? SQL server? Then will need to copy to network drive.

 

Cheers

Hi

 

I'm using the scripting toolkit and I'm finding that it only exports 2000 records. How do I increase it so that it exports the whole table? And is it a good idea to export 900K records with it?

 

Cheers

 

function Results(queryResult) {
 if (queryResult.size > 0) {
  var output = "";
  var records = queryResult.getArray("records");
  for (var i=0;i<records.length;i++) {
   var account = records[i];
   output += account.Id + "," + account.Name + "\r\n";
  }
  WScript.echo(output);
 }else WScript.echo("No records matched.");
 ToolKit.Quit();
}
var callback = {onSuccess : Results, onFailure : function(e){WScript.echo(e)}};
var queryResult = sforce.connection.query("Select Id,Name from Account", callback);

my issue is how do you map to fields that are read only. It doesn't work, well at least not for me. I have created an S-Control which is invoked by a hyper link which is on the Accounts Profile custom object page. In Turn when this is clicked it should create a new task and pre populate some of the fields.

Solutions that I have tried.

1) Mapping with original record type

1) Mapping with another record type and with a new page layout that it switchs to it when the user clicks onto the link. Obviously making the original page layout and FLS as "edit all" and the new record type to be restrictive.

Here is the code for the mapping with original record type

 

<script language="JavaScript">

var myDate=new Date();
var month = myDate.getMonth() +1;
var day = myDate.getDate();
var year = myDate.getFullYear();

function redirect() {
parent.frames.location.replace("/500/e?retURL=%2F{!Account.Id}&cas6=Client Set-Up&cas11=Client Set-Up&cas14=Client Set-Up&00N00000006qSf2={!Account_Profile__c.Company_Listed_on_Stock_Exchange__c}&cas3={!Account_Profile__c.Contact_Name__c}&00N00000006oqSt="+day + "/" + month+ "/" + year)
}
redirect();

</script>

Also, if I try to add another mapping after the last line of code "+ year)" It freaks out.

Hi

 

I'm using the scripting toolkit and I'm finding that it only exports 2000 records. How do I increase it so that it exports the whole table? And is it a good idea to export 900K records with it?

 

Cheers

 

function Results(queryResult) {
 if (queryResult.size > 0) {
  var output = "";
  var records = queryResult.getArray("records");
  for (var i=0;i<records.length;i++) {
   var account = records[i];
   output += account.Id + "," + account.Name + "\r\n";
  }
  WScript.echo(output);
 }else WScript.echo("No records matched.");
 ToolKit.Quit();
}
var callback = {onSuccess : Results, onFailure : function(e){WScript.echo(e)}};
var queryResult = sforce.connection.query("Select Id,Name from Account", callback);

my issue is how do you map to fields that are read only. It doesn't work, well at least not for me. I have created an S-Control which is invoked by a hyper link which is on the Accounts Profile custom object page. In Turn when this is clicked it should create a new task and pre populate some of the fields.

Solutions that I have tried.

1) Mapping with original record type

1) Mapping with another record type and with a new page layout that it switchs to it when the user clicks onto the link. Obviously making the original page layout and FLS as "edit all" and the new record type to be restrictive.

Here is the code for the mapping with original record type

 

<script language="JavaScript">

var myDate=new Date();
var month = myDate.getMonth() +1;
var day = myDate.getDate();
var year = myDate.getFullYear();

function redirect() {
parent.frames.location.replace("/500/e?retURL=%2F{!Account.Id}&cas6=Client Set-Up&cas11=Client Set-Up&cas14=Client Set-Up&00N00000006qSf2={!Account_Profile__c.Company_Listed_on_Stock_Exchange__c}&cas3={!Account_Profile__c.Contact_Name__c}&00N00000006oqSt="+day + "/" + month+ "/" + year)
}
redirect();

</script>

Also, if I try to add another mapping after the last line of code "+ year)" It freaks out.