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 | |||
var sagebatch=SageCRMBatch(); | |||
var | var address_id = di.getid('address','01010104'); | ||
var | var sageRecord_address = SageCRMRecord('Address'); | ||
sageRecord_address.Set("addr_addressname","xyz5"); | |||
sageRecord_address.Set(" | sageRecord_address.Set("addr_address1","test address 5"); | ||
sageRecord_address.Set(" | sageRecord_address.Set("Addr_Country","US"); | ||
sageRecord_address. | sageRecord_address.id = address_id; | ||
sageRecord_address. | sageRecord_address.mode="Update"; | ||
sageRecord_address | sagebatch.add(sageRecord_address); | ||
var comp_id = di.getid('company','Perfect Company'); | |||
var | var sageRecord_company = SageCRMRecord('Company'); | ||
sageRecord_company.Set("Comp_Website","https://testcompany5.com"); | |||
sageRecord_company.Set(" | sageRecord_company.Set("Comp_PrimaryAddressId",address_id); | ||
sageRecord_company. | sageRecord_company.id = comp_id; | ||
sageRecord_company. | sageRecord_company.mode="Update"; | ||
sageRecord_company | sagebatch.add(sageRecord_company); | ||
sagebatch. | 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();