ImportManager class - Revision history

Nguyenduyan at 05:28, 14 April 2025

2025-04-14T05:28:07Z

← Older revision		Revision as of 05:28, 14 April 2025
Line 74:		Line 74:
	//EX for import new user info and phone number		//EX for import new user info and phone number
	array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode"};		array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode"};
	array Data={{"An","~~test~~","an@~~maysunshine~~.vn","da-DK","da-DK","12345678","dk"}};		array Data={{"TestFirstName","TestLastName","so@testmail.com","da-DK","da-DK","12345678","dk"}};
	Bool advancedMode=false;		Bool advancedMode=false;
	number groupResourceId =15548117;		number groupResourceId =15548117;
Line 96:		Line 96:
	//EX for importing new user and new qas		//EX for importing new user and new qas
	array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode","Q2","Q4","Q5","TextValue","NumberValue"};		array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode","Q2","Q4","Q5","TextValue","NumberValue"};
	array Data={{"An","~~test2111_01~~","an@~~maysunshine~~.vn","da-DK","da-DK","12345678","dk",1,"q4",1,"Text1",1}};		array Data={{"TestFirstName","TestLastName","so@testmail.com","da-DK","da-DK","12345678","dk",1,"q4",1,"Text1",1}};
	Bool advancedMode=false;		Bool advancedMode=false;
	number groupResourceId =15548117;		number groupResourceId =15548117;
Line 122:		Line 122:
	//Using SetDefaultNewUser		//Using SetDefaultNewUser
	array Headers={"First name","Last name","User_Email"};		array Headers={"First name","Last name","User_Email"};
	array Data={{"An","~~test2211~~","an@~~maysunshine~~.vn"}};		array Data={{"TestFirstName","TestLastName","so@testmail.com"}};
	Bool advancedMode=false;		Bool advancedMode=false;
	number groupResourceId =15548117;		number groupResourceId =15548117;

Administrator at 04:47, 2 July 2020

2020-07-02T04:47:13Z

Nguyenduyan at 02:50, 27 June 2018

2018-06-27T02:50:13Z

← Older revision		Revision as of 02:50, 27 June 2018
Line 28:		Line 28:
	\|Description=<nowiki>Validate prior to actual importing. Throws if errors, otherwise returns warning.</nowiki>}}		\|Description=<nowiki>Validate prior to actual importing. Throws if errors, otherwise returns warning.</nowiki>}}
	\|Properties=		\|Properties=
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>~~DefaultCulture~~</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the culture used during import in case we don't want to use the logged-in-user's one (UseLoggedInUsersCultureDuringImport = false)</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>Culture</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the culture used during import in case we don't want to use the logged-in-user's one (UseLoggedInUsersCultureDuringImport = false)</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>Language</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the language used when importing text</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>Language</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the language used when importing text</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}
Line 34:		Line 34:
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>UseLoggedInUsersCultureDuringImport</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if the culture used during import is the same as the logged in user or invariant culture. Default is invariant</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>UseLoggedInUsersCultureDuringImport</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if the culture used during import is the same as the logged in user or invariant culture. Default is invariant</nowiki>}}
	}}		}}

Nguyenduyan at 04:16, 19 June 2018

2018-06-19T04:16:31Z

← Older revision		Revision as of 04:16, 19 June 2018
Line 186:		Line 186:

	<source lang="javascript">		<source lang="javascript">
	//Set culture while import. If not set will use "." format, example: "45.967". Set Culture ~~only~~ work with UseLoggedInUsersCultureDuringImport=false		//Set culture while import. If not set will use "." format, example: "45.967"
			//Set Culture work combine with UseLoggedInUsersCultureDuringImport=false
	array Headers={"qNumber"};		array Headers={"qNumber"};
	array Data={{"45,967"}};		array Data={{"45,967"}};

Nguyenduyan at 04:14, 19 June 2018

2018-06-19T04:14:03Z

← Older revision		Revision as of 04:14, 19 June 2018
Line 188:		Line 188:
	//Set culture while import. If not set will use "." format, example: "45.967". Set Culture only work with UseLoggedInUsersCultureDuringImport=false		//Set culture while import. If not set will use "." format, example: "45.967". Set Culture only work with UseLoggedInUsersCultureDuringImport=false
	array Headers={"qNumber"};		array Headers={"qNumber"};
	array Data={{"2,12"}};		array Data={{"45,967"}};
	Bool advancedMode=false;		Bool advancedMode=false;
	number groupResourceId =0;		number groupResourceId =0;

Nguyenduyan at 04:12, 19 June 2018

2018-06-19T04:12:46Z

