Import into Creatio - Revision history

CreatioWikiSysop at 11:30, 2 March 2026

2026-03-02T11:30:25Z

← Older revision		Revision as of 07:30, 2 March 2026
Line 1:		Line 1:
	Using JINT mode you can insert data. The example below creates ~~and~~ Account and Contact record. Then it updates the Account making the Contact the Primary contact for the Account.		Using JINT mode you can insert data. The example below creates an Account and Contact record. Then it updates the Account making the Contact the Primary contact for the Account.

CreatioWikiSysop at 18:33, 22 February 2026

2026-02-22T18:33:32Z

← Older revision		Revision as of 14:33, 22 February 2026
Line 86:		Line 86:

	di.display(newId);		di.display(newId);

			[[File:Jint creatio demo.png]]

CreatioWikiSysop at 13:54, 3 October 2025

2025-10-03T13:54:10Z

← Older revision		Revision as of 09:54, 3 October 2025
Line 67:		Line 67:

	}		}

			----
			SetNumeric example

			So whenever we wants to set value as Numeric/Float then we we need to use creatioRecord.SetNumeric('Price',12.40);

			EG

			var creatioRecord = CreatioRecord('Product');

			creatioRecord.Set('Name', 'TestProductName7');

			creatioRecord.Set('Code', 'Test007');

			creatioRecord.SetNumeric('Price', 15.30);

			var newId=creatioRecord.Insert();

			di.display(newId);

CreatioWikiSysop at 12:32, 5 June 2025

2025-06-05T12:32:33Z

← Older revision		Revision as of 08:32, 5 June 2025
Line 1:		Line 1:
	~~Here we cover iIf~~ you ~~wanted to import~~ data ~~from say a SQL database into Creatio~~.		Using JINT mode you can insert data. The example below creates and Account and Contact record. Then it updates the Account making the Contact the Primary contact for the Account.

	~~In our example we will~~ use ~~a Sage 300 database~~. ~~Our aim~~ is ~~to import AR_Customer records into Creation Accounts and Contacts~~.
			You can see use of the method "getguid" which allows you to map Creatio Lookup record Guids.
			----


			'''SAMPLE SCRIPT'''

			var account_name = "Acme Consulting";

			var account_category = "B";

			var account_industry = "Advertising";

			//get any guid values

			var account_categoryGUID = di.'''getguid'''("AccountCategory",account_category);

			var account_industryGUID = di.'''getguid'''("AccountIndustry",account_industry);

			var creatioRecord = '''CreatioRecord'''('Account');

			'''creatioRecord'''.Set("AccountCategoryId", account_categoryGUID);

			'''creatioRecord'''.Set("IndustryId", account_industryGUID);

			var accountFilter="Name eq '"+account_name+"'";

			var cRecord=di.'''querydb'''("Account",accountFilter,"Id");

			var accountId=null;

			if (cRecord && cRecord.Rows.Count==1)

			{

			//only do if count is one

			var updated='''creatioRecord'''.'''Update'''(cRecord.Rows[0]['Id']);

			}else if (cRecord && cRecord.Rows.Count==0){

			'''creatioRecord'''.Set("Name", account_name);

			var newId='''creatioRecord'''.'''Insert'''();

			var creatioRecord_contact = '''CreatioRecord'''('Contact');

			'''creatioRecord_contact'''.Set("AccountId",newId);

			'''creatioRecord_contact'''.Set("Name","Michael Scalea");

			'''creatioRecord_contact'''.Set("JobTitle","Owner");

			var newContactId='''creatioRecord_contact'''.'''Insert'''();

			var '''creatioRecord_ac''' = '''CreatioRecord'''('Account');

			'''creatioRecord_ac'''.Set("PrimaryContactId",newContactId);

			'''creatioRecord_ac'''.'''update'''(newId);

			}else{

			di.display("**Duplicate Account Found**:"+account_name);

			}

CreatioWikiSysop: Created page with "Here we cover iIf you wanted to import data from say a SQL database into Creatio. In our example we will use a Sage 300 database. Our aim is to import AR_Customer records into Creation Accounts and Contacts."

2025-04-10T08:47:40Z

Created page with "Here we cover iIf you wanted to import data from say a SQL database into Creatio. In our example we will use a Sage 300 database. Our aim is to import AR_Customer records into Creation Accounts and Contacts."

New page

Here we cover iIf you wanted to import data from say a SQL database into Creatio.

In our example we will use a Sage 300 database. Our aim is to import AR_Customer records into Creation Accounts and Contacts.