Batching Updates: Difference between revisions

From Accelerator for SageCRM
(Created page with "Using JINT mode we can use scripting to batch updates. This speeds up any inserts/updates SAMPLE SCRIPT jint di var sagebatch=SageCRMBatch(); var address_id = di.getid('address','01010104'); var sageRecord_address = SageCRMRecord('Address'); sageRecord_address.Set("addr_addressname","xyz5"); sageRecord_address.Set("addr_address1","test address 5"); sageRecord_address.Set("Addr_Country","US"); sageRecord_address.id = address_id; sageRecord_address.mode="Update";...")
 
No edit summary
 
Line 2: Line 2:


SAMPLE SCRIPT
SAMPLE SCRIPT
<nowiki>
jint di


jint di
var sagebatch=SageCRMBatch();


var sagebatch=SageCRMBatch();
var address_id = di.getid('address','01010104');


var address_id = di.getid('address','01010104');
var sageRecord_address = SageCRMRecord('Address');


var sageRecord_address = SageCRMRecord('Address');
sageRecord_address.Set("addr_addressname","xyz5");


sageRecord_address.Set("addr_addressname","xyz5");
sageRecord_address.Set("addr_address1","test address 5");


sageRecord_address.Set("addr_address1","test address 5");
sageRecord_address.Set("Addr_Country","US");


sageRecord_address.Set("Addr_Country","US");
sageRecord_address.id = address_id;


sageRecord_address.id = address_id;
sageRecord_address.mode="Update";


sageRecord_address.mode="Update";
sagebatch.add(sageRecord_address);


sagebatch.add(sageRecord_address);
var comp_id = di.getid('company','Perfect Company');


var comp_id = di.getid('company','Perfect Company');
var sageRecord_company = SageCRMRecord('Company');


var sageRecord_company = SageCRMRecord('Company');
sageRecord_company.Set("Comp_Website","https://testcompany5.com");


sageRecord_company.Set("Comp_Website","https://testcompany5.com");
sageRecord_company.Set("Comp_PrimaryAddressId",address_id);


sageRecord_company.Set("Comp_PrimaryAddressId",address_id);
sageRecord_company.id = comp_id;


sageRecord_company.id = comp_id;
sageRecord_company.mode="Update";


sageRecord_company.mode="Update";
sagebatch.add(sageRecord_company);


sagebatch.add(sageRecord_company);
var sagebatchResult=sagebatch.process();


var sagebatchResult=sagebatch.process();
</nowiki>

Latest revision as of 11:28, 2 March 2026

Using JINT mode we can use scripting to batch updates. This speeds up any inserts/updates

SAMPLE SCRIPT

	jint di

	var sagebatch=SageCRMBatch();

	var address_id = di.getid('address','01010104');

	var sageRecord_address = SageCRMRecord('Address');

	sageRecord_address.Set("addr_addressname","xyz5");

	sageRecord_address.Set("addr_address1","test address 5");

	sageRecord_address.Set("Addr_Country","US");

	sageRecord_address.id = address_id;

	sageRecord_address.mode="Update";

	sagebatch.add(sageRecord_address);

	var comp_id = di.getid('company','Perfect Company');

	var sageRecord_company = SageCRMRecord('Company');

	sageRecord_company.Set("Comp_Website","https://testcompany5.com");

	sageRecord_company.Set("Comp_PrimaryAddressId",address_id);

	sageRecord_company.id = comp_id;

	sageRecord_company.mode="Update";

	sagebatch.add(sageRecord_company);

	var sagebatchResult=sagebatch.process();