@@ Line 181: / Line 181: @@
 Dictionary mapping = new Dictionary();
 iM.SetDataImportOptions(qnaireRId,type,idColumnName,isCommaSeparatedFormat,mapping);
 iM.Validate();
 iM.Import();
 </source>

Nguyenduyan at 02:17, 19 June 2018

2018-06-19T02:17:54Z

Nguyenduyan at 10:14, 10 April 2018

2018-04-10T10:14:57Z

← Older revision		Revision as of 10:14, 10 April 2018
Line 166:		Line 166:
	<br /><source lang="javascript">		<br /><source lang="javascript">
	//update an existing qas by CustomerId (using SetDataImportOptions with type 4)		//update an existing qas by CustomerId (using SetDataImportOptions with type 4)
			//CustomerID must be a text field, not numeric
	array Headers={"CustomerID","Q1","Age"};		array Headers={"CustomerID","Q1","Age"};
	array Data={{"AB123",2,1}};		array Data={{"AB123",2,1}};

Nguyenduyan at 07:10, 31 May 2017

2017-05-31T07:10:52Z

← Older revision		Revision as of 07:10, 31 May 2017
Line 53:		Line 53:
	</source>		</source>

	<br/><source lang="javascript">		<br /><source lang="javascript">
	//EX for import data to an existing answer sheet		//EX for import data to an existing answer sheet
	array Headers={"RPQId","Q2","Q4","Q5","TextValue","NumberValue"};		array Headers={"RPQId","Q2","Q4","Q5","TextValue","NumberValue"};
Line 70:		Line 70:
	</source>		</source>

	<br/><source lang="javascript">		<br /><source lang="javascript">
	//EX for import new user info and phone number		//EX for import new user info and phone number
	array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode"};		array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode"};
Line 92:		Line 92:
	</source>		</source>

	<br/><source lang="javascript">		<br /><source lang="javascript">
	//EX for importing new user and new qas		//EX for importing new user and new qas
	array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode","Q2","Q4","Q5","TextValue","NumberValue"};		array Headers={"First name","Last name","User_Email","Language","Culture","PhoneType_NotIdentified","User_CountryCode","Q2","Q4","Q5","TextValue","NumberValue"};
Line 118:		Line 118:
	iM.Validate();		iM.Validate();
	iM.Import();		iM.Import();
	</source><br/><source lang="javascript">		</source><br /><source lang="javascript">
	//Using SetDefaultNewUser		//Using SetDefaultNewUser
	array Headers={"First name","Last name","User_Email"};		array Headers={"First name","Last name","User_Email"};
Line 143:		Line 143:
	iM.Import();		iM.Import();

	</source><br/><source lang="javascript">		</source><br /><source lang="javascript">
	//Update an existing user		//Update an existing user
	array Headers={"userId","Language","Culture","Currency"};		array Headers={"userId","Language","Culture","Currency"};
Line 164:		Line 164:
	iM.Import();		iM.Import();
	</source>		</source>
	<br/><source lang="javascript">		<br /><source lang="javascript">
			//update an existing qas by CustomerId (using SetDataImportOptions with type 4)
	array Headers={"CustomerID","Q1","Age"};		array Headers={"CustomerID","Q1","Age"};
	array Data={{"AB123",2,1}};		array Data={{"AB123",2,1}};

Nguyenduyan at 07:07, 31 May 2017

2017-05-31T07:07:32Z

@@ Line 161: / Line 161: @@
 Dictionary mapping = new Dictionary();
 iM.SetUserImportOptions(userIdColumnName,userNameMask,generatePasswords,importUserInfo,importPhoneNumber,importAddress,importPoints,importQualification,parentResourceId,mapping);
 iM.Validate();
 iM.Import();
 </source>

