New pages
From Accelerator for SageCRM
- 11:41, 2 March 2026 Import into Sage CRM (hist | edit) [1,308 bytes] Sagecrmw (talk | contribs) (Created page with "Using JINT mode you can insert data. The example below creates a Company and Person record. Then it updates the Company making the Contact the Primary contact for the Company. You can see use of the method "getID" which allows you to map SageCRM Lookup record Codes. ---- '''SAMPLE SCRIPT''' var account_name = "Acme Consulting"; var _source = "Import"; var _status = "Active"; //get any lookup code values (useful if mapping from another system w...")
- 11:27, 2 March 2026 Batching Updates (hist | edit) [932 bytes] Sagecrmw (talk | contribs) (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";...")
- 11:26, 2 March 2026 DI Jint (hist | edit) [803 bytes] Sagecrmw (talk | contribs) (Created page with "There are specific commands in the Javascript Engine (JINT) relating to SageCRM Only. getID - This is used where you have the "Name" value and need the ID. You would use this for an integration where Id's would not map but you could map the Names. Only one result is returned so this depends on the Name value being unique. Otherwise use querydb. - Parameters (a) COLLECTION (b) FILTER - returns ID value EG >var _compId = di.getID('Company', 'Union Computer'); 2...")
- 22:49, 14 February 2026 Query Sage CRM Data (hist | edit) [1,925 bytes] Sagecrmw (talk | contribs) (Created page with "Example walk through A. Add SageCRM as a server For SageCRM: eg.addserver sagecrm <ALIAS> "<URL>" "<USERNAME>" "<PASSWORD>" Syntax: >addserver sagecrm <ALIAS> "<URL>" "<USERNAME>" "<PASSWORD>" EG >addserver sagecrm "crm" "https://crm.yourserver.com" "Supervisor" "********" This sets up Sage CRM as a connection in the App B. List the tables(collections) in the system >dbtables C. See the columns in a table (collection) >describe Company Filte...")
- 22:47, 14 February 2026 DI Overview (hist | edit) [406 bytes] Sagecrmw (talk | contribs) (Created page with "Data Islands and Sage CRM allows you to quickly and easily build robust custom Integrations. You can: * Export Sage CRM data for use in a datawarehouse/mart and feed other systems from Sage CRM * Import data into Sage CRM from ERP or any data located anywhere. ---- There are 2 modes you can use for Data Islands. 1. Command line 2. JINT (Javascript) For more complex data flows you would use JINT.")