← Older revision		Revision as of 04:47, 2 July 2020
Line 2:		Line 2:
	\|Name=<nowiki>ImportManager</nowiki>		\|Name=<nowiki>ImportManager</nowiki>
	\|Description=<nowiki>Import data and users.</nowiki>		\|Description=<nowiki>Import data and users.</nowiki>
	\|Constructors=		\|InheritsFrom=object\|Constructors=
	{{CGscriptConstructors_Template\|Parameters=		{{CGscriptConstructors_Template\|Parameters=
	{{CGscriptParameters_Template\|Type=array\|Name=<nowiki>Headers</nowiki>\|Description=<nowiki>A list of string that are the header names</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=array\|Name=<nowiki>data</nowiki>\|Description=<nowiki>Data to import. An array of arrays of equal length as the headers</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>advancedMode</nowiki>\|Description=<nowiki>Enable setting advanced settings - Requires special navigation access</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>groupResourceId</nowiki>\|Description=<nowiki>Group to add users to new users to and/or sample rule. Set to 0 to not add to group</nowiki>}}		{{CGscriptParameters_Template\|Type=array\|Name=<nowiki>Headers</nowiki>\|Description=<nowiki>A list of string that are the header names</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=array\|Name=<nowiki>data</nowiki>\|Description=<nowiki>Data to import. An array of arrays of equal length as the headers</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>advancedMode</nowiki>\|Description=<nowiki>Enable setting advanced settings - Requires special navigation access</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>groupResourceId</nowiki>\|Description=<nowiki>Group to add users to new users to and/or sample rule. Set to 0 to not add to group</nowiki>}}
Line 17:		Line 17:
	\|Description=<nowiki>Defaults for new users. If empty or not set, uses the global defaults</nowiki>}}		\|Description=<nowiki>Defaults for new users. If empty or not set, uses the global defaults</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>SetUserImportOptions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>SetUserImportOptions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userIdColumnName</nowiki>\|Description=<nowiki>The header name of the userId column</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userNameMask</nowiki>\|Description=<nowiki>The mask used to create new usernames - an advanced setting</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>generatePasswords</nowiki>\|Description=<nowiki>Generate passwords during import</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importUserInfo</nowiki>\|Description=<nowiki>Import or Update users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPhoneNumber</nowiki>\|Description=<nowiki>Import or Update phonenumbers</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importAddress</nowiki>\|Description=<nowiki>Import or Update addresses</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPoints</nowiki>\|Description=<nowiki>Import or Update points</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importQualification</nowiki>\|Description=<nowiki>Import or Update qualifications</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=array\|Name=<nowiki>permissions</nowiki>\|Description=<nowiki>Determine which groups should have access to the new users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=Dictionary\|Name=<nowiki>mapping</nowiki>\|Description=<nowiki>Mapping between header names and import names. If empty, automapping is used</nowiki>}}		{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userIdColumnName</nowiki>\|Description=<nowiki>The header name of the userId column</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userNameMask</nowiki>\|Description=<nowiki>The mask used to create new usernames - an advanced setting</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>generatePasswords</nowiki>\|Description=<nowiki>OBSOLETE. Always false. Generate passwords during import</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importUserInfo</nowiki>\|Description=<nowiki>Import or Update users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPhoneNumber</nowiki>\|Description=<nowiki>Import or Update phonenumbers</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importAddress</nowiki>\|Description=<nowiki>Import or Update addresses</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPoints</nowiki>\|Description=<nowiki>Import or Update points</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importQualification</nowiki>\|Description=<nowiki>Import or Update qualifications</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=array\|Name=<nowiki>permissions</nowiki>\|Description=<nowiki>Determine which groups should have access to the new users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=Dictionary\|Name=<nowiki>mapping</nowiki>\|Description=<nowiki>Mapping between header names and import names. If empty, automapping is used</nowiki>}}
	\|Description=<nowiki>OBSOLETE. Use the new overload with parentResourceId.</nowiki>}}		\|Description=<nowiki>OBSOLETE. Use the new overload with parentResourceId.</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Dictionary\|Name=<nowiki>SetUserImportOptions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Dictionary\|Name=<nowiki>SetUserImportOptions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userIdColumnName</nowiki>\|Description=<nowiki>The header name of the userId column</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userNameMask</nowiki>\|Description=<nowiki>The mask used to create new usernames - an advanced setting</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>generatePasswords</nowiki>\|Description=<nowiki>Generate passwords during import</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importUserInfo</nowiki>\|Description=<nowiki>Import or Update users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPhoneNumber</nowiki>\|Description=<nowiki>Import or Update phonenumbers</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importAddress</nowiki>\|Description=<nowiki>Import or Update addresses</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPoints</nowiki>\|Description=<nowiki>Import or Update points</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importQualification</nowiki>\|Description=<nowiki>Import or Update qualifications</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>parentResourceId</nowiki>\|Description=<nowiki>Resource Id of the parent of the new users. Ignored if updating users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=Dictionary\|Name=<nowiki>mapping</nowiki>\|Description=<nowiki>Mapping between header names and import names. If empty, automapping is used</nowiki>}}		{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userIdColumnName</nowiki>\|Description=<nowiki>The header name of the userId column</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>userNameMask</nowiki>\|Description=<nowiki>The mask used to create new usernames - an advanced setting</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>generatePasswords</nowiki>\|Description=<nowiki>OBSOLETE. Always false. Generate passwords during import</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importUserInfo</nowiki>\|Description=<nowiki>Import or Update users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPhoneNumber</nowiki>\|Description=<nowiki>Import or Update phonenumbers</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importAddress</nowiki>\|Description=<nowiki>Import or Update addresses</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importPoints</nowiki>\|Description=<nowiki>Import or Update points</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>importQualification</nowiki>\|Description=<nowiki>Import or Update qualifications</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>parentResourceId</nowiki>\|Description=<nowiki>Resource Id of the parent of the new users. Ignored if updating users</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=Dictionary\|Name=<nowiki>mapping</nowiki>\|Description=<nowiki>Mapping between header names and import names. If empty, automapping is used</nowiki>}}
	\|Description=<nowiki>Set specific options for importing new users or altering existing users</nowiki>}}		\|Description=<nowiki>Set specific options for importing new users or altering existing users</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Inherited=object\|Description=<nowiki>The string representation of the object.</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>Validate</nowiki>\|Description=<nowiki>Same as Validate(true)</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>Validate</nowiki>\|Description=<nowiki>Same as Validate(true)</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>Validate</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>Validate</nowiki>\|Parameters=
Line 31:		Line 31:
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>Language</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the language used when importing text</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>Language</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the language used when importing text</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>UseLoggedInUsersCultureDuringImport</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if the culture used during import is the same as the logged in user or invariant culture. Default is invariant</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>UseLoggedInUsersCultureDuringImport</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if the culture used during import is the same as the logged in user or invariant culture. Default is invariant</nowiki>}}
	}}		}}




	=== <span style="color:#DF8621">'''Examples'''</span> ===		=== <span style="color:#DF8621">'''Examples'''</span> ===

← Older revision		Revision as of 02:17, 19 June 2018
Line 9:		Line 9:
	{{CGscriptMethods_Template\|ReturnType=array\|Name=<nowiki>GetPossibleAutoMasForData</nowiki>\|Description=<nowiki>Get default automaps. First value is column name, second is actual import field</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=array\|Name=<nowiki>GetPossibleAutoMasForData</nowiki>\|Description=<nowiki>Get default automaps. First value is column name, second is actual import field</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=array\|Name=<nowiki>GetPossibleAutoMasForUser</nowiki>\|Description=<nowiki>Get default automaps. First value is column name, second is actual import field</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=array\|Name=<nowiki>GetPossibleAutoMasForUser</nowiki>\|Description=<nowiki>Get default automaps. First value is column name, second is actual import field</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=~~Empty~~\|Name=<nowiki>Import</nowiki>\|Description=<nowiki>Run the Import. Note that this will commit any pending changes</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=Dictionary\|Name=<nowiki>Import</nowiki>\|Description=<nowiki>Run the Import. Note that this will commit any pending changes</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Dictionary\|Name=<nowiki>SetDataImportOptions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Dictionary\|Name=<nowiki>SetDataImportOptions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>projectQuestionnaireResourceId</nowiki>\|Description=<nowiki>The resource Id of where the data should be added/updated</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>type</nowiki>\|Description=<nowiki>How to treat when already have existing answer sheets. 1 for Zero or One AnswerSheet, 2 for delete existing and create new, 3 for mapping to rpqIdColumnName</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>idColumnName</nowiki>\|Description=<nowiki>Mapping for column name in case type is 3 or 4</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>isCommaSeparatedFormat</nowiki>\|Description=<nowiki>Import multi questions as comma separated format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=Dictionary\|Name=<nowiki>mapping</nowiki>\|Description=<nowiki>Mapping between header names and import names. If empty, automapping is used</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>projectQuestionnaireResourceId</nowiki>\|Description=<nowiki>The resource Id of where the data should be added/updated</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>type</nowiki>\|Description=<nowiki>How to treat when already have existing answer sheets. 1 for Zero or One AnswerSheet, 2 for delete existing and create new, 3 for mapping to rpqIdColumnName</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>idColumnName</nowiki>\|Description=<nowiki>Mapping for column name in case type is 3 or 4</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>isCommaSeparatedFormat</nowiki>\|Description=<nowiki>Import multi questions as comma separated format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=Dictionary\|Name=<nowiki>mapping</nowiki>\|Description=<nowiki>Mapping between header names and import names. If empty, automapping is used</nowiki>}}
Line 28:		Line 28:
	\|Description=<nowiki>Validate prior to actual importing. Throws if errors, otherwise returns warning.</nowiki>}}		\|Description=<nowiki>Validate prior to actual importing. Throws if errors, otherwise returns warning.</nowiki>}}
	\|Properties=		\|Properties=
			{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>DefaultCulture</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the culture used during import in case we don't want to use the logged-in-user's one (UseLoggedInUsersCultureDuringImport = false)</nowiki>}}
			{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>Language</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set the language used when importing text</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>UseLoggedInUsersCultureDuringImport</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if the culture used during import is the same as the logged in user or invariant culture. Default is invariant</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>UseLoggedInUsersCultureDuringImport</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if the culture used during import is the same as the logged in user or invariant culture. Default is invariant</nowiki>}}
	}}		}}